ORA-01031 in one node alone on a 2 node RAC
Dear All,
Problem Description:
We have a 2 node RAC cluster, which is hosting 6 databases.Of which one of the database backup has started failing consistently due to ORA-01031 error,when trying to connect to the target database.We later explored this unique scenario.
(i) Connecting to the database using 'sys/xxxx@db1 as sysdba' or 'sys/xxxx@db2 as sysdba' works just fine
(ii) Connecting to the database using 'sys/xxxx@db as sysdba' fails with ORA-01031 insufficient privilege
(iii) This issue impacts only one database (specifically the second instance - when the connection is redirected towards 2nd node when we use DB_NAME to connect, ORA-01031 errror occurs) ,rest are all (instances/db) fine.
We have a 2 node RAC cluster, which is hosting 6 databases.Of which one of the database backup has started failing consistently due to ORA-01031 error,when trying to connect to the target database.We later explored this unique scenario.
(i) Connecting to the database using 'sys/xxxx@db1 as sysdba' or 'sys/xxxx@db2 as sysdba' works just fine
(ii) Connecting to the database using 'sys/xxxx@db as sysdba' fails with ORA-01031 insufficient privilege
(iii) This issue impacts only one database (specifically the second instance - when the connection is redirected towards 2nd node when we use DB_NAME to connect, ORA-01031 errror occurs) ,rest are all (instances/db) fine.
0