Home » RDBMS Server » Networking and Gateways » TNS-12541:No Listener (oracle,8174,hpux11.1)
TNS-12541:No Listener [message #297591] Fri, 01 February 2008 11:18 Go to next message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
Hi Guys,
I cloned a new db 8174 and everything went fine but when i am trying to do tnsping the new db iam getting the following error.

tnsping amufsdv.kk.xxx.com
Attempting to contact (address=(protocol=tcp)(host=abc.kk.xxx.com)(port=1150))TNS-12541: TNS:no listener

but the result of tnsping shows different host abc.kk.xxx.com which is different from where the database resides on def.kk.xxx.com.

tnsnames.ora
AMUFSDV.kk.xxx.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = def.kk.xxx.com)(PORT = 1131))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = amufsdv.kk.xxx.com)
    )
  )


sqlnet.ora
# SQLNET.ORA Network Configuration File: /oracle/product/8.1.7ee/network/admin/s
qlnet.ora
# Generated by Oracle configuration tools.

NAME.DEFAULT_ZONE = world

NAMES.PREFERRED_SERVERS =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ONSAM1.kk.xxx.com)(PORT = 15000))
    (ADDRESS = (PROTOCOL = TCP)(HOST = ONSAM2.kk.xxx.com)(PORT = 15000))
    (ADDRESS = (PROTOCOL = TCP)(HOST = ONSAM3.kk.xxx.com)(PORT = 15000))
  )

NAMES.DEFAULT_DOMAIN = world

TRACE_LEVEL_CLIENT = OFF

NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES)

AUTOMATIC_IPC = off



ouput of Listener services
$ lsnrctl services listener_amufsqa1

LSNRCTL for HPUX: Version 8.1.7.4.0 - Production on 01-FEB-2008 17:13:54

(c) Copyright 1998 Oracle Corporation.  All rights reserved.

Connecting to (ADDRESS=(COMMUNITY=TCP.world)(HOST=def.kk.xxx.com)(PROTOCOL=TCP)(PORT=1131))
Services Summary...
  amufsdv               has 1 service handler(s)
    DEDICATED SERVER established:0 refused:0
      LOCAL SERVER
  amufsqa1              has 1 service handler(s)
    DEDICATED SERVER established:56 refused:0
      LOCAL SERVER
The command completed successfully
$


init.ora parameters
db_name                         = amufsdv
db_domain                       = kk.xxx.com
global_names                    = TRUE
instance_name                   = amufsdv
service_names                   = amufsdv.kk.xxx.com


can anybody please let me know where i am going wrong with it.
Re: TNS-12541:No Listener [message #297594 is a reply to message #297591] Fri, 01 February 2008 11:30 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
Nice formatting, but I am unclear as to who did what to where.
It appears you have multiple server systems & possibly even a different client system.

Please clarify from which system(s) the posted files originated.

As a general recommendation I suggest you comment out all lines in SQLNET.ORA which contain "world" or "WORLD".
Re: TNS-12541:No Listener [message #297596 is a reply to message #297591] Fri, 01 February 2008 11:41 Go to previous message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
Sorry for not making it clear.I am running the commands from the cloned db(amufsdv)which is running on def.kk.xxx.com machine,but when i am trying to tnsping amufsdv its pointing to a different server abc.kk.xxx.com in the ouput .Just taking to another DBA who is working for this client for long time, he said that amufsdv use to existed on another server abc.kk.xxx.com earlier and is registered into onames but they de-commissioned it sometime back but its entry is still existing in onames thats what causing it to point to old server.

Thanks for your suggestions.


Previous Topic: No Listener
Next Topic: Listener not starting
Goto Forum:
  


Current Time: Sat Dec 03 17:51:49 CST 2016

Total time taken to generate the page: 0.04353 seconds