DG主机远程连接DG机的时候报错:
SQL> conn sys/oracle@orcldg as sysdba
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
查看密码文件:
SQL> select * from v$pwfile_users;
no rows selected
原来是没有密码文件,做dg的时候,cp密码文件错误了,应该是orapworcl,搞成了orapworcldg。还是有参数不懂的。
搞定:
SQL> conn sys/oracle@orcldg as sysdba
Connected.
SQL>
远程连接,不是操作系统验证的话,就要通过密码文件验证的。