Issue is resolved. I tried resetting the database password again. While setting new password i didnt not use the special character. then tried giving updated password in database configuration and it worked 🙂
Its strange and hard to digest the solution but my issue is resolved 🙂
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.
if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta