After Server Reboot Database not started automatically in Windows
Whenever user reboot the windows server he got the below issue.
ORA-12514: TNS:listener does not currently know of service requested in connect
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.
Database not stated automatically. So we started the database manually and analyse the issue the database is not configured with auto startup option
We edited the instance configuration using “oradim” utility.
oradim -EDIT -SID <database name> -STARTMODE auto -SPFILE
-> Retested the issue and the database came up automatically and issue has been fixed