2024. 11. 16. 22:05 내가 읽은 책
'2024/11'에 해당되는 글 4건
- 2024.11.16 오늘도 나아가는 중입니다 - 조민 에세이
- 2024.11.08 Pat Metheny - MoonDial (2024)
- 2024.11.08 23ai SYSTEM, SYSAUX, USERS Big tablespace 사용하지 않기
- 2024.11.04 23ai RU 10월패치 23.6.0.24.10(37037086) 적용 테스트
2024. 11. 8. 23:31 좋아하는 음악
Pat Metheny - MoonDial (2024)
팻메시니 옹의 어쿠스틱 기타 앨범이 2024년 7월에 발매 되었다.
Custom 제작한 바리톤 나일론 기타로 연주하여 음의 폭이 넓다고 한다.
한 동안 플레이리스트에 넣고 반복 청취예정..
01. MoonDial (Metheny) 6:23
02. La Crosse (Metheny) 4:48
03. You’re Everything (Corea/Potter) 2:38
04. Here, There and Everywhere (Lennon/McCartney) 4:23
05. We Can’t See It, But It’s There (Metheny) 2:58
06. Falcon Love (Metheny) 7:13
07. Everything Happens To Me/Somewhere (Dennis/Adair; Bernstein/Sondheim) 7:11
08. Londonderry Air (Traditional) 5:03
09. This Belongs To You (Metheny) 5:28
10. Shōga (Metheny) 3:14
11. My Love And I (Raskin/Mercer) 3:50
12. Angel Eyes (Dennis/Brent) 6:56
13. MoonDial (epilogue) (Metheny) 1:13
2024. 11. 8. 12:32 오라클
23ai SYSTEM, SYSAUX, USERS Big tablespace 사용하지 않기
23ai SYSTEM, SYSAUX, USERS Big tablespace 사용하지 않기
23ai 는 Default Type 이 Big File 이라 초기생성시부터 Small file 로 생성가능한지 테스트 진행..
현재 상태는 아래와 같다.
SQL> select TABLESPACE_NAME, BIGFILE from DBA_TABLESPACES;
TABLESPACE_NAME BIG
------------------------------ ---
SYSTEM YES
SYSAUX YES
UNDOTBS1 NO
TEMP NO
USERS YES
SQL> alter session set container=PDB1;
Session altered.
SQL> select TABLESPACE_NAME, BIGFILE from DBA_TABLESPACES;
TABLESPACE_NAME BIG
------------------------------ ---
SYSTEM YES
SYSAUX YES
UNDOTBS1 NO
TEMP NO
USERS YES
CDB/PDB 모두 Big File 이다.
1. 우선 기본 Template 에서 아래 부분을 Big file 로 지정된 부분을 모두 false 로 변경
vi /u01/app/oracle/product/23.0.0.0/dbhome_1/assistants/dbca/template/New_Database.dbt
<DatabaseTemplate name="New Database" description="" version="23.0.0.0.0">
<CommonAttributes>
<option name="OMS" value="false" includeInPDBs="false"/>
<option name="JSERVER" value="true" includeInPDBs="true"/>
<option name="SPATIAL" value="true" includeInPDBs="true"/>
<option name="ORACLE_TEXT" value="true" includeInPDBs="true">
<tablespace id="SYSAUX"/>
</option>
<option name="CWMLITE" value="true" includeInPDBs="true">
<tablespace id="SYSAUX"/>
</option>
<option name="SAMPLE_SCHEMA" value="false" includeInPDBs="false"/>
<option name="DV" value="false" includeInPDBs="false"/>
</CommonAttributes>
<Variables/>
<CustomScripts Execute="false"/>
<InitParamAttributes>
<InitParams>
<initParam name="db_block_size" value="8" unit="KB"/>
<initParam name="open_cursors" value="300"/>
<initParam name="undo_tablespace" value="UNDOTBS1"/>
<initParam name="control_files" value="("{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl", "{ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME}/control02.ctl")"/>
<initParam name="compatible" value="23.6.0"/>
<initParam name="diagnostic_dest" value="{ORACLE_BASE}"/>
<initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>
<initParam name="dispatchers" value="(PROTOCOL=TCP) (SERVICE={SID}XDB)"/>
</InitParams>
<MiscParams>
<databaseType>MULTIPURPOSE</databaseType>
<maxUserConn>20</maxUserConn>
<percentageMemTOSGA>40</percentageMemTOSGA>
<archiveLogMode>false</archiveLogMode>
<initParamFileName>{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/pfile/init.ora</initParamFileName>
</MiscParams>
<SPfile useSPFile="true">{ORACLE_HOME}/dbs/spfile{SID}.ora</SPfile>
</InitParamAttributes>
<StorageAttributes>
<ControlfileAttributes id="Controlfile">
<maxDatafiles>100</maxDatafiles>
<maxLogfiles>16</maxLogfiles>
<maxLogMembers>3</maxLogMembers>
<maxLogHistory>1</maxLogHistory>
<maxInstances>8</maxInstances>
<image name="control01.ctl" filepath="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/"/>
<image name="control02.ctl" filepath="{ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME}/"/>
</ControlfileAttributes>
<DatafileAttributes id="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/sysaux01.dbf">
<tablespace>SYSAUX</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">550</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">10240</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/users01.dbf">
<tablespace>USERS</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">7</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">1280</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/system01.dbf">
<tablespace>SYSTEM</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">700</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">10240</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/temp01.dbf">
<tablespace>TEMP</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">20</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">640</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/undotbs01.dbf">
<tablespace>UNDOTBS1</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">200</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">5120</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<TablespaceAttributes id="SYSAUX">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>false</temporary>
<defaultTemp>false</defaultTemp>
<undo>false</undo>
<local>true</local>
<blockSize>-1</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">64</initSize>
<increment unit="KB">64</increment>
<incrementPercent>50</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>4096</maxExtends>
<minExtendsSize unit="KB">64</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/sysaux01.dbf"/>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="USERS">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>false</temporary>
<defaultTemp>false</defaultTemp>
<undo>false</undo>
<local>true</local>
<blockSize>-1</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">128</initSize>
<increment unit="KB">128</increment>
<incrementPercent>0</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>4096</maxExtends>
<minExtendsSize unit="KB">128</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/users01.dbf"/>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="SYSTEM">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>false</temporary>
<defaultTemp>false</defaultTemp>
<undo>false</undo>
<local>true</local>
<blockSize>-1</blockSize>
<allocation>3</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">64</initSize>
<increment unit="KB">64</increment>
<incrementPercent>50</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>-1</maxExtends>
<minExtendsSize unit="KB">64</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/system01.dbf"/>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="TEMP">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>true</temporary>
<defaultTemp>true</defaultTemp>
<undo>false</undo>
<local>true</local>
<blockSize>-1</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">64</initSize>
<increment unit="KB">64</increment>
<incrementPercent>0</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>0</maxExtends>
<minExtendsSize unit="KB">64</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/temp01.dbf"/>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="UNDOTBS1">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>false</temporary>
<defaultTemp>false</defaultTemp>
<undo>true</undo>
<local>true</local>
<blockSize>-1</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">512</initSize>
<increment unit="KB">512</increment>
<incrementPercent>50</incrementPercent>
<minExtends>8</minExtends>
<maxExtends>4096</maxExtends>
<minExtendsSize unit="KB">512</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/undotbs01.dbf"/>
</datafilesList>
</TablespaceAttributes>
<RedoLogGroupAttributes id="1">
<reuse>false</reuse>
<fileSize unit="KB">204800</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo01.log" filepath="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="2">
<reuse>false</reuse>
<fileSize unit="KB">204800</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo02.log" filepath="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="3">
<reuse>false</reuse>
<fileSize unit="KB">204800</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo03.log" filepath="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/"/>
</RedoLogGroupAttributes>
</StorageAttributes>
</DatabaseTemplate>
2. 스크립트를 실행해서 /u01/app/oracle/admin/TESTC/scripts/TESTC.sh
Database 를 생성
3. Database 생성시 많이 오래 걸림....1시간 30분 정도
4. 완료가 되면 확인을 해 보자.
[TESTC]oracle@23ai:/home/oracle# ss
SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Nov 8 12:07:09 2024
Version 23.6.0.24.10
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connected to:
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10
SQL> select TABLESPACE_NAME, BIGFILE from DBA_TABLESPACES;
TABLESPACE_NAME BIG
------------------------------ ---
SYSTEM NO
SYSAUX NO
UNDOTBS1 NO
TEMP NO
USERS NO
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
TESTC
SQL> alter session set container=TESTP;
Session altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 TESTP READ WRITE NO
SQL> select TABLESPACE_NAME, BIGFILE from DBA_TABLESPACES;
TABLESPACE_NAME BIG
------------------------------ ---
SYSTEM NO
SYSAUX NO
UNDOTBS1 NO
TEMP NO
USERS NO
SQL> set lines 200 pages 1000
SQL> col property_name for a20
SQL> col property_value for a20
SQL> col description for a50
SQL> select * from database_properties where property_name = 'DEFAULT_TBS_TYPE';
PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
-------------------- -------------------- --------------------------------------------------
DEFAULT_TBS_TYPE SMALLFILE Default tablespace type
SQL> alter session set container=TESTP;
Session altered.
SQL> set lines 200 pages 1000
SQL> col property_name for a20
SQL> col property_value for a20
SQL> col description for a50
SQL> select * from database_properties where property_name = 'DEFAULT_TBS_TYPE';
PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
-------------------- -------------------- --------------------------------------------------
DEFAULT_TBS_TYPE SMALLFILE Default tablespace type
CDB/PDB 모두 Small File 로 생성되었다.
- 끝 -
2024. 11. 4. 13:51 오라클
23ai RU 10월패치 23.6.0.24.10(37037086) 적용 테스트
23ai RU 10월패치 23.6.0.24.10(37037086) 적용 테스트
- OPatch Version 은 가장 최신인 12.2.0.1.44 필요
- 중간에 로그를 살펴보면 여유공간으로 /u01 엔진영역에 12G 정도가 더 필요하다.
- 소요시간은 5분 25초 소요
[Nov 4, 2024 1:17:16 PM] [INFO] Heap in use : 6 MB
Total memory: 184 MB
Free memory : 177 MB
Max memory : 3072 MB
[Nov 4, 2024 1:17:16 PM] [INFO] Oracle Home : /u01/app/oracle/product/23.0.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/23.0.0.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.44
OUI version : 12.2.0.9.0
OUI location : /u01/app/oracle/product/23.0.0.0/dbhome_1/oui
Log file location : /u01/app/oracle/product/23.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2024-11-04_13-17-15PM_1.log
[Nov 4, 2024 1:17:16 PM] [INFO] Patch history file: /u01/app/oracle/product/23.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
[Nov 4, 2024 1:17:18 PM] [INFO] [OPSR-TIME] Loading raw inventory
[Nov 4, 2024 1:17:18 PM] [INFO] [OPSR-MEMORY] Loaded all components from inventory. Heap memory in use: 16 (MB)
[Nov 4, 2024 1:17:18 PM] [INFO] [OPSR-MEMORY] Loaded all one offs from inventory. Heap memory in use: 16 (MB)
[Nov 4, 2024 1:17:18 PM] [INFO] [OPSR-TIME] Raw inventory loaded successfully
[Nov 4, 2024 1:17:18 PM] [INFO] NApply::no CAS enabled, OPatch runs with legacy process.
[Nov 4, 2024 1:17:18 PM] [INFO] Verifying environment and performing prerequisite checks...
[Nov 4, 2024 1:17:18 PM] [INFO] [OPSR-TIME] Running prerequisite checks
[Nov 4, 2024 1:17:18 PM] [INFO] opatch-external.jar is in /u01/app/oracle/product/23.0.0.0/dbhome_1/OPatch/jlib/opatch-external.jar
[Nov 4, 2024 1:17:21 PM] [INFO] OPatch invoked in CLI. Run Init Prereqs
[Nov 4, 2024 1:17:22 PM] [INFO] Running Initial prerequisite checks...
[Nov 4, 2024 1:17:24 PM] [INFO] Checking if Oracle Home has components required by patches...
[Nov 4, 2024 1:17:25 PM] [INFO] CheckMissingComps: Cached file does not exist or is invalid, re-build prereq result.
[Nov 4, 2024 1:17:25 PM] [INFO] [OPSR-TIME] Loading cooked inventory
[Nov 4, 2024 1:17:25 PM] [INFO] [OPSR-MEMORY] : Loading cooked one offs. Heap memory used 221 (MB)
[Nov 4, 2024 1:17:25 PM] [INFO] [OPSR-MEMORY] : Loaded cooked oneoffs. Heap memory used : 221 (MB)
[Nov 4, 2024 1:17:25 PM] [INFO] [OPSR-TIME] Cooked inventory loaded successfully
[Nov 4, 2024 1:17:25 PM] [INFO] Checking conflict among patches...
[Nov 4, 2024 1:17:25 PM] [INFO] Running prereq checkConflictAmongPatchesWithDetail
[Nov 4, 2024 1:17:25 PM] [INFO] Following patches can be applied: 37037086
[Nov 4, 2024 1:17:25 PM] [INFO] Following patches are not required:
[Nov 4, 2024 1:17:25 PM] [INFO] Following patches are auto rollbackable:
[Nov 4, 2024 1:17:25 PM] [INFO] Finished checking prereq checkConflictAmongPatchesWithDetail
[Nov 4, 2024 1:17:25 PM] [INFO] Conflict checking amongst patches PASSED
[Nov 4, 2024 1:17:25 PM] [INFO] Checking conflicts against Oracle Home...
[Nov 4, 2024 1:17:25 PM] [INFO] Running prereq checkConflictAgainstOHWithDetail
[Nov 4, 2024 1:17:26 PM] [INFO] Following patches can be applied: 37037086
[Nov 4, 2024 1:17:26 PM] [INFO] Following patches are not required:
[Nov 4, 2024 1:17:26 PM] [INFO] Following patches are auto rollbackable:
[Nov 4, 2024 1:17:26 PM] [INFO] Finished checking prereq checkConflictAgainstOHWithDetail
[Nov 4, 2024 1:17:28 PM] [INFO] Running prerequisite checks...
[Nov 4, 2024 1:17:28 PM] [INFO] Space Needed : 11630.222MB
[Nov 4, 2024 1:17:28 PM] [INFO] Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 37037086
[Nov 4, 2024 1:17:28 PM] [INFO] OPatch/jre does not exist. Adding /u01/app/oracle/product/23.0.0.0/dbhome_1/jdk/bin/java to oop dependency list
- 패치 적용
[CDB1]oracle@23ai:/oradata/install# opatch apply ./37037086/
Oracle Interim Patch Installer version 12.2.0.1.44
Copyright (c) 2024, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/23.0.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/23.0.0.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.44
OUI version : 12.2.0.9.0
Log file location : /u01/app/oracle/product/23.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2024-11-04_13-17-15PM_1.log
Verifying environment and performing prerequisite checks...
--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...
Oracle Interim Patch Installer version 12.2.0.1.44
Copyright (c) 2024, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/23.0.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/23.0.0.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.44
OUI version : 12.2.0.9.0
Log file location : /u01/app/oracle/product/23.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2024-11-04_13-17-31PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 37037086
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/23.0.0.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '37037086' to OH '/u01/app/oracle/product/23.0.0.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.client, 23.0.0.0.0 ] , [ oracle.companionCD.db, 23.0.0.0.0 ] , [ oracle.dbjava.dev, 23.0.0.0.0 ] , [ oracle.dslm, 23.0.0.0.0 ] , [ oracle.has.client.cvu, 23.0.0.0.0 ] , [ oracle.ldap.companion, 23.0.0.0.0 ] , [ oracle.mgw.common.companion, 23.0.0.0.0 ] , [ oracle.network.cman, 23.0.0.0.0 ] , [ oracle.network.gsm, 23.0.0.0.0 ] , [ oracle.nlsrtl.companion, 23.0.0.0.0 ] , [ oracle.odbc.companion, 23.0.0.0.0 ] , [ oracle.oraolap.mgmt, 23.0.0.0.0 ] , [ oracle.pg4appc, 23.0.0.0.0 ] , [ oracle.pg4mq, 23.0.0.0.0 ] , [ oracle.precomp.companion, 23.0.0.0.0 ] , [ oracle.rdbms.companion, 23.0.0.0.0 ] , [ oracle.rdbms.ic, 23.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 23.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 23.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 23.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 23.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 23.0.0.0.0 ] , [ oracle.sdo.companion, 23.0.0.0.0 ] , [ oracle.sqlj, 23.0.0.0.0 ] , [ oracle.sqlj.companion, 23.0.0.0.0 ] , [ oracle.sqlplus.companion, 23.0.0.0.0 ] , [ oracle.tg, 23.0.0.0.0 ] , [ oracle.xdk.companion, 23.0.0.0.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.assistants.acf, 23.0.0.0.0...
Patching component oracle.assistants.deconfig, 23.0.0.0.0...
Patching component oracle.assistants.netca.client, 23.0.0.0.0...
Patching component oracle.assistants.server, 23.0.0.0.0...
Patching component oracle.bali.ewt, 12.2.1.0.0...
Patching component oracle.bali.ice, 6.1.3.2.0...
Patching component oracle.bali.jewt, 11.1.1.1.0...
Patching component oracle.bali.share, 12.2.1.0.0...
Patching component oracle.blaslapack, 23.0.0.0.0...
Patching component oracle.buildtools.common, 23.0.0.0.0...
Patching component oracle.buildtools.rsf, 23.0.0.0.0...
Patching component oracle.crypto.fips, 23.0.0.0.0...
Patching component oracle.crypto.ojmisc, 23.0.0.0.0...
Patching component oracle.crypto.pki, 23.0.0.0.0...
Patching component oracle.crypto.rsa, 23.0.0.0.0...
Patching component oracle.crypto.rsf, 23.0.0.0.0...
Patching component oracle.ctx, 23.0.0.0.0...
Patching component oracle.ctx.atg, 23.0.0.0.0...
Patching component oracle.ctx.companion, 23.0.0.0.0...
Patching component oracle.ctx.rsf, 23.0.0.0.0...
Patching component oracle.dbdev, 23.0.0.0.0...
Patching component oracle.dbjava.ic, 23.0.0.0.0...
Patching component oracle.dbjava.jdbc, 23.0.0.0.0...
Patching component oracle.dbjava.server, 23.0.0.0.0...
Patching component oracle.dbjava.ucp, 23.0.0.0.0...
Patching component oracle.dbtoolslistener, 23.0.0.0.0...
Patching component oracle.hadoopcore, 23.0.0.0.0...
Patching component oracle.has.common, 23.0.0.0.0...
Patching component oracle.has.common.cvu, 23.0.0.0.0...
Patching component oracle.has.db, 23.0.0.0.0...
Patching component oracle.has.db.cvu, 23.0.0.0.0...
Patching component oracle.has.rsf, 23.0.0.0.0...
Patching component oracle.help.ohj, 11.1.2.0.0...
Patching component oracle.help.share, 11.1.2.0.0...
Patching component oracle.install.deinstalltool, 23.0.0.0.0...
Patching component oracle.javavm.client, 23.0.0.0.0...
Patching component oracle.javavm.companion, 23.0.0.0.0...
Patching component oracle.javavm.server, 23.0.0.0.0...
Patching component oracle.javavhttp://m.server.core, 23.0.0.0.0...
Patching component oracle.jdk, 11.0.24.7.0...
Patching component oracle.ldap.admin, 23.0.0.0.0...
Patching component oracle.ldap.client, 23.0.0.0.0...
Patching component oracle.ldap.rsf, 23.0.0.0.0...
Patching component oracle.mgw.common, 23.0.0.0.0...
Patching component oracle.network, 23.0.0.0.0...
Patching component oracle.network.aso, 23.0.0.0.0...
Patching component oracle.network.client, 23.0.0.0.0...
Patching component oracle.network.listener, 23.0.0.0.0...
Patching component oracle.network.netmgr, 23.0.0.0.0...
Patching component oracle.network.rsf, 23.0.0.0.0...
Patching component oracle.nlsrtl.rsf, 23.0.0.0.0...
Patching component oracle.nlsrtl.rsf.core, 23.0.0.0.0...
Patching component oracle.nlsrtl.rsf.ic, 23.0.0.0.0...
Patching component oracle.nlsrtl.rsf.lbuilder, 23.0.0.0.0...
Patching component oracle.odbc, 23.0.0.0.0...
Patching component oracle.odbc.ic, 23.0.0.0.0...
Patching component oracle.onnx, 23.0.0.0.0...
Patching component oracle.ons, 23.0.0.0.0...
Patching component oracle.ons.core, 23.0.0.0.0...
Patching component oracle.ons.ic, 23.0.0.0.0...
Patching component oracle.options, 23.0.0.0.0...
Patching component oracle.oracler.server, 23.0.0.0.0...
Patching component oracle.oracore.rsf, 23.0.0.0.0...
Patching component oracle.oracore.rsf.core, 23.0.0.0.0...
Patching component oracle.oraml.server, 23.0.0.0.0...
Patching component oracle.oraolap, 23.0.0.0.0...
Patching component oracle.oraolap.api, 23.0.0.0.0...
Patching component oracle.oraolap.dbscripts, 23.0.0.0.0...
Patching component oracle.ordim.client, 23.0.0.0.0...
Patching component oracle.ordim.server, 23.0.0.0.0...
Patching component oracle.ovm, 23.0.0.0.0...
Patching component oracle.perlint, 5.38.2.0.0...
Patching component oracle.precomp.common, 23.0.0.0.0...
Patching component oracle.precomp.common.core, 23.0.0.0.0...
Patching component oracle.precomp.lang, 23.0.0.0.0...
Patching component oracle.precomp.rsf, 23.0.0.0.0...
Patching component oracle.python, 3.12.3.0.0...
Patching component oracle.rdbms, 23.0.0.0.0...
Patching component oracle.rdbms.crs, 23.0.0.0.0...
Patching component oracle.rdbms.db, 23.0.0.0.0...
Patching component oracle.rdbms.dbcur, 23.0.0.0.0...
Patching component oracle.rdbms.dbscripts, 23.0.0.0.0...
Patching component oracle.rdbms.deconfig, 23.0.0.0.0...
Patching component oracle.rdbms.dm, 23.0.0.0.0...
Patching component oracle.rdbms.dv, 23.0.0.0.0...
Patching component oracle.rdbms.hs_common, 23.0.0.0.0...
Patching component oracle.rdbms.hsodbc, 23.0.0.0.0...
Patching component oracle.rdbms.install.common, 23.0.0.0.0...
Patching component oracle.rdbms.install.plugins, 23.0.0.0.0...
Patching component oracle.rdbms.install.seeddb, 23.0.0.0.0...
Patching component oracle.rdbms.lbac, 23.0.0.0.0...
Patching component oracle.rdbms.locator, 23.0.0.0.0...
Patching component oracle.rdbms.oci, 23.0.0.0.0...
Patching component oracle.rdbms.olap, 23.0.0.0.0...
Patching component oracle.rdbms.plsql, 23.0.0.0.0...
Patching component oracle.rdbms.rat, 23.0.0.0.0...
Patching component oracle.rdbms.rman, 23.0.0.0.0...
Patching component oracle.rdbms.rsf, 23.0.0.0.0...
Patching component oracle.rdbms.rsf.ic, 23.0.0.0.0...
Patching component oracle.rdbms.scheduler, 23.0.0.0.0...
Patching component oracle.rdbms.util, 23.0.0.0.0...
Patching component oracle.rhp.common, 23.0.0.0.0...
Patching component oracle.rhp.db, 23.0.0.0.0...
Patching component oracle.rsf, 23.0.0.0.0...
Patching component oracle.sdo, 23.0.0.0.0...
Patching component oracle.sdo.locator, 23.0.0.0.0...
Patching component oracle.sdo.locator.jrf, 23.0.0.0.0...
Patching component oracle.server, 23.0.0.0.0...
Patching component oracle.slax.rsf, 23.0.0.0.0...
Patching component oracle.sqlj.sqljruntime, 23.0.0.0.0...
Patching component oracle.sqlplus, 23.0.0.0.0...
Patching component oracle.sqlplus.ic, 23.0.0.0.0...
Patching component oracle.sqlplus.rsf, 23.0.0.0.0...
Patching component oracle.tfa.db, 23.0.0.0.0...
Patching component oracle.usm.deconfig, 23.0.0.0.0...
Patching component oracle.wwg.plsql, 23.0.0.0.0...
Patching component oracle.xdk, 23.0.0.0.0...
Patching component oracle.xdk.parser.java, 23.0.0.0.0...
Patching component oracle.xdk.rsf, 23.0.0.0.0...
Patching component oracle.xdk.server, 23.0.0.0.0...
Patching component oracle.xdk.xquery, 23.0.0.0.0...
Patch 37037086 successfully applied.
Log file location: /u01/app/oracle/product/23.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2024-11-04_13-17-31PM_1.log
OPatch succeeded.
[CDB1]oracle@23ai:/home/oracle# opatch lspatches
37037086;Database Release Update : 23.6.0.24.10 (37037086)
OPatch succeeded.
- datapatch 적용
[CDB1]oracle@23ai:/u01/app/oracle/product/23.0.0.0/dbhome_1/OPatch# ./datapatch -verbose
SQL Patching tool version 23.6.0.24.10 Lim on Mon Nov 4 13:36:47 2024
Copyright (c) 2012, 2024, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/product/23.0.0.0/dbhome_1/cfgtoollogs/sqlpatch/sqlpatch_sid_CDB1_ts_2024_11_04_13_36_47_pid_10845/sqlpatch_invocation.log
Connecting to database...OK
Gathering database info...done
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of interim SQL patches:
No interim patches found
Current state of release update SQL patches:
Binary registry:
23.6.0.24.10 Release_Update 241010183751: Installed
PDB CDB$ROOT:
Applied 23.5.0.24.07 Release_Update 241010183751 successfully on
PDB PDB$SEED:
Applied 23.5.0.24.07 Release_Update 241010183751 successfully on
PDB PDB1:
Applied 23.5.0.24.07 Release_Update 241010183751 successfully on
Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED PDB1
No interim patches need to be rolled back
Patch 37037086 (Database Release Update : 23.6.0.24.10 (37037086)):
Apply from 23.5.0.24.07 Release_Update 241010183751 to 23.6.0.24.10 Release_Update 241010183751
No interim patches need to be applied
Installing patches...
Patch installation complete. Total patches installed: 3
Validating logfiles...done
Patch 37037086 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/product/23.0.0.0/dbhome_1/cfgtoollogs/sqlpatch/sqlpatch_sid_CDB1_ts_2024_11_04_13_36_47_pid_10845/37037086_apply_CDB1_CDBROOT_2024Nov04_13_37_02.log (no errors)
Patch 37037086 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/product/23.0.0.0/dbhome_1/cfgtoollogs/sqlpatch/sqlpatch_sid_CDB1_ts_2024_11_04_13_36_47_pid_10845/37037086_apply_CDB1_PDBSEED_2024Nov04_13_39_36.log (no errors)
Patch 37037086 apply (pdb PDB1): SUCCESS
logfile: /u01/app/oracle/product/23.0.0.0/dbhome_1/cfgtoollogs/sqlpatch/sqlpatch_sid_CDB1_ts_2024_11_04_13_36_47_pid_10845/37037086_apply_CDB1_PDB1_2024Nov04_13_39_36.log (no errors)
SQL Patching tool complete on Mon Nov 4 13:42:36 2024
- DBA_REGISTRY_SQLPATCH 적용 확인
SQL>
SET LINESIZE 400
COLUMN ACTION_TIME FORMAT A20
COLUMN ACTION FORMAT A10
COLUMN STATUS FORMAT A10
COLUMN DESCRIPTION FORMAT A40
COLUMN VERSION FORMAT A10
COLUMN BUNDLE_SERIES FORMAT A10
SELECT TO_CHAR(ACTION_TIME, 'YYYYMMDD HH24:MI:SS') AS ACTION_TIME
,ACTION
,STATUS
,DESCRIPTION
,PATCH_ID
FROM DBA_REGISTRY_SQLPATCH
ORDER BY ACTION_TIME;
ACTION_TIME ACTION STATUS DESCRIPTION PATCH_ID
-------------------- ---------- ---------- ---------------------------------------- ----------
20241104 13:38:42 APPLY END Database Release Update : 23.6.0.24.10 ( 37037086
37037086)
