This document describes in detail the Steps to fix RMAN-06403: could not obtain a fully authorized session ORA-01034: ORACLE not available error from Oracle Enterprise Manager Cloud Control 12c.
1. The error:
Enterprise Manager Cloud Control backups are failing with the following error;
2. Cause:
The common cause of this error is the Oracle database Home or Oracle SID have been changed , but, the database target has not been modified with the new Oracle Home / Oracle SID.
Let ‘s verify the Database target details;
Go to Database Target > Oracle Database > Target Information
(Click on the image to zoom)
Note The Oracle Home (In This example: /jv01/app/oracle/product/11.2.0/dbhome_1)
(Click on the image to zoom)
Connect to the database server as sysdba and run the following from sqlplus;
3. Solution:
We have confirmed the Oracle database home has been changed. We have 2 solutions;
A- Solution 1:
1) Go to the database instance where job failed.
2) Choose Oracle Database ->Target setup -> monitoring Configuration.
3) Check all the information and make sure you enter the correct Oracle Home.
4) Check the test connection.
5) Save the Monitoring Configuration information
6) Give the saved monitoring configuration 5-10 minutes to process, access the target again.
B- Solution 2:
Solution 2, will be remove the database target from EM12c and re-add it again.
Go to: Oracle Database > Target Setup > Remove Target
(Click on the image to zoom)
Manually Add the target;
Go to: Setup > Add Target > Add Targets Manually
(Click on the image to zoom)
Choose: Add Non-Host Targets Using Guided Process (Also Adds related Targets)
(Click on the image to zoom)
Enter the host name;
(Click on the image to zoom)
Enter now the correct Oracle Home and the other Database target details:
(Click on the image to zoom)
Now, Re-add the RMAN Jobs.
References: Backup jobs in Grid Control Failing with ORA-01034: ORACLE not available [ID 947915.1]
Hope it helps!
Wissem