ORA-01034 and Ora-27101 after rebooting the server [ID 238073.1] Symptom(s) ~~~~~~~~~~Database has been configured to start automatically whenever the server is rebooted. But the database does not start and any query to the database fails with Ora-27101 and Ora-1034 errors. Same errors are reported in the Oradim.log.ORA-01034 ORACLE not available ORA-27101 "Shared Memory Realm Does Not Exist"
Change(s) ~~~~~~~~~~DBAs are trying to automate the startup of the database when server reboots. The Registry key ORA_<SID>_AUTOSTART is set to TRUE and ORA_<SID>_PFILE is pointing to correct location. The "startmode" of Oracle service ORACLESERVICE<SID> has been set to AUTOMATIC. Cause ~~~~~~~The Oracle service ORACLESERVICE<SID> get corrupted for some unknown reasons and does not start the database successfully Fix ~~~~recreate the Oracle service using ORADIM utilitya) delete the current service - c:\> oradim -delete -sid <sid_name>b) make sure the service has status DISABLED in Service Windows and it does not appear after refreshing the Service Windows. If the service still appears, reboot the server.c) create the service c:\> oradim -new -sid <sid> -startmode auto -pfile <absolute path of init.ora>
~~~~~~~~~~Database has been configured to start automatically whenever the server
is rebooted. But the database does not start and any query to the database
fails with Ora-27101 and Ora-1034 errors. Same errors are reported in
the Oradim.log.ORA-01034 ORACLE not available
ORA-27101 "Shared Memory Realm Does Not Exist"
Change(s)
~~~~~~~~~~DBAs are trying to automate the startup of the database when
server reboots. The Registry key ORA_<SID>_AUTOSTART is set to
TRUE and ORA_<SID>_PFILE is pointing to correct location. The "startmode"
of Oracle service ORACLESERVICE<SID> has been set to AUTOMATIC.
Cause
~~~~~~~The Oracle service ORACLESERVICE<SID> get corrupted for some unknown
reasons and does not start the database successfully
Fix
~~~~recreate the Oracle service using ORADIM utilitya) delete the current service -
c:\> oradim -delete -sid <sid_name>b) make sure the service has status DISABLED in Service Windows and it
does not appear after refreshing the Service Windows. If the service
still appears, reboot the server.c) create the service
c:\> oradim -new -sid <sid> -startmode auto -pfile <absolute path of init.ora>