Installing Performance Analysisy Oracle 6.5.45 on two node RAC system. The middleware is already installed (MW installation completed successfully).
When running the PA 6.5.45 collector agent installation on node 1, the installation terminates with the following error:
The middleware agent component failed to initiate a database connection to the monitored instance <SID>. Please verify that OS user running the middleware can initiate a SQL*PLUS connection from the middle-tier host to the monitored Oracle instance using Oracle Home <ORACLE_HOME>. If this attempt fails, please contact Quest Support
We have verified we can connect successfully from the middleware server to the monitored instance with sqlplus and also by issuing the following from command prompt on middleware server:
sqlplus user/password"@(DESCRIPTION=(ADDRESS=(HOST=<hostname>) (PROTOCOL=tcp)(PORT=<port>)) (CONNECT_DATA=(SID=<SID>)))"
32-bit client installed on 64 bit middleware server
This issue is resolved by installing a 64-bit client on the 64-bit middleware server
Verify the correct Oracle home is entered during the install; entering the correct middleware Oracle Home at the prompt on the Monitored Instance Settings screen resolves the issue