Having trouble connecting SQL Developer to database on LINUX machine
Hello,
I am trying to connect my windows 7 home premium machine to an oracle database 11g on a RedHat 5 machine using SQL Developer. i got this error message on SQL Developer
Status : Failure - Test failed :The Network Adapter could not establish the connection
on Linux
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 03-APR-2013 16:13:13
Uptime 7 days 22 hr. 16 min. 41 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/11.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.X.X.X)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orc11g" has 1 instance(s).
Instance "orc11g", status READY, has 1 handler(s) for this service...
Service "orc11gXDB" has 1 instance(s).
Instance "orc11g", status READY, has 1 handler(s) for this service...
Service "orc11g_XPT" has 1 instance(s).
Instance "orc11g", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
and TNSPING
tnsping 172.x.x.x
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 11-APR-2013 14:32:17
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=172.x.x.x))(ADDRESS=(PROTOCOL=TCP)(HOST=172.x.x.x)(PORT=1521)))
OK (0 msec)
[oracle@ltebilling ~]$
Tnsnames.ora On Linux ,
ORC11G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.x.x.x)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orc11g)
)
)
Listner on Linux ,
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.x.x.x)(PORT = 1521))
)
)
/ect/hosts Linux ,
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
172.x.x.x LTEBilling
and there is no problem of ping linux from windows
Edited by: user11309581 on Apr 11, 2013 3:16 PM