Re: Oracle Personal 8i on Win 98

"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 - 19:26:48 CST