High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Using DBMS_SERVICE for DataGuard on Oracle 12c

Hi,

In Oracle 11g Data guard configuration, I created SERVICE_NAME using DBMS_SERVICE.

dbms_service.create_service('lpm_prod', 'lpm_prod');

dbms_service.start_service('lpm_prod'); 

'lpm_prod' service appared in v$active_services and dba_services

In TNSNAMES, I have:

L_MV5.WORLD =

(DESCRIPTION =

 (ADDRESS_LIST =

  (ADDRESS = (PROTOCOL = TCP)(HOST = SV-PROD)(PORT = 1521))

  (ADDRESS = (PROTOCOL = TCP)(HOST = SV-BACKUP)(PORT = 1521))

 )

 (CONNECT_DATA =

   (SERVICE_NAME = lpm_prod)

 )

 ) 

In worked fine in Oracle11g, but in Oracle 12c, this doesn't work any more, when I tried to connect I got ORA-12514 error.

Someone has an idea, what is the problem ?

Thanks.

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