Admin/admin

10g listener service XDB,_XPT

Qhtlr 2010. 2. 24. 11:22

"orclXDB" is needed for XML database, and is set by DISPATCHERS initialization parameter. Try, as sysdba
SQL> show parameter DISPATCHERS

"orcl_XPT" : in 10g a service with name <sid>_XPT is automatically configured in addition to normal service names, and is intended for use within Data Guard environments.

alter sytem set "__dg_broker_service_names" = '' ;

히든파라미터 보기
set lines 140
col parameter format a20
col DESCRIPTION format a50
col SESSION_VALUE  format a15
col INSTANCE_VALUE format a15
SELECT   a.ksppinm parameter
        ,a.ksppdesc description
        ,b.ksppstvl session_value
        ,c.ksppstvl instance_value
    FROM x$ksppi a
        ,x$ksppcv b
        ,x$ksppsv c
   WHERE a.indx = b.indx AND a.indx = c.indx AND SUBSTR (a.ksppinm
                                                        ,1
                                                        ,1
                                                        ) = '_'
   and a.ksppinm like '%_dg_broker%'
ORDER BY a.ksppinm;