ORDIM – Oracle Multimedia – Invalid after upgrade

Posted on by Anand

ORDIM - The Oracle Multimedia component might be in INVALID state after the database upgrade to 12c. While I was testing the upgrade on test server, received below errors after the catctl.pl completion. Serial Phase #:69 Files: 1 Use of uninitialized value $gsRTInclusion in concatenation (.) or string at catctl.pl line 1500. Time: 49s ------------------------------------------------------ … Continue reading ORDIM – Oracle Multimedia – Invalid after upgrade

Upgrading to 11.2.0.4 – Dictionary View Performing Poor

Posted on by Anand

Just a quick blog post on things you might see after upgrading to 11.2.0.4. We recently upgraded database from 11.2.0.3 to 11.2.0.4 and query on some data dictionary views ran too slow. 1. Performace of query on dba_free_space degraded 2. Performance of query involving dba_segments is slow DEV01> select ceil(sum(b.bytes)/1024/1024) b from sys.dba_free_space b; Elapsed: … Continue reading Upgrading to 11.2.0.4 – Dictionary View Performing Poor

Upgrade DB using exisiting Oracle Home in 11.2 and later – “In-Place Upgrade”

Posted on by Anand

From 11gR2, Oracle introduced "Out-of-Place" upgrade, where during the upgrade we install the patch set into a new, separate Oracle home, and its best practices recommendation, as minimizes the downtime.Once, the patch set installation is complete in the new Oracle Home location, we can perform the upgrade using DBUA or manual method. So, can't we … Continue reading Upgrade DB using exisiting Oracle Home in 11.2 and later – “In-Place Upgrade”