Re: Connecting to Oracle Lite

From: John Koo <johnkoo_at_i-wave.net>
Date: Thu, 21 Jan 1999 15:02:07 -0800
Message-ID: <36A7B1EF.C46@i-wave.net>

wynnytv_at_hotmail.com wrote:
>
> The problem I've been desperately struggling with for 2 days is:
>
> I'm trying to connect to a Oracle Lite database
> using SQL*Net (TCP or IPC or BEQ).
>
> I can create a database using the Oracle8 Navigator but if I click on that
> database (or on the POLite database) I would get a password entry dialog
> saying...
>
> ora-03121: no interface driver connected - function not performed
> Please provide a database passord
>
> To me this means that when Oracle8 Navigator failed to connect to the table,
> it then presumed the error to be a denial of service from Oracle security and
> it then falsely responded by prompting for a password.
>
> This ora-03121 error is what I get in every SQL*Net application using the
> format documented by Oracle...
>
> username = SYSTEM
> password = anything
> host string = ODBC:My_DSN:My_ODB_File
>
> I can however connect to OraLite Databases through pure ODBC applications
> like Access and MS-Query where all I need to specify is the DSN. MS-Query
> even lets me create tables, but I ultimately need to use IMP80.EXE to import
> a whole schema.
>
> Whenever I needed to take Oracle Enterprise Server on the road on a laptop I
> would use Beq-local.world. But in Oracle Lite BEQ is not one of the
> protocols to choose from. I suppose my other options are using
> Tcp-loopback.world or making a local TNS entry using the IPC protocol. These
> I have tried to setup using the "Oracle Net8 Assistant" which configures the
> files tnsnames.ora, listener.ora, and sqlnet.ora. If you don't think you can
> help me, I would still very much appreciate if I could have a look at your
> copies of these files.
>
> Thanks in advance,
>
> Victor Wynnytsky
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

How does one connect to a POL database?

To connect to a POL database, the username is typically SYSTEM (with POL v2.4 the default username is OOT_SCH). The password is ignored as the POL database is initially not password protected, but must be specified for SQL*Plus. The connect string should be ODBC:data_source_name. The "ODBC:" tells SQL*Plus that this is not a SQL*Net connection,

and that it must use the Oracle Open Client Adapter (OCA) to access the database. 
                         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

The following command line is used to access the default starter database via SQL*Plus:

     plus33 system/manager_at_odbc:polite:polite
     SQL> select * from all_tables;
     SQL> exit;

John Koo Received on Thu Jan 21 1999 - 17:02:07 CST