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
ORA-00600:[kcbsor_2], [3], [2]
Recently we had a node crash of one node in 3-node 11.2.0.3 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 … Continue reading ORA-00600:[kcbsor_2], [3], [2]
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
Extract keeps ABENDING – No valid archive log dest for Thread N – OGG
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, … Continue reading Extract keeps ABENDING – No valid archive log dest for Thread N – OGG
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
ORA-01567: dropping log N would leave less than 2 log files for instance UNNAMED_INSTANCE_N (thread N)
Recently we had a database refresh where a standalone db got refreshed from the 4-node RAC. After the completion of the refresh, saw 10 redo log groups.As it was a single instance database and wouldn't have much workload, thought of dropping 6 groups. SQL> select GROUP# from v$log; GROUP# ---------- 1 2 3 4 5 … Continue reading ORA-01567: dropping log N would leave less than 2 log files for instance UNNAMED_INSTANCE_N (thread N)
DBA_INDEXES shows no index but Create Index errors out with ORA-01408: such column list already indexed
Yesterday we had a very interesting issue popped up on 10.2.0.5 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 SYS@matrix1 > @index Enter value for owner: anand Enter value for table_name: TEST … Continue reading DBA_INDEXES shows no index but Create Index errors out with ORA-01408: such column list already indexed
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
single-task message and Cursor:pin S wait on X
Recently we had faced an issue where the CPU utilization on 3-node RAC (10.2.0.5) servers were high. The load testing team had reported for the same as they were doing loading testing on the machine and wanted us to have a look. I was asked to check and find the reason for the same, so … Continue reading single-task message and Cursor:pin S wait on X
Learn. Share. Repeat. 