Hi All,
Any suggestion to fix this issue??
We are using Webmethods IS 9.7. One of our application DB is upgraded from Oracle12C to 19C. After the upgrade we are facing below issue :
[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=318767104)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
Below configurations used:
|Connection Properties|
|Transaction Type|LOCAL_TRANSACTION|
|DataSource Class|oracle.jdbc.pool.OracleDataSource|
|serverName| Given**|
|user|USER_AAA|
|password|******|
|databaseName|*DBNAME|
|portNumber|1521|
|networkProtocol||
|Other Properties|driverType=thin|
|Connection Management Properties|
|Enable Connection Pooling|true|
|Minimum Pool Size|1|
|Maximum Pool Size|10|
|Pool Increment Size|1|
|Block Timeout (msec)|1000|
|Expire Timeout (msec)|1000|
|Startup Retry Count|0|
|Startup Backoff Timeout (sec)|10|