2 Replies Latest reply: May 13, 2014 10:06 AM by user9286819 RSS

    Unable to fetch Audit records from MS-SQL server

    Andy.....!

      Hi All,

       

      I have installed AVDF and registered the hosts and secured targets for Oracle as well as MS-SQL database servers. I can see auditing records for Oracle database without any problem but I am unable to see MS-SQL db's audit records on my AVDF servers.

       

      My MS-SQL server host, agent, AVDF service are in running state when I see it on AVDF server. When I check logs on MS-SQL server in 'AV_HOME' location I got the following errors:

      --------------------------------------------

      Log_File : av.agent-1460-0

      --------------------------------------------

      [2014-04-15T14:18:33.247-07:00] [agent] [ERROR] [] [] [tid: 10] [ecid: 192.168.2.57:915:1397596713234:0,0] Error occurred in Agent.[[

      Failed to connect to DB

        at oracle.av.platform.common.dao.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:480)

        at oracle.av.platform.agent.AgentController.doStart(AgentController.java:1588)

        at oracle.av.platform.agent.AgentController.doProcess(AgentController.java:1924)

        at oracle.av.platform.agent.AgentController.main(AgentController.java:1938)

      Nested Exception:

      java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

        at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:488)

        at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:163)

        at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:928)

        at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:863)

        at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:855)

        at oracle.av.platform.common.dao.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:467)

        at oracle.av.platform.agent.AgentController.doStart(AgentController.java:1588)

        at oracle.av.platform.agent.AgentController.doProcess(AgentController.java:1924)

        at oracle.av.platform.agent.AgentController.main(AgentController.java:1938)

      Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

        at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:368)

        at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:49)

        at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:80)

        at oracle.ucp.jdbc.DataSourceConnectionFactoryAdapter.createConnection(DataSourceConnectionFactoryAdapter.java:102)

        at oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.createOnePooledConnectionInternal(UniversalConnectionPoolImpl.java:1588)

        at oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.access$600(UniversalConnectionPoolImpl.java:1424)

        at oracle.ucp.common.UniversalConnectionPoolImpl.createOnePooledConnection(UniversalConnectionPoolImpl.java:498)

        at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.createOnePooledConnection(OracleJDBCConnectionPool.java:129)

        at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionWithoutCountingRequests(UniversalConnectionPoolImpl.java:297)

        at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnection(UniversalConnectionPoolImpl.java:142)

        at oracle.ucp.jdbc.JDBCConnectionPool.borrowConnection(JDBCConnectionPool.java:157)

        at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:916)

        ... 6 more

       

       

      ]]

       

       

      --------------------------------------------

      Log_File : av.common-1460-0

      --------------------------------------------

       

      [2014-04-15T14:18:32.653-07:00] [common] [ERROR] [] [] [tid: 10] [ecid: 192.168.2.57:915:1397596713234:0,0] Unable to get connection to the datasourceException occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

       

       

       

      ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

       

      I have checked for the default port i.e. 1433 but that is OPEN and FIREWALL is also Off.

       

      Kindly suggest for the same.

       

      Regards,

      Andy.....!