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