SID_XPT Service Generated On Listener

Created a new Oracle 10g (10.2.0.3) database on a Solaris 10 (64-bit) server this morning. I noticed when I reviewed the status of the Listener, there was a peculiar service registered that I didn’t expect.

% lsnrctl status

Services Summary…
Service “d103″ has 1 instance(s).
Instance “d103″, status READY, has 1 handler(s) for this service…
Service “d103_XPT” has 1 instance(s).
Instance “d103″, status READY, has 1 handler(s) for this service…
The command completed successfully

Searching on Metalink, I found Metalink Note 339940.1 - “How to stop the _XPT service from registering with the listener”. It explains why this service appears.

In version 10.2 of the RDBMS when an instance registers with its listeners it will register a service with the name <sid>_XPT (e.g. v102_XPT) in addition to the normal service names.

This service does not cause a problem and is intended for use within Data Guard environments.

The Note also explains how to resolve the issue.

In the init.ora file for the instance set,

__dg_broker_service_names=”

Please note that this setting begins with two underscore characters. The instance will need to be restarted for this to take effect.

As suggested, I added the parameter to my init.ora and restarted the database instance. No more XPT service registered.

% lsnrctl status

Services Summary…
Service “d103″ has 1 instance(s).
Instance “d103″, status READY, has 1 handler(s) for this service…
The command completed successfully

References
Metalink Forum ID 611575.993 - “<SID>_XPT service dynamically registered”