Oracle Local Registry (OLR) – 11gR2

From 11gR2 Oracle introduced "Oracle Local Registry(OLR)", something new as part of Oracle Clusterware.OLR is node's local repository,similar to OCR (but local) and is managed by OHASD.It pertains data of local node only and is not shared among other nodes.On a linux environment the configuration file is placed in /etc/oracle location. $ pwd /etc/oracle $ …

CRS-0215: Could not start resource ‘ora.test_prm.test1.inst’.

On a 3-node RAC database, one of the instance was not coming up, throwing the below error $ srvctl start instance -d test_prm -i test1 -o open PRKP-1001 : Error starting instance test1 on node nn4040 CRS-0215: Could not start resource 'ora.test_prm.test1.inst'. I was asked to look into it, so the first thing i tried …

lsnrctl: symbol lookup error: lsnrctl: undefined symbol: nlgh

On starting the listener after applying the PSU patch on 11.2.0.2 database, i was getting the below error - (matrix) /u01/app/oracle/product/rdbms/11202/network/admin> lsnrctl start LISTENER_RM4040 lsnrctl: symbol lookup error: lsnrctl: undefined symbol: nlgh As per Metalink, The most common cause of this error is that the Oracle software binaries are not linked correctly. To link the …

Transparent Data Encryption (TDE) – EXPDP and IMPDP – 10gR2 and 11gR2

It had been long time i had played with TDE, so thought of experimenting few things, as its the best way to learn 😉 . As most of us know,TDE enables to encrypt individual table columns or a tablespace.Prior to 11g, only table column level was supported.A user with "create table" privilege can choose one …

ologgerd daemon – 11gR2

In past few weeks i have been involved in RAC as well as non-RAC databases upgrade from 10.2.0.5 to 11.2.0.2.With every upgrade i come to learn something new 🙂 After an upgrade to 11.2.0.2, for one of the development database which is a 2-node RAC, EMGC started showing Swap Utilization 99.99%.The "TOP" command showed node …