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