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

[ranaveer.mariyagu]

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 ?

[Ryan.Paredez]

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...

[Michael.Horstmann]

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!