Unable to connect database in ready api

[PratikshaMehete]

Hello all,

I have reset my database password from SQL developer. Now from ready api i entered new password in database configuration.  I am not able to establish the connection. Below error occured

Unable to get a connection for the specified properties: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

[sdeevers]

I believe HimanshuTayal gave you the cirrect info to register the driver;

DriverManager.registerDriver( new oracle.jdbc.driver.OracleDriver());

However, you may also want to check your environment to be sure you are using the correct Oracle driver. You can get the applicable Oracle packagehere,  https://www.soapui.org/jdbc/reference/jdbc-drivers.html. Saved the driver package in the "C:\Program Files\SmartBear\ReadyAPI-3.0.0\bin\ext" directory for the connection to be established. As a side note, when you upgrade to another version of Ready API you will need to move the oracle file to the new release directory.

Hope this helps you get the problem resolved.

[HimanshuTayal]

@PratikshaMehete  :

check the link , hope you will get some help.

[PratikshaMehete]

I checked correct ojdbc driver present in EXT folder. However earlier i was able to connect to database but when i reset the password the issue occured to me. i tried uninstalling ready api and installed again but didnt worked.

[nmrao]

This issue is nothing to do with the tool.
Like I mentioned in previous reply, No client will be able to connect. While it is tricky to resolve, suggest you to connect to Oracle forums and your DBA.

[PratikshaMehete]

1. DBA confirmed the listeners are up and running. 2. Initially using ready api tool i was able to connect the database .. when I reset the password, using new password i am not able to connect. 3. I am able to connect the database using SQL developer with new password so DBA saying there is issue from there end.. 4. One of my colleague is able to connect same database with ready api tool with his credentials. 5. Checked the oracle thin jar present in EXT folder.

[nmrao]

"DBA saying there is issue from there end." - is your DBA looking into the problem?

[PratikshaMehete]

typo mistake - "DBA saying there is NO issue from there end.

[nmrao]

May be you want to check these threads for understanding

https://stackoverflow.com/questions/12574414/io-error-the-network-adapter-could-not-establish-the-co...
https://stackoverflow.com/questions/22337901/io-exception-the-network-adapter-could-not-establish-th...

[HimanshuTayal]

@PratikshaMehete  : Is your issue resolved or still you are searching for the solution, if it is resolved please let us all know that how you managed to solved the issue so that it will be helpful for anyother help seeker.

[sonya_m]

Thank you for being helpful Community!

@PratikshaMehete any updates?