3 Replies Latest reply: Jul 8, 2013 3:12 AM by aasubram RSS

    Connectivity related Issue

    aasubram

      I was trying to connect to a remote oracle database 10.2.0.5 (hosted at windows 2008 R2 server) from my local SQL Developer tool.

       

      When setting up connection in SQL Developer tool, I was able to connect to the database by selecting TNS (Network Allias).

       

      However, it does not work when I choose Basic type with the same information (HOST, PORT, SID).

       

       

      TNS entry as below:

      ORCL_DB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 91.198.255.83)(PORT = 1521)) )

      (CONNECT_DATA = (SID = ORCL) (SERVER = DEDICATED) ) )

       

      It works fine if I choose TNS (Network Allias: ORCL_DB).

       

      For the Basic setting:

      ◦Hostname = 91.198.255.83

      ◦Port = 1521

      ◦SID = ORCL

       

      The error I received when connecting to db based on Basic option is Failure -Io exception: The Network Adapter could not establish the connection.

       

      Below are the entries of SQLnet.ora. Any entry should I add into sqlnet.ora?

      •SQLNET.AUTHENTICATION_SERVICES= (NONE)

      •NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

       

      What is the difference between TNS and Basic setting option?

       

      Furthermore, I have issue when connecting to the remote db from jdbc client:

      "jdbc:oracle:thin:@oradb001:1521:ORCL" whereby oradb001 = 91.198.255.81

       

      But it works if I put jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 91.198.255.83)(PORT = 1521)) )     (CONNECT_DATA = (SID = ORCL) (SERVER = DEDICATED) ) )

       

      Please advise and assist.

       

      Thanks,

      Anand