Wednesday, July 16, 2014

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

[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
 
 
Check the listener.ora and tnsnames.ora file for oracle_sid/db_name entry is upper case or lower case .
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@db_source auxiliary sys/oracle@db_destination
Recovery Manager: Release 11.2.0.3.0 - Production on Thu May 10 21:29:47 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: DB (DBID=2596658962)
connected to auxiliary database (not started)
RMAN>
 

3 comments:

  1. Replies
    1. hi anisur
      i amm gettingan issue
      rman target=/ auxiliary=sys/sys@tnschandu1

      Recovery Manager: Release 11.2.0.4.0 - Production on Wed Nov 15 02:01:57 2017

      Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

      connected to target database: CHANDU (DBID=2494320441)
      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-12514: TNS:listener does not currently know of service requested in connect descriptor
      Thanks$Regards
      chandu

      Delete