OraFAQ Forum: Server Administration » Remove defunct/unused Oracle services in Windows XP

Home » RDBMS Server » Server Administration » Remove defunct/unused Oracle services in Windows XP

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

Remove defunct/unused Oracle services in Windows XP [message #192819]

Wed, 13 September 2006 15:30

Henry_VA
Messages: 12
Registered: September 2006
Location: Northern VA

Junior Member

Hi folks,
I've a need to clean up some defunct/unused services such as:

OracleOraHome92TNSListenerTEST_LNS2
...

'oradim' utility works with remove/delete an Oracle Service for the particular SID, but not for the listener service and others.

Regards,

Report message to a moderator

Re: Remove defunct/unused Oracle services in Windows XP [message #192821 is a reply to message #192819]

Wed, 13 September 2006 15:41

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You need to delete the listener service entry listed in the registry at

HKLM\SYSTEM\CurrentControlSet\Services\OracleOraHome92TNSListenerTEST_LNS2

Report message to a moderator

Re: Remove defunct/unused Oracle services in Windows XP [message #192946 is a reply to message #192819]

Thu, 14 September 2006 06:09

email.sandeepnaik
Messages: 121
Registered: August 2006

Senior Member

you can use instsrv.exe to delete obsolete services.

find it from windows\system32 folder.

Sandeep

Report message to a moderator

Re: Remove defunct/unused Oracle services in Windows XP [message #192969 is a reply to message #192821]

Thu, 14 September 2006 07:23

Henry_VA
Messages: 12
Registered: September 2006
Location: Northern VA

Junior Member

Dear ebrian,
Thanks for your help. It works perfectly. I've a chance to learn about how to backup windows registry, before making a change to it, too.
Regards,

[Updated on: Thu, 14 September 2006 07:55]

Report message to a moderator

Re: Remove defunct/unused Oracle services in Windows XP [message #192970 is a reply to message #192946]

Thu, 14 September 2006 07:25

Henry_VA
Messages: 12
Registered: September 2006
Location: Northern VA

Junior Member

Dear Sandeep,
I'll try this method in the future when I need to do that again . Thanks. Cool

Regards,

[Updated on: Thu, 14 September 2006 07:53]

Report message to a moderator

Re: Remove defunct/unused Oracle services in Windows XP [message #192978 is a reply to message #192946]

Thu, 14 September 2006 07:52

Henry_VA
Messages: 12
Registered: September 2006
Location: Northern VA

Junior Member

Dear Sandeep,
I was looking for it, but I couldn't find this executable, instsrv.exe, in my entire C: drive, my "c:\windows" or "c:\windows\system32" XP directories.
Regards,

Report message to a moderator

Re: Remove defunct/unused Oracle services in Windows XP [message #193005 is a reply to message #192978]

Thu, 14 September 2006 09:30

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You'll need to get it from a Windows Resource Kit, that's why I was hesitant to suggest that method.

Report message to a moderator

Re: Remove defunct/unused Oracle services in Windows XP [message #193070 is a reply to message #192819]

Thu, 14 September 2006 14:47

email.sandeepnaik
Messages: 121
Registered: August 2006

Senior Member

ebrian is correct. This is part of windows resource kit.

However, once you have it, its simple to use. Also, some folks are not comfortable in editing or changing registry. This utility will help those users.

Sandeep

Report message to a moderator

Re: Remove defunct/unused Oracle services in Windows XP [message #193247 is a reply to message #193070]

Fri, 15 September 2006 07:27

Henry_VA
Messages: 12
Registered: September 2006
Location: Northern VA

Junior Member

Sandeep,
Thank you for your assistance. Have a good day.
Henry,

Report message to a moderator

Re: Remove defunct/unused Oracle services in Windows XP [message #197106 is a reply to message #192819]

Tue, 10 October 2006 01:48

samjose
Messages: 2
Registered: October 2006
Location: Mumbai

Junior Member

Hi Guys,

I could find three sets of ControlSet Keys named ControlSet001,ControlSet003 and CurrentControlset. Of these keys I could delete the entries in ControlSet003 and CurrentControlset. When I tried to delete the key named LEGACY_ORACLEORAHOME92TNSLISTENER<SID> in ControlSet001 it gave some error.

Even after deleting the entries in ControlSet003 and CurrentControlset the service didn't get removed from services window too. I request your advice on this matter.

Warm Regards,

Shaiju

Report message to a moderator

Re: Remove defunct/unused Oracle services in Windows XP [message #197152 is a reply to message #197106]

Tue, 10 October 2006 05:03

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You need to reboot for the listener service to be removed completely.

In order to delete the LEGACY registry entry, you need to modify the security settings for that entry in the registry.

Report message to a moderator

Re: Remove defunct/unused Oracle services in Windows XP [message #197908 is a reply to message #192819]

Fri, 13 October 2006 04:37

samjose
Messages: 2
Registered: October 2006
Location: Mumbai

Junior Member

It worked.

Thank you Ebrian.

Warm Regards,

Shaiju

Report message to a moderator

Previous Topic:	the oracle9i jvm version
Next Topic:	grant problems

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:26:27 CDT 2024