Re: SQL*Net Listener

From: John D Groenveld <groenvel_at_cse.psu.edu>
Date: 1997/12/13
Message-ID: <66v6sa$3iu$1@tholian.cse.psu.edu>#1/1

In article <348F5816.D054B6C9_at_nafus.com>, Rob Nafus <rob_at_nafus.com> wrote:
>Windows 95 clients can not login using SQL Client. I am sure I have the
>listener.ora file
>wrong. Anybody got a guid setting up this file?
Use the listener.ora on the server to configure tnsnames.ora on the client. The listener.ora will have the port and SID.

This is a bare-bones tnsnames.ora:
tns_alias =

	(DESCRIPTION =
		(ADDRESS_LIST =
			(ADDRESS =
				(PROTOCOL = TCP)
				(HOST = sun)
				(PORT = 1521)
			)
		(CONNECT_DATA =
			(SID = orcl)
		)
	)

use "tnsping tns_alias" to confirm your settings on the client.

John
groenvel_at_cse.psu.edu Received on Sat Dec 13 1997 - 00:00:00 CST