Re: Error ORA-03121 with Oracle 8.0.4

Ok, it was a problem of ociw32.dll which was in a bad version.

Cédric AVENAS <cedric.avenas_at_ad6.com> a écrit dans le message : 8k1hh3$l2$1_at_reader1.imaginet.fr...
> Thanks for your posts but here is more details for problem I have.
> On my NT Workstation (SP5):
>
> 1/
> I install Oracle client 8.0.4.
> 2 /
> I lauch net 8 easy config and I configure my (service ,protocol TCP IP,
> @IP). When I test the service I put my user name, my password and click
 on
> the Test button. I have the message "Trying to connect", folowed by
 another
> message which is "Error while trying to retrieve text for error 0RA
 00000".
> When I look at the Oracle documentation I read :
>
> ORA - 00000 normal, succesful completion
> Cause: An operation has completed normally, having met no exceptions
> Action: No action required.
>
> Fine!!!
>
> 3/
> I try to connect with SQL PLUS with my (user/passord_at_service) it works
 well.
>
> 4/
> I try to connect with a client application (not an oracle application) and
 I
> have the error "Unable to connect to server. Error while trying to
 retrieve
> text for error 03121" and that's all It doesn't work anyway.
>
> Note:
> ====
> I ve tried to install the Oracle 8.0.4.0.7 but it's also the same way.
>
> I know that Oracle 8.0.4 is not yet supported but Please Help ME !
>
> Troy Meyerink <meyerink_at_edcmail.cr.usgs.gov> a écrit dans le message :
> 3963A209.A19CF519_at_edcmail.cr.usgs.gov...
> > I think I had this once. The problem with the client was that there was
 a
> > special character like parens in the PC's network name. Once I renamed
 the
> > PC, SQL*Net worked fine.
> >
> > Troy Meyerink
> > Database Administrator
> > Raytheon
> > EROS Data Center
> > Sioux Falls, SD
> >
> > sybrandb_at_my-deja.com wrote:
> >
> > > In article <8jtg3a$6t2$1_at_reader1.imaginet.fr>,
> > > "Cédric AVENAS" <cedric.avenas_at_ad6.com> wrote:
> > > > I'm installing the Oracle 8.0.4 client on 6 NT Workstations (SP5).
 All is OK
> > > > for the 6 workstations.
> > > > When I use Net8 Easy Config, it's OK for 5 stations. But there is
 one
 for
> > > > which the net8 easy config tool terminate in a bad way (Watson
 Doctor), when
> > > > I try to test the service.
> > > > If I configure the TNSNAMES.ORA directly with notepad, I can use
 sqlplus
> > > > with the user/password_at_service. But when I try to access this
 service
 with
> > > > my client application (which works good on the 5 others
 workstations)
 I have
> > > > the ORA-03121 Error, which means that the net8 driver is not loaded
> > > > efficiently. I've tried to reinstall the client but it'also the same
 way.
> > > >
> > > > What I'm doing wrong?
> > > > Thanks...
> > > >
> > > >
> > >
> > > A few remarks
> > > - you are aware 8.0.4 has been desupported a long time ago? The
 current
> > > version is 8.0.6
> > > - I understand from your post you are configuring all clients
> > > separately. There´s no need to do so, and actually it is dangerous in
> > > larger organisations where local tnsnames.ora files tend to drift
> > > apart. You are advised to locate your tnsnames.ora on a network drive
> > > and have the registry string tns_admin=<directory for tnsnames.ora> in
> > > hklm\software\oracle or configure Oracle Names. Your sqlnet.ora should
> > > also go to that network drive.
> > > - Generally speaking 3121 means the driver is not loaded at all. Also
> > > generally speaking this problem occurs when
> > > . the client doesn´t specify a servicename
> > > . the default servicename oracle does not exist in tnsnames.ora
> > > - for now, if you are convinced, you don´t have the issue above I
 would
> > > recommend trying to isolate the differences between the 5 correct
> > > clients and the shitty client. There must be something on Winblows
> > > level.
> > >
> > > Hth,
> > >
> > > --
> > > Sybrand Bakker, Oracle DBA
> > >
> > > All standard disclaimers apply
> >