MOS Docs to Review for EBS DB Upgrade to 11gR2 (Latest Patch Release)

If you are considering Oracle database upgrade from 9i/10g to 11gR2 or applying release patches (11.2.0.1 to 11.2.0.3 or 11.2.0.4), several issues can be avoided by applying the recommended patches and PSU.  And if you are not on the latest 11gR2 release (11.2.0.3 or 11.2.0.4), I strongly recommend getting there, with the latest PSU possible… … Read more

SQL Developer 4.0 on Linux – Easy Install Steps

Few quick screens to show the download and install of SQL Developer 4.0 on Oracle Linux 6.3. SQL Developer 4.0 is cool… for DBA and Developer… You can pretty much do almost all day-to-day database administration tasks using SQL Developer… Read my doc on Slideshare…   More… Follow Jeff’s blog… And check out OBE…     … Read more

Streams Answer…

I posted the question few days back on a streams issue I have been working on… https://bijoos.com/oraclenotes/oraclenotes/2013/199 It looks like there was a open or long transaction, and before that transaction was committed or rollback, the archivelog file got deleted by the RMAN backup and cleanup job…  or we just hit a bug (patch 13853654)… so, … Read more

Streams/CDC Question? Help…

Yes, a question indeed, looking for help through the blog!  I recently got into a streams issue, have not supported streams in a live environment  until recently (when you work on your virtual desktop streams and golden gate and everything works perfect, isn’t!!)… Ok, here is the question… need to give you some background… To protect … Read more

OracleDB12c New Feature: Password File in ASM

Prior to Oracle Database 12c, the password file always was located under $ORACLE_HOME/dbs directory, even for RAC instances and for RAC ASM cluster. DBA had to manage and keep in sync the password file in each node. In 12c, now the password file can be stored on ASM instance and hence shared by all instances … Read more

OracleDB12c New Feature: Exporting View Data

Oracle Database 12c datapump export expdp has an option to export the views as tables. Expdp exports the view definition as a table and its data. This is an extremely useful feature to export subset of data. At import time, datapump creates the table with column name and data type similar to the view and … Read more