Re: Can not connect sql *plus

Is the oracle listener running ? Try (on a dos prompt) "lsnrctl status". In the installation of Developer, the forms sqlnet doesn't know where is your database.

Documentation -> sqlnet, local database, net8

Other tips: take a look in the registry under HKLM/software/oracle the voice ORACLE_SID and LOCAL (I think you have more than 1 oracle_home, so look in that of Forms and in the main tree (software/oracle)

bye

"Ross" <roshanpatel24_at_yahoo.com> wrote in message news:<cp4_7.2529$lt4.120941_at_ozemail.com.au>...
> I can connect to database by sql Plus which came with the 8i CD. But I can't
> login with sql *plus which came with Forms 6i.
>
>
> "Ross" <roshanpatel24_at_yahoo.com> wrote in message
> news:IyOY7.676$lt4.37402_at_ozemail.com.au...
> > Hi,
> >
> > I have installed Oracle 8i Enterprise edition on Windows 2000 OS. Also I
> > have installed Forms/Reports 6i.
> > when I start sql *plus and insert username/password then I get following
> > error. I can not connect to the database. I checked in the "Task Manager",
> > that the oracle.exe is running.

> >
> > ERROR:
> > ORA-12203: TNS: Unable to connect to destination.
> >
> > I tried various username/Password but same error. It logs me out after
> three
> > attempt.
> >
> > Any advise,
> >
> > Ross
> >
> >
Received on Mon Jan 07 2002 - 09:30:24 CST