Thursday 9 May 2013

RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges

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> 








6 comments:

  1. Nice Post! sometimes the smallest things cause the biggest headaches...

    ReplyDelete
  2. Thanks a lot for this post!
    I was stuck at this error while cloning

    ReplyDelete
  3. Awesome post! Thank you.

    ReplyDelete
  4. I was also stuck whiling cloning but this post really help me out. Thnaks

    ReplyDelete
  5. Thank you, It was my problem too!

    ReplyDelete
  6. Bet365 casino app review & bonus codes - JT Hub
    Is bet365 경기도 출장샵 safe or scam? How 인천광역 출장샵 does 당진 출장마사지 Bet365 offer live betting? How does Bet365 파주 출장마사지 live betting work? 상주 출장샵 Bet365 casino app review & bonus codes.

    ReplyDelete