I haven't used Personal Oracle in a long time, but IIRC, it
was a single user system and intentionally had no sql*net
listener. You connected with two-task using a 2: or local
or something similar...of course I could be totally off base
since it's late and I'm tired....
"Gary" <garygfx_at_hotmail.com> wrote in message
news:92m1v1$q3c$1_at_neptunium.btinternet.com...
> "Reiling Lee" <reiling.lee_at_dwp.net> wrote:
> > I am new here and trying to learn Oracle. I downloaed a copy of Oracle
> > Personal 8i Edition for Win 98. I had no problem to install it for the
> > default settings. However, when I tried to run sqlplus, I got the error
> > message for "no listener". What do I need to do to start the listener?
Can
I
> > install more than one copy of Oracle on the same machine? If so, why
would
I
> > do it and what would be the pros and cons?
>
> I have the same problem - I don't think Oracle Corp completed the setup
for
> Win98 users. Here's a message written a little earlier in this newsgroup.
> I'm sure the author won't mind me copying it in below. It looks helpful
but
> I haven't tried it myself yet.
>
> Best regards,
> Gary.
>
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:92dk1s$6qbm7$3_at_ID-62141.news.dfncis.de...
> >
> > You need to setup a listener and you need to setup tnsnames.ora.
> > You can do so using the Net8 Configuration Assistant.
> > You need to configure either the IPC protocol or the TCP protocol (It
looks
> > like Microsoft has deleted netbeui from win98, which is the protocol
Oracle
> > calls named pipes).
> > If you use the TCP protocol, your best bet is to use 'localhost' as your
> > host name, and enter the following line in your
> > \windows\hosts file
> > 127.0.0.1 localhost
> > Make sure you can ping localhost from a dos box, this will verify the
tcp/ip
> > protocol is properly functioning.
> > If you are asked for a SID and you took all defaults, the SID is ORCL,
and
> > the ORACLE_HOME directory
> > c:\oracle\ora81
> > In the tnsnames configuration you need to make sure you choose Net8
> > compatible configuration and again specify host, sid and oracle_home.
Also
> > everywhere use the default port of 1521.
> > After configuration you need to issue lsnrctl start in a DOS box.
> > If you get that working, you can either use ODBC (non-native protocol)
or
> > Oracle Objects for OLE (native protocol) . In the former case you need
the
> > ODBC administrator applet to setup a proper ODBC connection.
> > I just went through the procedure myself yesterday, and I didn't yet
> > configure ODBC, which is not much of a priority for me, as I don't have
a
> > recent version of VB.
> > If you require further assistance respond to me privately, preferably in
> > Dutch
> >
> > Regards,
> >
> > Sybrand Bakker, Oracle DBA
>
>
>
Received on Sat Dec 30 2000 - 22:55:51 CST
