Re: no tnsnames.ora

On Thu, 07 Aug 2003 09:19:17 GMT, SPIDERMAN <consultant2b_at_hotmail.com> wrote:

> Hi gurus,
>
> I installed Oracle 9i database 9.2.0.1.0 on WindowXP Prof, but found no
> tnsnames.ora in oracle_home/network/admin. I reinstalled and same thing
> happened. lsnrctl status shows
>
> ........
>
> Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
> TNS-12541: TNS:no listener
> TNS-12560: TNS:protocol adapter error
> TNS-00511: No listener
> 32-bit Windows Error: 61: Unknown error
> --------------------
>
> lsnrctl start shows the following. Please help.
> ---------------------
>
> ............
>

Presumably, therefore, you did a 'software only' install? Because in that case, no database is created as part of the install, and therefore there's no need for networking files to be created either (and no basis on which Oracle can create them either).

After installing the software alone, you use the Networking Assistant to create tnsnames and listener.ora's. And the Database Creation Assistant to create a database.

If you *did* create a database as part of the install, then it's possible for the networking step to fail (one reason I actually prefer software only installs, actually) so you get stuck with a database with no networking files. In that case, just run the Network Assistant to create them yourself.

> TNSLSNR for 32-bit Windows: Version 9.2.0.1.0
> Log messages written to C:\oracle\ora92\netwo
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL
> ck.com)(PORT=1521)))
>
> Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=15
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for 32-bit
> tion
> Start Date 07-AUG-2003 05:09:2
> Uptime 0 days 0 hr. 0 min.
> Trace Level off
> Security OFF
> SNMP OFF
> Listener Log File C:\oracle\ora92\net
> Listening Endpoints Summary...
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=d
> =1521)))
> The listener supports no services
> The command completed successfully

All that's happening here is that the 'lsnrctl start' command actually causes a new listener to be created the first time it's run. Works the same on all platforms. Specifically on Windows, it causes a Listener service to be created too. And you should now find that you do indeed have a listener.ora. Though it won't have much in it: because you just 'start the default listener', all the settings are the default ones (which might be all you need at this stage... hence the functionality existing in the first place). In other words, you've now got a listener called LISTENER, using TCP/IP and listening on port 1521.

~QM Received on Thu Aug 07 2003 - 05:22:25 CDT