OraFAQ Forum: Networking and Gateways » TNS-12541:No Listener

Home » RDBMS Server » Networking and Gateways » TNS-12541:No Listener (oracle,8174,hpux11.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS-12541:No Listener [message #297591]

Fri, 01 February 2008 11:18

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

Code: [Select all] [Show/ hide]

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

Code: [Select all] [Show/ hide]

# 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

Code: [Select all] [Show/ hide]

$ 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

Code: [Select all] [Show/ hide]

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.

Report message to a moderator

Re: TNS-12541:No Listener [message #297594 is a reply to message #297591]

Fri, 01 February 2008 11:30

BlackSwan
Messages: 26766
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".

Report message to a moderator

Re: TNS-12541:No Listener [message #297596 is a reply to message #297591]

Fri, 01 February 2008 11:41

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.

Report message to a moderator

Previous Topic:	No Listener
Next Topic:	Listener not starting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 09:45:17 CDT 2025