Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to make connection to the local database using Personal Oracle 7.2
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