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: Error ORA-03121 with Oracle 8.0.4

Re: Error ORA-03121 with Oracle 8.0.4

From: Troy Meyerink <meyerink_at_edcmail.cr.usgs.gov>
Date: 2000/07/05
Message-ID: <3963A1D7.453EEB1@edcmail.cr.usgs.gov>#1/1

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
> ------------------------------------------------------------------------
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jul 05 2000 - 00:00:00 CDT

Original text of this message

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