MGMTDB is new database instance which is used for storing Cluster Health Monitor (CHM) data. In 11g this was being stored in berkley database but starting Oracle database 12c it is configured as Oracle Database Instance. In 11g, .bdb files were stored in $GRID_HOME/crf/db/hostname and used to take up lot of space (>100G) due to bug…
Last week Oracle released 12c database and Oracle blogosphere is bustling with lot of people posting details about new versions and setup. I too decided to take plunge and setup my own RAC cluster. I had 4 machines with me but no shared storage 🙁 Long back I had done one installation using openfiler (Followed…
Quick note for people using NFS for shared storage on RAC database. Till RHEL5 we had to ensure nfs,nfslock and portmap service has to be running. These services are required otherwise you will get following errors while mounting database ORA-00210: cannot open the specified control file ORA-00202: control file: '/u01/oradata/orcl/control01.ctl' ORA-27086: unable to lock file…
In this blog post I will be discussing listener startup issues faced in 11gR2 RAC. I will be constantly updating this post based on my experiences or any comments on this blog post. Let’s get started.You will experience following errors while starting listener using srvctl [[email protected]]~% srvctl start listener -n prod01 PRCR-1013 : Failed to…
This post was actually a comment from Sasi which came on previous article 10.2 CRS startup issue . I am converting it to a post so that we can get some feedback on this issue from other users. I suspect this to be caused by RHEL5 bug (fixed in RHEL5u6) related to NIC going down when…
I had installed a 11.2.0.2 RAC setup few days back with incorrect timezone. It had to be PDT but I installed with UTC. Starting/stopping clusteware with correct timezone didn’t solve the issue. In 11.2.0.2 Oracle stores timezone information in file $GRID_HOME/crs/install/s_config_(hostname).txt. In my case file looked like this cd /oragrid/product/11.2/crs/install cat s_crsconfig_prod1.txt <strong>TZ=UTC</strong> NLS_LANG=AMERICAN_AMERICA.AL32UTF8 TNS_ADMIN=…