Home » RDBMS Server » Server Administration » TNS-12541, Connecting to server on the same subnet
TNS-12541, Connecting to server on the same subnet [message #220921] Thu, 22 February 2007 14:42 Go to next message
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 #220922 is a reply to message #220921] Thu, 22 February 2007 14:43 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
post the output from:
$ lsnrctl status
Re: TNS-12541, Connecting to server on the same subnet [message #220939 is a reply to message #220922] Thu, 22 February 2007 15:55 Go to previous message
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

============================================================
Previous Topic: Regarding views and synonyms
Next Topic: How would i know the usernames in the dump file
Goto Forum:
  


Current Time: Sat Dec 03 16:02:48 CST 2016

Total time taken to generate the page: 0.07443 seconds