Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can not connect sql *plus

Re: Can not connect sql *plus

From: Bricklen Anderson <bricklen_at_shaw.ca>
Date: Sun, 06 Jan 2002 23:14:58 GMT
Message-ID: <3C38DA0A.64BFC1A7@shaw.ca>


you have two different tnsnames.ora files for that. one with Forms, the other with the db. Either use both of the net8 assistants to configure, or easier yet, just copy the good tnsnames file and overwrite (or append, your choice) the tnsnames.ora file that isn't configured.

hth
Ross wrote:
>
> 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 Sun Jan 06 2002 - 17:14:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US