Tuesday, December 30, 2014

PRCR-1065: Failed to stop resource ora.asm

Error PRCR-1065 and CRS-2529 can be returned while stopping the ASM using srvctl command on Grid Infrastructure 11.2 and above as can be seen in the following.
[grid@salman1 ~]$ srvctl stop asm
PRCR-1065 : Failed to stop resource ora.asm

Monday, December 29, 2014

Oracle Database 12c Patch/Upgrade from 12.1.0.1 to 12.1.0.2

For manual upgrade guide from 11g to 12c, click here. Same guide can also be followed to manually upgrade from 12.1.0.1 to 12.1.0.2.
Before going through this upgrade guide, you may be interested to view the guide to patch/upgrade standalone Grid Infrastructure from 12.1.0.1 to 12.1.0.2

Sunday, December 21, 2014

ORA-38500 While Enabling Real-Time Redo Apply

If you are trying to enable real time redo apply whereby LGWR process of primary database writes directly to the standby redo log file of the standby database, you might face ORA-38500 error message. Following is an example of this error message.
SQL> ALTER DATABASE RECOVER MANAGED STAND

Thursday, December 18, 2014

Grid Infrastructure 12c Patch/Upgrade from 12.1.0.1 to 12.1.0.2

In this post, I will be demonstrating the steps to upgrade/patch the Grid Infrastructure (GI) 12.1.0.1 to 12.1.0.2. Since ASM runs from GI home, ASM would be upgraded while upgrade of GI home. As we know that Oracle now provides full installation binaries for patchset releases so the binaries are required to be downloaded from MOS. You would need to download Patch

Wednesday, December 10, 2014

Error: "Message 279 not found" while starting Listener

One of my customers has Oracle 11.2.0.4 on windows 2008 R2 (x64). After reboot of this database server, listener did not come up automatically and even manually starting the listener was returning following error at the command prompt.

Popular Posts - All Times