Could not start Lsnrctl and Tnsping
From: Svetozar Radojcin <cwele_at_EuNet.yu>
Date: Wed, 28 Nov 2001 18:04:11 +0100
Message-ID: <3C05190B.CB60239F_at_EuNet.yu>
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
)
)
The same error appears when I try to use Tnsping TCP-loopback.world. Here is part of tnsnames.ora:
)
(CONNECT_DATA = (SID = ORCL)
)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Date: Wed, 28 Nov 2001 18:04:11 +0100
Message-ID: <3C05190B.CB60239F_at_EuNet.yu>
Personal Oracle 8.0.3, Win98.
"Lsnrctl80 start" always generate :
"This program has performed one illegal operation and will ..."
Here is the content of Listener.ora file:
LISTENER =
(ADDRESS_LIST =
# (ADDRESS = # (PROTOCOL = TCP) # (Host = home) # (Port = 1521) # ) (ADDRESS =
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
) # (ADDRESS = # (PROTOCOL = SPX) # (Service = home_lsnr) # )
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
)
)
# TRACE_FILE_LISTENER = TESTTRC
The same error appears when I try to use Tnsping TCP-loopback.world. Here is part of tnsnames.ora:
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
However, tnsping beq-local.world is ok (where beq-local.world is:
Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = BEQ)
(PROGRAM = oracle80)
(ARGV0 = oracle80ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Why this happens ? Any idea ? Received on Wed Nov 28 2001 - 18:04:11 CET