ORA-00600:[kcbsor_2], [3], [2]

Posted Leave a commentPosted in corruption, ORa-600, Oracle, RAC, RMAN

Recently we had a node crash of one node in 3-node RAC database configuration.The alert log showed – Thu Apr 26 00:15:16 2012 Hex dump of (file 488, block 345039) in trace file /u01/oradiag/diag/rdbms/matrix_adc/matrix3/trace/matrix3_dbw1_16218.trc Corrupt block relative dba: 0x7a0543cf (file 488, block 345039) Bad header found during preparing block for write Data in bad […]

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

Extract keeps ABENDING – No valid archive log dest for Thread N – OGG

Posted Leave a commentPosted in 10gR2, GoldenGate, Oracle, RAC

Recently we refreshed one of the 2-node UAT database from 3-node production.The 2-node UAT acts as the source for the GoldenGate.After the refresh of source and the initial load on the target, we started the extract and replicat process.As, the source was 2-node RAC, extract was added with 2 Threads information ADD EXTRACT ext, TRANLOG, […]

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

DBA_INDEXES shows no index but Create Index errors out with ORA-01408: such column list already indexed

Posted Leave a commentPosted in Indexes, Oracle, RAC

Yesterday we had a very interesting issue popped up on database where the team running a sql script got “ORA-01408: such column list already indexed” though the dba_indexes showed no index on the table.The index to be created was “test_u1” 23:11:01 [email protected] > @index Enter value for owner: anand Enter value for table_name: TEST […]

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