vi ~oracle/.bash_profile 오라클 계정 환경 설정 추가
export TMP=/tmp export TMPDIR=$TMP export EDITOR=vi export ORACLE_BASE=/opt/oracle export ORACLE_HOME=$ORACLE_BASE/product/23c/dbhomeFree export ORACLE_SID=FREE export ORACLE_TERM=xterm export BASE_PATH=/usr/sbin:$PATH export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin::$BASE_PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib export NLS_LANG=AMERICAN_KOREA.AL32UTF8 export PS1='[\u@$ORACLE_SID \W]$ '
{}
데이터베이스 접속
sqlplus / as sysdba
$ sqlplus / as sysdba SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Wed Apr 12 11:33:59 2023 Version 23.2.0.0.0 Copyright (c) 1982, 2023, Oracle. All rights reserved. Connected to: Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release Version 23.2.0.0.0 SQL> select status from v$instance; STATUS ------------------------------------ OPEN