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.