oracle rpm 설치

1. oracle rpm 설치(root 계정)

yum -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm

 

2. Oracle DB 생성 및 구성

vi /etc/sysconfig/oracledb_ORCLCDB-19c.conf

 

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

 

vi /etc/sysconfig/oracledb_ORCLCDB-19c.conf

 

/opt/oracle이 일반적으로 오라클 설치 후 보이는 $ORACLE_BASE가 됨

 

 

3. 오라클, 리스너 프로세스 확인

 

# ps -ef | grep pmon

oracle    3177     1  0 12:23 ?        00:00:00 ora_pmon_ORCLCDB

root      6070 31606  0 13:02 pts/1    00:00:00 grep --color=auto pmon

# ps -ef | grep tns

root        15     2  0 10:54 ?        00:00:00 [netns]

root      6081 31606  0 13:02 pts/1    00:00:00 grep --color=auto tns

oracle   32537     1  0 12:02 ?        00:00:00 /opt/oracle/product/19c/dbhome_1/bin/tnslsnr LISTENER -inherit

  

4. 리스너 상태 확인

lsnrctl status;

lsnrctl start;

 

5. oracle 계정 .bash_profile 설정

 

# su - oracle

$ vi .bash_profile

export TMP=/tmp;

export ORACLE_BASE=/opt/oracle

export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1

export ORACLE_SID=ORCLCDB

export PATH=$PATH:$ORACLE_HOME/bin

alias ss='sqlplus / as sysdba'

 

## 적용 ##

. ./.bash_profile

 

6. sqlplus 확인

 

$ sqlplus / as sysdba

 

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Apr 10 13:07:51 2020

Version 19.3.0.0.0

 

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

 

SQL> select instance_name, version, status from v$instance;

 

INSTANCE_NAME     VERSION       STATUS

---------------- ----------------- ------------

ORCLCDB      19.0.0.0.0       OPEN