Re: Oracle 9i Lite and SQL*Plus

First of all, its Oracle 9i Lite -- not the full Oracle database

Oracle 9i Lite and SQL Plus are both on Windows 2000 SP3

Your reply does not make any sense -- there is no up to Oracle 9i

"Ban Spam" <ban-spam_at_operamail.com> wrote in message news:Xns92A5939C79668SunnySD_at_68.6.19.6...
> "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 - 22:09:27 CDT