Re: lsnrctl stop remoteservice

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 28 Sep 2001 05:40:26 +0200
Message-ID: <tr9cc8161ese9b@news.demon.nl>

"Yong Huang" <yong321_at_yahoo.com> wrote in message news:b3cb12d6.0109271313.7a9ba36e_at_posting.google.com...
> Just want to confirm this. Suppose you installed Oracle server on your
> own PC. You can tnsping prod, where prod is your local tnsnames.ora
> entry pointing to your production database located remotely. Not only
> that, but you can also lsnrctl status prod. And even this: lsnrctl
> stop prod, unless the listener for your prod database is password
> protected. Oracle Support told me this is the expected behavior. The
> solution is simply password-protect the production server listener.
>
> Yong Huang
> yong321_at_yahoo.com

100% correct. An ordinary client however wouldn't have lnsrctl installed, unless he has also Personal Oracle.
Do not forget the password in listener.ora can be stored encrypted and unencrypted. To do the former use an assistant, to do the latter just edit listener.ora

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Thu Sep 27 2001 - 22:40:26 CDT