After Server Reboot Database not started automatically in Windows

Issue:

Whenever user reboot the windows server he got the below issue.

Error:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

Analysis:

We checked the service status in “services.msc” reboot configuration, it is mentioned as “Automatic”.

When we checked the status it is connected as “ideal instance”. Immediatly we started the database manually.

Cause:

Database not stated automatically. So we started the database manually and analyse the issue the database is not configured with auto startup option

Solution:

We edited the instance configuration using “oradim” utility.

Command used:

oradim -EDIT -SID <database name> -STARTMODE  auto -SPFILE 



-> Retested the issue and the database came up automatically and issue has been fixed

  • October 7, 2015 | 13 views