Home » RDBMS Server » Server Administration » about XDB service issue (10.2.0.1)
about XDB service issue [message #547092] Mon, 12 March 2012 04:38 Go to next message
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 #547094 is a reply to message #547092] Mon, 12 March 2012 04:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Internal Oracle service for XDB.

Regards
Michel

[Updated on: Mon, 12 March 2012 04:45]

Report message to a moderator

Re: about XDB service issue [message #547099 is a reply to message #547094] Mon, 12 March 2012 05:02 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,
How can i remove it?
Re: about XDB service issue [message #547101 is a reply to message #547099] Mon, 12 March 2012 05:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use dbms_service (see your previous topic).

Regards
Michel
Re: about XDB service issue [message #547120 is a reply to message #547101] Mon, 12 March 2012 07:16 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks!
Re: about XDB service issue [message #547161 is a reply to message #547120] Tue, 13 March 2012 03:13 Go to previous messageGo to next message
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 #547162 is a reply to message #547161] Tue, 13 March 2012 03:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If the service is declared in listener.ora then remove it and reload (or maybe restart) the listener.
If you don't use xmldb features or web service then better uninstall them.

Regards
Michel
Re: about XDB service issue [message #547166 is a reply to message #547162] Tue, 13 March 2012 03:53 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: service_name issue
Next Topic: Partition Exchange in Hash Partitioned Table
Goto Forum:
  


Current Time: Fri Nov 08 06:25:14 CST 2024