ora-1031解决一例

      今天建立了一个测试环境，打算再次测试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/archive/2008/01/25/1053361.html