Hi All,
I need your help in understanding a situation with server control utility. Yesterday I have configured Oracle restart functionality in couple of our production databases. Things worked fine in most of the databases (including the standby databases), but in one database(Primary) when I issued “srvctl start database -d <database name>' to start the auto restart service on a database that was in read-write mode, then Oracle shutdown the database. I have not seen this behavior in other databases. Please see the list of following steps performed, and share if you have any explanation.
I am using Oracle version 19.24.0.0.0
-
srvctl config database -d <database> – I have verified the parameters (
spfile – set to correct spfile
startup options, – set to open
stop options – set to immediate
database role – set to primary
management policy – set to Automatic
-
srvctl status database -d <database> – The output was “Database is not running”
-
srvctl start database -d <database name> – This is where it took some time because this command restarted the database
I have looked at alert log, and ASM logs for any information but could not find any other than shutdown and start of DB.
Please share your thoughts
Thanks