[제목]
[2025-10-26] VMware Workstation 기반 Oracle Linux 7.9 환경에서 Oracle 12cR2 2 Node RAC를 12.2.0.1.190716 (29757449) PSU 골드 이미지로 설치하는 절차 정리
[테스트 개요]
<사전
작업>
VMware OL7.9 환경 구성 및 OS 설정, 사용자·그룹(dba 통합) 및 디렉토리 구조 준비
완료.
<Grid
Infrastructure 설치>
ASM 디스크 구성 후 GridSetup.sh로 GI 설치 및
190716 PSU 적용 확인.
<Oracle
소프트웨어 구성>
db12201.zip 전개 → relink 및 Oracle s/w의 root.sh 실행 → RAC 바이너리 활성화 및
attachHome 완료.
<최종
확인>
DBCA로 RAC DB 생성 후 datapatch 적용, CRS 리소스 및 INVALID 객체 정상
확인.
[테스트 환경]
--> 설치 완료 후 정보 확인
OS : Oracle
Linux Server 7.9 (grep ^PRETTY_NAME= /etc/os-release | cut -d= -f2- | tr -d
'"')
OS Kernal : 5.4.17-2102.201.3.el7uek.x86_64 (uname -r)
Oracle Version
: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit
Production
(echo -e "set pages 0 lines 200 feedback off heading off\nselect banner from
v\$version where banner like 'Oracle Database%';" | sqlplus -s / as
sysdba)
Oracle
Configuration
DB명 : ORA12RS (echo -e 'set pages 0 feedback
off heading off verify off\nselect '\''DB명 : '\''||name from v$database;' |
sqlplus -s / as sysdba) '
RAC Node
1
Hostname : ol7ora12rs1
(hostname)
Public IP : 192.168.240.21 (getent ahostsv4
`hostname` | awk '{print $1; exit}')
Instance Name :
ORA12RS1 (echo -e 'set pages 0 feedback off heading off verify off\nselect
'\''Instance Name : '\''||instance_name from v$instance;' | sqlplus -s / as
sysdba) '
RAC Node 2
Hostname :
ol7ora12rs2
Public IP : 192.168.240.22 (getent ahostsv4
`hostname` | awk '{print $1; exit}')
Instance Name :
ORA12RS2 (echo -e 'set pages 0 feedback off heading off verify off\nselect
'\''Instance Name : '\''||instance_name from v$instance;' | sqlplus -s / as
sysdba) '
Patch
Info
Grid (opatch lspatches) (grid os
user)
29770090;ACFS JUL 2019 RELEASE UPDATE 12.2.0.1.190716
(29770090)
29770040;OCW JUL 2019 RELEASE UPDATE 12.2.0.1.190716
(29770040)
29757449;Database Jul 2019 Release Update :
12.2.0.1.190716 (29757449)
28566910;TOMCAT RELEASE UPDATE
12.2.0.1.0(ID:180802.1448.S) (28566910)
26839277;DBWLM RELEASE
UPDATE 12.2.0.1.0(ID:170913) (26839277)
Oracle (opatch lspatches) (oracle os
user)
29770040;OCW JUL 2019 RELEASE UPDATE 12.2.0.1.190716
(29770040)
29757449;Database Jul 2019 Release Update :
12.2.0.1.190716 (29757449)
[내용]
1. 들어가기 전 기 완료된 작업 목록
VM 생성
생성된 VM에
Oracle Linux 7.9 설치
OS 설정
/etc/hosts 설정
rlwrap
설치
selinux 설정
fstab 설정
필수 패키지 검증
Oracle
Preinstall 설치
/etc/group 확인
limits.d
설정
/etc/sysctl.conf 설정
각종 불필요한 프로세스 중지 및 비활성화
chrony
설치
dnsmasq 설치 및 설정
사용자 그룹 및 사용자 설정
설치 디렉토리
생성
grid os user를 위한 limit 조건 추가
root, grid, oracle 사용자의
.bash_profile 및 .bashrc 설정
transparent_hugepage disable 및 disable
확인
systemd-logind 설정
tuned-adm 서비스 확인 및 설정
cio 옵션이
설정되어 있는지(없어야함) 확인
pam_limits.so 설정
NOZEROCONF=yes
확인
java jdk 1.8 설치
OSW 설치
OSW 자동 기동
ASM 환경
구성
공유 스토리지 생성
UDEV로 구성
두번째 노드 생성
--> 위의 작업이 모두 완료된
상태
2. 현재 상태 확인
--결국 grid 설치 바로 직전임
--gcc 설치 (각각의 노드)
[root@ol7ora12rs1][/root]$ yum install -y
gcc*
[root@ol7ora12rs2][/root]$ yum install -y gcc*
[root@ol7ora12rs1][/root]$ hostname
ol7ora12rs1
[root@ol7ora12rs2][/root]$ hostname
ol7ora12rs2
--양쪽 노드 모두 동일함
[root@ol7ora12rs1][/root]$ cat
/etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4
localhost4.localdomain4
::1
localhost localhost.localdomain localhost6 localhost6.localdomain6
### Public
IP
192.168.240.21 ol7ora12rs1
192.168.240.22
ol7ora12rs2
### Private
IP
10.0.2.21
ol7ora12rs1-priv
10.0.2.22
ol7ora12rs2-priv
### Virtual
IP
192.168.240.24 ol7ora12rs1-vip
192.168.240.25
ol7ora12rs2-vip
###
DNS
192.168.240.27 ol7ora12rs-scan
192.168.240.28
ol7ora12rs-scan
192.168.240.29 ol7ora12rs-scan
--udev로 아래와 같이 공유 스토리지가 연결된 상태
[root@ol7ora12rs1][/root]$ ls -l
/dev/oracleasm/disks
total 0
lrwxrwxrwx. 1 root root 9
Oct 25 18:59 CRS1 -> ../../sdc
lrwxrwxrwx. 1 root root 9 Oct 25 18:59 CRS2
-> ../../sdb
lrwxrwxrwx. 1 root root 9 Oct 25 18:59 CRS3 ->
../../sdd
lrwxrwxrwx. 1 root root 9 Oct 25 18:59 DATA1_1 ->
../../sde
lrwxrwxrwx. 1 root root 9 Oct 25 18:59 FRA1_1 ->
../../sdf
lrwxrwxrwx. 1 root root 9 Oct 25 18:59 MGMT1_1 ->
../../sdg
[root@ol7ora12rs1][/dev]$ ls -l sd* | grep -v
sda
brw-rw----. 1 grid dba 8, 16 Oct 25 18:59 sdb
brw-rw----. 1 grid
dba 8, 32 Oct 25 18:59 sdc
brw-rw----. 1 grid dba 8, 48 Oct 25
18:59 sdd
brw-rw----. 1 grid dba 8, 64 Oct 25 18:59 sde
brw-rw----.
1 grid dba 8, 80 Oct 25 18:59 sdf
brw-rw----. 1 grid dba 8, 96
Oct 25 18:59 sdg
--환경 변수 확인 (각각의 노드에서 확인)
--1번 노드
--grid os user
[+ASM1:grid@ol7ora12rs1][/home/grid]$ echo
$GRID_HOME
/u01/app/12c/grid
[+ASM1:grid@ol7ora12rs1][/home/grid]$ echo
$DB_HOME
/u01/app/oracle/product/12.2.0/dbhome_1
[+ASM1:grid@ol7ora12rs1][/home/grid]$ echo
$ORACLE_BASE
/u01/app/oracle
[+ASM1:grid@ol7ora12rs1][/home/grid]$ echo
$ORACLE_SID
+ASM1
--oracle os user
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ echo
$ORACLE_HOME
/u01/app/oracle/product/12.2.0/dbhome_1
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ echo
$ORACLE_BASE
/u01/app/oracle
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ echo
$ORACLE_SID
ORA12RS1
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ echo
$ORACLE_DBNAME
ORA12RS
--2번 노드
--grid os user
[+ASM2:grid@ol7ora12rs2][/home/grid]$ echo
$GRID_HOME
/u01/app/12c/grid
[+ASM2:grid@ol7ora12rs2][/home/grid]$ echo
$DB_HOME
/u01/app/oracle/product/12.2.0/dbhome_1
[+ASM2:grid@ol7ora12rs2][/home/grid]$ echo
$ORACLE_BASE
/u01/app/oracle
[+ASM2:grid@ol7ora12rs2][/home/grid]$ echo
$ORACLE_SID
+ASM2
--oracle os user
[ORA12RS2:oracle@ol7ora12rs2][/home/oracle]$ echo
$ORACLE_HOME
/u01/app/oracle/product/12.2.0/dbhome_1
[ORA12RS2:oracle@ol7ora12rs2][/home/oracle]$ echo
$ORACLE_BASE
/u01/app/oracle
[ORA12RS2:oracle@ol7ora12rs2][/home/oracle]$ echo
$ORACLE_SID
ORA12RS2
[ORA12RS2:oracle@ol7ora12rs2][/home/oracle]$ echo
$ORACLE_DBNAME
ORA12RS
3. RAC 설치 시 grid 및 oracle os user의 os group을 모두 dba로 지정하기 위한 작업
------------------------------------각각의 노드에서 동일 작업 수행
START-------------------------------------------
--oracle os user의 그룹을 dba,oper로 한정 (oracle s/w에서 dbca로 Create Database 작업 시 oper 필수)
[root@ol7ora12rs1][/root]$ usermod -g dba -G dba,oper
oracle
[root@ol7ora12rs1][/root]$ id oracle
uid=54321(oracle) gid=54322(dba)
groups=54322(dba),54323(oper)
--grid os user의 그룹을 dba로 한정
[root@ol7ora12rs1][/root]$ usermod -g dba -G dba
grid
[root@ol7ora12rs1][/root]$ id grid
uid=54322(grid) gid=54322(dba)
groups=54322(dba)
[root@ol7ora12rs1][/root]$ cat /etc/group
root:x:0:
..생략
oinstall:x:54321:
dba:x:54322:oracle,grid
oper:x:54323:oracle
backupdba:x:54324:oracle
dgdba:x:54325:oracle
kmdba:x:54326:oracle
racdba:x:54330:oracle
chrony:x:995:
asmadmin:x:54331:grid
asmdba:x:54332:grid,oracle
asmoper:x:54333:grid
--그룹 삭제
[root@ol7ora12rs1][/root]$ groupdel
oinstall
[root@ol7ora12rs1][/root]$ groupdel
backupdba
[root@ol7ora12rs1][/root]$ groupdel
dgdba
[root@ol7ora12rs1][/root]$ groupdel kmdba
[root@ol7ora12rs1][/root]$
groupdel racdba
[root@ol7ora12rs1][/root]$ groupdel
asmadmin
[root@ol7ora12rs1][/root]$ groupdel
asmdba
[root@ol7ora12rs1][/root]$ groupdel asmoper
--기존에 존재한 오라클 설치 디레토리(/u01)를 삭제 후 다시 생성
[root@ol7ora12rs1][/root]$ rm -rf /u01
[root@ol7ora12rs1][/root]$ mkdir -pv
/u01/app/oracle
[root@ol7ora12rs1][/root]$ chown
grid:dba -R /u01
[root@ol7ora12rs1][/root]$ mkdir -pv
/u01/app/12c/grid
[root@ol7ora12rs1][/root]$ chown
grid:dba -R /u01/app/12c
[root@ol7ora12rs1][/root]$ mkdir -pv
/u01/app/oracle/product/12.2.0/dbhome_1
[root@ol7ora12rs1][/root]$ chown
oracle:dba -R /u01/app/oracle/product
------------------------------------각각의 노드에서 동일 작업 수행 END-------------------------------------------
4.
grid/oracle gold image 다운로드
https://giaas.oraclecorp.com
--> 오라클 직원은 해당 사이트에서 골드이미지를 받을 수 있음
--다운받은
버전은
12.2.0.1.190716_p29699173_122010_Linux-x86-64 임
5. grid
설치
/home/grid/
위치에
grid12201.zip(해당 파일이 오라클에 본사에서 제공해준 파일임) 파일을 업로드
--압축해제
[+ASM1:grid@ol7ora12rs1][/home/grid]$
unzip -q grid12201.zip -d $GRID_HOME
--cvuqdisk 설치 (root os
user)
--1번 노드
[root@ol7ora12rs1][/root]$ export
CVUQDISK_GRP=dba
[root@ol7ora12rs1][/root]$ rpm -ivh
$GRID_HOME/cv/rpm/cvuqdisk-1.0.10-1.rpm
Preparing...
################################# [100%]
Updating /
installing...
1:cvuqdisk-1.0.10-1
################################# [100%]
[root@ol7ora12rs1][/root]$ scp -p $GRID_HOME/cv/rpm/cvuqdisk-1.0.10-1.rpm ol7ora12rs2:/tmp
--> 2번 노드로 파일 전송함
--2번 노드
[root@ol7ora12rs2][/root]$ export
CVUQDISK_GRP=dba
[root@ol7ora12rs2][/root]$ rpm -ivh
/tmp/cvuqdisk-1.0.10-1.rpm
Preparing...
################################# [100%]
Updating /
installing...
1:cvuqdisk-1.0.10-1
################################# [100%]
--ssh 설정
[+ASM1:grid@ol7ora12rs1][/home/grid]$
$GRID_HOME/oui/prov/resources/scripts/sshUserSetup.sh
-user oracle -hosts "ol7ora12rs1 ol7ora12rs2" -noPromptPassphrase
-advanced
$GRID_HOME/oui/prov/resources/scripts/sshUserSetup.sh -user grid
-hosts "ol7ora12rs1 ol7ora12rs2" -noPromptPassphrase
-advanced
--설치 전 검증
[+ASM1:grid@ol7ora12rs1][/home/grid]$
$GRID_HOME/runcluvfy.sh stage
-pre crsinst -n ol7ora12rs1,ol7ora12rs2 \
-asm -asmgrp dba -osdba dba -orainv
dba \
-asmdev
/dev/oracleasm/disks/CRS1,/dev/oracleasm/disks/CRS2,/dev/oracleasm/disks/CRS3,/dev/oracleasm/disks/DATA1_1,/dev/oracleasm/disks/FRA1_1,/dev/oracleasm/disks/MGMT1_1
\
-verbose
...
Pre-check for cluster services setup was
successful.
CVU
operation performed: stage -pre
crsinst
Date:
Oct 25, 2025 8:11:46 PM
CVU
home:
/u01/app/12c/grid/
User:
grid
[+ASM1:grid@ol7ora12rs1][/home/grid]$
$GRID_HOME/runcluvfy.sh stage
-pre crsinst -n ol7ora12rs1,ol7ora12rs2 \
-asm -asmgrp dba -osdba dba -orainv
dba \
-asmdev
/dev/oracleasm/disks/CRS1,/dev/oracleasm/disks/CRS2,/dev/oracleasm/disks/CRS3,/dev/oracleasm/disks/DATA1_1,/dev/oracleasm/disks/FRA1_1,/dev/oracleasm/disks/MGMT1_1
\
-method root -networks ens33/ens34 -verbose
...
Pre-check for cluster services setup was
successful.
CVU
operation performed: stage -pre
crsinst
Date:
Oct 25, 2025 8:17:18 PM
CVU
home:
/u01/app/12c/grid/
User:
grid
--grid 설치
[+ASM1:grid@ol7ora12rs1][/home/grid]$ $GRID_HOME/gridSetup.sh
Configure
Oracle Grid Infrastructure for a New Cluster 선택 후 Next
Configure an Oracle
Standalone Cluster 선택 후
Cluster Name : ol7ora12rs
SCAN Name :
ol7ora12rs-scan
SCAN Port : 1521
설정 후 Next
Add
Public Hostname : ol7ora12rs2
Node Role : HUB
Virtual
Hostname : ol7ora12rs2-vip
SSH connectivitiy -> grid의 패스워드 입력 (1234) ->
TEST
Next
ens33,
192.168.240.0, public
ens34, 10.0.2.0 ASM&Private
인 것을 확인 후
Next
Configure
ASM Using block Devices 선택 후 Next
Yes (GIMR Yes) ->
Next
Change
Discovery Path -> /dev/oracleasm/disks
Disk Group name : CRS
Redundancy
: Normal
Allocation Unit Size : 4MB
CRS1, CRS2, CRS3
선택
Next
Disk Group
name : MGMT
Redundancy : External
Allocation Unit Size : 4MB
MGMT1_1
선택
Next
Use same
Passwords for these accounts 선택 후 패스워드 입력 (패스워드는 oracle로 함) -> Next
IPMI :
Do not use로 선택 후 Next
EM 체크 해제 후 Next
순서대로 dba, dba, dba 로 지정 후
Next
Oracle base
: /u01/app/oracle로 한 후 Next
Inventory Directory : /u01/app/oraInventory 로 한 후
Next
Automatically run configuration scritps -> 루트 패스워드 입력
I/O
scheduler 및 DNS/NIS name service관련 에러가 나왔지만 ignore All한 후 Next
Save Response
File 클릭 후 RSP 파일을 저장 시켜 놔야함 (저장 위치는 /home/grid/grid.rsp)
Install 버튼 클릭 (드디어
설치 시작)
--asm 디스크 그룹 추가
[+ASM1:grid@ol7ora12rs1][/home/grid]$ asmca
ASM ->
Disk Groups -> Create
Disk Group name : DATA1
Redundancy :
External
DATA1_1 선택 후 OK
ASM ->
Disk Groups -> Create
Disk Group name : FRA1
Redundancy :
External
FRA1_1 선택 후 OK
[+ASM1:grid@ol7ora12rs1][/home/grid]$ crsctl stat res -t | grep -i
dg
ora.CRS.dg
ora.DATA1.dg
ora.FRA1.dg
ora.MGMT.dg
[+ASM2:grid@ol7ora12rs2][/home/grid]$ alias
csrt
alias csrt='crsctl stat res -t'
[+ASM1:grid@ol7ora12rs1][/home/grid]$
csrt
--------------------------------------------------------------------------------
Name
Target State
Server
State
details
--------------------------------------------------------------------------------
Local
Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE
ol7ora12rs1
STABLE
ONLINE ONLINE
ol7ora12rs2
STABLE
ora.CRS.dg
ONLINE ONLINE
ol7ora12rs1
STABLE
ONLINE ONLINE
ol7ora12rs2
STABLE
ora.DATA1.dg
ONLINE ONLINE
ol7ora12rs1
STABLE
ONLINE ONLINE
ol7ora12rs2
STABLE
ora.FRA1.dg
ONLINE ONLINE
ol7ora12rs1
STABLE
ONLINE ONLINE
ol7ora12rs2
STABLE
ora.LISTENER.lsnr
ONLINE ONLINE
ol7ora12rs1
STABLE
ONLINE ONLINE
ol7ora12rs2
STABLE
ora.MGMT.dg
ONLINE ONLINE
ol7ora12rs1
STABLE
ONLINE ONLINE
ol7ora12rs2
STABLE
ora.chad
ONLINE ONLINE
ol7ora12rs1
STABLE
ONLINE ONLINE
ol7ora12rs2
STABLE
ora.net1.network
ONLINE ONLINE
ol7ora12rs1
STABLE
ONLINE ONLINE
ol7ora12rs2
STABLE
ora.ons
ONLINE ONLINE
ol7ora12rs1
STABLE
ONLINE ONLINE
ol7ora12rs2
STABLE
--------------------------------------------------------------------------------
Cluster
Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE
ONLINE
ol7ora12rs2
STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE
ONLINE
ol7ora12rs1
STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE
ONLINE
ol7ora12rs1
STABLE
ora.MGMTLSNR
1 ONLINE
ONLINE
ol7ora12rs1
169.254.103.123
10.0
.2.21,STABLE
ora.asm
1 ONLINE
ONLINE
ol7ora12rs1
Started,STABLE
2 ONLINE
ONLINE
ol7ora12rs2
Started,STABLE
3 OFFLINE
OFFLINE
STABLE
ora.cvu
1 ONLINE
ONLINE
ol7ora12rs1
STABLE
ora.mgmtdb
1 ONLINE
ONLINE
ol7ora12rs1
Open,STABLE
ora.ol7ora12rs1.vip
1 ONLINE
ONLINE
ol7ora12rs1
STABLE
ora.ol7ora12rs2.vip
1 ONLINE
ONLINE
ol7ora12rs2
STABLE
ora.qosmserver
1 ONLINE
ONLINE
ol7ora12rs1
STABLE
ora.scan1.vip
1 ONLINE
ONLINE
ol7ora12rs2
STABLE
ora.scan2.vip
1 ONLINE
ONLINE
ol7ora12rs1
STABLE
ora.scan3.vip
1 ONLINE
ONLINE
ol7ora12rs1
STABLE
--------------------------------------------------------------------------------
--grid s/w 패치 확인
[+ASM1:grid@ol7ora12rs1][/home/grid]$ which
opatch
/u01/app/12c/grid/OPatch/opatch
+ASM1:grid@ol7ora12rs1][/home/grid]$ opatch
lspatches
29770090;ACFS JUL 2019 RELEASE UPDATE 12.2.0.1.190716
(29770090)
29770040;OCW JUL 2019 RELEASE UPDATE 12.2.0.1.190716
(29770040)
29757449;Database Jul 2019 Release Update : 12.2.0.1.190716
(29757449)
28566910;TOMCAT RELEASE UPDATE 12.2.0.1.0(ID:180802.1448.S)
(28566910)
26839277;DBWLM RELEASE UPDATE 12.2.0.1.0(ID:170913)
(26839277)
OPatch
succeeded.
[+ASM1:grid@ol7ora12rs1][/home/grid]$ opatch
lsinventory
Oracle Interim Patch Installer version 12.2.0.1.47
Copyright (c) 2025,
Oracle Corporation. All rights reserved.
Oracle
Home : /u01/app/12c/grid
Central
Inventory : /u01/app/oraInventory
from :
/u01/app/12c/grid/oraInst.loc
OPatch version :
12.2.0.1.47
OUI version :
12.2.0.1.4
Log file location :
/u01/app/12c/grid/cfgtoollogs/opatch/opatch2025-10-25_21-20-52PM_1.log
Lsinventory
Output file location :
/u01/app/12c/grid/cfgtoollogs/opatch/lsinv/lsinventory2025-10-25_21-20-52PM.txt
--------------------------------------------------------------------------------
Local
Machine Information::
Hostname: ol7ora12rs1
ARU platform id: 226
ARU
platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Grid
Infrastructure
12c
12.2.0.1.0
There are 1 products installed in this Oracle
Home.
Interim
patches (5) :
Patch
29770090 : applied on Thu Oct 23 07:33:55 KST
2025
Unique Patch ID: 22918814
Patch description: "ACFS JUL
2019 RELEASE UPDATE 12.2.0.1.190716 (29770090)"
Created on 10
Jun 2019, 15:42:50 hrs PST8PDT
Bugs
fixed:
21129279, 22591010, 23059642, 23152694,
23181299, 23625427,
24285969
...중간생략
29761172
Patch
29770040 : applied on Thu Oct 23 07:32:38 KST
2025
Unique Patch ID: 22917824
Patch description: "OCW JUL
2019 RELEASE UPDATE 12.2.0.1.190716 (29770040)"
Created on 19
Jun 2019, 13:36:44 hrs PST8PDT
Bugs
fixed:
12816839, 13250991, 18701017, 20559126,
20674742, 21477269,
21679331
...중간생략
29379299, 29380201, 29400176, 29505730, 29632978
Patch
29757449 : applied on Thu Oct 23 07:31:48 KST
2025
Unique Patch ID: 23009673
Patch description: "Database
Jul 2019 Release Update : 12.2.0.1.190716 (29757449)"
Created on
9 Jul 2019, 21:38:38 hrs PST8PDT
Bugs
fixed:
12763598, 13554903, 14221306, 14690846,
15931756, 16002385, 16438495
...중간생략
29690625, 29813494, 29836659, 8480838, 8932139
Patch
28566910 : applied on Thu Oct 23 07:30:42 KST
2025
Unique Patch ID: 22413436
Patch description: "TOMCAT
RELEASE UPDATE 12.2.0.1.0(ID:180802.1448.S) (28566910)"
Created
on 28 Aug 2018, 23:01:25 hrs PST8PDT
Bugs
fixed:
25728967, 26934551,
28402313
Patch
26839277 : applied on Thu Oct 23 07:30:40 KST
2025
Unique Patch ID: 21578760
Patch description: "DBWLM
RELEASE UPDATE 12.2.0.1.0(ID:170913) (26839277)"
Created on 21
Sep 2017, 03:13:10 hrs PST8PDT
Bugs
fixed:
26584906
--------------------------------------------------------------------------------
OPatch
succeeded.
[+ASM1:grid@ol7ora12rs1][/home/grid]$ cat
/u01/app/oraInventory/ContentsXML/inventory.xml
<?xml version="1.0" standalone="yes"
?>
<!-- Copyright (c) 1999, 2025, Oracle and/or its affiliates.
All
rights reserved. -->
<!-- Do not modify the contents of this file by
hand. -->
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>12.2.0.1.4</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME
NAME="OraGI12Home1"
LOC="/u01/app/12c/grid" TYPE="O" IDX="1"
CRS="true"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>
--2번 노드에서도 확인
[+ASM2:grid@ol7ora12rs2][/home/grid]$ which
opatch
/u01/app/12c/grid/OPatch/opatch
[+ASM2:grid@ol7ora12rs2][/home/grid]$ opatch
lspatches
29770090;ACFS JUL 2019 RELEASE UPDATE 12.2.0.1.190716
(29770090)
29770040;OCW JUL 2019 RELEASE UPDATE 12.2.0.1.190716
(29770040)
29757449;Database Jul 2019 Release Update : 12.2.0.1.190716
(29757449)
28566910;TOMCAT RELEASE UPDATE 12.2.0.1.0(ID:180802.1448.S)
(28566910)
26839277;DBWLM RELEASE UPDATE 12.2.0.1.0(ID:170913)
(26839277)
OPatch
succeeded.
[+ASM2:grid@ol7ora12rs2][/home/grid]$ opatch
lsinventory
Oracle Interim Patch Installer version 12.2.0.1.47
Copyright (c) 2025,
Oracle Corporation. All rights reserved.
Oracle
Home : /u01/app/12c/grid
Central
Inventory : /u01/app/oraInventory
from :
/u01/app/12c/grid/oraInst.loc
OPatch version :
12.2.0.1.47
OUI version :
12.2.0.1.4
Log file location :
/u01/app/12c/grid/cfgtoollogs/opatch/opatch2025-10-25_21-22-11PM_1.log
Lsinventory
Output file location :
/u01/app/12c/grid/cfgtoollogs/opatch/lsinv/lsinventory2025-10-25_21-22-11PM.txt
--------------------------------------------------------------------------------
Local
Machine Information::
Hostname: ol7ora12rs2
ARU platform id: 226
ARU
platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Grid
Infrastructure
12c
12.2.0.1.0
There are 1 products installed in this Oracle
Home.
Interim
patches (5) :
Patch
29770090 : applied on Thu Oct 23 07:33:55 KST
2025
Unique Patch ID: 22918814
Patch description: "ACFS JUL
2019 RELEASE UPDATE 12.2.0.1.190716 (29770090)"
Created on 10
Jun 2019, 15:42:50 hrs PST8PDT
Bugs
fixed:
21129279, 22591010, 23059642, 23152694,
23181299, 23625427,
24285969
...중간생략
29761172
Patch
29770040 : applied on Thu Oct 23 07:32:38 KST
2025
Unique Patch ID: 22917824
Patch description: "OCW JUL
2019 RELEASE UPDATE 12.2.0.1.190716 (29770040)"
Created on 19
Jun 2019, 13:36:44 hrs PST8PDT
Bugs
fixed:
12816839, 13250991, 18701017, 20559126,
20674742, 21477269,
21679331
...중간생략
29379299, 29380201, 29400176, 29505730, 29632978
Patch
29757449 : applied on Thu Oct 23 07:31:48 KST
2025
Unique Patch ID: 23009673
Patch description: "Database
Jul 2019 Release Update : 12.2.0.1.190716 (29757449)"
Created on
9 Jul 2019, 21:38:38 hrs PST8PDT
Bugs
fixed:
12763598, 13554903, 14221306, 14690846,
15931756, 16002385,
16438495
...중간생략
29690625, 29813494, 29836659, 8480838, 8932139
Patch
28566910 : applied on Thu Oct 23 07:30:42 KST
2025
Unique Patch ID: 22413436
Patch description: "TOMCAT
RELEASE UPDATE 12.2.0.1.0(ID:180802.1448.S) (28566910)"
Created
on 28 Aug 2018, 23:01:25 hrs PST8PDT
Bugs
fixed:
25728967, 26934551,
28402313
Patch
26839277 : applied on Thu Oct 23 07:30:40 KST
2025
Unique Patch ID: 21578760
Patch description: "DBWLM
RELEASE UPDATE 12.2.0.1.0(ID:170913) (26839277)"
Created on 21
Sep 2017, 03:13:10 hrs PST8PDT
Bugs
fixed:
26584906
--------------------------------------------------------------------------------
OPatch succeeded.
[+ASM2:grid@ol7ora12rs2][/home/grid]$ cat
/u01/app/oraInventory/ContentsXML/inventory.xml
<?xml version="1.0" standalone="yes"
?>
<!-- Copyright (c) 1999, 2025, Oracle and/or its affiliates.
All
rights reserved. -->
<!-- Do not modify the contents of this file by
hand. -->
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>12.2.0.1.4</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME
NAME="OraGI12Home1"
LOC="/u01/app/12c/grid" TYPE="O" IDX="1"
CRS="true"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>
6. oracle s/w 설치
----------------------------------------각각의 노드에서 실행
START---------------------------------------
/home/oracle 위치에 db12201.zip (골드 이미지임) 파일 업로드
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ ls -l
db12201.zip
-rw-r--r--. 1 oracle dba 4038318702 Oct 23 14:46
db12201.zip
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ echo
$ORACLE_HOME
/u01/app/oracle/product/12.2.0/dbhome_1
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ ls -l
/u01/app/oracle/product/12.2.0/dbhome_1
total 0
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ unzip -q /home/oracle/db12201.zip -d $ORACLE_HOME
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ cd
$ORACLE_HOME
[ORA12RS1:oracle@ol7ora12rs1][/u01/app/oracle/product/12.2.0/dbhome_1]$
ls
addnode ccr css
dbjava
demo env.ora
instantclient jdk log
nls OPatch ordim owm
QOpatch relnotes schagent.conf
sqlj suptools
utl
apex cdata
ctx dbs diagnostics
has inventory
jlib md oc4j
opmn ords perl
R
root.sh
scheduler sqlpatch sysman
wwg
assistants clone cv
dc_ocm
dmu
hs
javavm ldap
mgw odbc oracore oss
plsql racg
root.sh.old
slax
sqlplus ucp
xdk
bin crs
data deinstall
dv install
jdbc lib
network olap ord oui
precomp rdbms root.sh.old.1
sqldeveloper srvm
usm
[ORA12RS1:oracle@ol7ora12rs1][/u01/app/oracle/product/12.2.0/dbhome_1]$
ls -l | grep -i database
--> database 디렉토리가 없음 (해당 골드 이미지에서 누락시킨것으로
보임)
[ORA12RS1:oracle@ol7ora12rs1][/u01/app/oracle/product/12.2.0/dbhome_1]$
find . | grep -i runinstaller
./inventory/Templates/oui/bin/platform/linux64/runInstaller.sh
./oui/bin/runInstaller
./oui/bin/runInstaller.sh
--> 설치할수가 없는 상황 ($ORACLE_HOME/database/runInsteller 가 없는
상황)
--해당 oracle s/w Relink 작업
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ $ORACLE_HOME/bin/relink
all
writing relink log to:
/u01/app/oracle/product/12.2.0/dbhome_1/install/relink.log
-- $ORACLE_BASE 위치에 필수 디렉토리 생성 (grid os user로 실행)
[+ASM1:grid@ol7ora12rs1][/home/grid]$ mkdir -pv
/u01/app/oracle/cfgtoollogs/dbca
[+ASM1:grid@ol7ora12rs1][/home/grid]$ chmod
775 /u01/app/oracle/cfgtoollogs/dbca
[+ASM1:grid@ol7ora12rs1][/home/grid]$
mkdir -pv
/u01/app/oracle/cfgtoollogs/sqlpatch
[+ASM1:grid@ol7ora12rs1][/home/grid]$
chmod 775 /u01/app/oracle/cfgtoollogs/sqlpatch
[+ASM1:grid@ol7ora12rs1][/home/grid]$ echo
$ORACLE_BASE
/u01/app/oracle
[+ASM1:grid@ol7ora12rs1][/home/grid]$ ls -l
$ORACLE_BASE
total
4
drwxr-x---. 4 grid
dba 33 Oct 25 20:45 admin
drwxr-x---. 2
grid dba 6 Oct 25 20:45
audit
..생략
[+ASM1:grid@ol7ora12rs1][/home/grid]$ chmod 770 /u01/app/oracle/admin
[+ASM1:grid@ol7ora12rs1][/home/grid]$ mkdir -pv /u01/app/oracle/audit
[+ASM1:grid@ol7ora12rs1][/home/grid]$ chmod 770 /u01/app/oracle/audit
--> admin과 audit 디렉토리에도 oracle os user가 쓸수 있도록 권한을 줌
--oracle s/w의 rac 기능을 on 시킴
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ cd
$ORACLE_HOME/rdbms/lib
[ORA12RS1:oracle@ol7ora12rs1][/u01/app/oracle/product/12.2.0/dbhome_1/rdbms/lib]$
make -f ins_rdbms.mk rac_on ioracle
--oracle s/w의
$ORACLE_HOME/root.sh 에서 실행시키는 rootmacro.sh 쉘 내에서 OSDBA_GROUP 값을 dba로
변경
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ cp
$ORACLE_HOME/install/utl/rootmacro.sh
$ORACLE_HOME/install/utl/rootmacro.sh.bak.20251025
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ vi
$ORACLE_HOME/install/utl/rootmacro.sh
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ grep -i OSDBA_GROUP
$ORACLE_HOME/install/utl/rootmacro.sh | grep
dba
OSDBA_GROUP=dba
--> OSDBA_GROUP이 값을 기존 oinstall에서 dba로 변경함
[root@ol7ora12rs1][/root]$ echo $DB_HOME
/u01/app/oracle/product/12.2.0/dbhome_1
[root@ol7ora12rs1][/root]$ cat
$DB_HOME/root.sh
#!/bin/sh
unset
WAS_ROOTMACRO_CALL_MADE
. /u01/app/oracle/product/12.2.0/dbhome_1/install/utl/rootmacro.sh
"$@"
. /u01/app/oracle/product/12.2.0/dbhome_1/install/utl/rootinstall.sh
/u01/app/oracle/product/12.2.0/dbhome_1/suptools/tfa/release/tfa_home/install/roottfa.sh
/u01/app/oracle/product/12.2.0/dbhome_1/install/root_schagent.sh
#
# Root
Actions related to network
#
/u01/app/oracle/product/12.2.0/dbhome_1/network/install/sqlnet/setowner.sh
#
#
Invoke standalone rootadd_rdbms.sh
#
/u01/app/oracle/product/12.2.0/dbhome_1/rdbms/install/rootadd_rdbms.sh
/u01/app/oracle/product/12.2.0/dbhome_1/rdbms/install/rootadd_filemap.sh
--> 해당 oracle s/w 골드이미지를 생성한 오라클 서버의 $ORACLE_HOME 디렉토리 위치는 /u01/app/oracle/product/12.2.0/dbhome_1 였기 때문에
--> 해당 경로를 이번 설치 시에서 그대로 사용한 것임
--> 만약 $ORACLE_HOME을 새로운 위치로 지정하고 싶다면 해당 쉘 스크립트(root.sh)와 root.sh 내에서 호출되는 모든 쉘 스크립트의 점검 및 수정이 필요함
[root@ol7ora12rs1][/root]$
$DB_HOME/root.sh
Check
/u01/app/oracle/product/12.2.0/dbhome_1/install/root_ol7ora12rs1_2025-10-25_21-51-13-585033395.log
for the output of root script
[root@ol7ora12rs1][/root]$ cat
/u01/app/oracle/product/12.2.0/dbhome_1/install/root_ol7ora12rs1_2025-10-25_21-51-13-585033395.log
Performing root user
operation.
The
following environment variables are set as:
ORACLE_OWNER=
oracle
ORACLE_HOME=
/u01/app/oracle/product/12.2.0/dbhome_1
Copying dbhome to
/usr/local/bin ...
Copying oraenv to /usr/local/bin
...
Copying coraenv to /usr/local/bin ...
Entries
will be added to the /etc/oratab file as needed by
Database Configuration
Assistant when a database is created
Finished running generic part of root
script.
Now product-specific root actions will be performed.
Oracle Trace
File Analyzer (TFA) is available at :
/u01/app/oracle/product/12.2.0/dbhome_1/suptools/tfa/release/tfa_home/bin/tfactl
--> root.sh 가 정상적으로 실행된 것을 확인
srvctl start
database fails with ORA-01017 (Doc ID 2922455.1) 참고
--config.c 파일 내에서 각각의 그룹에 대한 os group을 변경해줘야함 (이걸 하지 않으면 CRS가 Oracle 인스턴스를 인식못함)
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ cp
$ORACLE_HOME/rdbms/lib/config.c
$ORACLE_HOME/rdbms/lib/config.c.bak.20251025
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ vi
$ORACLE_HOME/rdbms/lib/config.c
--> 해당 파일 열어서
#define SS_DBA_GRP "dba"
#define
SS_OPER_GRP "oper"
#define SS_ASM_GRP ""
#define SS_BKP_GRP ""
#define
SS_DGD_GRP ""
#define SS_KMT_GRP ""
#define SS_RAC_GRP ""
--> 이부분을 아래와 같이 변경함
#define SS_DBA_GRP "dba"
#define
SS_OPER_GRP "oper"
#define SS_ASM_GRP "dba"
#define SS_BKP_GRP
"dba"
#define SS_DGD_GRP "dba"
#define SS_KMT_GRP "dba"
#define
SS_RAC_GRP "dba"
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ cd
$ORACLE_HOME/rdbms/lib/
[ORA12RS1:oracle@ol7ora12rs1][/u01/app/oracle/product/12.2.0/dbhome_1/rdbms/lib]$
make -f ins_rdbms.mk config.o ioracle
--패치 인벤토리 등록
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ which
opatch
/u01/app/oracle/product/12.2.0/dbhome_1/OPatch/opatch
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ opatch
lspatches
Argument(s) Error... Oracle Home's central inventory is not
found.
'
Please check the arguments and try again.
OPatch failed with error code 135
--> 패치 인벤토리가 등록안된 상태라서 명령어 실행불가
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ $ORACLE_HOME/oui/bin/runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME=$ORACLE_HOME ORACLE_HOME_NAME="OraDB12Home1"
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ cat
/u01/app/oraInventory/ContentsXML/inventory.xml
<?xml version="1.0" standalone="yes"
?>
<!-- Copyright (c) 1999, 2025, Oracle and/or its affiliates.
All
rights reserved. -->
<!-- Do not modify the contents of this file by
hand. -->
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>12.2.0.1.4</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME
NAME="OraGI12Home1" LOC="/u01/app/12c/grid" TYPE="O" IDX="1"
CRS="true"/>
<HOME NAME="OraDB12Home1"
LOC="/u01/app/oracle/product/12.2.0/dbhome_1" TYPE="O"
IDX="2"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ opatch
lspatches
29770040;OCW JUL 2019 RELEASE UPDATE 12.2.0.1.190716
(29770040)
29757449;Database Jul 2019 Release Update : 12.2.0.1.190716
(29757449)
OPatch
succeeded.
----------------------------------------각각의 노드에서 실행 END---------------------------------------
7. 데이터베이스 생성
[ORA12RS1:oracle@ol7ora12rs1][/home/oracle]$ dbca
Create a
database -> Next
Advanced configuration -> Next
Database Type :
RAC
Configuration type : Admin Managed
General Purpose or Transaction
Processing
Next
ol7ora12rs1, ol7ora12rs2 모두 선택 후 Next
Global database name :
ORA12RS
SID Prefix : ORA12RS
Create as Container Database : 체크
해제
Next
Database
files Storage Type : ASM
Database files location :
+DATA1/{DB_UNIQUE_NAME}
Use Oracle-Managed Files (OMF): 체크
Multiplex redo
logs and control files : +DATA1, +FRA1 -> ok
Next
Specifiy
Fast Recovery Area -> 체크해제
--Recovery files Storage type :
ASM
--Fast Recovery Area : +FRA1
--Fast Recovery Area Size :
18544MB (26492*0.7)
Enable
archivning : 체크 -> Edit archive mode parmaters -> Archive log file format
: %t_%s_%r.ARC -> OK
Archive log destination :
+FRA1
Next
Oracle
Database Vault 구성 체크 해제
Oracle Label Security 구성 체크
해제
Next
Memory
설정
Use Automatic Shared Memory Managent 선택 시
--물리 메모리 16기가 기준
물리 메모리의
40%를 SGA와 PGA할당함
물리 메모리의 40%는 16384*0.4 = ~6553 MB
SGA Size : 4915 MB
(6553 MB * 0.75)
PGA Size : 1638 MB (6553 MB-4915 MB)
Sizing
설정
Processes : 1432 (oracle ulimit의 max user processes설정보다 작아야함. 2047일경우 :
2047*0.7=1432)
Chracter
sets 설정
Choose from the list of character sets 선택 : KO16MSWIN949
National
character set : AL16UTF16
Default Language : American
Default territory :
Korea
Connection
Mode : Dedicated Server Mode
Sample schemas : Add Sample schemas to the
database 체크
Next
Run Cluster Verification Utility Checks Periodically : 체크
해제
EM 체크 해제
Next
Use the
same administrative password for all accounts 선택 ->
oracle
Next
Create
Database 체크하고
Generate database creation scripts 체크 ->
{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/scripts
Customize
Storage Locations 클릭
Control Files
Maximum Datafiles : 1000
Redo
Log Groups
1, 2, 3 : Thread 1으로, 204800 KB로
4, 5, 6 : Thread 2으로, 204800
KB로
Next
All
Initialization Parameters... -> Show advanced parameters
체크
optimizer_adaptive_plans : false, include in spfile
체크
optimizer_adaptive_reporting_only : true, include in spfile
체크
optimizer_dynamic_sampling : 0, include in spfile
체크
parallel_force_local : true, include in spfile 체크
parallel_min_servers
: 0, include in spfile 체크
pga_aggregate_limit : 0, include in spfile
체크
undo_retention : 3600, include in spfile 체크
SCAN 및
DNS/NIS 관련 Failed가 났지만 ignore all로 하고 Next
Save Response File -> /home/oracle/dbca.rsp
Finish하면 설치 시작!
[+ASM1:grid@ol7ora12rs1][/home/grid]$
csrt
--------------------------------------------------------------------------------
Name
Target State
Server
State
details
--------------------------------------------------------------------------------
Local
Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE
ol7ora12rs1
STABLE
ONLINE ONLINE
ol7ora12rs2
STABLE
ora.CRS.dg
ONLINE ONLINE
ol7ora12rs1
STABLE
ONLINE ONLINE
ol7ora12rs2
STABLE
ora.DATA1.dg
ONLINE ONLINE
ol7ora12rs1
STABLE
ONLINE ONLINE
ol7ora12rs2
STABLE
ora.FRA1.dg
ONLINE ONLINE
ol7ora12rs1
STABLE
ONLINE ONLINE
ol7ora12rs2
STABLE
ora.LISTENER.lsnr
ONLINE ONLINE
ol7ora12rs1
STABLE
ONLINE ONLINE
ol7ora12rs2
STABLE
ora.MGMT.dg
ONLINE ONLINE
ol7ora12rs1
STABLE
ONLINE ONLINE
ol7ora12rs2
STABLE
ora.chad
ONLINE ONLINE
ol7ora12rs1
STABLE
ONLINE ONLINE
ol7ora12rs2
STABLE
ora.net1.network
ONLINE ONLINE
ol7ora12rs1
STABLE
ONLINE ONLINE
ol7ora12rs2
STABLE
ora.ons
ONLINE ONLINE
ol7ora12rs1
STABLE
ONLINE ONLINE
ol7ora12rs2
STABLE
--------------------------------------------------------------------------------
Cluster
Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE
ONLINE
ol7ora12rs2
STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE
ONLINE
ol7ora12rs1
STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE
ONLINE
ol7ora12rs1
STABLE
ora.MGMTLSNR
1 ONLINE
ONLINE
ol7ora12rs1
169.254.103.123
10.0
.2.21,STABLE
ora.asm
1 ONLINE
ONLINE
ol7ora12rs1
Started,STABLE
2 ONLINE
ONLINE
ol7ora12rs2
Started,STABLE
3 OFFLINE
OFFLINE
STABLE
ora.cvu
1 ONLINE
ONLINE
ol7ora12rs1
STABLE
ora.mgmtdb
1 ONLINE
ONLINE
ol7ora12rs1
Open,STABLE
ora.ol7ora12rs1.vip
1 ONLINE
ONLINE
ol7ora12rs1
STABLE
ora.ol7ora12rs2.vip
1 ONLINE
ONLINE
ol7ora12rs2
STABLE
ora.ora12rs.db
1 ONLINE
ONLINE
ol7ora12rs1
Open,HOME=/u01/app/o
racle/product/12.2.0
/dbhome_1,STABLE
2 ONLINE
ONLINE
ol7ora12rs2
Open,HOME=/u01/app/o
racle/product/12.2.0
/dbhome_1,STABLE
ora.qosmserver
1 ONLINE
ONLINE
ol7ora12rs1
STABLE
ora.scan1.vip
1 ONLINE
ONLINE
ol7ora12rs2
STABLE
ora.scan2.vip
1 ONLINE
ONLINE
ol7ora12rs1
STABLE
ora.scan3.vip
1 ONLINE
ONLINE
ol7ora12rs1
STABLE
--------------------------------------------------------------------------------
[+ASM1:grid@ol7ora12rs1][/home/grid]$
--> DB 생성 완료되고 인스턴스 잘 기동됨
[ORA12RS2:oracle@ol7ora12rs2][/home/oracle]$ sqlplus "/as
sysdba"
SQL*Plus: Release 12.2.0.1.0 Production on Sat Oct 25 23:27:28 2025
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release
12.2.0.1.0 - 64bit Production
SQL> select name from v$database;
NAME
---------------------------
ORA12RS
SQL> select instance_name from gv$instance;
INSTANCE_NAME
------------------------------------------------
ORA12RS2
ORA12RS1
--> datapatch 확인
SQL> select PATCH_ID, PATCH_UID, VERSION, ACTION, status, INSTALL_ID, BUNDLE_ID from DBA_REGISTRY_SQLPATCH;
PATCH_ID PATCH_UID
VERSION
ACTION
STATUS
INSTALL_ID BUNDLE_ID
--------- --------- -------------------- ---------------
------------------------- ---------- ---------
29757449 23009673
12.2.0.1
APPLY WITH
ERRORS
1 190716
--> WITH ERRORS 임
--> 원인을 찾지않고 datapatch 재수행해봄
[ORA12RS2:oracle@ol7ora12rs2][/u01/app/oracle/product/12.2.0/dbhome_1/OPatch]$
./datapatch -prereq
SQL Patching tool version 12.2.0.1.0
Production on Sat Oct 25 23:29:56 2025
Copyright (c) 2012, 2019,
Oracle. All rights reserved.
Connecting to database...OK
Determining current state...done
Adding
patches to installation queue and performing prereq
checks...done
Installation queue:
Nothing to roll back
The following patches will be applied:
29757449 (DATABASE JUL 2019
RELEASE UPDATE 12.2.0.1.190716)
SQL
Patching tool complete on Sat Oct 25 23:30:13 2025
[ORA12RS2:oracle@ol7ora12rs2][/u01/app/oracle/product/12.2.0/dbhome_1/OPatch]$
./datapatch
SQL Patching tool version 12.2.0.1.0 Production on Sat Oct 25 23:30:18
2025
Copyright (c) 2012, 2019, Oracle. All rights
reserved.
Connecting
to database...OK
Bootstrapping registry and package to current
versions...done
Determining current state...done
Adding patches to
installation queue and performing prereq checks...done
Installation
queue:
Nothing to roll back
The following patches will be
applied:
29757449 (DATABASE JUL 2019 RELEASE UPDATE
12.2.0.1.190716)
Installing
patches...
Patch installation complete. Total patches installed:
1
Validating
logfiles...done
SQL Patching tool complete on Sat Oct 25 23:31:28
2025
SQL> select PATCH_ID, PATCH_UID, VERSION, ACTION, status, INSTALL_ID, BUNDLE_ID from DBA_REGISTRY_SQLPATCH;
PATCH_ID PATCH_UID
VERSION
ACTION
STATUS
INSTALL_ID BUNDLE_ID
--------- --------- -------------------- ---------------
------------------------- ---------- ---------
29757449 23009673
12.2.0.1
APPLY WITH
ERRORS
1 190716
29757449 23009673
12.2.0.1
APPLY
SUCCESS
2 190716
--> 정상적으로 실행됨
[ORA12RS2:oracle@ol7ora12rs2][/u01/app/oracle/product/12.2.0/dbhome_1/OPatch]$
./datapatch -prereq
SQL Patching tool version 12.2.0.1.0
Production on Sat Oct 25 23:32:05 2025
Copyright (c) 2012, 2019,
Oracle. All rights reserved.
Connecting
to database...OK
Determining current state...done
Adding patches to
installation queue and performing prereq checks...done
Installation
queue:
Nothing to roll back
Nothing to
apply
SQL Patching tool complete on Sat Oct 25 23:32:18 2025
SQL>
SELECT COUNT(*) FROM dba_objects WHERE status='INVALID';
COUNT(*)
----------
0