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 $ … Continue reading Oracle Local Registry (OLR) – 11gR2

Advertisement

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 … Continue reading CRS-0215: Could not start resource ‘ora.test_prm.test1.inst’.

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 … Continue reading lsnrctl: symbol lookup error: lsnrctl: undefined symbol: nlgh

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 … Continue reading Transparent Data Encryption (TDE) – EXPDP and IMPDP – 10gR2 and 11gR2