rhel8_19c_rac
redhat 8 - kernel version 4.18. RAC 19c EE 설치
- 아이피 주소 설정
CMD 창에 ping 날려보기
192.168.7.141_rhel8_19c_rac1_jhs
192.168.7.142_rhel8_19c_rac2_jhs
설치파일은 아래 4가지 파일을 이용함
GRID : LINUX.X64_193000_grid_home.zip
DB : LINUX.X64_193000_db_home.zip
OPatch : p6880880_190000_Linux-x86-64.zip(12.2.0.1.27)
Patch 37262208: COMBO OF OJVM COMPONENT 19.26.0.0.250121 + GI RU 19.26.0.0.250121
Patch 37262172: COMBO OF OJVM COMPONENT 19.26.0.0.250121 + DB RU 19.26.0.0.250121
oracd 에 업로드 할 rpm
oracleasm-support-2.1.12-1.el8.x86_64
oracleasmlib-2.0.17-1.el8.x86_64
패치 번호 확인해 !
rhel8_19c_rac
------------------------------------------------------
-rac
uname -a
df -h
cat /etc/*release*
---
netstat -rp
-----
vi /etc/hosts
###public
192.168.7.141 rac1
192.168.7.142 rac2
###private
10.0.0.1 rac1-priv
10.0.0.2 rac2-priv
###vip
192.168.7.143 rac1-vip
192.168.7.144 rac2-vip
###scanip
192.168.7.145 rac-scan
-------------
hostname
---
ping test
---
ping rac2
ping rac1
---
ping rac2-priv
ping rac1-priv
grep -E "dba|1001" /etc/group
grep -E "grid|oracle|1001|1002" /etc/passwd
groupadd -g 1001 dba
useradd -g dba -u 1002 grid
useradd -g dba -u 1001 oracle
id grid
id oracle
passwd grid
passwd oracle
---
커널 파라미터 계산
---
vi /etc/sysctl.conf
kernel.sem = 250 32000 100 128
kernel.shmmax=4294967296
kernel.shmmni=4096
kernel.shmall=2097152
fs.file-max=6815744
fs.aio-max-nr=1048576
net.ipv4.ip_local_port_range=9000 65500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048576
sysctl -p
sysctl -a
-------------------------
shell limit
-----
vi /etc/security/limits.conf
------
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 7329287
oracle soft memlock 7329287
grid soft nofile 1024
grid hard nofile 65536
grid soft nproc 16384
grid hard nproc 16384
grid soft stack 10240
grid hard stack 32768
grid hard memlock 7329287
grid soft memlock 7329287
-----------------------
방화벽 끄기
----------------------
systemctl stop firewalld
systemctl disable firewalld
systemctl status firewalld
-------------------
avahi-daemon 끄기
------------
systemctl stop avahi-daemon.socket avahi-daemon.service
systemctl disable avahi-daemon.socket avahi-daemon.service
systemctl status avahi-daemon.socket avahi-daemon.service
-------------
SElinux 종료
------------
vi /etc/selinux/config
disabled
--------------
상태확인
---
getenforce
Disabled
[root@rac1 ~]# getenforce
Enforcing
---> reboot
[root@rac2 ~]# getenforce
Disabled
--------
nozerconf 설정
---------------
vi /etc/sysconfig/network
NOZEROCONF=yes
------------------------
컴파일러 확인
--------------------------
su - oracle
which cc ar ld make nm
exit
su - grid
which cc ar ld make nm
--------------------
환경변수 설정
-------------------------------
root bash_profile 설정(rac1)
-------------------
vi ~/.bash_profile
export ORACLE_BASE=/oracle/app/grid
export ORACLE_HOME=/oracle/app/19c/grid
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export LANG=C
. ~/.bash_profile
----------------------------------
root bash_profile 설정(rac2)
-------------------
vi ~/.bash_profile
export ORACLE_BASE=/oracle/app/grid
export ORACLE_HOME=/oracle/app/19c/grid
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export LANG=C
. ~/.bash_profile
----------------------------------
grid 유저 bash_profile 설정(rac1)
----------------------------------------
vi ~/.bash_profile
export PS1="[\u@\h \W]$ "
export EDITOR=vi
export ORACLE_SID=+ASM1
export GRID_BASE=/oracle/app/grid
export GRID_HOME=/oracle/app/19c/grid
export ORACLE_BASE=/oracle/app/grid
export ORACLE_HOME=/oracle/app/19c/grid
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=/usr/sbin:/usr/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export LANG=C
. ~/.bash_profile
----------------------------------
grid 유저 bash_profile 설정(rac2)
----------------------------------------
vi ~/.bash_profile
export PS1="[\u@\h \W]$ "
export EDITOR=vi
export ORACLE_SID=+ASM2
export GRID_BASE=/oracle/app/grid
export GRID_HOME=/oracle/app/19c/grid
export ORACLE_BASE=/oracle/app/grid
export ORACLE_HOME=/oracle/app/19c/grid
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=/usr/sbin:/usr/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export LANG=C
. ~/.bash_profile
----------------------------------------
오라클 유저 bash_profile 설정(rac1)
-------------------------------
vi ~/.bash_profile
export PS1="[\u@\h \W]$ "
export EDITOR=vi
export ORACLE_TERM=xterm
export ORACLE_SID=racdb1
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19c/db_home
export GRID_HOME=/oracle/app/19c/grid
export PATH=/bin:/sbin:/usr/sbin:/usr/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$GRID_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export LANG=C
alias ss='sqlplus "/as sysdba"'
. ~/.bash_profile
----------------------------------------
오라클 유저 bash_profile 설정(rac2)
-------------------------------
vi ~/.bash_profile
export PS1="[\u@\h \W]$ "
export EDITOR=vi
export ORACLE_TERM=xterm
export ORACLE_SID=racdb2
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19c/db_home
export GRID_HOME=/oracle/app/19c/grid
export PATH=/bin:/sbin:/usr/sbin:/usr/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$GRID_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export LANG=C
alias ss='sqlplus "/as sysdba"'
. ~/.bash_profile
------------------------
#디렉토리 생성 oracd 만들고 rpm 올리면서 작업하기
[root]
mkdir /oracd
mkdir /oracle
chown oracle:dba /oracle
chmod 775 /oracle
[oracle]
su - oracle
mkdir -pv $ORACLE_HOME
chmod -R 775 /oracle/app
exit
[grid]
su - grid
mkdir -pv $ORACLE_BASE
mkdir -pv $ORACLE_HOME
exit
[root]
chown -R grid:dba /oracle
chown -R oracle:dba /oracle/app/oracle
chown -R grid:dba /oracd
--------------
# Temp 파일시스템 할당
vi /etc/fstab
tmpfs /dev/shm tmpfs size=7g 0 0
--------------
# /dev/shm 영역 remount
mount -o remount /dev/shm
--------------
# 추가 후 확인
df -h /dev/shm
Filesystem Size Used Avail Use% Mounted on
tmpfs 7.0G 0 7.0G 0% /dev/shm
--------------
#디스크 나누기 (((((((((((node 1만)))))))))))))))
fdisk -l
fdisk /dev/sdb
n
p
enter
enter
enter
t
8e
w
#pv create
pvcreate /dev/sdb1
#vg create
vgcreate datavg /dev/sdb1
#lv vreate
lvcreate -n DATA01 -L 35G /dev/datavg
lvcreate -n RECO01 -L 25G /dev/datavg
lvcreate -n OCR01 -L 5G /dev/datavg
lvcreate -n OCR02 -L 5G /dev/datavg
lvcreate -n OCR03 -L 5G /dev/datavg
#확인
lsblk
lvdisplay
-------------
#rhel : 리포형성 (node 1,2 모두)
테스트 시 해당 방법으로 Local Repository 구성
리눅스 CD 마운트
root> mount /dev/sr0 /media
기존에 존재하는 repo 파일을 다른 경로로 백업
root> cd /etc/yum.repos.d
root> mkdir back
root> mv *.repo back
vi local.repo
[root@test yum.repos.d]# vi local.repo
[AppStream]
name=localRepository
baseurl=file:///media/AppStream
enabled=1
gpgcheck=0
[BaseOS]
name=localRepository
baseurl=file:///media/BaseOS
enabled=1
gpgcheck=0
-------------------------------------------------------------------
#asm rpm 설치 node 1,2 모두
------------
rpm -ivh oracleasm-support-2.1.12-1.el8.x86_64.rpm
dnf install -y oracleasm
rpm -ivh oracleasmlib-2.0.17-1.el8.x86_64.rpm
#설치확인
rpm -qa | grep oracleasm
------------------------------
#oracleasm 설정 ((((((((node 1 only ))))))
oracleasm configure -i
grid
dba
y
y
Default user to own the driver interface []: grid
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
#초기화
oracleasm init
lsblk
#oracleasm 만들기 ((((((((node 1 only ))))))
oracleasm createdisk DATA01 /dev/datavg/DATA01
oracleasm createdisk RECO01 /dev/datavg/RECO01
oracleasm createdisk OCR01 /dev/datavg/OCR01
oracleasm createdisk OCR02 /dev/datavg/OCR02
oracleasm createdisk OCR03 /dev/datavg/OCR03
#디스크 권한 확인
cd /dev/oracleasm/disks/
[root@rac1 disks]# ls -arlt
total 0
drwxr-xr-x 4 root root 0 Feb 13 15:25 ..
drwxr-xr-x 1 root root 0 Feb 13 15:25 .
brw-rw---- 1 grid dba 253, 3 Feb 13 15:26 RECO01
brw-rw---- 1 grid dba 253, 2 Feb 13 15:26 DATA01
brw-rw---- 1 grid dba 253, 5 Feb 13 15:26 OCR02
brw-rw---- 1 grid dba 253, 4 Feb 13 15:26 OCR01
brw-rw---- 1 grid dba 253, 6 Feb 13 15:26 OCR03
#노드2에서 확인)
oracleasm configure -i
oracleasm init
oracleasm scandisks
oracleasm listdisks
[root@rac2 oracd]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
Instantiating disk "DATA01"
Instantiating disk "RECO01"
Instantiating disk "OCR01"
Instantiating disk "OCR02"
Instantiating disk "OCR03"
[root@rac2 oracd]# oracleasm listdisks
DATA01
OCR01
OCR02
OCR03
RECO01
>>> 확인
----------
lsmod | grep oracleasm
했는데 아무것도 안뜬다면
##연결 해야함
modprobe oracleasm
[root@rac2 ~]# lsmod | grep oracleasm
oracleasm 69632 1
이렇게 나와야 한다.
------------
#필수 패키지 다운 node 1 ,2
dnf update -y
dnf install -y bc
dnf install -y binutils
dnf install -y compat-libcap1
dnf install -y compat-libstdc++-33
dnf install -y elfutils-libelf
dnf install -y elfutils-libelf-devel
dnf install -y fontconfig-devel
dnf install -y glibc
dnf install -y glibc-devel
dnf install -y ksh
dnf install -y libaio
dnf install -y libaio-devel
dnf install -y libXrender
dnf install -y libXrender-devel
dnf install -y libX11
dnf install -y libXau
dnf install -y libXi
dnf install -y libXtst
dnf install -y libgcc
dnf install -y libstdc++
dnf install -y libstdc++-devel
dnf install -y libxcb
dnf install -y make
dnf install -y policycoreutils
dnf install -y policycoreutils-python
dnf install -y smartmontools
dnf install -y sysstat
dnf install -y libnsl
dnf install -y libnsl.i686
dnf install -y libnsl2
dnf install -y libnsl2.i686
dnf install -y gcc
dnf install -y unixODBC
--------------------------
grid home unzip ((((((((((((((((grid rac1 only ))))))))))))))))
----------------------
su - grid
cd /oracd
ls -al
echo $ORALCE_HOME
unzip () -d $ORACLE_HOME
unzip LINUX.X64_193000_grid_home.zip -d $ORACLE_HOME
----------------------------------
ssh 연결설정 [ 1번 노드 grid, oracle 유저 에서 하는거임 ]
#$ssh 연결설정 (네트워크 제대로 연결되어있는지 확인)
---------node1,2 수행----------
mkdir ~/.ssh
chmod 700 ~/.ssh
cd ~/.ssh
ssh-keygen -t dsa
ssh-keygen -t rsa
#$node1에서 node2 공개 키를 받아 authorized_keys에 추가
---------node1에서만 수행----------
cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
ssh rac2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh rac2 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
#$node 2로전송
scp ~/.ssh/authorized_keys rac2:~/.ssh/authorized_keys
#$권한 변경
---------node1,2 수행----------
chmod 600 authorized_keys
#node 1,2 ssh 확인 처음할 때 yes 입력필요!
[rac1, rac2]
ssh rac1 date;ssh rac2 date;ssh rac1-priv date;ssh rac2-priv date;
grid
#ssh 연결설정 ----- 1번 노드 만 -------
cd $ORACLE_HOME
cd oui/prov/resources/scripts/
ls -al
cat /etc/hosts
./sshUserSetup.sh -user grid -hosts "rac1 rac2 rac1-priv rac2-priv" -hostfile /etc/hosts
yes
#확인
ssh rac1 date;ssh rac2 date;ssh rac1-priv date;ssh rac2-priv date;
#rac2로 ssh key 전송
cd
ls -alt
tar -cvpf ssh.tar .ssh
scp ssh.tar rac2:/home/grid
#rac2 tar풀기
cd
ls -alrt ssh.tar << 도착해있음
tar -xvpf ssh.tar
#ssh 확인
[rac1, rac2]
ssh rac1 date;ssh rac2 date;ssh rac1-priv date;ssh rac2-priv date;
passwd 입력없이 이렇게 뜨면 됨
Thu Feb 13 01:04:49 KST 2025
Thu Feb 13 01:04:50 KST 2025
Thu Feb 13 01:04:51 KST 2025
Thu Feb 13 01:04:52 KST 2025
oracle 유저로 가서 반복한다
[[ oracle ]]
#ssh 연결설정 ----- 1번 노드 만 -------
cd $GRID_HOME
cd oui/prov/resources/scripts/
ls -al
cat /etc/hosts
./sshUserSetup.sh -user oracle -hosts "rac1 rac2 rac1-priv rac2-priv" -hostfile /etc/hosts
yes
#확인
ssh rac1 date;ssh rac2 date;ssh rac1-priv date;ssh rac2-priv date;
#rac2로 ssh key 전송 -- 1번 노드
cd
ls -alt
tar -cvpf ssh.tar .ssh
scp ssh.tar rac2:/home/oracle
#rac2 tar풀기 --- 2번 노드
cd
ls -alrt
tar -xvpf ssh.tar
#ssh 확인
[rac1, rac2]
ssh rac1 date;ssh rac2 date;ssh rac1-priv date;ssh rac2-priv date;
passwd 입력없이 이렇게 뜨면 됨
Thu Feb 13 01:04:49 KST 2025
Thu Feb 13 01:04:50 KST 2025
Thu Feb 13 01:04:51 KST 2025
Thu Feb 13 01:04:52 KST 2025
-----------------------------------------------------------------------------------------------------------------
#필요 rpm 설치 [[[ root ]]]
cd $ORACLE_HOME
cd cv/rpm
ls -al
export CVUQDISK_GRP=dba
rpm -ivh cvuqdisk-1.0.10-1.rpm
#rac2 로 옮기고 설치
scp cvuqdisk-1.0.10-1.rpm rac2:/tmp
connectind? -> yes
passwd : <<<<<<<<<<<<<< 루트에서 보내는거라 비번 있음,
[rac2]
cd /tmp
ls -al | grep cvuq
export CVUQDISK_GRP=dba
rpm -ivh cvuqdisk-1.0.10-1.rpm
----------------------------------------------------------------------------------------
#환경구성 node 1 only root
cd $ORACLE_HOME
ls
./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -verbose > vfy.log
----------------------------------------------------------------------------------------
#OPatch 버전 확인 , 백업 , 교체 node 1 only
su - grid
cd $ORACLE_HOME
opatch version
mv OPatch OPatch.OLD
cd /oracd
ls -al << 여기서 권한이 root:root 로 되어있었는데 맞나?>
unzip (6880) -d $ORACLE_HOME
opatch version
[grid@rac1 oracd]$ opatch version
OPatch Version: 12.2.0.1.45
ls -al
unzip p37262208_190000_Linux-x86-64.zip <<<<< /oracd 에 그대로 언집
----------------------------------------------------------------------------------------
#grid 계정으로 셋업 ojvm 패치까지
>>>>> GUI 실행을 위해 GRID 로 터미널 열 것 <<<<<<
grid 계정 , node 1
cd $ORACLE_HOME
export CV_ASSUME_DISTID=RHEL7.6
./gridSetup.sh -applyRU /oracd/37262208/37257886
패치 번호는
Patch 37262208: COMBO OF OJVM COMPONENT 19.26.0.0.250121 + GI RU 19.26.0.0.250121
Patch 37257886 - Database Grid Infrastructure Jan 2025 Release Update 19.26.0.0.250121 --> RAC-Rolling Installable
로 하면됨
패치가 되기까지 시간이 걸리니까 기다리기.
>>>>> CLSRSC-400: A system reboot is required to continue installing.
아래와 같이 조치한 후 reboot 하고 다시 진행..
1. vi $ORACLE_HOME/lib/acfstoolsdriver.sh
2. 해당부분 찾아서 # 처리한다.
exec ${RUNTHIS} $@
3. 그 자리에 대신 insert
exit 0
>> 다시 루트스크립트 돌리기
/oracle/app/19c/grid/root.sh
루트 스크립트 다 돌리고
SCAN IP가 DNS에 등록되어 있지 않아 생긴 에러는 skip 버튼으로 넘어간다.
설치 마지막에
[INS-20802] 에러는 무시한다.
GRID 설치 완료.
설치가 제대로 완료되었는지 확인한다.
[grid@rac1 ~]# crsctl stat res -t
CRS 디스크를 확인한다.
[oracle@rac1 ~]$ ocrcheck만약 Grid 설치 도중 에러가 발생해서, 다시 설치를 하려고 하는데 CRS 파일이 이미 할당되어있어서 진행을 할 수 없는 경우에는
(만약 CRS가 All disks로 해야 나오고, candidate(후보)가 아니라 member로 이미 할당되어 있는 경우)
VirtualBox에서 각 서버에 연결되어있는 공유 디스크들의 연결을 삭제하고, 파일 - 도구 - 가상 미디어 관리자로 들어가서 해당 공유 디스크를 지운다.
그리고 나서 앞서 했던 단계 중 공유 스토리지 생성부분만 다시 수행한다.
[grid@rac1 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 901284
Used space (kbytes) : 84292
Available space (kbytes) : 816992
ID : 1673879911
Device/File Name : +OCR
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check bypassed due to non-privileged user
---------- GRID 패치 확인 --------------------------------------------------
$ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME
[grid@rac1 ~]$ $ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME
37461387;TOMCAT RELEASE UPDATE 19.0.0.0.0 (37461387)
37268031;OCW RELEASE UPDATE 19.26.0.0.0 (37268031)
37266638;ACFS RELEASE UPDATE 19.26.0.0.0 (37266638)
37260974;Database Release Update : 19.26.0.0.250121 (37260974)
36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186)
OPatch succeeded.#####################################################
ASM 디스크 그룹 추가
#####################################################
grid 유저에서 asmca를 실행한다.
$ asmca
결과 확인
$ crsctl stat res -t
#####################################################
ORACLE 엔진 설치
#####################################################
(당연히 oracle 유저에서 ) node 1
설치파일 압축 해제
$ cd $ORACLE_HOME
$ unzip /oracd/LINUX.X64_193000_db_home.zip -d $ORACLE_HOME
OPatch 파일 최신 파일로 교체
$ cd $ORACLE_HOME
$ mv OPatch OPatch.bk
cd /oracd
ls -al
unzip 'p6880880_190000_Linux-x86-64(1).zip' -d $ORACLE_HOME
replace 할거냐고 물어본다. 나는 All 누름.
opatch version
[oracle@rac1 oracd]$ opatch version
OPatch Version: 12.2.0.1.45
OPatch succeeded.
unzip p37262172_190000_Linux-x86-64.zip <<<<< /oracd 에 그대로 언집
ssh 키 체크 oracle 유저 노드 1, 2 번 모두 확인
$ ssh rac1 date;ssh rac2 date;ssh rac1-priv date;ssh rac2-priv date;runinstaller 실행
root 유저에서
ls -alrt 확인 후 그룹명 확인
# chown -R oracle:dba /oracd <<<<< root 에서 실행
oracle:dba < 이거 확인 하고다시 oracle 유저로 와서
하기 직전에 df -h 로 공간 확인한다.
10G 이상 / 에 여유공간 있어야 함.
cd $ORACLE_HOME
export CV_ASSUME_DISTID=RHEL7.6
./runInstaller -applyRU /oracd/37262172/37260974
Patch 37260974 - Database Jan 2025 Release Update 19.26.0.0.250121 --> RAC-Rolling Installable
------------------
[INS-06006] Passwordless SSH connectivity not set up between the following node(s): [rac2].
기존 scp 파일 백업
mv /usr/bin/scp /usr/bin/scp.orig
scp 파일 신규 생성 및 아래 내용 입력
vi /usr/bin/scp
/usr/bin/scp.orig -T $*
scp 파일 권한 부여
chmod 555 /usr/bin/scp
---------------
OJVM 패치 (1번 2번 노드 모두) oracle 유저
cd /oracd/37262172/37102264
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME
2번 노드에 없다면
/oracd 에 올려주고 unzip 도 한다.
하기 전에 ls -al 로 확인 하고
만약 소유 바꾸고싶으면
chown -R oracle:dba /oracd 를 한다.
df -h 해서 공간 확인하고
부족하면 rm -rf 해서 확보하고
cd /oracd/37262172/37102264
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME
패치 잘 됐는지 확인한다
$ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME
37102264;OJVM RELEASE UPDATE: 19.26.0.0.250121 (37102264) <<<<< 26 확인
37260974;Database Release Update : 19.26.0.0.250121 (37260974) <<<<< 26 확인
29585399;OCW RELEASE UPDㅛATE 19.3.0.0.0 (29585399)
OPatch succeeded.
#####################################################
DB 생성
#####################################################
DBCA 실행
oracle 유저로 접속해서 dbca를 실행한다.
[oracle@rac1 ~]$ dbca
확인
[oracle@rac1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.OCR.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
ora.RECO.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
ora.cvu
1 ONLINE ONLINE rac1 STABLE
ora.qosmserver
1 ONLINE ONLINE rac1 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.racdb.db
1 ONLINE ONLINE rac1 Open,HOME=/oracle/ap
p/oracle/product/19c
/db_home,STABLE
2 ONLINE ONLINE rac2 Open,HOME=/oracle/ap
p/oracle/product/19c
/db_home,STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
--------------------------------------------------------------------------------
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Feb 17 19:55:57 2025
Version 19.26.0.0.0
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.26.0.0.0
SQL> select instance_name, version, status from gv$instance;
INSTANCE_NAME VERSION STATUS
---------------- ----------------- ------------
racdb2 19.0.0.0.0 OPEN
racdb1 19.0.0.0.0 OPEN
종료
# crsctl stop crs
기동
# crsctl start crs -wait
˗ˋˏ O R A C L E ˎˊ˗