Home » RDBMS Server » Networking and Gateways » Unable to stop listener
Unable to stop listener [message #118406] Wed, 04 May 2005 22:18 Go to next message
thomasho
Messages: 5
Registered: December 2004
Junior Member
Hi all

I try to stop listener and already reset password via the command SET PASSWORD in lsnrctl.

However, when I type "lsnrctl stop service_name password", there is error message: NL-00857: wrong number (0 - 1 needed) of arguments to "stop"

I don't have any idea how to fix it

Could you please kindly advise what configuration needed for fixing the problem

Thanks a lot

Regards
Thomas
Re: Unable to stop listener [message #118415 is a reply to message #118406] Thu, 05 May 2005 01:35 Go to previous messageGo to next message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
The correct syntax as per the Oracle Database Net Services Administrator's Guide:

lsnrctl> SET PASSWORD
lsnrctl> STOP [listener_name]


Best regards.

Frank
Re: Unable to stop listener [message #118421 is a reply to message #118415] Thu, 05 May 2005 02:13 Go to previous messageGo to next message
thomasho
Messages: 5
Registered: December 2004
Junior Member
Thanks for your reply

but I type in the way you suggested.
There is another error shown below

LSNRCTL> set password
Password:
The command completed successfully
LSNRCTL> stop listener
Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=nhkrtl01)(PORT=1521))
TNS-01169: The listener has not recognized the password

Is it error in configurating in listener.ora?

The setting in listener.ora

#listener.ora

LISTENER=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=nhkrtl01)
(PORT=1521)
)
)

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
ADMIN_RESTRICTIONS_LISTENER = ON

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=nhkrtail)
(ORACLE_HOME=/dba00/oracle/product/8.1.7)
)
)

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=nhkrtest)
(ORACLE_HOME=/dba00/oracle/product/8.1.7)
)
)


TRACE_LEVEL_LISTENER = OFF


Re: Unable to stop listener [message #118709 is a reply to message #118421] Sat, 07 May 2005 03:17 Go to previous message
mazherullah
Messages: 1
Registered: May 2005
Location: Riyadh
Junior Member
Hi Thomas,

Check other Listener entries.

If still the problem exisit, then do create a new listner and try. It should work out.

Mazherullah
Previous Topic: SQL*Net 2.3.4 vs Oracle 9.2
Next Topic: ORA-00439: feature not enabled: %s
Goto Forum:
  


Current Time: Fri Nov 22 03:18:27 CST 2024