ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

在主库查询  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;
 
 
原文地址:https://www.cnblogs.com/l10n/p/9407250.html