本帖最后由 likgui 于 2011-11-8 01:10 编辑
密码设置一样了,在dg1,dg2用
sqlplus / as sysdba@ORCL as sysdba
sqlplus / as sysdba@ORCLSTB as sysdba
是可以登录的,还是报错
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
Thu Jan 16 00:32:04 2014
Error 12154 received logging on to the standby
Errors in file /u01/app/oracle/diag/rdbms/lotest/lotest2/trace/lotest2_arc2_4793.trc:
ORA-12154: TNS:could not resolve the connect identifier specified
PING[ARC2]: Heartbeat failed to connect to standby 'lotstdg1,lgwr'. Error is 12154.