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

[richie]

Hi @PratikshaMehete 

yeah - this non-helpful response occurs occasionally when you can't connect to your Oracle RDBMS.

if you've changed the password youre using to connect to the Oracle user/schema with - the error response sounds about right.

I'd recreate the RDBMS connection with the updated password - but before that - have you double checked you can access the database with the new password using SQLDeveloper?

I'd double check you can hit the database with teh new password via SQLDeveloper and as long as you can - I'd just create a new DB connection with the new password - then repoint any of your JDBC steps that connect to that DB to use your newly created connection.

Cheers,

rich

[nmrao]

Please see if the below link helps:
https://stackoverflow.com/questions/24127839/oracle-sql-developer-failure-test-failed-the-network-ad...

[HimanshuTayal]

@PratikshaMehete :

Are you able to manually connet the DB with the credential you are using with ReadyAPI.

[PratikshaMehete]

Hi,

yes i am able to connect DB with new password in SQL Developer.

[PratikshaMehete]

hi,

thanks for reply,

I checked i am able to connect the DB using new password in SQL Developer

[PratikshaMehete]

I recreated the RDBMS connection with the updated password still i am getting the same error

[HimanshuTayal]

could you share any image/screenshot for the error that you are getting, so that it will be more clear what's the issue

[sonya_m]

Thank you everyone!

Hi @PratikshaMehete , was the issue solved? Please share the details with us

[sdeevers]

If you are using environments, check / update if necessary the value associated in the "JDBC Connections" tab for your environment.