본문 바로가기
Database/Oracle

Oracle 19c RAC .bash_profile 설정 가이드

by DBTechBiz 2022. 10. 18.

 


Oracle 19c RAC .bash_profile 설정 가이드

root, grid, oracle 계정에 대한 .bash_profile 설정으로 아래의 내용을 참고하여 각 시스템에 맞게 작성


 


root 계정

경로 : /home/root/.bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific enviroment and startup programs

PATH=$PATH:$HOME/bin

export PATH
###
export PS1='\u@\h:$PWD#'
export ORACLE_BASE=/u01/app/oracle
export GI_HOME=/u01/app/19.0.0.0/grid
export RAT_CRS_HOME=/u01/app/19.0.0.0/grid
export PATH=$PATH:$GI_HOME/bin

alias sar='tail -f /working/exadata/sar_log/sar_$(date +'%Y%m%d').log'

 


grid 계정

경로 : /home/grid/.bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific enviroment and startup programs

export PATH
export TZ=Asia/Seoul
###
set -o vi
#stty erase ^?

export PS1='[$ORACLE_SID]\u@\h:$PWD> '
export INST_ID=1 #2번 노드는 INST_ID=2
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/19.0.0.0/grid
export ORACLE_UNQNAME=+ASM
export ORACLE_UNQNAME_LOWER=`echo $ORACLE_UNQNAME | tr A-Z a-z`
export ORACLE_SID=${ORACLE_UNQNAME}$INST_ID
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export NLS_LANG=American_America.KO16KSC5601

alias sa='sqlplus / as sysasm'
alias bdump='cd $ORACLE_BASE/diag/asm/+asm/+ASM${INST_ID}/trace'
alias gridlog='cd $GI_HOME/log/`hostname =s`'
alias t_asmalert='tail -f $ORACLE_BASE/diag/asm/+asm/+ASM${INST_ID}/trace/alert*.log'
alias t_crsdlog='tail -f $GI_HOME/log/`hostname -s`/crsd/crsd.log'
alert t_cssdlog='tail -f $GI_HOME/log/`hostname -s`/cssd/ocssd.log'

#export DISPLAY=192.24.126.57:0.0 #GUI 모드 설치 (Server IP 주소)

 


oracle 계정

경로 : /home/oracle/.bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific enviroment and startup programs

export PATH
###
set -o vi
#stty erase ^?

export PS1='[$ORACLE_SID]\u@\h:$PWD> '
export INST_ID=1 #2번 노드는 INST_ID=2
export ASM_SID='+ASM${INST_ID}'
export ORACLE_BASE=/u01/app/oracle
export GI_HOME=/u01/app/19.0.0.0/grid
export ORACLE_HOME=$ORACLE_BASE/product/19.0.0.0/dbhome_1
export ORACLE_UNQNAME=ORADB
export ORACLE_UNQNAME_LOWER=`echo $ORACLE_UNQNAME | tr A-Z a-z`
export ORACLE_SID=${ORACLE_UNQNAME}$INST_ID
export PATH=$PATH:$GI_HOME/bin:$ORACLE_HOME/bin:$GI_HOME/OPatch:$ORACLE_HOME/OPatch
export TNS_ADMIN=$GI_HOME/network/admin
export NLS_LANG=American_America.KO16KSC5601
export DIAGNOSTIC_DEST='/log/oracle'
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

alias sd='sqlplus / as sysdba'
alias bdump='cd $DIAGNOSTIC_DEST/diag/rdbms/${ORACLE_UNQNAME_LOWER}/${ORACLE_SID}/trace'
alias t_dbalert='tail -30f $DIAGNOSTIC_DEST/diag/rdbms/${ORACLE_UNQNAME_LOWER}/${ORACLE_SID}/trace/alert*.log'
alias oratop='$ORACLE_HOME/suptools/oratop/oratop -r / as sysdba'
반응형

댓글