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

    Question by:
    On

    Topics:

    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?

    Good Question?
    0
     

    ?

    The member who asked this question verified this comment provided the solution that solved their problem.

    Accepted Solution on 2005-10-19 at 12:45:09ID: 15119149

    Try to follow this thread, it is simular to your problem.
    http://www.experts-exchange.com/Databases/Oracle/Q_21593541.html

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

    Top Expert Contributor

    Essential articles and videos from the Experts

    More valuable questions with Expert answers

    201511-LO-Qu-074

    Extend your technology team with the Experts Exchange community.

    — trusted by —

    Who answers my questions?Our community has technology experts around the world.

    slightwv

    8,680

    Solutions

    Expert in:

    • Oracle Database
    • Databases-Other
    • Query Syntax
    • Linux
    • Unix OS

    sdstuber

    14

    Articles

    7,393

    Solutions

    Expert in:

    • Oracle Database
    • Query Syntax
    • Databases-Other
    • Enterprise Software
    • MS SQL Server

    johnsone

    2,110

    Solutions

    Expert in:

    • Oracle Database
    • Databases-Other
    • Query Syntax
    • Linux
    • Unix OS

    Gerwin Jansen

    5

    Articles

    1,859

    Solutions

    Expert in:

    • Linux
    • Unix OS
    • Linux Distributions
    • Oracle Database
    • Scripting Languages

    awking00

    2,136

    Solutions

    Expert in:

    • Oracle Database
    • Query Syntax
    • Databases-Other
    • MS SQL Server
    • Java

    Docteur_Z

    86

    Solutions

    Expert in:

    • Oracle Database

    wilcoxon

    899

    Solutions

    Expert in:

    • Perl
    • Shell Scripting
    • Linux
    • Regular Expressions
    • Scripting Languages

    Kdo

    2

    Articles

    3,892

    Solutions

    Expert in:

    • C
    • DB2
    • MySQL Server
    • C++
    • Databases-Other

    Jim Horn

    18

    Articles

    10,529

    Solutions

    Expert in:

    • MS Access
    • MS SQL Server
    • MS SQL Server 2008
    • MS SQL Server 2005
    • Query Syntax

    RELATED TOPICS view all topics

    1. Query Syntax
      (46,101)
    2. Databases-Other
      (53,010)
    3. MS SQL Server
      (154,713)
    4. Unix OS
      (33,021)
    5. Enterprise Software
      (5,604)
    6. Linux
      (64,246)
    7. Java
      (98,163)
    8. .NET Programming
      (131,132)
    9. MS SQL Server 2005
      (71,596)
    10. MySQL Server
      (45,807)