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

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.,

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.

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

Hope this post helps. Thanks for visiting 🙂