 Oracle Service not starting on Windows 2000 [message #136817] |
Sat, 10 September 2005 23:10  |
denu
Messages: 3
Registered: September 2005
Location: India
|
Junior Member |
|
|
Hello There....
I had installed Oracle Personal Edition 8.1.6.0.0 on Windows 2000 Professional Edition. Previously it was working properly. But, all of a sudden after some 15-20 days, it started giving problem.
The problem is that, I am able to start all the other Oracle services, but not able to start the OracleServiceDBNAME. Whenever I start the service manually or automatically, it stays in "Starting" mode and does not completely start.
What might be the problem and its solution?
I would be obliged, if you could help me out, as I have a lot of information stored on the database.
Thanks in Advance,
Regards,
Denis
|
|
|
|
|
|
|
|
|
|
| Re: Oracle Service not starting on Windows 2000 [message #138277 is a reply to message #137482] |
Wed, 21 September 2005 02:32  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Denu as per reply of Frank your database really need more attention but .... do one thing as you are on windows o/s
press ALT+CTL+DEl
than click task manger
In task manager click processes
In that you can see oracle.exe right click it and click end process tree.
than go to your control pannel --> administrative tool --> services and try to start your service oracleservice<sid>
Note:-Sid==> system identifier (i.e.database name)
Note :- dont forget to start listener related services in control pannel 
Hope my given information will be usefull to you.
Regards
Always friend sunilkumar.
[Updated on: Wed, 21 September 2005 02:34] Report message to a moderator |
|
|
|
| Re: Oracle Service not starting on Windows 2000 [message #138283 is a reply to message #138277] |
Wed, 21 September 2005 03:17 |
Jay Munshi
Messages: 30
Registered: July 2004
|
Member |
|
|
I dont think it is advisable to kill oracle.exe process. it could cause corruption of the database creating further complications.
To shutdown the database login to internal/oracle from the sql prompt and issue "shutdown immediate".
to recover the database there are commands that you can fire from sqlplus and for zero loss requirements you will need to configure database in archive log mode.
Regards,
Jay Munshi
http://jaydba.tripod.com
|
|
|
|
|
|
| Re: Oracle Service not starting on Windows 2000 [message #138295 is a reply to message #138284] |
Wed, 21 September 2005 03:58 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
jay ... see the first post of this question in that it is specified that....
>>The problem is that, I am able to start all the other Oracle services, but not able to start the OracleServiceDBNAME. Whenever I start the service manually or automatically, it stays in "Starting" mode and does not completely start.
>>What might be the problem and its solution?
From above u can see that the database is not started & denu is trying to start it...so better for him to kill the oracle.exe and can take necessary step...
Regard
always friend sunilkumar.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
