cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Not a customer? Start a free trial

Click the Start a free trial link to start a 15-day SaaS trial of our product and join our community as a trial user. If you are an existing customer do not start a free trial.

AppDynamics customers and established members should click the sign in button to authenticate.

Infrastructure (Server, Network, Database)

Database agent ignore listener IP and try to connect to server IP

Mario.Krupa
Explorer

Database agent ignore listener IP and try to connect to server IP

My database collector is set to use custom JDBC string:

 

jdbc:oracle:thin:@(DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.64.129.132)(PORT = 5350))

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.64.129.133)(PORT = 5350))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = SERVICE_NAME.XYZ.COM)

    )

  )

 

So I would expect, it will try to reach database on above IP addresses (db listener)

 

BUT instead of that it tries to connect to oracle server VIPs where we have installed databases and ignoring listeners IPs

 

Caused by: java.io.IOException: Connection timed out, socket connect lapse 127231 ms. server.xyz.com/10.64.50.184 5152 0 1 true

                at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:209)

                at oracle.net.nt.ConnOption.connect(ConnOption.java:161)

                at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:470)

                ... 29 more

               

Caused by: java.io.IOException: Connection timed out, socket connect lapse 127231 ms. server.xyz.com/10.64.50.174 5152 0 1 true

                at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:209)

                at oracle.net.nt.ConnOption.connect(ConnOption.java:161)

                at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:470)

 

Of course, FW allows communication only towards listener IPs and not to servers original IPs

What to do?

Thanks.

Tags (2)
By replying you agree to the Terms and Conditions of the AppDynamics Community.
Database agent ignore listener IP and try to connect to server IP
0 REPLIES 0