OraFAQ Forum: Windows » Oracle Service on Win 2000

Home » Infrastructure » Windows » Oracle Service on Win 2000

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Service on Win 2000 [message #99594]

Mon, 21 January 2002 22:36

VijayaKrishna
Messages: 1
Registered: January 2002

Junior Member

Hello Everyone,

I am facing a problem with Oracle service on Windows 2000 server o/s.

The Problem is : sometimes when i restrat the system the Oracle service instance is not gettting started automatically eventhough its set as Automatic, and i need to go to DBA Studio GUI to start the database instance with SYSDBA privilege. My Oracle is 8.1.6 , Please help me how to solve this problem. This is the second time am facing this problem. When i faced this problem for the first time, while restarting automatically CHKDISK was executed and this problem was solved , but now its not running CHKDSK. In services list the service related to ORACLE is shown as 'Starting' and its not completely getting started.

Thaks in advance for the replies.

Report message to a moderator

Re: Oracle Service on Win 2000 [message #99597 is a reply to message #99594]

Tue, 22 January 2002 05:17

Paul Evans
Messages: 2
Registered: January 2002

Junior Member

Check your registry settings at the following location:
HKEY_LOCAL_MACHINESOFTWAREORACLEHOME0
You will have a number of settings but the two you need to check are:
ORA_(SID)_AUTOSTART should be set to True
and
ORA_(SID)_PFILE should hold the correct path for the init(SID).ora file for the database (SID being the name of the database). If either are wrong, to change them right-click and click Modify then insert the correct value. If you have more than one database running on the same server, you will have more than one HOME entry in this area of the registry (HOME0, HOME1, HOME2, etc). You need to check entries for each one. It is always a good idea to take an export of the registry before changing any settings.
Hope this helps.

Report message to a moderator

Re: Oracle Service on Win 2000 [message #100059 is a reply to message #99594]

Tue, 02 July 2002 06:43

Mark
Messages: 284
Registered: July 1998

Senior Member

Thanks a lot 4 your help. U're a great!!!

Report message to a moderator

Previous Topic:	Re: Installation Problems of Developer2000 on Windows 2000/NT
Next Topic:	Problems with starting database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 14 05:06:29 CDT 2025