pat98's always & forever

- CFS 환경에서 ocr/voting 디스크 추가/삭제 테스트 (19c 버전)

[root@ocfs1:/root]# crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [19.0.0.0.0]
[root@ocfs1:/root]# crsctl query crs softwareversion
Oracle Clusterware version on node [ocfs1] is [19.0.0.0.0]
[root@ocfs1:/root]# crsctl query crs releasepatch
Oracle Clusterware release patch level is [724960844] and the complete list of patches [29401763 29517242 29517247 29585399 ] have been applied on the local node. The release patch string is [19.3.0.0.0].

1) 먼저 voting 테스트
[root@ocfs1:/root]# crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   ccf411c9c5e24facbf4f82aa5f45bc5b (/vote01/vote01) []
 2. ONLINE   9d90852f7ced4f5bbf87312e7c8af744 (/vote02/vote02) []
 3. ONLINE   60ff24c4dca64f99bfc397502d4077ce (/vote03/vote03) []
Located 3 voting disk(s).

1. Replace 시도...에러남

[root@ocfs1:/vote01]# crsctl replace votedisk /vote04/vote04
CRS-4263: This operation is not allowed
CRS-4000: Command Replace failed, or completed with errors.

2. 추가
crsctl add css votedisk /vote04/vote04
Now formatting voting disk: /vote03/vote03.
CRS-4603: Successful addition of voting disk /vote03/vote03.

[root@ocfs1:/root]# crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   ccf411c9c5e24facbf4f82aa5f45bc5b (/vote01/vote01) []
 2. ONLINE   9d90852f7ced4f5bbf87312e7c8af744 (/vote02/vote02) []
 3. ONLINE   60ff24c4dca64f99bfc397502d4077ce (/vote03/vote03) []
 4. ONLINE   d54845ca4c3e4f78bf6a0569303b1b41 (/vote04/vote04) []
Located 4 voting disk(s).

-> 추가는 그냥 됨. 미리 touch 로 화일 안 만들어도 자동 생성됨.

3. 삭제

crsctl delete css votedisk /vote04/vote04
CRS-4611: Successful deletion of voting disk /vote04/vote04.

[root@ocfs1:/root]# crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   ccf411c9c5e24facbf4f82aa5f45bc5b (/vote01/vote01) []
 2. ONLINE   9d90852f7ced4f5bbf87312e7c8af744 (/vote02/vote02) []
 3. ONLINE   60ff24c4dca64f99bfc397502d4077ce (/vote03/vote03) []
Located 3 voting disk(s).

-rw-r-----   1 oracle dba  20972032 Dec 20 13:11 vote04

-> 삭제하면 물리적 화일은 정보만 업데이트 되고 그냥 남아 있음.

2) 다음은 ocr disk 테스트

1. 그냥 add 하면 아래와 같이 에러발생함.

[root@ocfs1:/root]# ocrconfig -add /vote04/ocr04
PROT-30: The Oracle Cluster Registry location to be added is not usable.
PROC-50: The Oracle Cluster Registry location to be added is inaccessible on nodes ocfs1.

2. touch /vote04/ocr04

    chown root:dba /vote04/ocr04

[root@ocfs1:/root]# ocrconfig -add /vote04/ocr04
[root@ocfs1:/root]# ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     491684
         Used space (kbytes)      :      84036
         Available space (kbytes) :     407648
         ID                       :  359905203
         Device/File Name         : /vote01/ocr01
                                    Device/File integrity check succeeded
         Device/File Name         : /vote02/ocr02
                                    Device/File integrity check succeeded
         Device/File Name         : /vote03/ocr03
                                    Device/File integrity check succeeded
         Device/File Name         : /vote04/ocr04
                                    Device/File integrity check succeeded
                                    Device/File not configured
         Cluster registry integrity check succeeded
         Logical corruption check succeeded

3. delete 및 replace  테스트

- 삭제 진행

[root@ocfs1:/vote04]# ocrconfig -delete /vote04/ocr04

[root@ocfs1:/vote04]# ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     491684
         Used space (kbytes)      :      84036
         Available space (kbytes) :     407648
         ID                       :  359905203
         Device/File Name         : /vote01/ocr01
                                    Device/File integrity check succeeded
         Device/File Name         : /vote02/ocr02
                                    Device/File integrity check succeeded
         Device/File Name         : /vote03/ocr03
                                    Device/File integrity check succeeded
                                    Device/File not configured
                                    Device/File not configured
         Cluster registry integrity check succeeded
         Logical corruption check succeeded

- replace 진행

[root@ocfs1:/root]# ocrconfig -replace /vote03/ocr03 -replacement /vote04/ocr04
[root@ocfs1:/root]# ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     491684
         Used space (kbytes)      :      84036
         Available space (kbytes) :     407648
         ID                       :  359905203
         Device/File Name         : /vote01/ocr01
                                    Device/File integrity check succeeded
         Device/File Name         : /vote02/ocr02
                                    Device/File integrity check succeeded
         Device/File Name         : /vote04/ocr04
                                    Device/File integrity check succeeded
                                    Device/File not configured
                                    Device/File not configured
         Cluster registry integrity check succeeded
         Logical corruption check succeeded

물리적인 화일은 남아있어서 수동으로 삭제 필요

[root@ocfs1:/vote04]# ls -al
total 22480
drwxrwxrwx   3 root   root      3896 Dec 20 23:31 .
drwxr-xr-x. 27 oracle dba       4096 Sep 10  2021 ..
drwxr-xr-x   2 root   root      3896 Sep 10  2021 lost+found
-rw-r--r--   1 root   dba  503484416 Dec 20 23:31 ocr04
-rw-r-----   1 oracle dba   20972032 Dec 20 13:15 vote04

결론 :

CFS 환경에서 ocr/voting add 작업시에는

1) voting 은 주어진 이름으로 바로 생성되고

2) ocr file 은 touch 로 미리 화일 생성이 되어 있어야 정상 작업이 가능하다

3) replace 도 정상적으로 잘됨.

https://docs.oracle.com/en/engineered-systems/health-diagnostics/autonomous-health-framework/ahfug/deprecated-legacy-orachk-and-exachk-scheduler-commands.html#GUID-8E1E97C5-DF5B-466C-94B7-DA44DB3E06AE

AHF 22.2 부터는 Exachk 명령이 살짝 바뀜.

- 기존의 해당 명령어는 deprecated 됨. (-d 옵션 먹지 않음)
exachk -d start
exachk -d stop
exachk -d status

- 신규 옵션은 아래와 같음.
exachk -autostart
exachk -autostop 
exachk -autostatus

최신 패치시 또는 applyRU 적용시 fuser 명령어 없어서 opatch 패치시 에러날때..

주로 RHEL7 OS 설치시 최소 minimum 옵션으로 설치시 fuser 명령어가 누락되는 듯 하다.

에러날때 opatch 로그를 보고 확인가능..

(첨부화일은 psmisc 설치하여 해결하고 싶다면 각각 RHEL7/RHEL8 용 rpm을 첨부함)

1. yum install psmisc 
또는 

2. export OPATCH_NO_FUSER=true
또는 

3. export PATH=$PATH:/tmp
cat > /tmp/fuser
또는

4. cd $GRID_HOME/bin
touch fuser
chmod 755 fuser

Steps to rename the cluster name (Doc ID 2725377.1)

19c (19.3) 부터는 cluster name 을 deconfig 작업없이 바꿀수가 있어 테스트 해봄. 

1. 이름 확인

root:/root> olsnodes -c
gtdb-scan

gtdb-scan에서 gtdb-clu 로 변경해 보겠다.

2. 한쪽에서만 명령수행

root:/root> crsrename cluster gtdb-clu   <----- 명령 실해우  조금 시간이 걸림

CRS-2004: successfully set the cluster name; restart Oracle High Availability Services on all nodes for new cluster name to take effect

3. 양쪽 다 내림
root:/root> crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'gtdb3'
CRS-2673: Attempting to stop 'ora.crf' on 'gtdb3'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'gtdb3'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'gtdb3'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'gtdb3'
CRS-2673: Attempting to stop 'ora.driver.afd' on 'gtdb3'
CRS-2677: Stop of 'ora.driver.afd' on 'gtdb3' succeeded
CRS-2677: Stop of 'ora.crf' on 'gtdb3' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'gtdb3'
CRS-2677: Stop of 'ora.gpnpd' on 'gtdb3' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'gtdb3' succeeded
CRS-2677: Stop of 'ora.drivers.acfs' on 'gtdb3' succeeded
CRS-2677: Stop of 'ora.gipcd' on 'gtdb3' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'gtdb3' has completed
CRS-4133: Oracle High Availability Services has been stopped.

4. 양쪽 다 올림
root:/root> crsctl start crs -wait
CRS-4123: Starting Oracle High Availability Services-managed resources
CRS-2672: Attempting to start 'ora.mdnsd' on 'gtdb3'
CRS-2672: Attempting to start 'ora.evmd' on 'gtdb3'
CRS-2676: Start of 'ora.mdnsd' on 'gtdb3' succeeded
CRS-2676: Start of 'ora.evmd' on 'gtdb3' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'gtdb3'
CRS-2676: Start of 'ora.gpnpd' on 'gtdb3' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'gtdb3'
CRS-2676: Start of 'ora.gipcd' on 'gtdb3' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'gtdb3'
CRS-2676: Start of 'ora.cssdmonitor' on 'gtdb3' succeeded
CRS-2672: Attempting to start 'ora.crf' on 'gtdb3'
CRS-2672: Attempting to start 'ora.cssd' on 'gtdb3'
CRS-2672: Attempting to start 'ora.diskmon' on 'gtdb3'
CRS-2676: Start of 'ora.diskmon' on 'gtdb3' succeeded
CRS-2676: Start of 'ora.crf' on 'gtdb3' succeeded
CRS-2676: Start of 'ora.cssd' on 'gtdb3' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'gtdb3'
CRS-2672: Attempting to start 'ora.ctssd' on 'gtdb3'
CRS-2676: Start of 'ora.ctssd' on 'gtdb3' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'gtdb3' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'gtdb3'
CRS-2676: Start of 'ora.asm' on 'gtdb3' succeeded
CRS-2672: Attempting to start 'ora.storage' on 'gtdb3'
CRS-2676: Start of 'ora.storage' on 'gtdb3' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'gtdb3'
CRS-2676: Start of 'ora.crsd' on 'gtdb3' succeeded
CRS-6023: Starting Oracle Cluster Ready Services-managed resources
CRS-2672: Attempting to start 'ora.proxy_advm' on 'gtdb3'
CRS-6017: Processing resource auto-start for servers: gtdb3
CRS-2672: Attempting to start 'ora.gtdb3.vip' on 'gtdb3'
CRS-2672: Attempting to start 'ora.scan1.vip' on 'gtdb3'
CRS-2672: Attempting to start 'ora.cvu' on 'gtdb3'
CRS-2672: Attempting to start 'ora.ons' on 'gtdb3'
CRS-2672: Attempting to start 'ora.chad' on 'gtdb3'
CRS-2672: Attempting to start 'ora.gtdb4.vip' on 'gtdb3'
CRS-2672: Attempting to start 'ora.qosmserver' on 'gtdb3'
CRS-2676: Start of 'ora.gtdb3.vip' on 'gtdb3' succeeded
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'gtdb3'
CRS-2672: Attempting to start 'ora.LISTENER_TEST.lsnr' on 'gtdb3'
CRS-2672: Attempting to start 'ora.TEST.lsnr' on 'gtdb3'
CRS-2676: Start of 'ora.gtdb4.vip' on 'gtdb3' succeeded
CRS-2676: Start of 'ora.cvu' on 'gtdb3' succeeded
CRS-2676: Start of 'ora.scan1.vip' on 'gtdb3' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'gtdb3'
CRS-2676: Start of 'ora.chad' on 'gtdb3' succeeded
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'gtdb3' succeeded
CRS-2676: Start of 'ora.LISTENER_TEST.lsnr' on 'gtdb3' succeeded
CRS-2676: Start of 'ora.TEST.lsnr' on 'gtdb3' succeeded
CRS-2676: Start of 'ora.ons' on 'gtdb3' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'gtdb3' succeeded
CRS-2676: Start of 'ora.proxy_advm' on 'gtdb3' succeeded
CRS-2672: Attempting to start 'ora.ORADATA.BOM.advm' on 'gtdb3'
CRS-2672: Attempting to start 'ora.ORADATA.CDC.advm' on 'gtdb3'
CRS-2672: Attempting to start 'ora.ORADATA.SOM.advm' on 'gtdb3'
CRS-2676: Start of 'ora.ORADATA.BOM.advm' on 'gtdb3' succeeded
CRS-2676: Start of 'ora.ORADATA.SOM.advm' on 'gtdb3' succeeded
CRS-2676: Start of 'ora.ORADATA.CDC.advm' on 'gtdb3' succeeded
CRS-2672: Attempting to start 'ora.kwak.db' on 'gtdb3'
CRS-2672: Attempting to start 'ora.velvet.db' on 'gtdb3'
CRS-2676: Start of 'ora.qosmserver' on 'gtdb3' succeeded
CRS-2676: Start of 'ora.velvet.db' on 'gtdb3' succeeded
CRS-2676: Start of 'ora.kwak.db' on 'gtdb3' succeeded
CRS-6017: Processing resource auto-start for servers: gtdb3,gtdb4
CRS-2673: Attempting to stop 'ora.gtdb4.vip' on 'gtdb3'
CRS-2672: Attempting to start 'ora.chad' on 'gtdb4'
CRS-2672: Attempting to start 'ora.ons' on 'gtdb4'
CRS-2677: Stop of 'ora.gtdb4.vip' on 'gtdb3' succeeded
CRS-2672: Attempting to start 'ora.gtdb4.vip' on 'gtdb4'
CRS-2676: Start of 'ora.gtdb4.vip' on 'gtdb4' succeeded
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'gtdb4'
CRS-2672: Attempting to start 'ora.LISTENER_TEST.lsnr' on 'gtdb4'
CRS-2672: Attempting to start 'ora.TEST.lsnr' on 'gtdb4'
CRS-2676: Start of 'ora.LISTENER_TEST.lsnr' on 'gtdb4' succeeded
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'gtdb4' succeeded
CRS-2676: Start of 'ora.chad' on 'gtdb4' succeeded
CRS-2676: Start of 'ora.ons' on 'gtdb4' succeeded
CRS-2676: Start of 'ora.TEST.lsnr' on 'gtdb4' succeeded
CRS-33672: Attempting to start resource group 'ora.asmgroup' on server 'gtdb4'
CRS-2672: Attempting to start 'ora.asmnet1.asmnetwork' on 'gtdb4'
CRS-2676: Start of 'ora.asmnet1.asmnetwork' on 'gtdb4' succeeded
CRS-2672: Attempting to start 'ora.ASMNET1LSNR_ASM.lsnr' on 'gtdb4'
CRS-2676: Start of 'ora.ASMNET1LSNR_ASM.lsnr' on 'gtdb4' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'gtdb4'
CRS-2676: Start of 'ora.asm' on 'gtdb4' succeeded
CRS-33676: Start of resource group 'ora.asmgroup' on server 'gtdb4' succeeded.
CRS-2672: Attempting to start 'ora.ORADATA.dg' on 'gtdb4'
CRS-2672: Attempting to start 'ora.proxy_advm' on 'gtdb4'
CRS-2676: Start of 'ora.ORADATA.dg' on 'gtdb4' succeeded
CRS-2672: Attempting to start 'ora.kwak.db' on 'gtdb4'
CRS-2676: Start of 'ora.proxy_advm' on 'gtdb4' succeeded
CRS-2672: Attempting to start 'ora.ORADATA.CDC.advm' on 'gtdb4'
CRS-2672: Attempting to start 'ora.ORADATA.SOM.advm' on 'gtdb4'
CRS-2676: Start of 'ora.ORADATA.CDC.advm' on 'gtdb4' succeeded
CRS-2676: Start of 'ora.ORADATA.SOM.advm' on 'gtdb4' succeeded
CRS-2672: Attempting to start 'ora.ORADATA.BOM.advm' on 'gtdb4'
CRS-2676: Start of 'ora.ORADATA.BOM.advm' on 'gtdb4' succeeded
CRS-2672: Attempting to start 'ora.velvet.db' on 'gtdb4'
CRS-2676: Start of 'ora.kwak.db' on 'gtdb4' succeeded
CRS-2672: Attempting to start 'ora.kwak.upmu.svc' on 'gtdb4'
CRS-2676: Start of 'ora.kwak.upmu.svc' on 'gtdb4' succeeded
CRS-2676: Start of 'ora.velvet.db' on 'gtdb4' succeeded
CRS-6016: Resource auto-start has completed for server gtdb3
CRS-6016: Resource auto-start has completed for server gtdb4
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
 

5. 이름 확인
root:/root> olsnodes -c
gtdb-clu

6. profile.xml 화일에 변경된 내용 확인

root:/oracle/grid/gpnp/gtdb3/profiles/peer> grep clu profile.xml
<?xml version="1.0" encoding="UTF-8"?><gpnp:GPnP-Profile Version="1.0" xmlns="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:gpnp="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:orcl="http://www.oracle.com/gpnp/2005/11/gpnp-profile" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.grid-pnp.org/2005/11/gpnp-profile gpnp-profile.xsd" ProfileSequence="8" ClusterUId="5b9302bf58ceefbcffeccf98c169882c" ClusterName="gtdb-clu" PALocation=""><gpnp:Network-Profile><gpnp:HostNetwork id="gen" HostName="*"><gpnp:Network id="net1" IP="172.16.0.0" Adapter="bond0" Use="public"/><gpnp:Network id="net2" IP="10.10.0.0" Adapter="bond1" Use="asm,cluster_interconnect"/></gpnp:HostNetwork></gpnp:Network-Profile><orcl:CSS-Profile id="css" DiscoveryString="+asm" LeaseDuration="400"/><orcl:ASM-Profile id="asm" DiscoveryString="/dev/mapper,AFD:*" SPFile="+ORARECO/spfileASM.ora" Mode="remote" Extended="false"/><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#"><ds:SignedInfo><ds:CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/><ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><ds:Reference URI=""><ds:Transforms><ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><ds:Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"> <InclusiveNamespaces xmlns="http://www.w3.org/2001/10/xml-exc-c14n#" PrefixList="gpnp orcl xsi"/></ds:Transform></ds:Transforms><ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><ds:DigestValue>77vX1zi7ocUXFjqmhHbMPiIheF0=</ds:DigestValue></ds:Reference></ds:SignedInfo><ds:SignatureValue>fGkXizhtfmUzGc7AZuAt88a5YjJlfSyoViTUWT2xj/Xe3WqIEI7yPYo6S0eQO7tWJ9TT2YPmQI6lWHGEDbFA6d0074wHvc0NjCreP3O6i0kgvs/eUFLhQzTuuyFZ5cHSYAx5eLthu7FF7a+jWJzqgTee1VmjoZyTZLaDjpyg9uE=</ds:SignatureValue></ds:Signature></gpnp:GPnP-Profile>

 • 현상
-  RAC 환경에서 LMS Process가 DRM(Dynamic Remastering) 수행 중 ORA-600: [kjbmprlst:shad!res] 에러로 인하여
Terminate되는 현상

• 원인
 - Oracle RAC 19c에서 발생 가능한 Bug.28730044 이슈가 존재 .
- <Note:28730044.8> Bug 28730044 - RAC Instance Crashes With Error ORA-600 [kjbmprlst:shad!res]

• 해결 방안
1. Patch 28730044 적용 권고 (패치 이름에 Exadata라고 되어 있지만, Non-Exadata에서도 발생하므로, 적용 권장)
2. 그러나, 이 이슈에 대한 Fix를 포함하는 DB RU가 없으므로, DB 파라미터로 DRM 기능을 off시키는 것이 권장됨
Workaround :
_gc_policy_time=0, _gc_undo_affinity=0

gridSetup.sh(root.sh) fails with INS-41814 during GI installation on RHEL8/OL8. (Doc ID 2858850.1)

환경 : RHEL 8.3 / 19c RAC 구성

증상 : 

보통 구성중 INS-41814 에러가 나는 모양인데..

내가 겪은 경우에는 CRS 설치 중 1번노드부터  19단계중 거의 다 끝나가는 18단계에서 아래와 같은 로그를 뿌리고 ora.crsd 가 생성되지 못하고 실패함 .

-> 세부적으로는 srvctl add cvu 명령어가 실패함

CLSRSC-504: Executing installationstep 18 of 19: 'ConfigNode'.

PRCT-21011 " "crsctl" 실행을 실패했습니다. 자세한 오류 : CRS-4003: Resource 'ora.crsd' is registered

/bin/sh: warning: setlocale: LC_ALL: cannot change locale (en_US.UTF-8)

해결책 :

해당 경우에는 어이없게도 한글팩은 설치되어 있는데 english locale 이 설치되지 않았음. rhel 8  환경에서는 종종 누락되는 모양이다.

 Install package glibc-langpack-* which include en_US.UTF-8 locale. (eg. glibc-langpack-en)

-> RHEL 8 / OL8 인 경우 en_US.UTF-8 locale 랭귀지 팩을 설치해 줄것.

Exadata DB서버 Core CoD 로 증설 작업 

https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-database-servers.html#GUID-6177B070-EF7C-4858-869D-E82C5F8293C0

-> Exadata 모델에 따라 Minimum 수량과 Maximum 수량이 있으므로 사전확인 필요

- CRS 중지 후

1. core 갯수 확인
DBMCLI> LIST DBSERVER attributes coreCount

2. core 수 변경
DBMCLI> ALTER DBSERVER pendingCoreCount = 24

3. core 갯수 확인
DBMCLI> LIST DBSERVER attributes pendingCoreCount

4. 서버 리부팅

5. active Core 확인
DBMCLI> LIST DBSERVER attributes coreCount

추가사항 : Exadata X6 모델인 경우 늘어난 코어가 보이지 않는 Bug 가 있으므로 아래와 같이 사전 조치
Exadata X6 Machine Is Not Showing Increased Corecount Value (Doc ID 2269705.1)

DBMCLI> alter dbserver iaasMode="off"

증상 : SYS 암호 변경시 시도시 ORA-03113 발생하며 에러

SQL> alter user sys identified by <pwd>;
alter user sys identified by <pwd>
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 898176
Session ID: 3403 Serial number: 31317

Solution :

Oracle DBMS RU 19.12로 업그레이드 했을경우 발생하는 것으로 추정

Patch 31912638 적용 또는

dba_profile의  PASSWORD_REUSE_MAX 와 PASSWORD_REUSE_TIME 을 UNLIMITED 로 변경할것.

MOS : 

ORA-3113 and ORA-7445 [__intel_avx_rep_memcpy()+1088] when altering SYS user password when PASSWORD_REUSE_MAX or PASSWORD_REUSE_TIME has a value (Doc ID 2798582.1)

-- 확인

SQL> select comp_name, version, status from dba_registry;

COMP_NAME                                VERSION         STATUS 
---------------------------------------- --------------- ----------- 
JServer JAVA Virtual Machine             12.1.0.2.0      VALID
Oracle XDK                  12.1.0.2.0      VALID
Oracle Database Java Packages      12.1.0.2.0      VALID

select role from dba_roles where role like '%JAVA%';

select currently_used, name from  dba_feature_usage_statistics where name like '%Java%';

-- JVM 설치

-- Start of File full_jvminst.sql
spool full_jvminst.log;
set echo on
connect / as sysdba
startup mount
alter system set "_system_trig_enabled" = false scope=memory;
alter database open;
select obj#, name from obj$
  where type#=28 or type#=29 or type#=30 or namespace=32;
@?/javavm/install/initjvm.sql
select count(*), object_type from all_objects
   where object_type like '%JAVA%' group by object_type;
@?/xdk/admin/initxml.sql
select count(*), object_type from all_objects
   where object_type like '%JAVA%' group by object_type;
@?/xdk/admin/xmlja.sql
select count(*), object_type from all_objects
   where object_type like '%JAVA%' group by object_type;
@?/rdbms/admin/catjava.sql
select count(*), object_type from all_objects
   where object_type like '%JAVA%' group by object_type;
@?/rdbms/admin/catexf.sql
select count(*), object_type from all_objects
   where object_type like '%JAVA%' group by object_type;
shutdown immediate
set echo off
spool off
exit
-- End of File full_jvminst.sql


-- 객체확인

select owner, count(*) from all_objects
where object_type like '%JAVA%' group by owner;

OWNERCOUNT(*) 
------------------------------ ----------
DMSYS 467
EXFSYS 40
MDSYS 117
ORDSYS   1354
SYS 14987
WKSYS  20

-- JVM 제거

-- Start of File full_rmjvm.sql
spool full_rmjvm.log
set echo on
connect / as sysdba
startup mount
alter system set "_system_trig_enabled" = false scope=memory;
alter system enable restricted session;
alter database open;
@?/rdbms/admin/catnoexf.sql
@?/rdbms/admin/catnojav.sql
@?/xdk/admin/rmxml.sql
@?/javavm/install/rmjvm.sql
truncate table java$jvm$status;
select * from obj$ where obj#=0 and type#=0;
delete from obj$ where obj#=0 and type#=0;
commit;
select owner, count(*) from all_objects
   where object_type like '%JAVA%' group by owner;
select obj#, name from obj$
   where type#=28 or type#=29 or type#=30 or namespace=32;
select o1.name from obj$ o1,obj$ o2
   where o1.type#=5 and o1.owner#=1 and o1.name=o2.name and o2.type#=29;
shutdown immediate
set echo off
spool off
exit

기본으로 PDB를 만들면 CDB를 Startup 했을 때 Open 되지 않고 Mount 상태까지만 올라온다.

귀찮으므로 자동으로 같이 올라오는 Trigger 를 만들어 준다.

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Nov 8 09:38:55 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
SQL> startup
ORACLE instance started.

Total System Global Area 4932499992 bytes
Fixed Size                  9144856 bytes
Variable Size             939524096 bytes
Database Buffers         3976200192 bytes
Redo Buffers                7630848 bytes
Database mounted.
Database opened.

- 생성

SQL>

create or replace trigger Sys.After_Startup after startup on database
begin
 execute immediate 'alter pluggable database all open';
end After_Startup;
/

Trigger created.

- 지울때는

drop trigger Sys.After_Startup;