How Unix user can Access Oracle
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: How Unix user can Access Oracle

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    224
    I installed Oracle on Unix, When I logon as Oracle, I can use SQLPLUS and other tools and utilities.

    I created another user on Unix, What should I do to enable this new user to acess Oracle. What setting I have to do in his .profile

    I already have Database user created for this user.

  2. #2
    Join Date
    Nov 2000
    Posts
    205
    Have you granted this user connect and create session privileges?

    Nirasha
    Nirasha Jaganath

  3. #3
    Join Date
    Mar 2001
    Posts
    635
    Hi

    I hope you have given proper access for the oracle database user

    The changes you have to make to ur .profile for the new unix user are the following

    for example

    export ORACLE_HOME=/oracle

    export PATH=$PATH:/ORACLE_HOME/bin:

    export LD_LIBARY_PATH=/ORACLE_HOME/lib

    export ORACLE_SID=ORACLESID

    Change the above accoring to ur environment

    Or


    the best thing is try to copy the .profile of Oracle user that is the unix user to the new user's home directory

    Regards
    Santosh

  4. #4
    Join Date
    Nov 2000
    Posts
    205
    Sorry I misread your thread, I did not realise it was an OS user. The user above is absolutely correct, the environment variables need to be the same.

    Also you should check that the user is part of DBA/Oracle etc group on UNIX. Tjis ensures that not only does he know where the executables are but also has rights to run them.

    Sorry about that.
    Nirasha
    Nirasha Jaganath

  5. #5
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    to finish the thread, if the OS user is in the dba group, he can conenct internal without password

  6. #6
    Join Date
    Nov 2000
    Posts
    224
    I set all the required environment variables in .profile of root, I logged in in Unix as root (OS USERNAME). When I invoke SQLPLUS, I get the following error,

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


    It works fine when I logon to Unix as Oracle (OS Username oracle).
    Infact, I copied oracle user's .profile to root user's .profile even then I get this message.

    Please help me in resolving this.

  7. #7
    Check the variable $PATH, check the order of the PATH, if root has more then put them at last, I mean
    root's PATH=/bin;/usr/bin;/usr/ucb/bin;/app/oracle/bin.....etc
    oracle's PATH=/app/oracle/bin;/usr/bin;/bin;/local/bin
    Then =>
    root's PATH=/app/oracle/bin;/usr/bin;/bin;/local/bin;/usr/ucb/bin;...etc
    I guess the problem is ucb path
    Ramon Caballero, DBA, rcaballe@yahoo.com

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I think the easiest way to setup your environment is to source the oraenv (or coraenv) file in $OH/bin
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  9. #9
    Join Date
    Nov 2000
    Posts
    224
    As I mentioned earlier, even If I copy the .profile of user "oracle" with right settings and for this user everything is working fine to root user's .profile the error following message comes,

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





  10. #10
    Join Date
    Mar 2001
    Posts
    635
    Hi

    Just try this from root user


    sqlplus username/password@oraclesid

    replace username with ur db username

    replace password with ur db password

    replace oraclesid with ur sid

    There are lot of issues like urs in metalink

    Regards
    Santosh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width