Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to make connection to the local database using Personal Oracle 7.2

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

From: Jim Belcher <jbelcher_at_perigee.net>
Date: 1998/01/21
Message-ID: <34c55a43.17612307@snews.zippo.com>#1/1

Billy,
  I have been following the conversations back and forth about connecting to the local DB with PO7. I am also having difficulty. 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.
TIA -- Jim Belcher

On Mon, 19 Jan 1998 07:42:37 +0200, "Billy Verreynne" <vslabs_at_onwe.co.za> wrote:

>Greg Teets wrote in message <34c1640b.405768_at_news.ececs.uc.edu>...
>>I set up Tcp-loopback as you suggested and I got the following
>>no-listener message.
>
>
>You need to edit the LISTENER.ORA file in \ORAWIN95\NETWORK\ADMIN and create
>an entry for your database/SID where the IP address equals loopback.
>
>Start the listener (in \ORAWIN95\BIN) with LSNRCTL START. Then try TNSPING
>again.
>
>regards,
>Billy
>
>
>
Received on Wed Jan 21 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US