OraFAQ Forum: Server Administration » HELP!!

Home » RDBMS Server » Server Administration » HELP!! - Missing DB service

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

HELP!! - Missing DB service [message #53870]

Tue, 15 October 2002 10:43

Steve Giamalis
Messages: 6
Registered: October 2002

Junior Member

I had an Oracle instance with SID=DAT9 running on a Windows 2000 server and being used by people in my company. No one has used it recently, but tried today and the instance was not available.

I checked the services on the server, and the service for the instance is not listed. All datafiles are still present. SID is listed in tnsnames and listener.ora.

I have no idea what to do and need to recover from this immediately as I need this database for a Europe trip at the end of the week.

Can anyone help?

Report message to a moderator

Re: HELP!! - Missing DB service [message #53871 is a reply to message #53870]

Tue, 15 October 2002 10:44

Steve Giamalis
Messages: 6
Registered: October 2002

Junior Member

Also - This is Oracle 8.1.7

Report message to a moderator

Re: HELP!! - Missing DB service [message #53873 is a reply to message #53870]

Tue, 15 October 2002 10:50

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

did u try to retstart the service and listener?
wat was the error?

Report message to a moderator

Re: HELP!! - Missing DB service [message #53875 is a reply to message #53870]

Tue, 15 October 2002 11:20

Steve Giamalis
Messages: 6
Registered: October 2002

Junior Member

I did stop and restart the listener. The service is physically not in the machine's services list for me to attempt to stop and restart. It's just not there. I have SIDS DAT1 - DAT9 on the machine and the services for DAT1 - DAT7 are the only ones appearing in the services window since the last reboot.

Report message to a moderator

Re: HELP!! - Missing DB service [message #53877 is a reply to message #53870]

Tue, 15 October 2002 11:44

Steve Giamalis
Messages: 6
Registered: October 2002

Junior Member

I do have 9 instances on the machine, but never have more than 4 or 5 active at once.

svrmgrl is giving my TNS error messages since the database service physically does not seem to exist, as near as I can tell.

Report message to a moderator

Re: HELP!! - Missing DB service [message #53886 is a reply to message #53870]

Wed, 16 October 2002 05:04

Steve Giamalis
Messages: 6
Registered: October 2002

Junior Member

Thanks for the help. We manually went into the registry andadded the keys back in the machine's services list to start the instance and it came up when I rebooted.

Report message to a moderator

Re: HELP!! - Missing DB service [message #53889 is a reply to message #53870]

Wed, 16 October 2002 05:20

Steve Giamalis
Messages: 6
Registered: October 2002

Junior Member

Thanks for the help. We manually went into the registry andadded the keys back in the machine's services list to start the instance and it came up when I rebooted.

Report message to a moderator

Previous Topic:	Extent rollback segment (ora 1562)
Next Topic:	standred package

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 16:48:13 CDT 2024