RMAN

After Upgrading from Oracle 11.2.0.4 to Oracle 12.1.0.2 Could not enter in to RMAN prompt – RMAN-00554 RMAN-03000 RMAN-06001 RMAN-01009 RMAN-01008 RMAN-01007

By September 24, 2015 September 12th, 2016 One Comment

I upgraded my Oracle Database from Oracle version 11.2.0.4 to Oracle version 12.1.0.2 using the DBUA (Database Upgrade Assistant). My upgrade completed successfully without any errors. My application is also working fine.

The day completed and my new Oracle 12c database was running fine with any issues. As we DBAs do, I tried to backup my database using the RMAN. So executed the command rman to enter in to the RMAN prompt. But ended up with the below error.,

<hostname>:/oracle/<DBSID>/121/rdbms/admin 80> rman

Recovery Manager: Release 12.1.0.2.0 – Production on Wed Sep 23 08:20:40 2015

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-03000: recovery manager compiler component initialization failed
RMAN-06001: error parsing job step library
RMAN-01009: syntax error: found “identifier”: expecting one of: “”
RMAN-01008: the bad identifier was: raschemaversion
RMAN-01007: at line 17 column 1 file: ?/rdbms/admin/recover.bsq

 

Note: I don’t have any recovery catalog configured.

 

After the upgrade, all the post upgrade tasks are completed successfully. I also executed the catalog.sql and catproc.sql once again and tried to enter in to the RMAN prompt, but no luck.

 

Later on analysing the issue and checking the alert logs, I just thought whether the Oracle Binaries were properly merged with the Operating System. Here my operating system is IBM Aix 7.1 64 bit.

 

SOLUTION:

I tried to relink all the Oracle Binaries using the command relink all. It worked for me.

<hostname>: $ORACLE_HOME/bin> ./relink all

The relink all command was successfully completed. Now I tried to enter in to the RMAN prompt.,

<hostname>:> rman

Recovery Manager: Release 12.1.0.2.0 – Production on Wed Sep 23 08:20:40 2015

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

RMAN>

 

Hope this post helps. Thanks for visiting 🙂

One Comment

Leave a Reply

© 2020 ORACLE-SCN. All Rights Reserved.

error: Content is protected !!