xoxomos
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?
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?
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.
in order to get access to the Oracle binaries and libraries.
ASKER
Yeah, I copied Oracles .profile into user b but that doesn't seem to make a difference.
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.???????????
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Thanx
ASKER
The one that doesn't has only a .profile.