0 Replies Latest reply on Jun 3, 2020 12:27 PM by Deepanshu Marria

    configured Oracle Standalone  Database using Remote Monitoring.

    Deepanshu Marria
      Share This:

      I have configured Oracle Standalone Database Pushed the Oracle Enterprise Km to the remote host from where Database host will be connected .

       

      After the configuration  getting the below error : Can anyone please tell what could be the possible reason for the error not able to see the Instance configuration status is OK .

       

      registerDriver: oracle.jdbc.OracleDriver@5d85079c

      DriverManager.getConnection("jdbc:oracle:thin:@(DBHOSTgiven):1500:CI2")

          trying oracle.jdbc.OracleDriver

      DriverManager.deregisterDriver: oracle.jdbc.OracleDriver@5d85079c

      SQLState(08006) vendor code(17002)

      java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

      at oracle.jdbc.driver.SQLStateMapping$SqlExceptionType$14.newInstance(SQLStateMapping.java:126)

      at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:159)

      at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:125)

      at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:175)

      at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:236)

      at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:445)

      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:772)

      at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:688)

      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)

      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691)

      at java.sql.DriverManager.getConnection(DriverManager.java:675)

      at java.sql.DriverManager.getConnection(DriverManager.java:219)

      at com.bmc.patrol.koe.connections.jdbc.callables.JDBCConnectCallable.call(Unknown Source)

      at com.bmc.patrol.koe.connections.jdbc.callables.JDBCConnectCallable.call(Unknown Source)

      at java.util.concurrent.FutureTask.run(FutureTask.java:277)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)

      at java.lang.Thread.run(Thread.java:812)

      SQLState(99999) vendor code(17430)

      java.sql.SQLException: Must be logged on to server

      at oracle.jdbc.driver.SQLStateMapping$SqlExceptionType$1.newInstance(SQLStateMapping.java:48)

      at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:159)

      at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:125)

      at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:175)

      at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:236)

      at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:242)

      at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:378)

      at oracle.jdbc.driver.T4CConnection.assertLoggedOn(T4CConnection.java:4525)

      at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:905)

      at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:725)

      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)

      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691)

      at java.sql.DriverManager.getConnection(DriverManager.java:675)

      at java.sql.DriverManager.getConnection(DriverManager.java:219)

      at com.bmc.patrol.koe.connections.jdbc.callables.JDBCConnectCallable.call(Unknown Source)

      at com.bmc.patrol.koe.connections.jdbc.callables.JDBCConnectCallable.call(Unknown Source)

      at java.util.concurrent.FutureTask.run(FutureTask.java:277)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)

      at java.lang.Thread.run(Thread.java:812)

          trying oracle.jdbc.OracleDriver

      SQLState(08006) vendor code(17002)

      java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

      at oracle.jdbc.driver.SQLStateMapping$SqlExceptionType$14.newInstance(SQLStateMapping.java:126)

      at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:159)

      at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:125)

      at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:175)

      at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:236)

      at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:445)

      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:772)

      at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:688)

      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)

      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691)

      at java.sql.DriverManager.getConnection(DriverManager.java:675)

      at java.sql.DriverManager.getConnection(DriverManager.java:219)

      at com.bmc.patrol.koe.connections.jdbc.callables.JDBCConnectCallable.call(Unknown Source)

      at com.bmc.patrol.koe.connections.jdbc.callables.JDBCConnectCallable.call(Unknown Source)

      at java.util.concurrent.FutureTask.run(FutureTask.java:277)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)

      at java.lang.Thread.run(Thread.java:812)

      SQLState(99999) vendor code(17430)

      java.sql.SQLException: Must be logged on to server

      at oracle.jdbc.driver.SQLStateMapping$SqlExceptionType$1.newInstance(SQLStateMapping.java:48)

      at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:159)

      at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:125)

      at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:175)

      at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:236)

      at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:242)

      at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:378)

      at oracle.jdbc.driver.T4CConnection.assertLoggedOn(T4CConnection.java:4525)

      at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:905)

      at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:725)

      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)

      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691)

      at java.sql.DriverManager.getConnection(DriverManager.java:675)

      at java.sql.DriverManager.getConnection(DriverManager.java:219)

      at com.bmc.patrol.koe.connections.jdbc.callables.JDBCConnectCallable.call(Unknown Source)

      at com.bmc.patrol.koe.connections.jdbc.callables.JDBCConnectCallable.call(Unknown Source)

      at java.util.concurrent.FutureTask.run(FutureTask.java:277)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)

      at java.lang.Thread.run(Thread.java:812)

      getConnection failed: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

      DriverManager.getConnection("jdbc:oracle:thin:@(DBHOSTgiven):1500:CI2")

          trying oracle.jdbc.OracleDriver

      SQLState(08006) vendor code(17002)