RPM 파일 다운로드 경로

다운로드 주소 : https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

 

root 유저로 preinstall 패키지 설치
rpm -ivh oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
[root@ol7 tmp]# rpm -ivh oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
경고: oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
준비 중...                         ################################# [100%]
Updating / installing...
   1:oracle-database-preinstall-19c-1.################################# [100%]

※ Preinstall 패키지가 설치되기 위해서는 사전에 OS 필수 패키지가 설치되어야 합니다.

누락된 OS 패키지가 있을 경우 preinstall 패키지 설치가 실패합니다.

[root@ol7 tmp]# rpm -ivh oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
경고: oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
오류: Failed dependencies:
        ksh is needed by oracle-database-preinstall-19c-1.0-1.el7.x86_64
        libaio-devel is needed by oracle-database-preinstall-19c-1.0-1.el7.x86_64

이럴 때에는 필수 OS 패키지를 먼저 설치해야 합니다.

root 유저로 OS 패키지 설치
rpm -ivh ksh-*
rpm -ivh libaio-devel-*
[root@ol7 Packages]# rpm -ivh ksh-20120801-26.el7.x86_64.rpm
경고: ksh-20120801-26.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
준비 중...                         ################################# [100%]
Updating / installing...
   1:ksh-20120801-26.el7              ################################# [100%]
 
[root@ol7 Packages]# rpm -ivh libaio-devel-0.3.109-13.el7.x86_64.rpm
경고: libaio-devel-0.3.109-13.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
준비 중...                         ################################# [100%]
Updating / installing...
   1:libaio-devel-0.3.109-13.el7      ################################# [100%]

 

root 유저로 소프트웨어 설치
rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm
[root@ol7 tmp]# rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm
경고: oracle-database-ee-19c-1.0-1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
준비 중...                         ################################# [100%]
Updating / installing...
   1:oracle-database-ee-19c-1.0-1     ################################# [100%]
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure a sample Oracle Database you can execute the following service configuration script as root: /etc/init.d/oracledb_ORCLCDB-19c configure

※ Preinstall 패키지가 설치 되어야 database 패키지 설치가 진행됩니다.

[root@ol7 tmp]# rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm
경고: oracle-database-ee-19c-1.0-1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
오류: Failed dependencies:
        oracle-database-preinstall-19c is needed by oracle-database-ee-19c-1.0-1.x86_64

 

root 유저로 기본 데이터베이스 생성
/etc/init.d/oracledb_ORCLCDB-19c configure
[root@ol7 ~]# /etc/init.d/oracledb_ORCLCDB-19c configure
Configuring Oracle Database ORCLCDB.
DB 작업 준비
8% 완료
데이터베이스 파일 복사 중
31% 완료
Oracle 인스턴스 생성 및 시작 중
32% 완료
36% 완료
40% 완료
43% 완료
46% 완료
데이터베이스 생성 완료 중
51% 완료
54% 완료
플러그인할 수 있는 데이터베이스 생성 중
58% 완료
77% 완료
사후 구성 작업 실행 중
100% 완료
데이터베이스 생성이 완료되었습니다. 자세한 내용은 다음의 로그 파일에서 확인하십시오.
 /opt/oracle/cfgtoollogs/dbca/ORCLCDB
데이터베이스 정보:
전역 데이터베이스 이름:ORCLCDB
SID(시스템 식별자):ORCLCDB
자세한 내용은 로그 파일 "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log"을(를) 참조하십시오.

Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.

 

설치 경로 확인
cd /opt/oracle
ls -ltra
[root@ol7 ~]# cd /opt/oracle

[root@ol7 oracle]# ls -ltra
합계 8
drwxr-xr-x.  3 oracle oinstall   17  4월 26 18:44 product
drwxrwx---.  2 oracle oinstall    6  4월 26 18:49 checkpoints
drwxr-xr-x.  6 root   root       78  4월 26 18:49 ..
drwxrwxr-x. 23 oracle oinstall 4096  4월 26 18:49 diag
drwxr-x---.  3 oracle oinstall   21  4월 26 18:51 admin
drwxr-x---.  3 oracle oinstall   21  4월 26 18:51 oradata
drwxr-xr-x. 10 oracle oinstall 4096  4월 26 18:51 .
drwxr-x---.  3 oracle oinstall   21  4월 26 18:53 audit
drwxr-x---.  5 oracle oinstall   47  4월 26 18:53 cfgtoollogs
drwxrwx---.  4 oracle oinstall   78  4월 26 19:10 oraInventory

 

DB 프로세스 확인
ps -ef | grep ora_ | grep -v grep
[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
oracle   19658     1  0 19:09 ?        00:00:00 ora_pxmn_ORCLCDB
oracle   19662     1  0 19:09 ?        00:00:01 ora_mmon_ORCLCDB
oracle   19665     1  0 19:09 ?        00:00:00 ora_mmnl_ORCLCDB
oracle   19667     1  0 19:09 ?        00:00:00 ora_d000_ORCLCDB
oracle   19669     1  0 19:09 ?        00:00:00 ora_s000_ORCLCDB
oracle   19671     1  0 19:09 ?        00:00:00 ora_tmon_ORCLCDB
oracle   19683     1  0 19:10 ?        00:00:00 ora_m000_ORCLCDB
oracle   19685     1  0 19:10 ?        00:00:00 ora_m001_ORCLCDB
oracle   19692     1  0 19:10 ?        00:00:00 ora_tt00_ORCLCDB
oracle   19694     1  0 19:10 ?        00:00:00 ora_tt01_ORCLCDB
oracle   19696     1  0 19:10 ?        00:00:00 ora_tt02_ORCLCDB
oracle   19699     1  0 19:10 ?        00:00:00 ora_aqpc_ORCLCDB
oracle   19701     1  0 19:10 ?        00:00:00 ora_w002_ORCLCDB
oracle   19705     1  0 19:10 ?        00:00:00 ora_p000_ORCLCDB
oracle   19707     1  0 19:10 ?        00:00:00 ora_p001_ORCLCDB
oracle   19710     1  0 19:10 ?        00:00:01 ora_cjq0_ORCLCDB
oracle   19751     1  0 19:10 ?        00:00:00 ora_w003_ORCLCDB
oracle   19872     1  0 19:10 ?        00:00:00 ora_w004_ORCLCDB
oracle   19902     1  0 19:10 ?        00:00:00 ora_qm02_ORCLCDB
oracle   19904     1  0 19:10 ?        00:00:00 ora_q001_ORCLCDB
oracle   19908     1  0 19:10 ?        00:00:00 ora_q003_ORCLCDB
oracle   19924     1  1 19:10 ?        00:00:01 ora_m002_ORCLCDB
oracle   19945     1  0 19:10 ?        00:00:00 ora_w005_ORCLCDB
oracle   19951     1  0 19:10 ?        00:00:00 ora_m003_ORCLCDB
oracle   19955     1  0 19:10 ?        00:00:00 ora_q004_ORCLCDB
oracle   19969     1  0 19:10 ?        00:00:00 ora_p002_ORCLCDB
oracle   19971     1  0 19:10 ?        00:00:00 ora_p003_ORCLCDB
oracle   20015     1  0 19:10 ?        00:00:00 ora_w006_ORCLCDB

 

리스너 프로세스 확인
ps -ef | grep tnslsnr | grep -v grep
[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

 

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
[oracle@ol7 ~]$ export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
[oracle@ol7 ~]$ export ORACLE_SID=ORCLCDB
[oracle@ol7 ~]$ export PATH=$PATH:$ORACLE_HOME/bin
[oracle@ol7 ~]$ export NLS_LANG=KOREAN_KOREA.AL32UTF8
[oracle@ol7 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on 금 4월 26 19:14:03 2019
Version 19.3.0.0.0

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


다음에 접속됨:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

 

상태 확인 및 SYS 계정 패스워드 변경
select NAME, OPEN_MODE from V$PDBS;
alter user SYS identified by <새 패스워드>;
SQL> select NAME, OPEN_MODE from V$PDBS;

NAME                 OPEN_MODE
-------------------- ----------
PDB$SEED             READ ONLY
ORCLPDB1             READ WRITE


SQL> alter user SYS identified by oracle_4U;

사용자가 변경되었습니다.

 

  • 레이블 없음