cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Failed to resolve DB topological structure. java.sql.SQLException: ORA-01005: null password given; logon denied

Upgraded the Machine Agent from 22 to v24.8.0.4467, after the changes, seeing below errors,

[DBAgent-7] 06 Nov 2024 17:24:28,994 ERROR ADBMonitorConfigResolver - [XXXXXXXXXXXX] Failed to resolve DB topological structure.
java.sql.SQLException: ORA-01005: null password given; logon denied

I have provided the userid and password in the configuration -> controller setting,

Any one faced this kind of issue ?

 

2 REPLIES 2

Ryan.Paredez
Community Manager

Hi @ranaveer.mariyagu,

While this is an older post, it still may be true as it's the same error. https://community.appdynamics.com/t5/Java-Java-Agent-Installation-JVM-and-Controller-Installation/DB...

They reference an AppD Docs page which is this one: https://docs.appdynamics.com/appd/24.x/24.10/en/database-visibility/add-database-collectors/configur...

 


Thanks,

Ryan, Cisco AppDynamics Community Manager




Found something helpful? Click the Accept as Solution button to help others find answers faster.

Liked something? Click the Thumbs Up button.



Check out Observabiity in Action

new deep dive videos weekly in the Knowledge Base.

IDK if this will help you, but speaking as someone monitoring 468 Oracle RAC clusters, if it were me I'd try the following 3 steps, possibly putting the pw-validation above others if I was to alter anything as I wrote it below.

1) Disable the collector for a few minutes + re-enable the db collector - This is my goto solution for messages like this.
2) Validate the DBMonitor agent that's the middle man in all this is updated and compatible with your updated controller.
3) While you're there, attempt to validate you can establish a basic JDBC connection to the DB from the instance the DBMon collector is running on, and that you can do basic topology queries with the AppD DB user the collector is using.

I'm just speaking to you as another user who's been through similar issues, so hopefully it helps!