Cause: Oracle password file does not exist in $ORACLE_HOME/dbs directory of AUXILIARY (Standby) Database.
Solution : Copy password file from primary database directory ($ORACLE_HOME/dbs) to AUXILIARY (Standby) Database directory ($ORACLE_HOME/dbs).
[oracle@bcbldb01 dbs]$ rman TARGET sys/oracle@DCCBSDB AUXILIARY sys/oracle@DCCBSDBDR
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jul 9 17:23:34 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: DCCBSDB (DBID=2308296244)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges
[oracle@drdb1 dbs]$ ls -ltr
total 16
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r--r-- 1 oracle oinstall 1536 Jun 17 13:30 orapwdccbsdb
-rw-r--r-- 1 oracle oinstall 1776 Jul 9 17:02 initdccbsdbdr.ora
-rw-rw---- 1 oracle oinstall 1544 Jul 9 17:21 hc_dccbsdbdr.dat
[oracle@drdb1 dbs]$ mv orapwdccbsdb orapwdccbsdbdr
[oracle@drdb1 dbs]$ ls -ltr
total 16
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r--r-- 1 oracle oinstall 1536 Jun 17 13:30 orapwdccbsdbdr
-rw-r--r-- 1 oracle oinstall 1776 Jul 9 17:02 initdccbsdbdr.ora
-rw-rw---- 1 oracle oinstall 1544 Jul 9 17:21 hc_dccbsdbdr.dat
[oracle@drdb1 dbs]$ mv orapwdccbsdb orapwdccbsdbdr
[oracle@bcbldb01 dbs]$ rman TARGET sys/oracle@DCCBSDB AUXILIARY sys/oracle@DCCBSDBDR
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jul 9 17:35:34 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: DCCBSDB (DBID=2308296244)
connected to auxiliary database: DCCBSDB (not mounted)
Solution : Copy password file from primary database directory ($ORACLE_HOME/dbs) to AUXILIARY (Standby) Database directory ($ORACLE_HOME/dbs).
[oracle@bcbldb01 dbs]$ rman TARGET sys/oracle@DCCBSDB AUXILIARY sys/oracle@DCCBSDBDR
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jul 9 17:23:34 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: DCCBSDB (DBID=2308296244)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges
[oracle@drdb1 dbs]$ ls -ltr
total 16
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r--r-- 1 oracle oinstall 1536 Jun 17 13:30 orapwdccbsdb
-rw-r--r-- 1 oracle oinstall 1776 Jul 9 17:02 initdccbsdbdr.ora
-rw-rw---- 1 oracle oinstall 1544 Jul 9 17:21 hc_dccbsdbdr.dat
[oracle@drdb1 dbs]$ mv orapwdccbsdb orapwdccbsdbdr
[oracle@drdb1 dbs]$ ls -ltr
total 16
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r--r-- 1 oracle oinstall 1536 Jun 17 13:30 orapwdccbsdbdr
-rw-r--r-- 1 oracle oinstall 1776 Jul 9 17:02 initdccbsdbdr.ora
-rw-rw---- 1 oracle oinstall 1544 Jul 9 17:21 hc_dccbsdbdr.dat
[oracle@drdb1 dbs]$ mv orapwdccbsdb orapwdccbsdbdr
[oracle@bcbldb01 dbs]$ rman TARGET sys/oracle@DCCBSDB AUXILIARY sys/oracle@DCCBSDBDR
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jul 9 17:35:34 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: DCCBSDB (DBID=2308296244)
connected to auxiliary database: DCCBSDB (not mounted)
No comments:
Post a Comment