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

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12203

Re: ORA-12203

From: Joel Garry <jgarry_at_my-deja.com>
Date: Wed, 15 Nov 2000 19:36:46 GMT
Message-ID: <8uuokd$mjo$1@nnrp1.deja.com>

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

Original text of this message

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