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
Comments