No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

FusionCube DB 3.1 Database Best Practice 03 (Oracle RAC 11g R2)

Rate and give feedback :
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
Configuring Environment Variables

Configuring Environment Variables

Procedure

  1. Plan ORACLE_UNQNAME for the database before configuring Oracle environment variables for each Oracle RAC node. Ensure that a unique Oracle SID is assigned to each RAC node (for example, dbn01 and dbn02).

    dbn01: ORACLE_SID=dbn01
    dbn02: ORACLE_SID=dbn02

  2. Modify the .bash_profile file as user oracle. Add the following content. To add the content to other nodes, change the value of ORACLE_SID, which is in bold (for example, dbn01).

    NOTE:

    Change the value of ORACLE_SID for another database node to dbn02. If there are more database nodes, change the values accordingly (for example, dbn03 and dbn04).

    [root@dbn01~]# su - oracle 
    [oracle@dbn01 ~]# vi .bash_profile  
    # Oracle Settings 
    TMP=/tmp; export TMP 
    TMPDIR=$TMP; export TMPDIR 
    ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE 
    ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db; export ORACLE_HOME 
    ORACLE_UNQNAME=dbn; export ORACLE_UNQNAME 
    ORACLE_SID=dbn01; export ORACLE_SID 
    ORACLE_TERM=xterm; export ORACLE_TERM 
    BASE_PATH=/usr/sbin:$PATH; export BASE_ 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 
    NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT 
    NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG     

  3. Modify the .bash_profile file as user grid. Add the following content. To add the content to other nodes, change the value of ORACLE_SID, which is in bold (for example, dbn01).

    NOTE:

    Change the value of ORACLE_SID for another database node to +ASM2. If there are more database nodes, change the values accordingly (for example, +ASM3 and +ASM4).

    [root@dbn01~]# su - grid 
    [grid@dbn01 ~]# vi .bash_profile  
    TMP=/tmp; export TMP 
    TMPDIR=$TMP; export TMPDIR 
    ORACLE_BASE=/u01/app/grid; export ORACLE_BASE 
    ORACLE_HOME=/u01/app/11.2.0/grid; export ORACLE_HOME 
    ORACLE_SID=+ASM1; export ORACLE_SID 
    NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT 
    THREADS_FLAG=native; export THREADS_FLAG  
    PATH=$ORACLE_HOME/bin:$PATH; export PATH     

  4. Set environment variables as user root. Add the following content (for example, dbn01):

    [root@dbn01 ~]# vi .bash_profile 
    export GRID_HOME=/u01/app/11.2.0/grid 
    export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db 
    export PATH=$GRID_HOME/bin:$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin     

Translation
Download
Updated: 2018-12-26

Document ID: EDOC1100035759

Views: 24240

Downloads: 32

Average rating:
This Document Applies to these Products
Related Documents
Related Version
Share
Previous Next