Re: no listener.ora

On Mon, 22 Dec 2003 13:52:37 -0500, "Oracle Learner" <hastenthunder_at_yahoo.com> wrote:

>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
>

Your understanding is wrong. If you are using the default ports only, you can just start the listener without setting up a listener.ora. Also the databases will automatically register themselves against the listener.
*HOWEVER* if you are using non-default ports, other than 1521, OR you need the Intelligent Agent to connect to your instance, you MUST set up a listener.ora

--
Sybrand Bakker, Senior Oracle DBA