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

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

1 comment:

Sridevi K said...


Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.