Getting ORA-01105 during RAC db startup
Posted by Kamran Agayev A. on July 30th, 2014
Today, while starting RAC instances of 2 node RAC database (10gR2 on Linux), I got the following error in the first node:
ORA-01105: mount is incompatible with mounts by other instances
ORA-01677: standby file name convert parameters differ from other instance
I checked the alert.log file, but there was no enough information to solve this issue:
Wed Jul 30 09:58:48 AZST 2014
Setting recovery target incarnation to 2
ORA-1105 signalled during: ALTER DATABASE MOUNT…
Wed Jul 30 09:58:58 AZST 2014
SUCCESS: diskgroup DATA was dismounted
After playing with some initialization parameters, I found a metalink note where it was defined as a bug (bug13001004)
Check out the following metalink note:
Spfile defined in OCR is not used if one exists in $ORACLE_HOME/dbs (Doc ID 1373622.1)
The solution is – to move parameter file to the centralized directory (/ocfs) and remove any instance_name parameter