| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Error ORA-03121 with Oracle 8.0.4
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 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
> > ------------------------------------------------------------------------
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
Received on Thu Jul 06 2000 - 00:00:00 CDT
 |
 |