Home » RDBMS Server » Server Administration » remove instance
remove instance [message #150066] Tue, 06 December 2005 02:16 Go to next message
hyundai
Messages: 1
Registered: December 2005
Junior Member
When I check the service running in my PC, I found that 1 service has more than 1 instance. How to remove the instance as it is better to have only 1 instance.

C:\>lsnrctl services

LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 06-NOV-2005 16:03:
43

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
Services Summary...

Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER

Service "NT" has 2 instance(s).
Instance "nt", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Instance "nt", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:4 refused:0 state:ready
LOCAL SERVER

Service "ntXDB" has 1 instance(s).
Instance "nt", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER <machine: CCSERVER1, pid: 3984>
(ADDRESS=(PROTOCOL=tcp)(HOST=CCServer1)(PORT=4017))

The command completed successfully
Re: remove instance [message #157645 is a reply to message #150066] Fri, 03 February 2006 11:09 Go to previous message
aciolac
Messages: 242
Registered: February 2006
Senior Member
This message en general seems that you listener servs two databases. I don't think that there are some problem.
Previous Topic: ORA-24761: transaction rolled back
Next Topic: create standby DB with diff directory structure
Goto Forum:
  


Current Time: Sun Jan 26 13:51:00 CST 2025