ora1031解决一例

      今天建立了一个测试环境,打算再次测试logical standby的建制。在建制物理standby时,发现archive log无法
传递到standby,手工可以。察看log,发现如下错误:

Errors in file c:\oracle\product\10.2.0\admin\it\bdump\it_arcp_2116.trc:
ORA-01031: insufficient privileges

PING[ARCp]: Heartbeat failed to connect to standby 'its'. Error is 1031.

权限问题?哦,standby没有生成密码文件。立刻生成密码文件.
SQL>shutdown database
SQL>connect sys as sysdba
SQL>startup mount
SQL>recover managed standby database disconnect from session;
很快,archive log传递过来了。呵呵!

原文地址:https://www.cnblogs.com/kevinsun/p/1053361.html