OraFAQ Forum: Networking and Gateways » TNS-12541: TNS:no listener

Home » RDBMS Server » Networking and Gateways » TNS-12541: TNS:no listener

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

TNS-12541: TNS:no listener [message #170031]

Mon, 01 May 2006 15:31

Jack_zhai
Messages: 12
Registered: February 2006

Junior Member

Hi,

I tried to config two listeners on one box. The two listeners were started up successfully, but when I tried to tnsping them. One is called JZHAI responsed well, another one stdby1 told me reported me the above error.

Here is the content of listener.ora
----------------------------------------
# LISTENER.ORA Network Configuration File: /app/oracle/proddb/8.1.7/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_STANDBY1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = stdby1)
(ORACLE_HOME = /app/oracle/proddb/8.1.7)
(SID_NAME = stdby1)
)
)

SID_LIST_PROD =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = PROD)
(ORACLE_HOME = /app/oracle/proddb/8.1.7)
(SID_NAME = PROD)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /app/oracle/proddb/8.1.7)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = JZHAI)
(ORACLE_HOME = /app/oracle/proddb/8.1.7)
(SID_NAME = JZHAI)
)
)

STANDBY1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = arrow)(PORT = 1526))
)

LOG_DIRECTORY_PROD = /app/oracle/proddb/8.1.7/network/admin

PROD =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCPROD))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = arrow)(PORT = 1521))
)
)

TRACE_FILE_PROD = PROD

#
# LISTENER.ORA FOR APPLICATIONS - Database Server
# Created by Rapid Install
#
#
# Net8 definition for Database listener
#

#SID_LIST_STANDBY =
# (SID_LIST=
# (SID_DESC=
# (GLOBAL_DBNAME = stdby1)
# (ORACLE_HOME= /app/oracle/proddb/8.1.7)
# (SID_NAME=stdby1)
# )
#)
#STANDBY =
# (DESCRIPTION_LIST =
# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = arrow)(PORT = 1526))
# )
# )

TRACE_DIRECTORY_PROD = /app/oracle/proddb/8.1.7/network/admin

LOG_FILE_PROD = PROD
--------------------------------------------------

Here is the content of tnsnames.ora
--------------------------------------------------
# TNSNAMES.ORA Network Configuration File: /app/oracle/proddb/8.1.7/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

RAIL_PRD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.53)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = rail_prd)
)
)

STDBY1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = arrow)(PORT = 1526))
)
(CONNECT_DATA =
(SERVICE_NAME = stdby1)
)
)

TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)(HOST = test-finance)(PORT = 1522))
)
(CONNECT_DATA =
(SID = TEST)
)
)

PROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)(HOST = arrow)(PORT = 1521))
)
(CONNECT_DATA =
(SID = PROD)
)
)

NEW_PROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)(HOST = 192.168.1.52)(PORT = 1521))
)
(CONNECT_DATA =
(SID = PROD)
)
)

#
# Intermedia
#
#
# Intermedia
#
#
# TNSNAMES.ORA FOR APPLICATIONS
# Created by Rapid Install
#
#
# Net8 definition for the database
#

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = arrow)(Port = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://admin)
)
)

#stdby1 =
# (DESCRIPTION =
# (ADDRESS_LIST =
# (ADDRESS = (PROTOCOL = TCP)(HOST = arrow)(PORT = 1526))
# )
# (CONNECT_DATA =
# (SERVICE_NAME = stdby1)
# )
# )

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCPROD))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

JZHAI =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = arrow)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = JZHAI)
)
)
------------------------------------------------
The two files were changed by netasst. So the syntax should be fine.

Can someone help me !

Thanks
Jack

Report message to a moderator

Re: TNS-12541: TNS:no listener [message #170125 is a reply to message #170031]

Tue, 02 May 2006 03:47

orausern
Messages: 826
Registered: December 2005

Senior Member

can you go to listener control utility, by going to command prompt and then typing lsnrctl

then give command status and post the output.

also try the commands (at lsnrctl prompt):
start stdby1

and post the output.
perhaps it might help..

Report message to a moderator

Previous Topic:	Dynamic TCP Port on Windows Oracle server
Next Topic:	Oracle redirect to high ports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 11:29:18 CDT 2024