Re: Oracle 9i Lite and SQL*Plus

"Enzo Maini" <touringcarclub_at_hotmail.com> wrote in news:yn0q9.26453$OB5.2307650_at_newsread2.prod.itd.earthlink.net:

> I have Oracle 9i installed and I am to connect to it using the sample
> included apps.
>
> I have also created my own apps in C++ and VB 6 -- no problem
>
> How do I connect to 9i Lite using SQL*Plus?
>
> I have tried
> Username: system
> Password: aaa (I know there is no password to start with)
> Host String: ODBC:POLite
>
> What is the trick? Do I need an entry in tnsnames.ora?
>
> Thanks
>
>
>

It would have been nice if you has specified what is the OS being used. I "assume" that both the DB & SQL now reside on the same system/box. If both are on the same box, then SQL*net is not required, but could be used. To access the DB without using SQL*Net then ORACLE_SID must be set to the proper value. If when ORACLE_SID is correct, then from the command line you should be able to connect to the instance (assuming that the instance is up & running).

HTH & YMMV HAND! Received on Sat Oct 12 2002 - 16:30:37 CDT