RE: admin_restrictions_listener

Ah, you're right of course.

I'm so used to doing everything from telnet sessions (even from my laptop) that I forgot it's possible to have the software locally. And of course I've made the mistake you mention (only once!) so I should have realized it.

Jay

-----Original Message-----
Sent: Thursday, October 17, 2002 2:11 PM To: ORACLE-L_at_fatcity.com
Cc: JayMiller_at_TDWaterhouse.com
Importance: High

Jay,

That doesn't solve the problem.

What Tim was referring to was executing the copy of lsnrctl that exists on his laptop.

I recall a DBA doing this accidentally at a previous job. He copied the listener.ora file to another server, then ran 'lsnrctl stop' before modifying the file for the new server.

Guess what happened?

Jared

"Miller, Jay" <JayMiller_at_TDWaterhouse.com> Sent by: root_at_fatcity.com
 10/17/2002 11:29 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: admin_restrictions_listener

Although if you set the lsnrctl to 700 that problem goes away (that's what we did). I'm still amazed that it's world executable.

Jay Miller

-----Original Message-----
Sent: Thursday, October 17, 2002 10:35 AM To: Multiple recipients of list ORACLE-L

yup. i can run "lsnrctl" from my laptop somewhere on your network and "stop" the listener otherwise...

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, October 17, 2002 3:38 AM

> hi all
>
> I have my listener.ora owned by the oracle owner with 600 permissions
and
> admin_restrictions_listener set.
> On a machine in the DMZ.
> Is there any point in having a password as well?
>
> thanks
> trevor
>
>
>
>
>
> Disclaimer.
>
> This e-mail is private and confidential. If you are not the intended
> recipient, please advise us by return e-mail immediately, and delete
> the e-mail and any attachments without using or disclosing the
> contents in any way. The views expressed in this e-mail are those
> of the author, and do not represent those of this company unless
> this is clearly indicated.
>
> You should scan this e-mail and any attachments for viruses.
>
> This company accepts no liability for any direct or indirect
> damage or loss resulting from the use of any attachments to this e-mail.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Trevor.Williams_at_rac.com.au
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: JayMiller_at_TDWaterhouse.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: JayMiller_at_TDWaterhouse.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).