When installing the collector agent on a UNIX monitored host using graphical/GUI mode, the middleware's Oracle home is not detected and unable to enter it manually.
The middleware is installed on a Windows server and it is able to connect successfully to the Oracle database using tnsping and SQLPlus.
Following errors are found in the installation logs:
"Failed to get_available_oracle_homes on Middleware host <hostname>"
Run the installation in console mode. The Oracle home on the middleware machine can be manually entered using this mode.