Home » RDBMS Server » Networking and Gateways » No listener
No listener [message #66134] Tue, 11 December 2001 23:40 Go to next message
Ned
Messages: 7
Registered: December 2001
Junior Member
Hi everybody,

I am trying to start my listener
and this is a error which I get:

LSNRCTL> stat
Connected (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))

TNS-12541: TNS: No Listener
TNS-12560: TNS: Protocol failed
TNS-00511: No Listener
32-bit Windows Error: 61: Unknown error
These are conf files I am using:

listener ora:

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Oracle8.world)
(ORACLE_HOME = C:ORA2)
(SID_NAME = ORCL)
)
)

________________________________
tnsnames.ora

NSN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
)
)
______________________________

I also tried GLOBAL_DBNAME = Oracle8.computer_name
and GLOBAL_DBNAME = Oracle8@computer_name but I got same error.

If I type start...
LSNRCTL> start
I get TNS-00077: connection refused message (TNS-12564)
Is it problem with database name (Oracle8)
Also, before installing ORA in ORA2 directory I had it in C:Oracle and I have another Designer
installation in C:Designer.
I am using Win2000.
Does anybody see answer. Thanks a lot
Ned



----------------------------------------------------------------------
Re: No listener [message #66161 is a reply to message #66134] Wed, 26 December 2001 21:38 Go to previous message
Gloria Zhao
Messages: 11
Registered: October 2001
Junior Member
Hi,

I'm not sure if it will help or not, but try to change IP address 127.0.0.1 (tnsnames.ora and listsner.ora files) to your machine's real IP Address.

Best regards.

Frank Naude

----------------------------------------------------------------------
Previous Topic: Slow data accessing
Next Topic: Performance in WEB Apps
Goto Forum:
  


Current Time: Sun Mar 03 22:42:10 CST 2024