在主库查询 SELECT DEST_ID,ERROR FROM V$ARCHIVE_DEST where rownum<3;
报错如下：
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
解决办法：
alter system set local_listener=‘(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.56)(PORT=1521))‘ scope=both;
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
原文：https://www.cnblogs.com/liang545621/p/9407250.html
