This discussion is archived
1 2 Previous Next 28 Replies Latest reply: Feb 11, 2013 11:51 AM by 972355 RSS

Env settings for oracle user ,  when installing Oracle on linux

972355 Newbie
Currently Being Moderated
Good Morning Oracle Experts ;

Basicallly my major subject is Electrical and Electronics

I am very new to ORACLE/LINUX [ LEARNING  ORACLE  DBA ] Technology.
I have THREE questions .. Please help me to understand oracle concepts.

QUES  1 :
i am getting confused about “setting bash_profile” and it’s contents
I googled , it said to set env variables for oracle user. Ok .
Can anyone explain clearly what exactly happens when “ setting bash_profile ” ?


MY   BASH_PROFILE SETTINGS
My  bash_profile having  following contents  :

+# Oracle Settings+
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=TSH1; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
+#LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL+

+if [ $USER = "oracle" ]; then+
+if [ $SHELL = "/bin/ksh" ]; then+
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi

QUES  2 :

Please  note  : This  url  says   lot of  env  variables

http://www.idevelopment.info/data/Oracle/DBA_tips/Unix/UNIX_4.shtml

2 . In my case , Why following env variables *[LD_ LIBRARY_PATH , CLASS_PATH , PATH]* are missing ?

My  pc  showing  only  four  env variables   $ env  |  grep  -e  ORA  -e  TNS

ORACLE_SID=TSH1
ORACLE_BASE=/u01/app/oracle
ORACLE_TERM=xterm
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1

QUES 3 :

*[ LD_ LIBRARY_PATH , CLASS_PATH , PATH ]*

*Are  they  [ above mentioned  env  variables] necessary (or) not necessary for oracle DB ?*
When listing  env  variables ,  why   they  are  not  displayed  ? (anything  wrong ) ?


As  a  beginner , I expect  some  clean  technical  information    to  improve my knowledge  ..
Thanks in advance ;
  • 1. Re: Env settings for oracle user ,  when installing Oracle on linux
    sb92075 Guru
    Currently Being Moderated
    post results from following OS commands using COPY & PASTE

    id
    env | sort
  • 2. Re: Env settings for oracle user ,  when installing Oracle on linux
    972355 Newbie
    Currently Being Moderated
    Required Output

    *$ id*

    uid=502(oracle) gid=502(oinstall) groups=502(oinstall),503(dba)

    *$ env | sort*

    CLASSPATH=/u01/app/oracle/product/10.2.0/db_1/JRE:/u01/app/oracle/product/10.2.0/db_1/jlib:/u01/app/oracle/product/10.2.0/db_1/rdbms/jlib
    COLORTERM=gnome-terminal
    DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-s2yfterD04
    DESKTOP_SESSION=default
    DISPLAY=:0.0
    G_BROKEN_FILENAMES=1
    GDMSESSION=default
    GNOME_DESKTOP_SESSION_ID=Default
    GNOME_KEYRING_SOCKET=/tmp/keyring-oJUn3E/socket
    GTK_RC_FILES=/etc/gtk/gtkrc:/home/oracle/.gtkrc-1.2-gnome2
    HISTSIZE=1000
    HOME=/home/oracle
    HOSTNAME=linuxserver
    INPUTRC=/etc/inputrc
    LANG=en_US.UTF-8
    LESSOPEN=|/usr/bin/lesspipe.sh %s
    LOGNAME=oracle
    LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
    MAIL=/var/spool/mail/oracle
    ORACLE_BASE=/u01/app/oracle
    ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
    ORACLE_SID=TSH1
    ORACLE_TERM=xterm
    PATH=/u01/app/oracle/product/10.2.0/db_1/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/oracle/bin
    PWD=/home/oracle
    SESSION_MANAGER=local/linuxserver:/tmp/.ICE-unix/4394
    SHELL=/bin/bash
    SHLVL=2
    SSH_AGENT_PID=4450
    SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
    SSH_AUTH_SOCK=/tmp/ssh-cbAqMq4394/agent.4394
    TERM=xterm
    TMP=/tmp
    USER=oracle
    _=/usr/bin/env
    WINDOWID=42039592
    XAUTHORITY=/home/oracle/.Xauthority
  • 3. Re: Env settings for oracle user ,  when installing Oracle on linux
    sb92075 Guru
    Currently Being Moderated
    as you can see both PATH & CLASSPATH exist; while LD_LIBRARY_PATH does not exist.
  • 4. Re: Env settings for oracle user ,  when installing Oracle on linux
    972355 Newbie
    Currently Being Moderated
    I asked few questions in my first reply . May i know answers ?

    When i am connecting DB , I never received any error.

    what is the use of LD_LIBRARY_PATH for oracle user ?
  • 5. Re: Env settings for oracle user ,  when installing Oracle on linux
    sb92075 Guru
    Currently Being Moderated
    969352 wrote:
    I asked few questions in my first reply . May i know answers ?

    When i am connecting DB , I never received any error.
    I can't see what you do (since you did not provide these details), so I can't know what might be wrong.

    >
    what is the use of LD_LIBRARY_PATH for oracle user ?
    LD_LIBRARY_PATH is used/required when linking Oracle software; but not required to use Oracle software
  • 6. Re: Env settings for oracle user ,  when installing Oracle on linux
    972355 Newbie
    Currently Being Moderated
    Again i am  clearly  posting my questions :

    QUES 1 :

    i am getting confused about “setting bash_profile” and it’s contents

    Please explain clearly what exactly happens when “ setting bash_profile ” ?


    QUES 2  :

    What is the purpose of the LD_ LIBRARY_PATH , CLASS_PATH , PATH ?

    Already you mentioned LD_LIBRARY_PATH , ( Please ignore , if not required )

    Thanks sb;
  • 7. Re: Env settings for oracle user ,  when installing Oracle on linux
    Mark D Powell Guru
    Currently Being Moderated
    For the correct setting of LD_LIBRARY_PATH look in your versions specific platform specific installation guide as the value has varied in the past by platform and release.

    It may be as simple as $ORACLE_HOME/lib but if you use certain Oracle featues like Directory Serve, Application Server, etc... there can be additional requirements. The installation documentation usuallys spells the requirements out.


    Note: 1071109.6] ORAENV NOT SETTING LD_LIBRARY_PATH may be of interest.


    HTH -- Mark D Powell --
  • 8. Re: Env settings for oracle user ,  when installing Oracle on linux
    972355 Newbie
    Currently Being Moderated
    Sorry mark , I have looked your reply didn't quite get it ..

    Could you please help me to clear my doubt ?

    *$echo $LD_LIBRARY_PATH*

    *$ echo $CLASSPATH*

    /u01/app/oracle/product/10.2.0/db_1/JRE:/u01/app/oracle/product/10.2.0/db_1/jlib:/u01/app/oracle/product/10.2.0/db_1/rdbms/jlib

    *$ echo $PATH*

    +/u01/app/oracle/product/10.2.0/db_1/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/oracle/bin+


    No output  for  first  command only ...

    Edited by: 969352 on Feb 9, 2013 10:44 AM
  • 9. Re: Env settings for oracle user ,  when installing Oracle on linux
    sb92075 Guru
    Currently Being Moderated
    http://www.lmgtfy.com/?q=unix+tutorial

    You questions more involve how Unix OS is pieced together.
    I suggest you spend some time learning Unix basics.
  • 10. Re: Env settings for oracle user ,  when installing Oracle on linux
    972355 Newbie
    Currently Being Moderated
    You said to read me :

    http://www.lmgtfy.com/?q=unix+tutorial

    but i'm not a unix background . Sorry for making trouble you.

    Let me know , if you have some leisure time ..
  • 11. Re: Env settings for oracle user ,  when installing Oracle on linux
    yoonas Expert
    Currently Being Moderated
    Hi,

    Just hit the first link from the search, then you will come to know :)

    Regards
    Yoonas
  • 12. Re: Env settings for oracle user ,  when installing Oracle on linux
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    969352 wrote:
    Sorry mark , I have looked your reply didn't quite get it ..

    Could you please help me to clear my doubt ?

    *$echo $LD_LIBRARY_PATH*
    Pl see Billy's response in this thread - What is LD_LIBRARY_PATH env variable for?

    Also -

    http://docs.oracle.com/cd/E11882_01/server.112/e10839/prcmp_cll_int.htm#UNXAR192
    http://docs.oracle.com/cd/E11882_01/server.112/e10839/admin_ora.htm#CHDJDFFG
    *$ echo $CLASSPATH*

    /u01/app/oracle/product/10.2.0/db_1/JRE:/u01/app/oracle/product/10.2.0/db_1/jlib:/u01/app/oracle/product/10.2.0/db_1/rdbms/jlib

    *$ echo $PATH*

    +/u01/app/oracle/product/10.2.0/db_1/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/oracle/bin+


    No output  for  first  command only ...

    Edited by: 969352 on Feb 9, 2013 10:44 AM
    HTH
    Srini
  • 13. Re: Env settings for oracle user ,  when installing Oracle on linux
    972355 Newbie
    Currently Being Moderated
    Ok Given links says *"Purpoee of LD_LIBRARY_PATH env "*

    but i asked , *why i cant  display [LD_LBRARY_PATH] when checking oracle_env variables ?*


    why  i asked this ques => i  will  install 11g  very soon.

    will  there be any problem to install 11g ? (n my case , Some env variables are not set perfectly or missed )

    If i get exact answer to trouble shoot my problem it will be good to me .

    Thanks Srini ..
  • 14. Re: Env settings for oracle user ,  when installing Oracle on linux
    sb92075 Guru
    Currently Being Moderated
    969352 wrote:
    Ok Given links says *"Purpoee of LD_LIBRARY_PATH env "*

    but i asked , *why i cant  display [LD_LBRARY_PATH] when checking oracle_env variables ?*


    why  i asked this ques => i  will  install 11g  very soon.

    will  there be any problem to install 11g ? (n my case , Some env variables are not set perfectly or missed )
    when all else fails Read The Fine Manual; Installation Guide!

    http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame=

    simply put NO environmental variable needs to be set or established prior to invoking OUI or dbca.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points