Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


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

Posted on 2005-10-19
Medium Priority
Last Modified: 2007-12-19
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
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?
Question by:xoxomos
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4

Author Comment

ID: 15114780
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.  
LVL 48

Expert Comment

ID: 15115029
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.

Author Comment

ID: 15117548
Yeah, I copied Oracles .profile into user b but that doesn't seem to make a difference.
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments


Author Comment

ID: 15118242
If I go:
psdwp /sysadm/xoxomos $ sqlplus

SQL*Plus: Release - 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
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 - 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 - 64bit Production
With the Partitioning, OLAP and Data Mining options


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


Accepted Solution

argonux earned 1200 total points
ID: 15119149
Try to follow this thread, it is simular to your problem.

The way you tried to connect before is called a direct/bequeath connection. This works by directly creating a new oracle process from sqlplus and comunicating with it using a pipe (no listener involved) . But since you were running it as a different user it was having some problems starting, I am not sure exactly why, maybe its permissions on the shared memory segments or the actual data files. In principle it should be able to work this way,even from another user, but maybe not on all platforms and depending on permissions, I am not sure.

The second way was connecting via the network listener (dependant on your tnsnames configuration) and the oracle process will get started by the oracle user, so there are no problems with permissions on shared memory or files.

You can set a TWO_TASK environment variable to dwproddb and the it would connect without specifying the @dwproddb.
When TWO_TASK is defined any connection you make without specifying a TNS entry will get "@TWO_TASK" glued to it before trying to connect. This works exactly as if you have connected to "sqlplus user/pass@dwproddb".

Author Comment

ID: 15119584
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.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question