select status,error from v$archive_dest where dest_id=2;
STATUS ERROR
--------- -----------------------------------------------------------------
ERROR ORA-12514: TNS:listener does not currently know of service
requested in connect descriptor
SYS@prod> /
STATUS ERROR
--------- -----------------------------------------------------------------
ERROR ORA-12514: TNS:listener does not currently know of service
requested in connect descriptor
SYS@prod> /
STATUS ERROR
--------- -----------------------------------------------------------------
ERROR ORA-12514: TNS:listener does not currently know of service
requested in connect descriptor
SYS@prod> /
STATUS ERROR
--------- -----------------------------------------------------------------
ERROR ORA-16191: Primary log shipping client not logged on standby
把主库的密码文件复制到从库,
主库和从库的 sqlnet.ora 文件中的
SQLNET.AUTHENTICATION_SERVICES
这一行注释掉
SYS@prod> select status,error from v$archive_dest where dest_id=2;
STATUS ERROR
--------- -----------------------------------------------------------------
VALID