1 2 Previous Next 28 Replies Latest reply: Feb 11, 2013 1:51 PM by 972355 RSS

    Env settings for oracle user ,  when installing Oracle on linux

    972355
      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
          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
            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
              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
                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
                  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
                    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
                      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
                        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
                          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
                            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
                              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
                                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
                                  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
                                    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