DataGuard:ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Please check service name and db_uniquie_name on the Production server.

alter system set log_archive_dest_3=’SERVICE=  < NAME >  VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) LGWR ASYNC DB_UNIQUE_NAME= <Name>’ ;

Hits: 2

Leave a Reply

Your email address will not be published. Required fields are marked *