Oracle 12c introduced feature to move table partitions and sub-partitions as online operations.So, this blog is related to this feature and the issue I faced. The database was upgraded from 11.2.0.4 to 12.1.0.2 and this issue is seen in upgraded databases only. Lets start!!! SQL> create table sales_part (product char(25),channel_id number,cust_id number, amount_sold number, time_id … Continue reading Online Partition Move fails with ORA-00932 – 12.1.0.2
ORDIM – Oracle Multimedia – Invalid after upgrade
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
PRCA-1057 : Failed to retrieve the password file location used by ASM
After the Oracle Restart (Grid Infrastructure) upgrade from 11.2. to 12.1.0.2 , you might encounter the below lines in the ASM alert log file Tue Jun 23 01:16:01 2015 WARNING: unknown state for ASM password file location resource, Return Value: 3 WARNING: unknown state for ASM password file location resource, Return Value: 3 After the … Continue reading PRCA-1057 : Failed to retrieve the password file location used by ASM
12c Upgrade – It can be slow!!!!
This post is for some of you who are planning to upgrade to 12c.I worked on upgrading single instance database from 11.2.0.3.13 to 12.1.2.0.3, so thought to share my experience. From 12c catupgrade.sql has been deprecated and Oracle has introduced catctl.pl script for upgrade. With catctl.pl script Oracle tries to perform as much work as … Continue reading 12c Upgrade – It can be slow!!!!
Upgrading to 11.2.0.4 – Dictionary View Performing Poor
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
Clusterware version consistency failed
Recently we rollbacked (qtree snapshots were restored) 11.2.0.3 2-node RAC back to 10.2.0.5 version after testing successful upgrade.Again it was time for mock upgrade to 11.2.0.3, before performing it on production.We started the runInstaller for CRS upgrade and after the "Prerequisite Checks" it showed " clusterware version consistency failed for both the nodes". The to … Continue reading Clusterware version consistency failed
Upgrade DB using exisiting Oracle Home in 11.2 and later – “In-Place 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 … Continue reading Upgrade DB using exisiting Oracle Home in 11.2 and later – “In-Place Upgrade”
Learn. Share. Repeat. 