Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How do I connect SQLPlus to Oracle 8 ?

Re: How do I connect SQLPlus to Oracle 8 ?

From: David <darussell_at_msn.com>
Date: Sat, 20 Jun 1998 23:17:48 +0100
Message-ID: <u4s2RmJn9GA.192@upnetnews05>


To connect to Personal Oracle Lite use the connect string ODBC:OLite, to connect to Personal Oracle 8 install the Net8 add-on and setup a loopback sqlnet connections.

Regards
David Russell

Prakash Siva wrote in message <6mf6qc$33h$2_at_ultra.sonic.net>...
>
>[ Article reposted from comp.database.oracle ]
>[ Author was Prakash Siva ]
>[ Posted on 19 Jun 1998 09:13:29 GMT ]
>
>Hi folks,
>
>I recently purchased Oracle Lite and Personal Oracle8 and installed them on
>my pc running win95. When I try to start SQLPlus 3.3 (which is part of
>Oracle Lite), with the login name /password as scott/tiger, I get the
error:
>
>---------------
>SQL*Plus: Release 3.3.2.0.2 - Production on Thu Jun 18 01:51:56 1998
>
>Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
>
>ERROR: ORA-03121: no interface driver connected - function not performed
>
>
>Enter user-name:
>----------------
>
>When I input the same scott/tiger combination, I again get this error.
Ditto
>for system/manager and sys/manager inputs. Error ORA-03121 is due to
>"SQL*Net driver not loaded into memory or there is a mismatch in the
version
>of the driver" (from Oracle error message list).
>
>Is SQL*Net required to connect an Oracle server and client process even if
>the server and client are on the same machine ?
>
>If not, how do I get SQLPlus to connect to the server process ?
>
>If SQL*Net is required, do I have to set up a listener process also ?
>
>Regards,
>
>Prakash.
>
Received on Sat Jun 20 1998 - 17:17:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US