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;