Starting Database From Windows Service Doesn’t Work

Today I have a stranger problem at work, starting a database (Release 12) on Windows 2012 R2 didn’t work from service. The solution was start service using oradim;

 
C:\Windows\system32> sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Sep 12 10:59:41 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error

It sounds like no service avaliable. I try start the Windows service and connect to database by using sqlplus;

 
C:\Windows\system32> net start oracleservicesfintest
The OracleServicesfintest service is starting.
The OracleServicesfintest service was started successfully.

C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32>
C:\Windows\system32> sqlplus '/ as sysdba'

SQL*Plus: Release 12.1.0.2.0 Production on Mon Sep 12 11:53:28 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error

It fails again with the same error… I take a look at eventviewer log but not error reported.

Finally I started the service from oradim, it worked fine;

 
C:\Windows\system32>
C:\Windows\system32>

C:\Windows\system32> oradim.exe -startup -sid test12

After that I restart the windows service for twice times more, It’s worked and I can’t found the problem … I think it was on the Operating System but I’m not sure 😦

HTH – Antonio NAVARRO

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s