How to Stop the <sid>_XPT Service from Registering with the Listener (Doc ID 339940.1)

Last updated on OCTOBER 07, 2011

Applies to:

Oracle Net Services - Version: 10.2.0.1.0 to 10.2.0.5 - Release: 10.2 to 10.2
Information in this document applies to any platform.
Checked for relevance on 08-OCT-2011.

Goal

The purpose of this article is to explain how to stop the <sid>_XPT (e.g. v102_XPT) service from being automatically registered with a listener.

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.

This <sid>_XPT service name is not defined in the SERVICE_NAMES setting so it is not obvious how to suppress it for the sake of clarity in non-Data Guard systems.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms