soo5049: the following error occurred in during connection.
The connection will be disconnected
Oracle client is not installed on the client pc.
Install the Oracle client.
If 10g is the database where the Spotlight objects reside, a 10g client also needs to be installed.
See also sol17602 for this type of issue.