ORDIM – Oracle Multimedia – Invalid after upgrade

Posted Leave a commentPosted in Oracle

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 —————————————————— […]

Upgrading to 11.2.0.4 – Dictionary View Performing Poor

Posted Leave a commentPosted in 11gR2, Oracle, Upgrade

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: […]

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

Posted 4 CommentsPosted in 11gR2, Oracle, Upgrade

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 […]