Re: Oracle 8 Personal Edition - can't talk to instance over tcp/ip

Chad Nale wrote:

> Been there before...
>
> I think that you need to go into net8 admin and define a listener, then
> reboot your machine. It's been quite a while since i did it, but i have had
> it working on win 98 with TCP/IP. Let me know if this works
>
> Chad
> cnale_at_microtaskinc.com
>
> Richard Price <explore65_at_yahooo.com> wrote in message
> news:Pylq3.464$ED3.28462_at_news.uswest.net...
> > Hello - I've got a fresh install of O8 PE that I can see and talk to over
> > SQL Plus via the BEQ protocol. What I can't do it talk to it over
> TCP/IP.
> > I can talk to other servers fine, indicating that sql net is installed and
> > working. I am using the following entry.
> >
> > LOC_IP.WORLD =
> > (DESCRIPTION =
> > (ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(HOST =
> > 192.168.100.200)(PORT = 1521))
> > (CONNECT_DATA =
> > (SID = ORCL)
> > )
> > )
> >
> > It produces the following error in SQL plus; "ORA-12224: TNS No
> linster".
> >
> > Now on my NT box under similar circumstances, I was a able to find the the
> > listener process and start it when it was stopped. How can I do this
> under
> > 98? Maybe this is one of those ares where O8 PE may have difficulties
> under
> > 98? It's interesting that it runs fine unde rsome protocols and not
> others.
> >
> > Thanks,
> > Richard
> >
> >

Simple, you donot have a listener runnnig for PO 8. Look for a file called listener*. This controls bring tnslistener80 or stops it. Kick this off, it will give you a MSDOS promprt. Say start then say status... It will give you whether start is successful or not then try connecting... Also look at tnsnames.ora. Make sure they are correct.... That's all needed... Received on Fri Aug 06 1999 - 10:58:42 CDT