12cR1 RAC Installation on OEL7

To build Oracle Clusterware Database at Home, I believe , RAC ATTACK is the best place to learn. Its is a free curriculum and platform for hands-on learning labs related to Oracle RAC. While reviewing the article, I thought to perform 12cR1 RAC installation on OEL 7.2. Attached is the document :- 12c_RAC_on_OEL7 The attached article is … Continue reading 12cR1 RAC Installation on OEL7

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

DB startup/shutdown error after downgrade from 11gR2 to 10gR2

I was asked to work on a 2-node RAC db which was downgraded to 10.2.0.5 from 11.2.0.3. While working, i had stopped the database using "shutdown immediate" command from sqlplus instead of srvctl. While start the db using srvctl - wdlab1: (matrix1) /u01/app/oracle/product/rdbms/10205> srvctl start database -d matrix_lab -o open PRKR-1001 : cluster database matrix_lab … Continue reading DB startup/shutdown error after downgrade from 11gR2 to 10gR2

hasGetClusterStatus Status verification failed due to cluvfy execution failure for node(s) – 10gR2 RAC

Received a mail from colleague reporting the below error from emgc Metric Collection Errors - Target crs_node1 Type Cluster Metric Clusterware Status Collection Timestamp Dec 14, 2011 5:35:02 AM Error Type Collection Problem Message WARN|has::Common::hasGetClusterStatus Status verification failed due to cluvfy execution failure for node(s) node3:EFAIL,NODE_STATUS::node2:EFAIL,NODE_STATUS::node1:EFAIL,NODE_STATUS::node4:EFAIL,OVERALL_STATUS: The first thing i did is ran cluvfy node1: … Continue reading hasGetClusterStatus Status verification failed due to cluvfy execution failure for node(s) – 10gR2 RAC

OHASD doesn’t start – 11gR2

Few weeks back had an issue where 2nd node of 4-node RAC got evicted and the alert log showed the below error before the instance was evicted - Errors in file /u04/oraout/matrix/diag/rdbms/matrix_adc/matrix2/trace/matrix2_ora_8418.trc (incident=16804): ORA-00603: ORACLE server session terminated by fatal error ORA-27504: IPC error creating OSD context ORA-27300: OS system dependent operation:if_not_found failed with status: … Continue reading OHASD doesn’t start – 11gR2

crsctl start crs doesn’t start crs – 10gR2

Today morning a box got rebooted, crs(10.2.0.5 vesrsion) didn't come up automatically. Manual crsctl start crs command didn't update any log file in crsd,cssd, or even the alertxx4040.log xx4040: (test1) /etc/oracle/scls_scr/test1/root> cat crsstart enable xx4040: (test1) /etc/oracle/scls_scr/test1/root> So, as crsstart is enabled, it should have come up automatically.Ran cluvfy xx4040: (test1) /home/oracle>cluvfy stage -pre crsinst … Continue reading crsctl start crs doesn’t start crs – 10gR2

Adding OCR and Voting Disk on NFS mount – 11gR2

From 11gR2 as the OCR and voting disk are stored on ASM storage the grid installer doesn't show the option to specify multiple OCR and voting disk locations.We have the ocr and voting disk stored on NFS mounted file system and during the installation only one location was specified. xx4040: (test1) /anand> crsctl query crs … Continue reading Adding OCR and Voting Disk on NFS mount – 11gR2

CRS-1006: No more members to consider

I had an error which i would call weird cause i couldn't understand it :). I was asked to start 2-Node 10.2.0.5 RAC db and its services. Interestingly received the below error while starting the service - ora.test_abc.test.abc.example.com.cs OFFLINE OFFLINE ora.test_abc.test.abc.example.com.test1.srv OFFLINE OFFLINE ora.test_abc.test.abc.example.com.test2.srv OFFLINE OFFLINE $ srvctl start service -d test_abc -s test.abc.example.com PRKP-1030 … Continue reading CRS-1006: No more members to consider

CRS-4046: Invalid Oracle Clusterware configuration. – 11gR2

After failed installation of 11gR2 Clusterware (due to wrong cluster_interconnect IP), during the second attempt, i received the below error while running the "root.sh" script on the first node. [root@node1 11.2.0.2]# sh root.sh Running Oracle 11g root script... The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/grid/11.2.0.2 Enter the full pathname of the … Continue reading CRS-4046: Invalid Oracle Clusterware configuration. – 11gR2

ORA-00132: syntax error or unresolved network name ‘LISTENER_TEST2AT’

On starting a 3-node 11gR2 RAC database on linux using srvctrl start database/instance command gave the below error - $ srvctl start instance -d testat -i test1at PRCR-1079 : Failed to start resource ora.testat.db CRS-5017: The resource action "ora.testat.db start" encountered the following error: ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or … Continue reading ORA-00132: syntax error or unresolved network name ‘LISTENER_TEST2AT’