Unable to enable the JDBC Connection to Oracle DB

i have installed Oracle 9i and Adaptor on my system.
When i configure a connection to the oracle DB i am getting following error :

Error encountered

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource MyWork:myConn.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

i have the classes.jar file (having OracleDataSource.classes) at two places :
Integration Server\Lib\jars and
Integration Server\packages\WmJDBCPakage\lib\jar

plz help to resolve this error!!

Hi Richa,

sounds like you met a permission problem in your Oracle DB.

Can you provide some more details about the driver you are using and your connection configuration screen?

Additional info need:

  • Version of IS
  • Version of Java (defines which driver jar to use.)