I tried it but didn't work. Any thing else.
"Bricklen Anderson" <bricklen_at_shaw.ca> wrote in message
news:3C33C80C.8467C1EF_at_shaw.ca...
> I had the same problem. I just copied my tnsnames and sqlnet files from
> $ORACLE_HOME/network/admin (I believe that's the right path) into my
> Developer directory under the net80 folder etc. that did the trick for
> me.
>
> Ross wrote:
> >
> > Thanks.
> >
> > How to setup tnsnames.ora file. Also how to get Error help files.
> >
> > "Ron Reidy" <rereidy_at_indra.com> wrote in message
> > news:3C33C26F.2D856327_at_indra.com...
> > > Ross wrote:
> > > >
> > > > 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
> > > $ oerr tns 12203
> > > 12203, 00000, "TNS:unable to connect to destination"
> > > // *Cause: Invalid TNS address supplied or destination is not
listening.
> > > // This error can also occur because of underlying network transport
> > > // problems.
> > > // *Action: Verify that the service name you entered on the command
line
> > > // was correct. Ensure that the listener is running at the remote node
> > > and
> > > // that the ADDRESS parameters specified in TNSNAMES.ORA are correct.
> > > // Finally, check that all Interchanges needed to make the connection
> > > are
> > > // up and running.
> > >
> > > You do not have tnsnames.ora set up correctly. Also look at
sqlnet.ora.
> > > --
> > > Ron Reidy
> > > Oracle DBA
Received on Wed Jan 02 2002 - 21:34:40 CST
