Personal Oracle is designed to be just that ... personal. A standalone
database (ala MS Access). There is no listener with Personal Oracle so you
cannot connect to it from a remote client. If that is the functionality you
desire, then you need - minimally, Workstation edition or, perhaps,
Enterprise Edition.
Richard Price wrote in message <2YBt3.4051$gu5.375106_at_news.uswest.net>...
>trying this again ...
>
>From: Richard Price <explore65_at_yahooo.com>
>Subject: Oracle 8 Personal Edition - can't talk to instance over tcp/ip
>Date: Thursday, August 05, 1999 1:25 PM
>
>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
>
>
>
>
Received on Sun Aug 15 1999 - 22:57:50 CDT
