Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12203
In article <8sn0oj$1kc$1_at_nnrp1.deja.com>,
jocave_at_my-deja.com wrote:
> In article <8slkee$ksd$1_at_news6.jaring.my>,
> "sean" <sean_at_kistem.po.my> wrote:
> > Hi all,
> >
> > Can anyone help me to resolve the following problem, on my Win95 ?
> >
> > SQLSTATE: 08001
> > Native Error Code:12203
> > Driver Manager [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-12203:
> > TNS: unable to connect to destination
> >
> > Our Oracle7.3.4 is installed on a WinNt 4 Server, on a LAN network.
> > Appreciate if anyone could help.
>
> - Can other machines connect to this database, or has the listener
gone
> down?
> - If other machines can connect, I suspect that your TNS name is
> misconfigured. From the Net8 Easy Config utility, you can test the
TNS
> name you created for this database. If the test fails, you've
entered
> one of the parameters incorrectly-- look at machines that can connect
> and make sure your settings agree with theirs.
Anyone ever figure out what this is? I'm having it on one of my
clients. I've whittled it down to a simple case. I'm using onames,
sqlplus 8, to a 7.3.4 db. tnsping works fine, connecting with the
password as part of the string works fine, having the sqlplus prompt
for the password (either with a connect statement or with the original
login screenlet) gets the ora 12203. It's almost as though it is
trying to use encryption at that time or something. On my own client
it works fine, but on another client supposedly configured the same it
doesn't.
>
> --
> Justin Cave - Oracle ODBC Development
>
> Opinions expressed herein are my own and may not reflect those of
> Oracle Corporation.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
jg
-- These opinions mine mailto:joel-garry_at_nospam.home.com Remove nospam to mail http://ourworld.compuserve.com/homepages/joel_garry Sent via Deja.com http://www.deja.com/ Before you buy.Received on Wed Nov 15 2000 - 13:36:46 CST