Tuesday 15 February 2022

RMAN Duplicate Database fails with ORACLE error from auxiliary database: ORA-00600: internal error code, arguments: [krbi_init_fra_metadata_not_backup_ctl]

 RMAN Duplicate Database fails with ORACLE error from auxiliary database: ORA-00600: internal error code, arguments: [krbi_init_fra_metadata_not_backup_ctl]

Issue: While using RMAN Duplicate Database from Standby Database to clone fails with below error:

ORACLE error from auxiliary database: ORA-00600: internal error code, arguments: [krbi_init_fra_metadata_not_backup_ctl]

This is known bug as per MOS Bug 21641760

However the oracle support gave below suggestion to try and it worked. 


Disable FRA ie
alter system set db_recovery_file_dest='';



RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

 

RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor


Issue:  Trying to clone a database using Duplicate Database from Active Database. 

rman is not able to connect from active database and gives below error:

RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Solution:  

1. Copy the password file from Active database and rename it to match the SID of the clone. 

2. Create a static listener in the listner.ora as shown below 

3 start the listener. 

LISTENER_EBS_2PRE =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = erpdbpreprod1-vip)(PORT = 1571)(IP = FIRST)))

      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = erpdbpreprod1)(PORT = 1571)(IP = FIRST)))

    )

  )


SID_LIST_LISTENER_EBS_2PRE =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = EBS_2PRE)

      (ORACLE_HOME = /u03/app/oracle/product/11.2.0/dbhome_1)

      (SID_NAME = EBS_2PRE1)

    )

  )

4. Test the connection from active database and it should connect the clone database which is in nomount stage. 

connected to target database: SPROD (DBID=xxxxxxx)
connected to auxiliary database: EBS_2PRE (not mounted)

XX_XXXXXXX is not a valid responsibility for the current user. Please contact your System Administrator.

  XX_XXXXXXX is not a valid responsibility for the current user. Please contact your System Administrator. Issue : When user logs into EBS, ...