Re: no listener.ora

From: Paul Drake <drak0nian_at_yahoo.com>
Date: 22 Dec 2003 16:58:59 -0800
Message-ID: <1ac7c7b3.0312221658.2dcf4bf1@posting.google.com>

"Oracle Learner" <hastenthunder_at_yahoo.com> wrote in message news:<V3HFb.444$Er.31714_at_mencken.net.nih.gov>...
> Platform: Red Hat Linux 9
> Oracle Version: Oracle 9i2
>
> As I understand it, there is no need to configure a listener service
> manually. After the first database is created, listener.ora is place in
> $ORACLE_HOME/network/admin and the databases' network and service
> information is automatically added to it (listener.ora).
>
> However I created a testing db and no listener.ora file is founded. The
> "lsnrctl status" command does not list the Listener Parameter File.
>
> Does anybody know why is this happening?
>
> Thanks

sounds like you did not create a listener.ora file with one of the GUI tools supplied by oracle.
you can save off the current config in LSNRCTL. If you have not created a listener.ora config file, then I would guess that there is no password on your listener. You might want to reconsider leaving the listener open without a password.

Check OTN - http://otn.oracle.com/deploy/security/alerts.htm for starters. there are additional docs up on Metalink (service contract required for registration).
Pete Finnegan's site has some papers on the subject also, I believe. Aaron Newman also produced a paper on securing the listener.

Pd Received on Mon Dec 22 2003 - 18:58:59 CST