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'
반응형
'Database > Oracle' 카테고리의 다른 글
Oracle Tablespace 생성/수정/삭제 (ASM 사용) (0) | 2022.10.18 |
---|---|
Oracle RAC 서버 재기동 시 DB 자동시작(AUTO_START) 변경 (0) | 2022.10.18 |
Excel Visual Basic 을 이용한 Oracle dba_users 정보 가져오기 (0) | 2022.09.13 |
ACFS 공유볼륨 생성/삭제/동적늘리기,줄이기 (0) | 2022.09.13 |
RMAN 을 이용한 Daily Archive Log 삭제 스케쥴러 (Delete daily archive log using rman) (0) | 2022.09.08 |
댓글