My Oracle Support Banner

Need To Create A Service For The Pluggable Database Without The Network Name - Exadata Cloud at Customer (Doc ID 2555497.1)

Last updated on DECEMBER 19, 2019

Applies to:

Oracle Database Exadata Cloud Machine - Version N/A to N/A
Generic (Platform Independent)
Exadata Cloud at Customer

Goal

I created two services to my pluggable database.

exec dbms_service.CREATE_SERVICE('dev_test1','dev_test1');
exec dbms_service.CREATE_SERVICE('dev_test22','dev_test22');
exec dbms_service.start_service('dev_test22');
exec dbms_service.start_service('dev_test1');


But when I checked the listener the services are there but with
us1.ocm.sXXXXXX.oraclecloudatcustomer.com added to the end.

So when I connect using ezconnect I have to specify long name
 (dev_test22.us1.ocm.sXXXXXX.oraclecloudatcustomer.com) to connect.

I want service name as "dev_test1" as I created.

Service "dev_test22.us1.ocm.sXXXXXX.oraclecloudatcustomer.com" has 1 instance(s).
  Instance "devcon1", status READY, has 1 handler(s) for this service...
Service "dev_test1.us1.ocm.sXXXXXX.oraclecloudatcustomer.com" has 1 instance(s).
  Instance "devcon1", status READY, has 1 handler(s) for this service...

 we need is a shorter service name, instead of   .us1.ocm.sXXXXXX.oraclecloudatcustomer.com.  Users are complaining about the long service name
 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.