Oracle : set oraenv

RInovation 2019. 10. 4. 07:59

(2020-05-26 수정) : Grid 19c 에서 oratab의 위치는 /var/opt/oracle/oratab

[oracle :/ #] cat /etc/oratab
TEST01:/u01/app/oracle/product/11.2.0.4/db_1:N TEST02:/u01/app/oracle/product/12c/db_1:N TEST03:/u01/app/oracle/product/19c/db_1:N

[oracle :/ #] su - oracle

[oracle :/ $] type oraenv
oraenv is /usr/local/bin/oraenv

[oracle :/ $] . oraenv
ORACLE_SID = [TEST01] ? TEST03

[oracle :/ $] env

- Oracle HOME, SID 확인