Database doesn't startup after booting the server!
uptimeSep 23 2005 — edited Feb 28 2006hi,
first my configuration:
windows 2003 server enterprise edition
oracle 10g enterprise edition
now to the problem i am dealing with. when i am starting or rebooting my server i actually have the problem that my database instance is not started automatically with the os. when i have a look at the services everything is fine and labeled as started (OracleServiceARTS3). when i am trying to start the database instance manually with sqlplus everything works perfectly and the database is mounted and opened as it should be. the tnsnames.ora file as i suppose is well configured as the tnsping is working properly. tnsnames.ora:
ARTS3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = int.zh.uptime.ch)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = arts3.int.zh.uptime.ch)
)
)
the registry has an entry like this:
ORA_ARTS3_AUTOSTART = TRUE
so that i must suppose that the database should start after rebooting the system. what can i tell you more... the environment is also set correctly with ORACLE_HOME and ORACLE_SID. i really do not habe any idea what the problem could be. last but not least i found the following entry in the oradim.log file:
Fri Sep 23 10:55:00 2005
C:\oracle\product\10.1.0\db_limmi_001\bin\oradim.exe -startup -sid arts3 -usrpwd * -log oradim.log -nocheck 0
Fri Sep 23 10:55:00 2005
ORA-12560: TNS:protocol adapter error
i must confess that i do not really understand this error as the tnsnames.ora file is well configured in my opinion. when i try to execute oradim.exe as it is shown in the path above everything works perfectly. so the confusion is getting bigger and bigger...
is there someone who can help me with this issue? thanks for help...
regards,
patrick.