Database Networking (MOSC)

MOSC Banner

How to register 2 services name : one with a domain name, the 2nd without domain ?

Hello all,

Does anyone know of a way to register 2 services name (I used package DBMS_SERVICE) :

 - one with a domain name,

 - the other without having a domain name appended?


For example, we have a Database (19) DBTEST , the db_domain is "cacao.com"

global_names= FALSE

db_name= DBTEST


I would like to register the service "serv01.cacao.com" and the service "serv02" in our listener.


EXECUTE DBMS_SERVICE.CREATE_SERVICE('serv02','serv02');


SELECT name,network_name FROM dba_services;

   NAME           NETWORK_NAME

   --------------- ----------------------------------------

   SYS$BACKGROUND

   SYS$USERS

   serv01.cacao.com       serv01.cacao.com

   serv02          serv02

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center