Problem description
Oracle Database discovery failure alerts are received post Oracle server upgrade
Cause
During discovery Oracle agent scans all OracleHome locations. After Oracle upgrade there will be multiple OracleHome directories on the server
Traceback
/var/log/PhoenixOracle/main_oracle_service.log shows
level=info ts=2023-07-18T03:00:36.782654824-05:00 filename=shallowdiscovery.go:45 message="Instance Info" InstanceSID=TestDB OracleHome=/sw/19.0.0/dbhome_1 OracleUser=oracle DBName=Test IsRac=false level=warn ts=2023-07-18T03:00:41.651124726-05:00 filename=deepdiscovery.go:200 message="Failed to do DEEP discovery of database." OracleSid=TestDB OracleHome=/sw/12201/db DbExists=true
Resolution
As can be seen in above traceback database TestDB is listed under two OracleHome directories
Where
/sw/12201/dbis the old OracleHome path for version 12c and/sw/19.0.0/dbhome_1is the new OracleHome path for version 19In order to exclude the old OracleHome path from discovery, edit the
/etc/PhoenixOracle/Phoenix.yml file and add the below entry EXCLUDE_ORACLE_HOME_FROM_DISCOVERY: ["/sw/12201/db"]
Restart the service on the server
systemctl restart PhoenixOracle