Database

Get Involved. Join the Conversation.

Topic

    Karthik Varma
    Unable to connect to Autonomous data warehouse database...Answered
    Topic posted October 17, 2019 by Karthik VarmaGold Medal: 3,500+ Points, tagged Monitoring, Performance, SQL Dev Web 
    44 Views, 2 Comments
    Title:
    Unable to connect to Autonomous data warehouse database where I am able to connect to Autonomous transaction processing database
    Content:

    I think this is weird. I am trying to connect to Autonomous databases from java application and also using SQL developer.

    ATP database

    final static String DB_URL = "jdbc:oracle:thin:@dbtransprocess_high?TNS_ADMIN=C://Users//karthik//Wallet_DBTransProcess";
    final static String DB_USER = "ADMIN;
    final static String DB_PASSWORD = "123456789";
    ADW database
     final static String DB_URL="jdbc:oracle:thin:@databaseapm_high?TNS_ADMIN=C://Users//karthik//Wallet_DatabaseAPM";
      final static String DB_USER = "ADMIN";
      final static String DB_PASSWORD = "abcdefgh";
    Rest of the code is same.
     
    Able to connect to ATP database but not to ADW database.
     
    Error Stacktrace:
    Exception in thread "main" java.sql.SQLRecoverableException: IO Error: Undefined Error
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854)
    at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)
    at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:406)
    at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:291)
    at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:206)
    at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:184)
    at com.zoho.listeners.DataSourceSample.main(DataSourceSample.java:72)
    Caused by: oracle.net.ns.NetException: Undefined Error
    at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:284)
     
    Any inputs?
    Image:

    Best Comment

    Simon Law

    This is odd. Are you able to use SQL Developer Web to connect to your ADW instance (databaseapm)?

    Assuming you are connecting from the same client machine, and that you are using open network. I would try restarting the ADW instance and see if this helps.

    -Simon

    Comment

     

    • Simon Law

      This is odd. Are you able to use SQL Developer Web to connect to your ADW instance (databaseapm)?

      Assuming you are connecting from the same client machine, and that you are using open network. I would try restarting the ADW instance and see if this helps.

      -Simon

      • Karthik Varma

        I deleted the ADW database & created the new one. It worked ! Not sure, why it didn't work for the old one. Maybe I messed up with some changes in order to connect to it.

        Thanks for the inputs @Simon