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
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