DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Wednesday, October 7, 2015

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.

Command used:

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

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

1 comment:

Sridevi K said...

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.