본문
[ORACLE] You may need to set ORACLE_HOME to your Oracle software directory
DB(Oracle) 2020. 1. 28. 13:38
반응형
1. bash_profile 수정
# cd
# vi .bash_profile
...
export PATH
export TMP=/tmp
export TMPDIR=/tmp
export ORACLE_BASE=/home/oracle/db
export ORACLE_SID=orcl
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1
export ORACLE_HOME_LISTNER=$ORACLE_HOME/bin/lsnrctl
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH=$ORACLE_HOME/bin:$PATH
2. 수정사항 적용
# source .bash_profile
3. Oracle 기동
1) sqlplus "/as sysdba"
2) SQL> startup
3) exit
4) lsnrctl start
→ 참조
반응형
댓글