In Oracle : XPT Oracle database service

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle DBA

Real Application Cluster (RAC) Maintenance tasks Backup and Recovery Database Architecture Replication Oracle Performance Tuning Oracle DBA - Other articles Oracle scripts/ Selects for DBA Oracle Errors (ORA-nnnnn)

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle DBA -> Oracle Database Architecture

-> XPT Oracle database service

 

 XPT Oracle database service

 

 

Here is the services which are registered with my listener on my database:

C:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 21-AUG-2010 09:57:18

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 21-AUG-2010 09:07:56
Uptime 0 days 0 hr. 49 min. 23 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\Oracle10g\OH\network\admin\listener.ora
Listener Log File D:\Oracle10g\OH\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cata1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "myDB_XPT" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...

Service "mydb" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...

The command completed successfully

 

 

myDB_XPT service is used for the data guard and can be disabled in a non-dataguard environment.

 

This can be done by adding

       __dg_broker_service_names=''     in the pfile or altering the spfile:
    alter system set "__dg_broker_service_names" = '' scope=spfile;
    
    Note: When you add a hidden parameter in the pfile (or spfile) please consult Oracle Metalink 
    or ask the permision of an Oracle consultant before.
    
    I modified the pfile I used and here is the result (the database was restarted):

             
C:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 21-AUG-2010 10:40:12

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 21-AUG-2010 09:07:56
Uptime 0 days 1 hr. 32 min. 17 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\Oracle10g\OH\network\admin\listener.ora
Listener Log File D:\Oracle10g\OH\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cata1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "mydb" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...

The command completed successfully

 

 

Note:

 

Oracle provides the ability to call operating system commands from PL/SQL with the feature external procedure calls (starting from Oracle8).

This can be done using the PLSExtProc Oracle database service. For using this service you must configure your listener (in ORACLE_HOME/network/admin/listener.ora) to start the PLSExtProc service:

 

SID_LIST_LISTENER =
          (SID_LIST =
              (SID_DESC =
                      (SID_NAME = PLSExtProc)
                      (ORACLE_HOME = D:\Oracle10g\OH)
                      (PROGRAM = extproc)
               )
           )

 

If the listener.ora is not configured for the PLSExtProc service, you will not be able to run the externel procedures from the Oracle database.

 

 

 

Related links:

  1. Oracle Database Listener  (Q&A)

  2. PLSExtProc Oracle database service

 

In-Oracle.com  -> Oracle DBA -> Oracle Database Architecture

-> XPT Oracle database service

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.