Driving me crazy. After each monthly windows patching over the last couple months, on our 64 bit windows 2012 server, one of our Oracle 11g (11.2.0.4) databases does not open properly.
For a decade it has been fine, regardless of version, always opened when the server came up through the windows service, no matter how bad it went down. Never had to touch anything!
Now , the last few after hours patching reboots (database is open during the reboot) this one db doesn't come up with the windows service. Even after all the users log off before the shutdown. Nothing is obvious in the alert.log file.
When entering sqlplus, you get
Oracle not available
Shared memory realm does not exist.
I need to do a 'recover database' (no archives are needed), then alter database open. it is fine then.
not hard to do, but usually happens over night, I need to get it working before the developers start their process to get the application working.
Any thoughts on what to check or change to ensure the db does proper cleanup on startup.. assuming I don't shut it down clean, which is not always an option. The windows service is set to automatic, naturally. There are 2 11g databases on this server.