Re: How to make connection to the local database using Personal Oracle 7.2

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1998/01/21
Message-ID: <885367521.317849609@dejanews.com>#1/1

In article <34c55a43.17612307_at_snews.zippo.com>,   jbelcher_at_perigee.net (Jim Belcher) wrote:
> When I looked for a LISTENER.ORA file under \ORAWIN95\NETWORK\ADMIN I
> could not find it. In fact, all that was there was the SQLNET.ORA and
> the TNSNAMES.ORA files. Can you tell me what it should look like? I
> am also recieving - 'no listener' messsage. It would be nice to
> connect.

There should be a sample LISTENER.ORA file in \ORAWIN95\NETWORK\ADMIN\SAMPLE that you can use. Here's a copy of the listener config file on my Win95 PC: -- LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = billyv) (Port = 1521) ) (ADDRESS

=  (PROTOCOL = TCP)  (Host = 127.0.0.1)  (Port = 1521)	) #  (ADDRESS = #
 (PROTOCOL = SPX) #  (Service = billyv_lsnr) #	)  )

STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 TRACE_LEVEL_LISTENER = ADMIN SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = ORCL) ) ) -- The database system id (SID) is the default ORCL. I've commented out the SPX protocol entry as I'm not running IPX/SPX. The listener is listening on 2 IP addresses, both on host billyv and on the loopback address. The TCP port is 1521. Port 1526 is also often used by Oracle listeners.

The rest of the info you'll find in the Adobe doc's that ship with Oracle.

regards,
Billy

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Wed Jan 21 1998 - 00:00:00 CST