Backup failing with the error ORACLE not available
Problem description
After upgrading Oracle from 12c to 19c backup is failing with the error code Oracle DTC18.
Error message:Failed to get DBID and Archive log mode.
Cause
Oracle home directory has changed
Traceback
log_modeFROMgv$database="unsupported value type"
level=error ts=2022-06-14T10:17:30.171669684Z filename=backup.go:2232 message="Failed to get DBID and Archive log mode."
level=error ts=2022-06-14T10:15:29.361743432Z filename=discovery.go:709 message="Failed to validate Database credentials" Layer=EventHandler
Connected to an idle instance.
ERROR at line 1:\nORA-01034: ORACLE not available\
Resolution
- Check home path on the Oracle server by running the following command:
echo $ORACLE_HOME
- Update the new home path on the Phoenix console under Database Parameters
- Stop the Phoenix Oracle service using the command:
service PhoenixOracle stop
- Start the Phoenix Oracle service using the command:
service PhoenixOracle start
- Refresh the GUI to verify if it appears in connected state
- If the issue persist, other possible causes are the following:
- Check if Database credentials were changed during the upgrade
- Verify SID by running the command:
echo $ORACLE_SID
- Make sure archive log mode is enabled on the database server
- Connect to the database & run the following command:
SQL> archive log list
- Database log mode should be: Archival Mode
- Connect to the database & run the following command: