Hi:
I have just installed SQL Developer on my window 7. Now I am trying to make connection to databases on different Linux servers. I copied a tnsnames.ora from a server to where I installed the SQL Developer and is going to enter other tns names to that file once the first one is successfully connected. I have entered the following. Please tell me what is the problem:
=======================
Connection Name: PROD_ORCL
Username: oraorcl
Password: oraorcl
Hostname: local (default)
Port:1521
SID: PROD
Status: Faliure-Test failed: IO Error: The Network Adapter could not establish the connection
=======================
TNS entry:
=========
PROD_ORCL=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xxx.xx)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=PROD)
(INSTANCE_NAME=PROD)
)
)
=========
Thank you for your help.
ip address scrambled Message was edited by: NGasparotto