RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges
I encountered this error while connecting to an auxiliary database.
[oracle@test1 admin]$ rman target sys/oracle@testdb_source auxiliary sys/oracle@testdb_destination
Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 9 21:28:21 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: TESTDB (DBID=2596658962)
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
Here I made one mistake in setting the oracle_sid/db_name. I had added the oracle_sid name in listner.ora file as upper case while in tnsnames.ora and initsid.ora as lower case which was the cause here.
I changed the sid name entry of all the mentioned files in the same case and then tried to connect the auxiliary database, it was successfull at that time.
[oracle@test1 admin]$ rman target sys/oracle@testdb_source auxiliary sys/oracle@testdb_destination
Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 9 21:29:47 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: TESTDB (DBID=2596658962)
connected to auxiliary database (not started)
RMAN>
RMAN>
