This content has been marked as final. Show 3 replies
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 = 18.104.22.168)(PORT = 1521)) )
(CONNECT_DATA = (SID = ORCL) (SERVER = DEDICATED) ) )
It works fine if I choose TNS (Network Allias: ORCL_DB).
For the Basic setting:
◦Hostname = 22.214.171.124
◦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?
•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 = 126.96.36.199
But it works if I put jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 188.8.131.52)(PORT = 1521)) ) (CONNECT_DATA = (SID = ORCL) (SERVER = DEDICATED) ) )
Please advise and assist.