Just after installing Spotlght on RAC, following error comes up when try to connect a session to a Oracle RAC database.
"Timeout calling Logon" error.
Is there a way to increase the Timeout value for this connection?
See attached screenshot SpotlightConnectionError.doc:
Spotlight:
The following error occurred in <connection name> during connection:
Timeout calling Loggon
Error found in Verify Cluster Connection Details dialog:
Oracle connection error:
ORA-12545: connect failed because target host or object does not exist
TNS entry in the tnsnames.ora file is incomplete
Perform the following to resolve this issue.
1. Verfiy that the Oracle RAC tns entries are correct in the tnsnames.ora file
2. When connecting with Spotlight on RAC, try selecting the correct connection string from the TNS Entry drop down list on the Verify Cluster Connection details dialog
