Clusterware version consistency failed

Posted Leave a commentPosted in 11gR2, cluvfy, CRS, HA, OHASD, OLR, Oracle, Upgrade

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 […]

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

Posted Leave a commentPosted in 10gR2, 11gR2, CRS, crsctl, Oracle, srvctl

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 […]

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

Posted Leave a commentPosted in 10gR2, cluvfy, CRS, Oracle, 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: […]

OHASD doesn't start – 11gR2

Posted 3 CommentsPosted in 11gR2, CRS, HA, OHASD, Oracle, RAC

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: […]

crsctl start crs doesn't start crs – 10gR2

Posted 4 CommentsPosted in 10gR2, CRS, Oracle, RAC

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 […]

CRS-1006: No more members to consider

Posted 2 CommentsPosted in CRS, Oracle, RAC

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 […]

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

Posted 6 CommentsPosted in 11gR2, CRS, Oracle

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. [[email protected] 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 […]

ORA-00132: syntax error or unresolved network name 'LISTENER_TEST2AT'

Posted Leave a commentPosted in 11gR2, CRS, Oracle, RAC

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 […]

Oracle Restart configuration after Renaming the Database – 11gR2

Posted 1 CommentPosted in 11gR2, CRS, Oracle

The Oracle Restart ensures that various Oracle components gets automatically restarted after hardware or software failures.In my last post as i had renamed the database, i had to update the OLR (Oracle Local Registry)for the database to come up automatically. [[email protected] bin]$ ./crsctl stat res -t ——————————————————————————– NAME TARGET STATE SERVER STATE_DETAILS ——————————————————————————– Local Resources […]