about XDB service issue [message #547092] |
Mon, 12 March 2012 04:38 |
andy huang
Messages: 498 Registered: July 2011
|
Senior Member |
|
|
Dear all,
I have not configure the service orclXDB,why does it show in the status command?
Service "orclXDB" has 1 instance(s).
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=huangxueliang)(PORT=152
)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Prod
ction
Start Date 12-MAR-2012 17:11:41
Uptime 0 days 0 hr. 22 min. 54 sec
Trace Level off
Security ON: Password or Local OS Authentication
SNMP OFF
Listener Parameter File d:\oracle\product\11.2.0\dbhome_1\network\admin\liste
er.ora
Listener Log File d:\oracle\product\11.2.0\dbhome_1\log\diag\tnslsnr\hu
ngxueliang\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=huangxueliang)(PORT=1521)))
Services Summary...
Service "ORCL" has 2 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "mydb" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
|
|
|
|
|
|
|
Re: about XDB service issue [message #547161 is a reply to message #547120] |
Tue, 13 March 2012 03:13 |
andy huang
Messages: 498 Registered: July 2011
|
Senior Member |
|
|
hi,
Michel,i can not stop the service oracleXDB,how can i do?
Begin
2 dbms_service.stop_service('oraclXDB');
3 End;
4 /
PL/SQL procedure successfully completed.
Begin
dbms_service.delete_service('oraclXDB');
3 End;
4 /
Begin
*
ERROR at line 1:
ORA-44305: service oraclXDB is running
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SERVICE", line 434
ORA-06512: at "SYS.DBMS_SERVICE", line 323
ORA-06512: at line 2
|
|
|
|
Re: about XDB service issue [message #547166 is a reply to message #547162] |
Tue, 13 March 2012 03:53 |
andy huang
Messages: 498 Registered: July 2011
|
Senior Member |
|
|
Thanks,
The listener file can not contain the xdb service.
[oracle@hxl admin]$ more listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = oracl)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = oracl)
)
(SID_DESC =
(GLOBAL_DBNAME = oraclbak)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = oraclbak)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hxl)(PORT = 1521))
)
|
|
|
Re: about XDB service issue [message #547170 is a reply to message #547166] |
Tue, 13 March 2012 04:25 |
andy huang
Messages: 498 Registered: July 2011
|
Senior Member |
|
|
hi,
Michel,i have remove the XDB service by setting the parameters dispatchers to null. but there is a XPT service,how can i to remove it?
set the dispatchers to null
SQL> show parameters dispatchers;
NAME TYPE VALUE
------------------------ ------------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=oraclX
DB)
max_dispatchers integer
SQL>
SQL> alter system set dispatchers='' scope=both;
System altered.
but there is a XPT service,i want to remove it.
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hxl)(PORT=1521)))
Services Summary...
Service "oracl" has 2 instance(s).
Instance "oracl", status UNKNOWN, has 1 handler(s) for this service...
Instance "oracl", status READY, has 1 handler(s) for this service...
Service "oracl_XPT" has 1 instance(s).
Instance "oracl", status READY, has 1 handler(s) for this service...
Service "oraclbak" has 1 instance(s).
Instance "oraclbak", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
|
|
|