Database Administration (MOSC)

MOSC Banner

ora12560 while using OracleServiceSID to start my database

edited Dec 18, 2009 7:24AM in Database Administration (MOSC) 8 commentsAnswered
Hi, Environement : Oracle database 10.2.0.1 on W2K3
When the service OracleServicemySID is launched, it doesn't start my database.
When I look at the properties of my service,I see it's expected to run : d:\oracle\product\10.2.0\db_1\bin\ORACLE.EXE mySID
When I look in oradim.exe I see the following error :
\oracle\product\10.2.0\db_1\bin\oradim.exe -startup -sid mySID -usrpwd *  -log oradim.log -nocheck 0
Tue Dec 15 08:19:07 2009
ORA-12560: TNS : protocol adapter error
The registry seems to be fine : ORACLE_SID is set to mySID

when I try to connect my database : using sqlplus sys/pwd@mySID as sysdba
It connects but I have the message : connected to an iddle instance

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center