Home » RDBMS Server » Server Administration » Remove defunct/unused Oracle services in Windows XP
Remove defunct/unused Oracle services in Windows XP [message #192819] Wed, 13 September 2006 15:30 Go to next message
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,
Re: Remove defunct/unused Oracle services in Windows XP [message #192821 is a reply to message #192819] Wed, 13 September 2006 15:41 Go to previous messageGo to next message
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
Re: Remove defunct/unused Oracle services in Windows XP [message #192946 is a reply to message #192819] Thu, 14 September 2006 06:09 Go to previous messageGo to next message
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
Re: Remove defunct/unused Oracle services in Windows XP [message #192969 is a reply to message #192821] Thu, 14 September 2006 07:23 Go to previous messageGo to next message
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

icon7.gif  Re: Remove defunct/unused Oracle services in Windows XP [message #192970 is a reply to message #192946] Thu, 14 September 2006 07:25 Go to previous messageGo to next message
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

icon9.gif  Re: Remove defunct/unused Oracle services in Windows XP [message #192978 is a reply to message #192946] Thu, 14 September 2006 07:52 Go to previous messageGo to next message
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,
Re: Remove defunct/unused Oracle services in Windows XP [message #193005 is a reply to message #192978] Thu, 14 September 2006 09:30 Go to previous messageGo to next message
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.
Re: Remove defunct/unused Oracle services in Windows XP [message #193070 is a reply to message #192819] Thu, 14 September 2006 14:47 Go to previous messageGo to next message
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
Re: Remove defunct/unused Oracle services in Windows XP [message #193247 is a reply to message #193070] Fri, 15 September 2006 07:27 Go to previous messageGo to next message
Henry_VA
Messages: 12
Registered: September 2006
Location: Northern VA
Junior Member
Sandeep,
Thank you for your assistance. Have a good day.
Henry,
icon4.gif  Re: Remove defunct/unused Oracle services in Windows XP [message #197106 is a reply to message #192819] Tue, 10 October 2006 01:48 Go to previous messageGo to next message
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
Re: Remove defunct/unused Oracle services in Windows XP [message #197152 is a reply to message #197106] Tue, 10 October 2006 05:03 Go to previous messageGo to next message
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.
Re: Remove defunct/unused Oracle services in Windows XP [message #197908 is a reply to message #192819] Fri, 13 October 2006 04:37 Go to previous message
samjose
Messages: 2
Registered: October 2006
Location: Mumbai
Junior Member
It worked.

Thank you Ebrian.

Warm Regards,

Shaiju
Previous Topic: the oracle9i jvm version
Next Topic: grant problems
Goto Forum:
  


Current Time: Wed Dec 07 14:51:50 CST 2016

Total time taken to generate the page: 0.14333 seconds