Dear All

I am using oracle 9.2.0.1.0.

IntegrationServer\lib\jars install the classes12.zip

And created the userName and password in oracle database and granted the DBA and connection, resource persmisson also.

in Jdbc connection mention the parameters for userName and password and also jdbc:wm:oracle://localhost:1521;SID=orcl.

even though its throwing error like.

Test of TN Failed
[wm-cjdbc34-0042][Oracle JDBC Driver]Error establishing socket to host and port: localhost:1521. Reason: Connection refused: connect
wm:oracle://localhost:1521;SID=orcl

Thanks in advance

With Regards
Reema

Hi,
The root of the problem was that they had an improperly encrypted password in the databaseproperties.properties file - after using the webMethods Encryption Utility and updating the databaseproperties.properties file with a properly encrypted pwd the problem will get solved.

Vishal Chaudhary
vishu.mindspring@gmail.com

Confirm that you have the DB running on your machine (localhost) and it is listening for connections on port 1521.