If password protection is being used, you must set the password before you
can issue the STOP command. When using passwords for the listener, you
cannot issue the STOP command at the operating system level because the
password can only be set within the lsnctrl utility.
There are two types of password mechanisms in lsnctrl.
1. Unencrypted and
2. U guessed it right - Encrypted.
Here is some theory:
In the listener.ora file add this line:
PASSWORDS_PRODUCTION_LISTENER = (password1, password2)
U can add as many passwords as u like. U can use any one of them to control
the listened.
Now, a word about the encrypted passwords:
At the prompt
LSNRCTL> CHANGE_PASSWORD
This will prompt you to enter a new password.
Now, You have an encrypted password.
TO STOP THE LISTENER, U HAVE TO MANUALLY ENTER OR TYPE IN THE PASSWORD IF
YOU ARE USING ENCRYPTED PASSWORD.
However, if u are using an unencrypted password, then just creat a script
file to contain these lines:
--------
set password password1 ( I am not sure of this syntax - check this one)
stop listener
-------
and at the OS level,
u can just say
lsnctrl @<Script_File>
Correct me if I am wrong.
Rajaram.
-----Original Message-----
From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 6:46 PM
To: Multiple recipients of list ORACLE-L
Subject: LSNRCTL Password
Can anyone tell me what the syntax is to start, stop, or reload the
listener
when there is a password on it?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
NetZero Platinum
No Banner Ads and Unlimited Access
Sign Up Today - Only $9.95 per month!
http://www.netzero.net
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rajaram
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
