| oracle service keeps "starting" [message #216031] |
Wed, 24 January 2007 14:21  |
oralex
Messages: 1
Registered: January 2007
Location: Spain
|
Junior Member |
|
|
Hi,
I have Oracle running on Windows 2000 Server, and the Oracle Service and Listener Service start when the machine boots, as usual. Everything was fine, but last day I couldn't get access to the DB.
After searching what was going wrong, I found a log message saying "Oracle not available". Then I took a look at the Windows services running and found that Oracle service was still in the state "Starting" while the listener was already in the state "Started". I waited,waited and waited but the Oracle service keeps "Starting" all the time.
I tried the usual thing, you know, rebooting and rebooting but nothing changes, the service keeps "Starting" all the time.
Since there is no warning messages, even in the Windows alert logs, I am completely lost.
Any clue will be really appreciated
Thanks in advance,
Alex
|
|
|
|
|
|
| Re: oracle service keeps "starting" [message #216386 is a reply to message #216031] |
Fri, 26 January 2007 23:57  |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
Hi,
addition Ebrain suggestion.
when you reboot your system and after windows oracle services started then you have to startup your database with "STARTUP" command.
cmd>set oracle_sid=<sid>
cmd>sqlplus "/ as sysdba"
connected to idle instance.
cmd>startup
regards
Taj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
