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”

About these ads

One Response to SID_XPT Service Generated On Listener

  1. Paul says:

    Usefull! I never looked what this was until now. There’s also a XDB service when you install XML DB.
    This is expained here:
    http://download.oracle.com/docs/cd/E11882_01/server.112/e10595/manproc003.htm#i1007216

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: