Oracle Extended RAC Database Failed during auto startup.

 The following Error was encountered when we tried starting up the database manually:

 

SQL> startup

ORACLE instance started.

 

Total System Global Area 4.8694E+11 bytes

Fixed Size                 37521640 bytes

Variable Size            5.5298E+10 bytes

Database Buffers         4.3111E+11 bytes

Redo Buffers              499347456 bytes

Database mounted.

Database opened.         " was non-numeric

Usage: { EXIT | QUIT }e [ SUCCESS | FAILURE | WARNING | n |

       <variable> | :<bindvariable> ]  [ COMMIT | ROLLBACK ]

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.18.0.0.0

 

 

[oradbp@dbnode13 ~]$ srvctl start instance -i testdb11 -d testdb

PRCR-1013 : Failed to start resource ora.testdb.db

PRCR-1064 : Failed to start resource ora.testdb.db on node dbnode13

CRS-2680: Clean of 'ora.testdb.db' on 'dbnode13' failed

CRS-5802: Unable to start the agent prdbnodess

[oradbp@dbnode13 ~]$ cd /oracle/products/db

[oradbp@dbnode13 db]$ ls

 

Working node Dir permissions:

 

[oradbp@occ13 occ13]$ ls -ld /oracle/products/gi_base

drwxrwxr-x. 7 oragrid root 83 Apr 16 16:04 /oracle/products/gi_base

[oradbp@occ13 occ13]$

 

Non Working node dir permissions:

[root@dbnode13 ~]# ls -ld /oracle/products/gi_base

drwxrwx---. 7 oragrid root 83 Apr 22 10:45 /oracle/products/gi_base

[root@dbnode13 ~]# chmod -R 775 /oracle/products/gi_base

[root@dbnode13 ~]#

 

Solution and conclusion:

Make sure the permissions are changed on non working directory to be same as node where cluster startup is working fine.

Thanks for reading.

regards,

ZAHEER