Re: Q: how to properly configure SQL*Net v2 TNS listener process?

Charles Chen <htchen_at_ix.netcom.com> wrote:

>Hi, I am trying to properly configure my SQL*Net v2 listener. I would
>start it up and then use the "lsnrctl status" command to check it.
>It would report uptime but that there are no services detected. I was
>wondering if this is a normal message or not. My Oracle 7.3.2.1.0 RDBMS
>server (which is on Solaris 2.5.1) is up because I can go into SQL*Plus
>and query the default EMP table. Any suggestions/answers are greatly
>appreciated.
>
>
>Thanks for your time,
>Henry

You need to create a listener.ora file in the $ORACLE_HOME/network/admin directory. The easiest way to do this is to use the network manager program (runs in Windows) and ftp the generated listener.ora file to the host.

Or if you want, I can email you a copy of one of mine and you can just change the appropriate values.

--
Chuck Hamilton
chuckh_at_dvol.com

This message delivered by electronic sled dogs. WOOF!