asked on

ld.so.1: oracle: fatal: libodm10.so: open failed:

Running Oracle 10g under solaris 9

When I try going into sqlplus as user b, i get message:

Enter user-name:
ld.so.1: oracle: fatal: libodm10.so: open failed: No such file or directory
ERROR:
ORA-12547: TNS:lost contact

I go in as user a and everything is fine. I've copied user a .profile to user b and still get the error.
Any ideas what is the problem?

xoxomos

ASKER

I've just noticed, the userid that works has both a .profile and a .bash_profile
The one that doesn't has only a .profile.

schwertner

The OS user B has to have same Oracle environment variables as user A
in order to get access to the Oracle binaries and libraries.

xoxomos

ASKER

Yeah, I copied Oracles .profile into user b but that doesn't seem to make a difference.

xoxomos

ASKER

If I go:
psdwp /sysadm/xoxomos $ sqlplus

SQL*Plus: Release 10.1.0.4.0 - Production on Wed Oct 19 10:50:56 2005

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: student
Enter password:
ld.so.1: oracle: fatal: libodm10.so: open failed: No such file or directory
ERROR:
ORA-12547: TNS:lost contact

Enter user-name:

But as the same os user I can go

psdwp /sysadm/xoxomos $ sqlplus student/nt311m3nt@dwproddb

SQL*Plus: Release 10.1.0.4.0 - Production on Wed Oct 19 10:52:17 2005

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL>

And everything is fine.???????????

ASKER CERTIFIED SOLUTION

argonux

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

xoxomos

ASKER

I'll close this and try to follow that thread you mentioned. Exporting the TWO_TASK inside the script even has the cron job running again ok.
Thanx