ORA-17629 ORA-17627 ORA-01031

        windows oracle 11g 使用duplicate target database for standby from active database;报错

 

启动 backup 于 03-4月 -13
使用通道 ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: Duplicate Db 命令 (在 04/03/2013 00:58:13 上) 失败
RMAN-05501: 终止复制目标数据库
RMAN-03015: 在存储的脚本Memory Script中出现错误
RMAN-03009: backup 命令 (ORA_DISK_1 通道上, 在 04/03/2013 00:58:13 上) 失败
ORA-17629: 无法连接到远程数据库服务器
ORA-17627: ORA-01031: insufficient privileges
ORA-17629: 无法连接到远程数据库服务器

 

解决方式：

                 无论是手工创建密码文件，还是复制主库的复制密码文件，依然报错，使用rman和本地connect as sysdba是可以的，由于使用这样方式，必须通过密码文件，需要使用服务名的方式连接数据库，所以一直无法复制文件过来，查询官方文档后，发现是密码文件的位置放的不对，可以手工修改注册表执行密码文件的位置或是放到默认的路径The default location ( %ORACLE_HOME%/database)----------这与linux不同，linux是放在dbs下，将密码文件放置到database路径，问题解决

ID 730067.1

https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=262344315469608&id=730067.1&_afrWindowMode=0&_adf.ctrl-state=12rk2lr2z7_70

On Windows

The default location of the password file on Windows is folder %ORACLE_HOME%/database and the name of the password file must be pwd<%ORACLE_SID%>.ora. When the passwordfile authentication is being used Oracle searches for the password file in the following locations(in this exact order):

1. The folder pointed to by the registry key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HomeXX\ORA_<%ORACLE_SID%>_PWFILE
2. The folder pointed to by the registry key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HomeXX\ORA_PWFILE
3. The default location ( %ORACLE_HOME%/database)

 

Note: Make sure that the password file exists in the folder specified by the registry keys if these are set.