Oracle Database 19c RPM Install

1. root 유저로 Oracle DB를 설치하기 위한 준비

yum install bc bind-utils compat-libcap1 compat-libstdc++-33 glibc-devel ksh libaio-devel libstdc++-devel net-tools nfs-utils psmisc smartmontools sysstat unzip xorg-x11-utils xorg-x11-xauth

2. root 유저로 preinstall 패키지 설치

rpm -ivh oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

3. root 유저로 소프트웨어 설치

rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm

4. root유저로 기본 데이터베이스 생성

/etc/init.d/oracledb_ORCLCDB-19c configure

5. 설치 경로 확인

cd /opt/oracle
ls -ltra

6. DB 프로세스 확인

[root@ol7 oracle]# ps -ef | grep ora_ | grep -v grep
oracle   19606     1  0 19:09 ?        00:00:00 ora_pmon_ORCLCDB
oracle   19608     1  0 19:09 ?        00:00:00 ora_clmn_ORCLCDB
oracle   19610     1  0 19:09 ?        00:00:00 ora_psp0_ORCLCDB
oracle   19612     1  1 19:09 ?        00:00:03 ora_vktm_ORCLCDB
oracle   19616     1  0 19:09 ?        00:00:00 ora_gen0_ORCLCDB
oracle   19618     1  0 19:09 ?        00:00:00 ora_mman_ORCLCDB
oracle   19622     1  0 19:09 ?        00:00:00 ora_gen1_ORCLCDB
oracle   19625     1  0 19:09 ?        00:00:00 ora_diag_ORCLCDB
oracle   19627     1  0 19:09 ?        00:00:00 ora_ofsd_ORCLCDB
oracle   19630     1  0 19:09 ?        00:00:00 ora_dbrm_ORCLCDB
oracle   19632     1  0 19:09 ?        00:00:00 ora_vkrm_ORCLCDB
oracle   19634     1  0 19:09 ?        00:00:00 ora_svcb_ORCLCDB
oracle   19636     1  0 19:09 ?        00:00:00 ora_pman_ORCLCDB
oracle   19638     1  0 19:09 ?        00:00:00 ora_dia0_ORCLCDB
oracle   19640     1  0 19:09 ?        00:00:00 ora_dbw0_ORCLCDB
oracle   19642     1  0 19:09 ?        00:00:00 ora_lgwr_ORCLCDB
oracle   19644     1  0 19:09 ?        00:00:00 ora_ckpt_ORCLCDB
oracle   19646     1  0 19:09 ?        00:00:00 ora_smon_ORCLCDB
oracle   19648     1  0 19:09 ?        00:00:00 ora_smco_ORCLCDB
oracle   19650     1  0 19:09 ?        00:00:00 ora_reco_ORCLCDB
oracle   19652     1  0 19:09 ?        00:00:00 ora_w000_ORCLCDB
oracle   19654     1  0 19:09 ?        00:00:00 ora_lreg_ORCLCDB
oracle   19656     1  0 19:09 ?        00:00:00 ora_w001_ORCLCDB
......

7. 리스너 프로세스 확인

[root@ol7 oracle]# ps -ef | grep tnslsnr | grep -v grep
oracle   16445     1  0 18:51 ?        00:00:00 /opt/oracle/product/19c/dbhome_1/bin/tnslsnr LISTENER -inherit

8. oracle 유저로 데이터베이스 접속

export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export ORACLE_SID=ORCLCDB
export PATH=$PATH:$ORACLE_HOME/bin
export NLS_LANG=KOREAN_KOREA.AL32UTF8
sqlplus / as sysdba

* 이 방법의 경우 세션 소멸 시 초기화되어버림

/home/oracle/.bash_profile 파일에 해당 내용 추가

export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export ORACLE_SID=ORCLCDB
export PATH=$PATH:$ORACLE_HOME/bin
export NLS_LANG=KOREAN_KOREA.AL32UTF8

바로 적용을 위해

source .bash_profile