Hi Scott, Yes, I've made sure that they are. My password files for both databases also have the same password. Thanks -- mohammed On Mon, Oct 13, 2014 at 4:04 PM, Deas, Scott <Scott.Deas@xxxxxxx> wrote: > Looking through some old notes (which may or may not be correct), the > sys passwords for both databases need to be the same. > > > > Thanks, > Scott > > > > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Mohammed Bhatti > *Sent:* Monday, October 13, 2014 3:54 PM > *To:* oracle-l-freelists > *Subject:* RMAN Duplicate Errors > > > > Hi Folks, > > Got a question regarding RMAN duplicate. I have an 11.2.0.3.0 2-node RAC > on ASM running on RHEL 5.9. I'm trying to duplicate this database to > another 2-node RAC database that I have already created on the same server. > > My target is DB01 and my auxiliary is DB02. > > I did the following steps (numerous times): > > Step 1 > > Create shell db, DB02 using dbca on ASM as a 2-RAC db > > Step 2 > > Backup this db > > Step 3 > > Follow note MOS Note ID: 1076656.1 and change sid name, db_name, > tnsnames.ora entry and listener.ora to uppercase. > > On DB02, change all entries from db021 and db022 to DB021 and DB022 as > suggested by MOS Note ID 1076656.1. The shutdown my auxiliary DB02 and > create a new spfile: > create spfile from pfile='initDB02.for_clone.ora' > > > > Step 4 > > Run the duplicate command as follows: > rman target sys/welcome1@db01 auxiliary sys/welcome1@db02 > > DUPLICATE TARGET DATABASE TO S70OAM FROM ACTIVE DATABASE; > > And here's the snipped output from the above command: > executing Memory Script > > sql statement: alter system set control_files = > ''+REDO/db02/controlfile/current.282.860849203'' comment= ''Set by RMAN'' > scope=spfile > > sql statement: alter system set db_name = ''DB01'' comment= ''Modified > by RMAN duplicate'' scope=spfile > > sql statement: alter system set db_unique_name = ''DB02'' comment= > ''Modified by RMAN duplicate'' scope=spfile > > Oracle instance shut down > > RMAN-00571: =========================================================== > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== > RMAN-00571: =========================================================== > RMAN-03002: failure of Duplicate Db command at 10/13/2014 12:46:58 > RMAN-06174: not connected to auxiliary database > RMAN-03015: error occurred in stored script Memory Script > RMAN-04006: error from auxiliary database: ORA-01031: insufficient > privileges > > RMAN> exit > > Here's my tnsnames.ora file: > DB01 = > (DESCRIPTION = > (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.102.1)(PORT = 1521)) > (CONNECT_DATA = > (SERVER = DEDICATED) > (SERVICE_NAME = db01) > ) > ) > > DB02 = > (DESCRIPTION = > (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.102.1)(PORT = 1521)) > (CONNECT_DATA = > (SERVER = DEDICATED) > (SERVICE_NAME = DB02) > (UR=A) > ) > ) > > Here's my listener.ora from the grid home: > SID_LIST_LISTENER = > (SID_LIST = > ) > (SID_DESC = > (GLOBAL_DBNAME = DB02) > (ORACLE_HOME = /u01/app/oracle/product/11.2.0.3/dbhome_1) > (SID_NAME = DB02) > ) > ) > > My password file is named: > spfileDB021.ora > > > > Before proceeding with these steps, I was able to connect to both DB01 and > DB02 using the tnsnames entry DB01 and DB02 e.g. > sqlplus sys@DB02 as sysdba > > rman target sys/welcome1@DB02 > > Before I open a support ticket, any suggestions as to what I'm doing > wrong? Have I missed anything? > > Thanks > > -- > > mohammed > > Notice of Confidentiality: **This E-mail and any of its attachments may > contain > Lincoln National Corporation proprietary information, which is privileged, > confidential, > or subject to copyright belonging to the Lincoln National Corporation > family of > companies. This E-mail is intended solely for the use of the individual or > entity to > which it is addressed. If you are not the intended recipient of this > E-mail, you are > hereby notified that any dissemination, distribution, copying, or action > taken in > relation to the contents of and attachments to this E-mail is strictly > prohibited > and may be unlawful. If you have received this E-mail in error, please > notify the > sender immediately and permanently delete the original and any copy of > this E-mail > and any printout. Thank You.** >