Re: How do I connect SQLPlus to Oracle 8 ?

Hai

     The problem may lie in not setting the correct ORACLE_SID parameter . Run regedit . GO to local_machine goto software goto oracle and look for ORACLE_SID . set the properly to your sid .This should work

           Bye vinod
vinod_km_at_yahoo.com

Prakash Siva wrote in message <6mf6pg$33h$1_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 Wed Jun 24 1998 - 04:56:04 CEST