2 Replies Latest reply: Nov 19, 2012 1:46 PM by Balazs Papp RSS

    Required User Variables

    895327
      I don't know if there's a definitive / specific answer for this question but it's one thing I can't seem to really understand. I've read the 11g R2 docs which advise you that if you're using Bash$ in Linux, then you're going to add entries in your $.bash_profile and they tell you just which ones you need to get the OUI installer running on a Linux system. They don't however clearly recommend or display examples or what you 'should' have in your Oracle users home environment. So besides the few that are listed below, are there any other mandatory 'env' variables I should / must have in a production Oracle 11g R2 Enterprise Edition system?
      # User specific environment and startup programs
      
      PATH=$PATH:$HOME/bin
      ORACLE_BASE=/u01/app/oracle
      ORACLE_HOME=$ORACLE_BASE/product/11.2/db1
      ORACLE_SID=ide
      
      export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID
        • 1. Re: Required User Variables
          sb92075
          ORACLE_BASE=/u01/app/oracle
          ORACLE_HOME=$ORACLE_BASE/product/11.2/db1
          ORACLE_SID=ide
          PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

          export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID
          • 2. Re: Required User Variables
            Balazs Papp
            actually none of these are mandatory or "must have" in your profile
            they just make your life easier so you dont have to set them at each login
            its comfortable when you have only 1 instance on a server, but not much of use when you have several in different homes

            1.2.1 & 1.2.2 & 1.2.3 :
            http://docs.oracle.com/cd/E11882_01/server.112/e10839/admin_ora.htm

            you can however simply set the enviroment by e.g:
            . oraenv
            which will prompt for a SID, then read /etc/oratab and set the variables based on that