This discussion is archived
2 Replies Latest reply: Nov 19, 2012 11:46 AM by Balazs Papp RSS

Required User Variables

895327 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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

Legend

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