반응형
■ [2025-06-10] Oracle 12cR2 Restart Single JVM 패치 (12cR2)

 

[2025-06-10] Oracle 12cR2 Restart Single JVM 패치 (12cR2)


[실습 환경]

OS : Oracle Linux Server 7.9 (Linux rdb01d 5.4.17-2102.201.3.el7uek.x86_64)
DB : Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SINGLE : rdb01d(192.168.0.41) : PTDB
db_unique_name : PTDB

 

--grid os user

[+ASM:grid@tdb01p][/home/grid]$ opatch lsinventory -detail | grep -i jvm

Oracle JVM                                                           12.2.0.1.0
Oracle JVM For Core                                                  12.2.0.1.0
     /kubscjvm.o --> ORACLE_HOME/lib/libclient12.a
     jvmti.h --> ORACLE_HOME/jdk/include/jvmti.h
     jvmticmlr.h --> ORACLE_HOME/jdk/include/jvmticmlr.h
     jvm.cfg --> ORACLE_HOME/jdk/jre/lib/amd64/jvm.cfg
     libjvm.so --> ORACLE_HOME/jdk/jre/lib/amd64/server/libjvm.so
     jvm.hprof.txt --> ORACLE_HOME/jdk/jre/lib/jvm.hprof.txt
     com-sun-tools-visualvm-jvm_zh_CN.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/locale/com-sun-tools-visualvm-jvm_zh_CN.jar
     com-sun-tools-visualvm-jvmstat_ja.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/locale/com-sun-tools-visualvm-jvmstat_ja.jar
     com-sun-tools-visualvm-jvm_ja.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/locale/com-sun-tools-visualvm-jvm_ja.jar
     com-sun-tools-visualvm-jvmstat_zh_CN.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/locale/com-sun-tools-visualvm-jvmstat_zh_CN.jar
     com-sun-tools-visualvm-jvm.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/com-sun-tools-visualvm-jvm.jar
     com-sun-tools-visualvm-jvmstat.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/com-sun-tools-visualvm-jvmstat.jar
     com-sun-tools-visualvm-jvmstat.xml --> ORACLE_HOME/jdk/lib/visualvm/visualvm/config/Modules/com-sun-tools-visualvm-jvmstat.xml
     com-sun-tools-visualvm-jvm.xml --> ORACLE_HOME/jdk/lib/visualvm/visualvm/config/Modules/com-sun-tools-visualvm-jvm.xml
     com-sun-tools-visualvm-jvmstat.xml --> ORACLE_HOME/jdk/lib/visualvm/visualvm/update_tracking/com-sun-tools-visualvm-jvmstat.xml
     com-sun-tools-visualvm-jvm.xml --> ORACLE_HOME/jdk/lib/visualvm/visualvm/update_tracking/com-sun-tools-visualvm-jvm.xml
     jvm.hprof.txt --> ORACLE_HOME/jdk/jre/lib/jvm.hprof.txt
     jvm.cfg --> ORACLE_HOME/jdk/jre/lib/amd64/jvm.cfg
     libjvm.so --> ORACLE_HOME/jdk/jre/lib/amd64/server/libjvm.so
     jvmticmlr.h --> ORACLE_HOME/jdk/include/jvmticmlr.h
     jvmti.h --> ORACLE_HOME/jdk/include/jvmti.h
     com-sun-tools-visualvm-jvmstat.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/com-sun-tools-visualvm-jvmstat.jar
     com-sun-tools-visualvm-jvm.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/com-sun-tools-visualvm-jvm.jar
     com-sun-tools-visualvm-jvm_ja.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/locale/com-sun-tools-visualvm-jvm_ja.jar
     com-sun-tools-visualvm-jvm_zh_CN.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/locale/com-sun-tools-visualvm-jvm_zh_CN.jar
     com-sun-tools-visualvm-jvmstat_zh_CN.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/locale/com-sun-tools-visualvm-jvmstat_zh_CN.jar
     com-sun-tools-visualvm-jvmstat_ja.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/locale/com-sun-tools-visualvm-jvmstat_ja.jar
     com-sun-tools-visualvm-jvmstat.xml --> ORACLE_HOME/jdk/lib/visualvm/visualvm/config/Modules/com-sun-tools-visualvm-jvmstat.xml
     com-sun-tools-visualvm-jvm.xml --> ORACLE_HOME/jdk/lib/visualvm/visualvm/config/Modules/com-sun-tools-visualvm-jvm.xml
     com-sun-tools-visualvm-jvm.xml --> ORACLE_HOME/jdk/lib/visualvm/visualvm/update_tracking/com-sun-tools-visualvm-jvm.xml
     com-sun-tools-visualvm-jvmstat.xml --> ORACLE_HOME/jdk/lib/visualvm/visualvm/update_tracking/com-sun-tools-visualvm-jvmstat.xml

 

--oracle os user
[PTDB:oracle@tdb01p][/home/oracle]$ opatch lsinventory -detail | grep -i jvm
Oracle JVM                                                           12.2.0.1.0
Oracle JVM For Core                                                  12.2.0.1.0
XML Parser for Oracle JVM                                            12.2.0.1.0
     /kubscjvm.o --> ORACLE_HOME/lib/libclient12.a
     jvmti.h --> ORACLE_HOME/jdk/include/jvmti.h
     jvmticmlr.h --> ORACLE_HOME/jdk/include/jvmticmlr.h
     libjvm.so --> ORACLE_HOME/jdk/jre/lib/amd64/server/libjvm.so
     jvm.cfg --> ORACLE_HOME/jdk/jre/lib/amd64/jvm.cfg
     jvm.hprof.txt --> ORACLE_HOME/jdk/jre/lib/jvm.hprof.txt
     com-sun-tools-visualvm-jvmstat.xml --> ORACLE_HOME/jdk/lib/visualvm/visualvm/config/Modules/com-sun-tools-visualvm-jvmstat.xml
     com-sun-tools-visualvm-jvm.xml --> ORACLE_HOME/jdk/lib/visualvm/visualvm/config/Modules/com-sun-tools-visualvm-jvm.xml
     com-sun-tools-visualvm-jvm_ja.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/locale/com-sun-tools-visualvm-jvm_ja.jar
     com-sun-tools-visualvm-jvmstat_zh_CN.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/locale/com-sun-tools-visualvm-jvmstat_zh_CN.jar
     com-sun-tools-visualvm-jvmstat_ja.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/locale/com-sun-tools-visualvm-jvmstat_ja.jar
     com-sun-tools-visualvm-jvm_zh_CN.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/locale/com-sun-tools-visualvm-jvm_zh_CN.jar
     com-sun-tools-visualvm-jvm.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/com-sun-tools-visualvm-jvm.jar
     com-sun-tools-visualvm-jvmstat.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/com-sun-tools-visualvm-jvmstat.jar
     com-sun-tools-visualvm-jvm.xml --> ORACLE_HOME/jdk/lib/visualvm/visualvm/update_tracking/com-sun-tools-visualvm-jvm.xml
     com-sun-tools-visualvm-jvmstat.xml --> ORACLE_HOME/jdk/lib/visualvm/visualvm/update_tracking/com-sun-tools-visualvm-jvmstat.xml
     jvm.hprof.txt --> ORACLE_HOME/jdk/jre/lib/jvm.hprof.txt
     jvm.cfg --> ORACLE_HOME/jdk/jre/lib/amd64/jvm.cfg
     libjvm.so --> ORACLE_HOME/jdk/jre/lib/amd64/server/libjvm.so
     jvmticmlr.h --> ORACLE_HOME/jdk/include/jvmticmlr.h
     jvmti.h --> ORACLE_HOME/jdk/include/jvmti.h
     com-sun-tools-visualvm-jvmstat.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/com-sun-tools-visualvm-jvmstat.jar
     com-sun-tools-visualvm-jvm.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/com-sun-tools-visualvm-jvm.jar
     com-sun-tools-visualvm-jvm_ja.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/locale/com-sun-tools-visualvm-jvm_ja.jar
     com-sun-tools-visualvm-jvm_zh_CN.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/locale/com-sun-tools-visualvm-jvm_zh_CN.jar
     com-sun-tools-visualvm-jvmstat_zh_CN.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/locale/com-sun-tools-visualvm-jvmstat_zh_CN.jar
     com-sun-tools-visualvm-jvmstat_ja.jar --> ORACLE_HOME/jdk/lib/visualvm/visualvm/modules/locale/com-sun-tools-visualvm-jvmstat_ja.jar
     com-sun-tools-visualvm-jvmstat.xml --> ORACLE_HOME/jdk/lib/visualvm/visualvm/config/Modules/com-sun-tools-visualvm-jvmstat.xml
     com-sun-tools-visualvm-jvm.xml --> ORACLE_HOME/jdk/lib/visualvm/visualvm/config/Modules/com-sun-tools-visualvm-jvm.xml
     com-sun-tools-visualvm-jvm.xml --> ORACLE_HOME/jdk/lib/visualvm/visualvm/update_tracking/com-sun-tools-visualvm-jvm.xml
     com-sun-tools-visualvm-jvmstat.xml --> ORACLE_HOME/jdk/lib/visualvm/visualvm/update_tracking/com-sun-tools-visualvm-jvmstat.xml


[2025-06-10:18:21:46][tdb01p]<SYS@PTDB>

col comp_name for a30
col version for a15
col status for a10
SELECT comp_name, version, status
FROM dba_registry
WHERE comp_id = 'JAVAVM';

COMP_NAME                      VERSION         STATUS
------------------------------ --------------- ----------
JServer JAVA Virtual Machine   12.2.0.1.0      VALID


COLUMN object_name FORMAT A30
SELECT owner
     , object_type
     , object_name
     , status
  FROM dba_objects
 WHERE status = 'INVALID'
 ORDER BY owner, object_type, object_name
 ;

no rows selected

Elapsed: 00:00:00.04

 

--jvm 패치 다운로드

Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (Doc ID 2118136.2)
Patch 33561275: OJVM RELEASE UPDATE 12.2.0.1.220118
p33561275_122010_Linux-x86-64.zip

--> 해당 파일을 다운로드 후 /tmp 위치로 업로드


--You must use the OPatch utility version 12.2.0.1.28 or later to apply this patch.
--Oracle recommends that you use the latest released OPatch version for 12.2, which is available for download from My Oracle Support patch 6880880 by selecting the 12.2.0.1.0 release.

--> opatch는 현재 최신 버전임

 

[PTDB:oracle@tdb01p][/home/oracle]$ opatch version
OPatch Version: 12.2.0.1.42

OPatch succeeded.

 

[PTDB:oracle@tdb01p][/home/oracle]$ ls -l /tmp/p33561275_122010_Linux-x86-64.zip
-rw-r--r--. 1 oracle oinstall 138022236 Jun 10 18:25 /tmp/p33561275_122010_Linux-x86-64.zip

 

[PTDB:oracle@tdb01p][/home/oracle]$ cd /tmp
[PTDB:oracle@tdb01p][/tmp]$ unzip /tmp/p33561275_122010_Linux-x86-64.zip
Archive:  /tmp/p33561275_122010_Linux-x86-64.zip
   creating: 33561275/
   creating: 33561275/etc/
   creating: 33561275/etc/config/
  inflating: 33561275/etc/config/inventory.xml
  inflating: 33561275/etc/config/actions.xml
  inflating: 33561275/README.html
 extracting: 33561275/README.txt
   creating: 33561275/files/
   creating: 33561275/files/javavm/
   creating: 33561275/files/javavm/lib/
 extracting: 33561275/files/javavm/lib/aurora.zip
   creating: 33561275/files/javavm/jdk/
   creating: 33561275/files/javavm/jdk/jdk8/
   creating: 33561275/files/javavm/jdk/jdk8/lib/
  inflating: 33561275/files/javavm/jdk/jdk8/lib/jce.jar
  inflating: 33561275/files/javavm/jdk/jdk8/lib/libjavavm12.a
   creating: 33561275/files/javavm/jdk/jdk8/lib/security/
  inflating: 33561275/files/javavm/jdk/jdk8/lib/security/java.security
  inflating: 33561275/files/javavm/jdk/jdk8/lib/security/local_policy.jar
  inflating: 33561275/files/javavm/jdk/jdk8/lib/security/US_export_policy.jar
  inflating: 33561275/files/javavm/jdk/jdk8/lib/security/cacerts
  inflating: 33561275/files/javavm/jdk/jdk8/lib/sunjce_provider.jar
   creating: 33561275/files/javavm/jdk/jdk8/admin/
  inflating: 33561275/files/javavm/jdk/jdk8/admin/classes.bin
  inflating: 33561275/files/javavm/jdk/jdk8/admin/lfclasses.bin
   creating: 33561275/files/javavm/install/
  inflating: 33561275/files/javavm/install/jvmpsui.sql
  inflating: 33561275/files/javavm/install/jvmpsupdii.sql
  inflating: 33561275/files/javavm/install/jvmpsupii.sql
  inflating: 33561275/files/javavm/install/jvmpsu.sql
  inflating: 33561275/files/javavm/install/bug26451793.sql
  inflating: 33561275/files/javavm/install/jvmpsupi.sql
  inflating: 33561275/files/javavm/install/jvmpsupdi.sql
   creating: 33561275/files/jdbc/
   creating: 33561275/files/jdbc/lib/
  inflating: 33561275/files/jdbc/lib/ojdbc8dms.jar
  inflating: 33561275/files/jdbc/lib/ojdbc8.jar
  inflating: 33561275/files/jdbc/lib/ojdbc8_g.jar
  inflating: 33561275/files/jdbc/lib/ojdbc8dms_g.jar
   creating: 33561275/files/rdbms/
   creating: 33561275/files/rdbms/lib/
  inflating: 33561275/files/rdbms/lib/jox.o
   creating: 33561275/files/sqlpatch/
   creating: 33561275/files/sqlpatch/33561275/
   creating: 33561275/files/sqlpatch/33561275/24539585/
  inflating: 33561275/files/sqlpatch/33561275/24539585/33561275.xml
  inflating: 33561275/files/sqlpatch/33561275/24539585/33561275_rollback.sql
  inflating: 33561275/files/sqlpatch/33561275/24539585/33561275_apply.sql
   creating: 33561275/files/sqlpatch/33561275/24539585/rollback_files/
   creating: 33561275/files/sqlpatch/33561275/24539585/rollback_files/javavm/
   creating: 33561275/files/sqlpatch/33561275/24539585/rollback_files/javavm/install/
  inflating: 33561275/files/sqlpatch/33561275/24539585/rollback_files/javavm/install/jvmpsui.sql
  inflating: 33561275/files/sqlpatch/33561275/24539585/rollback_files/javavm/install/jvmpsupdii.sql
  inflating: 33561275/files/sqlpatch/33561275/24539585/rollback_files/javavm/install/jvmpsupii.sql
  inflating: 33561275/files/sqlpatch/33561275/24539585/rollback_files/javavm/install/jvmpsu.sql
  inflating: 33561275/files/sqlpatch/33561275/24539585/rollback_files/javavm/install/jvmpsupi.sql
  inflating: 33561275/files/sqlpatch/33561275/24539585/rollback_files/javavm/install/jvmpsupdi.sql
  inflating: PatchSearch.xml

 

[PTDB:oracle@tdb01p][/tmp]$ cd /tmp/33561275/
[PTDB:oracle@tdb01p][/tmp/33561275]$ ls -l
total 88
drwxr-x---. 3 oracle oinstall    20 Dec 10  2021 etc
drwxr-x---. 6 oracle oinstall    61 Dec 10  2021 files
-rw-rw-r--. 1 oracle oinstall 82407 Mar 15  2022 README.html
-rw-r--r--. 1 oracle oinstall    11 Dec 10  2021 README.txt

 

--root os user
[root@tdb01p][/root]$ crsctl stop has -f
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'tdb01p'
CRS-2673: Attempting to stop 'ora.ptdb.db' on 'tdb01p'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'tdb01p'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'tdb01p' succeeded
CRS-2677: Stop of 'ora.ptdb.db' on 'tdb01p' succeeded
CRS-2673: Attempting to stop 'ora.DATA1.dg' on 'tdb01p'
CRS-2677: Stop of 'ora.DATA1.dg' on 'tdb01p' succeeded
CRS-2673: Attempting to stop 'ora.FRA1.dg' on 'tdb01p'
CRS-2677: Stop of 'ora.FRA1.dg' on 'tdb01p' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'tdb01p'
CRS-2677: Stop of 'ora.asm' on 'tdb01p' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'tdb01p'
CRS-2677: Stop of 'ora.evmd' on 'tdb01p' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'tdb01p'
CRS-2677: Stop of 'ora.cssd' on 'tdb01p' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'tdb01p' has completed
CRS-4133: Oracle High Availability Services has been stopped.

 

--oracle os user

--패치 충돌 확인

[PTDB:oracle@tdb01p][/home/oracle]$ cd /tmp/33561275
[PTDB:oracle@tdb01p][/tmp/33561275]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.42
Copyright (c) 2025, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/12c/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12c/db_1/oraInst.loc
OPatch version    : 12.2.0.1.42
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12c/db_1/cfgtoollogs/opatch/opatch2025-06-10_18-28-16PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

 

--패치 적용

[PTDB:oracle@tdb01p][/tmp/33561275]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.42
Copyright (c) 2025, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12c/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12c/db_1/oraInst.loc
OPatch version    : 12.2.0.1.42
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12c/db_1/cfgtoollogs/opatch/opatch2025-06-10_18-30-06PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   33561275

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/12c/db_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '33561275' to OH '/u01/app/oracle/product/12c/db_1'

Patching component oracle.javavm.server, 12.2.0.1.0...

Patching component oracle.javavm.server.core, 12.2.0.1.0...

Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...

Patching component oracle.javavm.client, 12.2.0.1.0...

Patching component oracle.rdbms, 12.2.0.1.0...

Patching component oracle.dbjava.jdbc, 12.2.0.1.0...

Patching component oracle.dbjava.ic, 12.2.0.1.0...
Patch 33561275 successfully applied.
Log file location: /u01/app/oracle/product/12c/db_1/cfgtoollogs/opatch/opatch2025-06-10_18-30-06PM_1.log

OPatch succeeded.

--root os user

[root@tdb01p][/root]$ crsctl start has

 

[PTDB:oracle@tdb01p][/home/oracle]$ ss

SQL*Plus: Release 12.2.0.1.0 Production on Tue Jun 10 19:01:49 2025

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

[2025-06-10:19:01:49][tdb01p]<SYS@PTDB> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

[2025-06-10:19:01:49][tdb01p]<SYS@PTDB> startup upgrade
ORACLE instance started.

Total System Global Area 5184159744 bytes
Fixed Size                  8631432 bytes
Variable Size            1946159992 bytes
Database Buffers         3221225472 bytes
Redo Buffers                8142848 bytes
Database mounted.
Database opened.


[2025-06-10:19:01:49][tdb01p]<SYS@PTDB> quit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

 

--datapatch 수행

[PTDB:oracle@tdb01p][/home/oracle]$ cd $ORACLE_HOME/OPatch
[PTDB:oracle@tdb01p][/u01/app/oracle/product/12c/db_1/OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.2.0.1.0 Production on Tue Jun 10 19:04:42 2025
Copyright (c) 2012, 2021, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_2952_2025_06_10_19_04_42/sqlpatch_invocation.log

Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of SQL patches:
Patch 33561275 (OJVM RELEASE UPDATE 12.2.0.1.220118):
  Installed in the binary registry only
Bundle series DBRU:
  ID 220118 in the binary registry and ID 220118 in the SQL registry

Adding patches to installation queue and performing prereq checks...
Installation queue:
  Nothing to roll back
  The following patches will be applied:
    33561275 (OJVM RELEASE UPDATE 12.2.0.1.220118)

Installing patches...
Patch installation complete.  Total patches installed: 1

Validating logfiles...
Patch 33561275 apply: SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33561275/24539585/33561275_apply_PTDB_2025Jun10_19_04_51.log (no errors)
SQL Patching tool complete on Tue Jun 10 19:05:53 2025

 

[PTDB:oracle@tdb01p][/u01/app/oracle/product/12c/db_1/OPatch]$ ss

SQL*Plus: Release 12.2.0.1.0 Production on Tue Jun 10 19:10:49 2025

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

[2025-06-10:19:10:49][tdb01p]<SYS@PTDB> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
[2025-06-10:19:10:49][tdb01p]<SYS@PTDB> startup
ORACLE instance started.

Total System Global Area 5184159744 bytes
Fixed Size                  8631432 bytes
Variable Size            1946159992 bytes
Database Buffers         3221225472 bytes
Redo Buffers                8142848 bytes
Database mounted.
Database opened.


col comp_name for a30
col version for a15
col status for a10
SELECT comp_name, version, status
FROM dba_registry
WHERE comp_id = 'JAVAVM';

COMP_NAME                      VERSION         STATUS
------------------------------ --------------- ----------
JServer JAVA Virtual Machine   12.2.0.1.0      VALID


COLUMN object_name FORMAT A30
SELECT owner
     , object_type
     , object_name
     , status
  FROM dba_objects
 WHERE status = 'INVALID'
 ORDER BY owner, object_type, object_name
 ;

no rows selected


col description for a50
col status for a20
select patch_id
     , status
  , description
    , action
  from dba_registry_sqlpatch
;

 

  PATCH_ID STATUS               DESCRIPTION                                        ACTION
---------- -------------------- -------------------------------------------------- ---------------------------------------------
  33587128 SUCCESS              DATABASE JAN 2022 RELEASE UPDATE 12.2.0.1.220118   APPLY
  33561275 SUCCESS              OJVM RELEASE UPDATE 12.2.0.1.220118                APPLY

 

반응형

'Oracle > Patch' 카테고리의 다른 글

[2025-12-26] Oracle Restart 19.28 에서 19.29 골드이미지로 Out-of Place Patching 및 원상 복구 절차  (0) 2025.12.26
[2025-11-23] Oracle 19c 2 Node RAC 환경에서 RU 19.28에서 19.29 골드이미지로 out-of-place Switch Patching 작업 과정  (0) 2025.11.26
[2024-11-17][OL7.9] 19c 2 Node RAC RU Patch 작업 (19.24 -> 19.25)  (0) 2025.10.03
[2025-09-11] Oracle 12cR2 2Node RAC 환경에서 최신의 PSU 패치 적용 및 패치 롤백  (0) 2025.09.12
[2025-07-03] Restart 19c Single Grid 및 Oracle Out-Of-Place Switch Home Patching  (3) 2025.07.03

+ Recent posts

티스토리툴바