| TNS-12541, Connecting to server on the same subnet [message #220921] |
Thu, 22 February 2007 14:42  |
harisurbam
Messages: 2
Registered: February 2007
Location: USA
|
Junior Member |
|
|
ISSUE with Connecting to Instance SCS
from Windows server or another Unix server (ECS)
Hi,
Issue connecting to Oracle Database on a Unix server A,
from another Unix B or Windows server C.
Get error when using "sqlplus system/manager@scs"
or "tnsping scs" -:
==============================================================
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (SDU = 32768) (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = scm5s
a) (PORT = 1527))) (CONNECT_DATA = (SID = SCS) (GLOBAL_NAME = SCS.WORLD)))
TNS-12541: TNS:no listener
==============================================================
Note the following -;
Host scm5s = IP Address 10.252.x.y
All three servers (two Unix & one Windows server) are on
the same subnet (10.252.x).
Hence the port 1527 being closed cannot be an issue.
We have tried connecting using sqlplus from the Unix
server B to Unix Server A.
Also tried connecting using sqlplus from the Windows
server c to Unix Server A.
Cannot try using telnet IP:Port since telnet is disabled.
Also tried tnsping SID
Entries in TNSNAMES.ORA
SCS.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 10.252.x.y)
(Port = 1527)
)
)
(CONNECT_DATA = (SID = SCS)
)
)
Entries in SQLNET.ORA
SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
Thanks
Hari
|
|
|
|
|
|
| Re: TNS-12541, Connecting to server on the same subnet [message #220939 is a reply to message #220922] |
Thu, 22 February 2007 15:55  |
harisurbam
Messages: 2
Registered: February 2007
Location: USA
|
Junior Member |
|
|
Hi,
The database (Intance SCS) as such is running fine.
As also the listener is running fine (Status shown below).
The issue is connecting to this database from other servers (tried out from one Unix & Windows server's).
===========================================================
LSNRCTL for HPUX: Version 9.2.0.6.0 - Production on 22-FEB-2007 21:53:54
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SCS.WORLD))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 9.2.0.6.0 - Production
Start Date 21-JAN-2007 04:47:17
Uptime 32 days 17 hr. 6 min. 36 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/SCS/920_64/network/admin/listener.ora
Listener Log File /oracle/SCS/920_64/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SCS.WORLD)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SCS)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.252.110.133)(PORT=1527)))
Services Summary...
Service "SCS" has 1 instance(s).
Instance "SCS", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
============================================================
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
