Database Sync

COMPATIBLE 파라미터 확인 및 변경

COMPATIBLE은 오라클이 디스크에 데이터를 저장하는 내부 포맷의 버전이고 Binary 벡터 타입은 '23.5.0.0.0'이상, Sparse 벡터 타입은 '23.7.0.0.0' 이상 이어함
주의 : COMPATIBLE 값은 한 번 올리면 절대 못 내림

[oracle@rhel10nm ~]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rhel10nm ~]$ env | grep SID
ORACLE_SID=CDB1
[oracle@rhel10nm ~]$
[oracle@rhel10nm ~]$ sqlplus "/as sysdba"
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         4 PDB2                           READ WRITE NO
SQL>
SQL> show con_id
CON_ID
------------------------------
1
SQL> -- 이 CDB 안에 어떤 컨테이너(PDB)들이 있는지 전체 목록 확인
SQL> COLUMN NAME FORMAT A15 
SQL> SELECT con_id, name, open_mode FROM v$containers ORDER BY con_id;
    CON_ID NAME            OPEN_MODE
---------- --------------- ----------
         1 CDB$ROOT        READ WRITE
         2 PDB$SEED        READ ONLY
         3 PDB1            READ WRITE
         4 PDB2            READ WRITE
SQL>
SQL> -- 현재 COMPATIBLE 값 확인
SQL> col VALUE for a30
SQL> SELECT name, value FROM v$parameter WHERE name = 'compatible';
NAME            VALUE
--------------- ------------------------------
compatible      23.6.0
SQL>
--COMPATIBLE 변경이 필요한 경우에만 실행
--COMPATIBLE 변경
SQL>
SQL> ALTER SYSTEM SET COMPATIBLE = '23.7.0' SCOPE=SPFILE;
System altered.
SQL> -- COMPATIBLE 변경은 SPFILE에만 반영되며, 재시작해야 실제로 적용됨
SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 3251890192 bytes
Fixed Size                  5031952 bytes
Variable Size             771751936 bytes
Database Buffers         2466250752 bytes
Redo Buffers                8855552 bytes
Database mounted.
Database opened.
SQL>
SQL> show parameter COMPATIBLE

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
compatible                           string      23.7.0
noncdb_compatible                    boolean     FALSE
SQL>
SQL> -- COMPATIBLE 변경 확인
SQL> col NAME for a20
SQL> col VALUE for a30
SQL> SELECT name, value FROM v$parameter WHERE name = 'compatible';
NAME                 VALUE
-------------------- ------------------------------
compatible           23.7.0
SQL> exit
Disconnected from Oracle AI Database 26ai Enterprise Edition Release 23.26.2.0.0 - Production
Version 23.26.2.0.0
[oracle@rhel10nm ~]$

Vector Memory Pool

Oracle DB 26ai부터는 여기에 Vector Memory Pool 추가 됨. Vector Memory Pool은 벡터 인덱스(HNSW 그래프 구조 등)를 디스크가 아니라 메모리에 올려놓고 빠르게 검색하기 위한 전용 공간

Vector Memory Pool 공간의 크기를 정하는 파라미터가 VECTOR_MEMORY_SIZE이고, CDB에서 설정하는 것과 PDB에서 설정하는 것의 의미가 다름

• CDB 레벨: Oracle DB 26ai 전체에서 사용 가능한 공간(Size)
• PDB 레벨: Oracle DB 26ai 전체에서 사용 가능한 공간에서 각각 PDB가 할당 받은 공간(Size)

[oracle@rhel10nm ~]$ --CDB Level에서 Vector Memory Pool 설정
[oracle@rhel10nm ~]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rhel10nm ~]$ env | grep SID
ORACLE_SID=CDB1
[oracle@rhel10nm ~]$
[oracle@rhel10nm ~]$ sqlplus "/as sysdba"
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> show parameter VECTOR_MEMORY_SIZE
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
vector_memory_size                   big integer 0
SQL>
SQL> -- CDB 전체에서 AI VECTOR_MEMORY_SIZE Parameter 512MB로 설정
SQL> ALTER SYSTEM SET VECTOR_MEMORY_SIZE = 512M SCOPE=SPFILE;
System altered.
SQL> --Oracle DB 재기동
SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> STARTUP;
ORACLE instance started.
Total System Global Area 3251890192 bytes
Fixed Size                  5031952 bytes
Variable Size             587202560 bytes
Database Buffers         2113929216 bytes
Redo Buffers                8855552 bytes
Vector Memory Area        536870912 bytes --> Vector Memory Area 추가 생성 됨
Database mounted.
Database opened.
SQL>
SQL> --VECTOR_MEMORY_SIZE 설정값 확인
SQL> SHOW PARAMETER VECTOR_MEMORY_SIZE;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
vector_memory_size                   big integer 512M
SQL>
SQL> exit
Disconnected from Oracle AI Database 26ai Enterprise Edition Release 23.26.2.0.0 - Production
Version 23.26.2.0.0
[oracle@rhel10nm ~]$
[oracle@rhel10nm ~]$ --각각 PDB Level에서 Vector Memory Area 설정
[oracle@rhel10nm ~]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rhel10nm ~]$ env | grep SID
ORACLE_SID=CDB1
[oracle@rhel10nm ~]$ sqlplus "/as sysdba"
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           MOUNTED
         4 PDB2                           MOUNTED
SQL>
SQL> --PDB1/PDB2 Open
SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN;
Pluggable database altered.
SQL> ALTER PLUGGABLE DATABASE pdb2 OPEN;
Pluggable database altered.
SQL>
SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         4 PDB2                           READ WRITE NO
SQL>
SQL> -- 재부팅해도 자동 Open 등록
SQL> ALTER PLUGGABLE DATABASE pdb1 SAVE STATE;
Pluggable database altered.
SQL> ALTER PLUGGABLE DATABASE pdb2 SAVE STATE;
Pluggable database altered.
SQL>
SQL> --PDB1으로 변경 및 VECTOR_MEMORY_SIZE 파리미터 변경
SQL> ALTER SESSION SET CONTAINER = PDB1;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
PDB1
SQL> show con_id
CON_ID
------------------------------
3
SQL>
SQL> show parameter VECTOR_MEMORY_SIZE
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
vector_memory_size                   big integer 512M
SQL>
SQL> ALTER SYSTEM SET VECTOR_MEMORY_SIZE = 256M SCOPE=BOTH;
System altered.
SQL> show parameter VECTOR_MEMORY_SIZE
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
vector_memory_size                   big integer 256M
SQL>
SQL> --PDB으로 변경 및 VECTOR_MEMORY_SIZE 파리미터 변경
SQL> ALTER SESSION SET CONTAINER = PDB2;
Session altered.
SQL> SHOW PARAMETER VECTOR_MEMORY_SIZE;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
vector_memory_size                   big integer 512M
SQL> ALTER SYSTEM SET VECTOR_MEMORY_SIZE = 128M SCOPE=BOTH;
System altered.
SQL> SHOW PARAMETER VECTOR_MEMORY_SIZE;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
vector_memory_size                   big integer 128M
SQL>
SQL> --전체 컨테이너의 Vector Memory Pool 상태
SQL> --CDB Root에서 실행
SQL> ALTER SESSION SET CONTAINER = CDB$ROOT;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> show con_id
CON_ID
------------------------------
1
SQL>
SQL> COLUMN POOL FORMAT A12
SQL> SELECT con_id, pool, ROUND(alloc_bytes/1024/1024, 1) AS alloc_mb,
  2  ROUND(used_bytes/1024/1024, 1)  AS used_mb, populate_status
  3  FROM v$vector_memory_pool ORDER BY con_id, pool;
    CON_ID POOL           ALLOC_MB    USED_MB POPULATE_STATUS
---------- ------------ ---------- ---------- --------------------------
         1 1MB POOL            447          0 DONE
         1 64KB POOL            48          0 DONE
         2 1MB POOL            448          0 DONE
         2 64KB POOL            48          0 DONE
         3 1MB POOL            224          0 DONE
         3 64KB POOL            24          0 DONE
         4 1MB POOL            112          0 DONE
         4 64KB POOL            12          0 DONE

8 rows selected.
SQL>
SQL> exit
Disconnected from Oracle AI Database 26ai Enterprise Edition Release 23.26.2.0.0 - Production
Version 23.26.2.0.0
[oracle@rhel10nm ~]$

사전 환경 설정

---Patch File 확인 및 unzip
[oracle@rhel10rac1 STAGE]$
[oracle@rhel10rac1 STAGE]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rhel10rac1 STAGE]$ pwd
/u01/app/STAGE
[oracle@rhel10rac1 STAGE]$ ls -al
total 3531012
drwxr-xr-x. 2 oracle dba        132 Aug  4 09:11 .
drwxr-xr-x. 6 root   dba         65 Aug  3 14:54 ..
-rw-r--r--. 1 oracle dba 2493354906 Aug  3 14:57 DB_Gold_Image_23.26.3_p39581612_230000_Linux-x86-64.zip
-rw-r--r--. 1 oracle dba 1122394588 Aug  3 14:58 GI_Gold_Image_23.26.3_p39581618_230000_Linux-x86-64.zip
[oracle@rhel10rac1 STAGE]$
[oracle@rhel10rac1 STAGE]$ mkdir -p /u01/app/oracle/product/26.0.0/dbhome_2
[oracle@rhel10rac1 STAGE]$
[oracle@rhel10rac1 STAGE]$ unzip -d /u01/app/oracle/product/26.0.0/dbhome_2 DB_Gold_Image_23.26.3_p39581612_230000_Linux-x86-64.zip
Archive:  DB_Gold_Image_23.26.3_p39581612_230000_Linux-x86-64.zip
  inflating: /u01/app/oracle/product/26.0.0/dbhome_2/META-INF/MANIFEST.MF
  inflating: /u01/app/oracle/product/26.0.0/dbhome_2/META-INF/ORACLE_C.SF
  inflating: /u01/app/oracle/product/26.0.0/dbhome_2/META-INF/ORACLE_C.RSA
   creating: /u01/app/oracle/product/26.0.0/dbhome_2/OPatch/
  inflating: /u01/app/oracle/product/26.0.0/dbhome_2/OPatch/README.txt
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  /u01/app/oracle/product/26.0.0/dbhome_2/rdbms/mesg/ocith.msb -> orath.msb
  /u01/app/oracle/product/26.0.0/dbhome_2/rdbms/mesg/ocitr.msb -> oratr.msb
  /u01/app/oracle/product/26.0.0/dbhome_2/rdbms/mesg/ocius.msb -> oraus.msb
  /u01/app/oracle/product/26.0.0/dbhome_2/rdbms/mesg/ocius.msg -> ./oraus.msg
  /u01/app/oracle/product/26.0.0/dbhome_2/rdbms/mesg/ocizhs.msb -> orazhs.msb
  /u01/app/oracle/product/26.0.0/dbhome_2/rdbms/mesg/ocizht.msb -> orazht.msb
[oracle@rhel10rac1 STAGE]$

Oracle DB Software Only Install

[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rhel10rac1 ~]$ vi /home/oracle/DATASYNCXML/db_sw_only_Gold_Image_RU3.rsp
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ more /home/oracle/DATASYNCXML/db_sw_only_Gold_Image_RU3.rsp
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v23.0.0
installOption=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=dba
INVENTORY_LOCATION=/u01/app/oraInventory
ORACLE_BASE=/u01/app/oracle
installEdition=EE
OSDBA=dba
OSBACKUPDBA=dba
OSDGDBA=dba
OSKMDBA=dba
OSRACDBA=dba
clusterNodes=rhel10rac1,rhel10rac2
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ cd /u01/app/oracle/product/26.0.0/dbhome_2
[oracle@rhel10rac1 dbhome_2]$ pwd
/u01/app/oracle/product/26.0.0/dbhome_2
[oracle@rhel10rac1 dbhome_2]$ ls
addnode     crs     cv         demo         has            inventory  jlib  md        nls     OPatch   ords             perl     QOpatch  README.html   schagent.conf  sqlj      suptools  xdk
assistants  crypto  data       diagnostics  hs             javavm     ldap  META-INF  odbc    opmn     oss              plsql    R        relnotes      sdk            sqlpatch  ucp
bin         css     dbs        dv           install        jdbc       lib   mgw       olap    oracore  oui              precomp  racg     root.sh       slax           sqlplus   usm
clone       ctx     deinstall  env.ora      instantclient  jdk        log   network   oml4py  ord      PatchSearch.xml  python   rdbms    runInstaller  sqlcl          srvm      utl
[oracle@rhel10rac1 dbhome_2]$
[oracle@rhel10rac1 dbhome_2]$ ./runInstaller -silent -ignorePrereqFailure -setupDBHomeAs /u01/app/oracle/product/26.0.0/dbhome_1 -responseFile /home/oracle/DATASYNCXML/db_sw_only_Gold_Image_RU3.rsp -clusterNodes rhel10rac1,rhel10rac2
Launching Oracle AI Database Setup Wizard...

[WARNING] [INS-13013] Target environment does not meet some mandatory requirements.
   CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /u01/app/oraInventory/logs/InstallActions2026-08-04_11-07-26AM/installActions2026-08-04_11-07-26AM.log.
   ACTION: Identify the list of failed prerequisite checks from the log: /u01/app/oraInventory/logs/InstallActions2026-08-04_11-07-26AM/installActions2026-08-04_11-07-26AM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
The response file for this session can be found at:
 /u01/app/oracle/product/26.0.0/dbhome_2/install/response/db_2026-08-04_11-07-26AM.rsp

You can find the log of this install session at:
 /u01/app/oraInventory/logs/InstallActions2026-08-04_11-07-26AM/installActions2026-08-04_11-07-26AM.log

As a root user, run the following script(s):
        1. /u01/app/oracle/product/26.0.0/dbhome_2/root.sh

Run /u01/app/oracle/product/26.0.0/dbhome_2/root.sh on the following nodes:
[rhel10rac1, rhel10rac2]


Successfully Setup Software with warning(s).
[oracle@rhel10rac1 dbhome_2]$
---root.sh
[root@rhel10rac1 ~]#
[root@rhel10rac1 ~]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@rhel10rac1 ~]#
[root@rhel10rac1 ~]# /u01/app/oracle/product/26.0.0/dbhome_2/root.sh
Check /u01/app/oracle/product/26.0.0/dbhome_2/install/root_rhel10rac1_2026-08-04_11-16-12-260235811.log for the output of root script
[root@rhel10rac1 ~]#

[root@rhel10rac2 ~]#
[root@rhel10rac2 ~]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@rhel10rac2 ~]#
[root@rhel10rac2 ~]# /u01/app/oracle/product/26.0.0/dbhome_2/root.sh
Check /u01/app/oracle/product/26.0.0/dbhome_2/install/root_rhel10rac2_2026-08-04_11-16-22-027619638.log for the output of root script
[root@rhel10rac2 ~]#

Oracle DB Home 변경

[oracle@rhel10rac1 bin]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rhel10rac1 bin]$ pwd
/u01/app/oracle/product/26.0.0/dbhome_2/bin
[oracle@rhel10rac1 bin]$
[oracle@rhel10rac1 bin]$ env | grep SID
ORACLE_SID=CDBRAC1
[oracle@rhel10rac1 bin]$
[oracle@rhel10rac1 bin]$ ./dbca -silent -moveDatabase -sourceDB CDBRAC
Session ID of the current execution is: 1
2% complete
3% complete
5% complete
7% complete
10% complete
13% complete
-----------------
Running Source_database_operations job
Completed Source_database_operations job
20% complete
-----------------
Running OJVM_pre_install_step-rhel10rac1 job
Completed OJVM_pre_install_step-rhel10rac1 job
27% complete
-----------------
Running OJVM_pre_install_step-rhel10rac2 job
Completed OJVM_pre_install_step-rhel10rac2 job
33% complete
-----------------
Running Copy_custom_config_files-rhel10rac1 job
Completed Copy_custom_config_files-rhel10rac1 job
34% complete
-----------------
Running Move_tns_alias_entries-rhel10rac1 job
Completed Move_tns_alias_entries-rhel10rac1 job
35% complete
-----------------
Running Move_ldap_entries-rhel10rac1 job
Skipping. Job is detected as not applicable.
36% complete
-----------------
Running Move_sqlnet_entries-rhel10rac1 job
Completed Move_sqlnet_entries-rhel10rac1 job
37% complete
38% complete
-----------------
Running Copy_timezone_files-rhel10rac1 job
Skipping. Job is detected as not applicable.
39% complete
40% complete
-----------------
Running Copy_custom_config_files-rhel10rac2 job
Completed Copy_custom_config_files-rhel10rac2 job
41% complete
-----------------
Running Move_tns_alias_entries-rhel10rac2 job
Completed Move_tns_alias_entries-rhel10rac2 job
42% complete
-----------------
Running Move_ldap_entries-rhel10rac2 job
Skipping. Job is detected as not applicable.
43% complete
-----------------
Running Move_sqlnet_entries-rhel10rac2 job
Completed Move_sqlnet_entries-rhel10rac2 job
44% complete
45% complete
-----------------
Running Copy_timezone_files-rhel10rac2 job
Skipping. Job is detected as not applicable.
46% complete
47% complete
-----------------
Running Stop_listeners_from_source-rhel10rac1 job
Skipping. Job is detected as not applicable.
48% complete
-----------------
Running Add_listeners_to_target-rhel10rac1 job
Skipping. Job is detected as not applicable.
49% complete
-----------------
Running Modify_listeners_resource-rhel10rac1 job
Skipping. Job is detected as not applicable.
51% complete
-----------------
Running Start_listeners_from_target-rhel10rac1 job
Skipping. Job is detected as not applicable.
52% complete
-----------------
Running Delete_listeners_from_source-rhel10rac1 job
Skipping. Job is detected as not applicable.
53% complete
-----------------
Running Stop_listeners_from_source-rhel10rac2 job
Skipping. Job is detected as not applicable.
55% complete
-----------------
Running Add_listeners_to_target-rhel10rac2 job
Skipping. Job is detected as not applicable.
56% complete
-----------------
Running Modify_listeners_resource-rhel10rac2 job
Skipping. Job is detected as not applicable.
57% complete
-----------------
Running Start_listeners_from_target-rhel10rac2 job
Skipping. Job is detected as not applicable.
59% complete
-----------------
Running Delete_listeners_from_source-rhel10rac2 job
Skipping. Job is detected as not applicable.
60% complete
61% complete
-----------------
Running Stop_database_instance-rhel10rac1 job
Completed Stop_database_instance-rhel10rac1 job
62% complete
-----------------
Running Modify_database_resource-rhel10rac1 job
Completed Modify_database_resource-rhel10rac1 job
63% complete
64% complete
65% complete
66% complete
-----------------
Running Start_database_instance-rhel10rac1 job
Completed Start_database_instance-rhel10rac1 job
67% complete
68% complete
-----------------
Running Stop_database_instance-rhel10rac2 job
Completed Stop_database_instance-rhel10rac2 job
69% complete
-----------------
Running Modify_database_resource-rhel10rac2 job
Completed Modify_database_resource-rhel10rac2 job
70% complete
71% complete
72% complete
-----------------
Running Start_database_instance-rhel10rac2 job
Completed Start_database_instance-rhel10rac2 job
73% complete
-----------------
Running Run_datapatch job
Completed Run_datapatch job
77% complete
-----------------
Running Recompile_invalid_objects job
Completed Recompile_invalid_objects job
80% complete
81% complete
82% complete
83% complete
84% complete
86% complete
87% complete
88% complete
89% complete
-----------------
Running Update_dba_directories job
Completed Update_dba_directories job
90% complete
91% complete
-----------------
Running Finalize_database_move job
Completed Finalize_database_move job
92% complete
-----------------
Running Post_database_move_validation job
Skipping. Job is detected as not applicable.
93% complete
-----------------
Running Run_custom_scripts job
Completed Run_custom_scripts job
97% complete
-----------------
Running Run_custom_rollback_scripts job
Skipping. Job is detected as not applicable.
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/CDBRAC/CDBRAC.log" for further details.
[oracle@rhel10rac1 bin]$

후속작업

--OS Oracle User .bash_profile 변경
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ env | grep SID
ORACLE_SID=CDBRAC1
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ env | grep HOME
GRID_HOME=/u01/app/grid/26.0.0/gdhome_2
DB_HOME=/u01/app/oracle/product/26.0.0/dbhome_2
HOME=/home/oracle
ORACLE_HOME=/u01/app/oracle/product/26.0.0/dbhome_2
[oracle@rhel10rac1 ~]$

--확인 작업
[oracle@rhel10rac1 ~]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rhel10rac1 ~]$ env | grep SID
ORACLE_SID=CDBRAC1
[oracle@rhel10rac1 ~]$ sqlplus "/as sysdba"
SQL> SET LINESIZE 200 PAGESIZE 100
SQL> COLUMN patch_id FORMAT 9999999999
SQL> COLUMN action FORMAT A10
SQL> COLUMN status FORMAT A12
SQL> COLUMN source_version FORMAT A15
SQL> COLUMN target_version FORMAT A15
SQL> COLUMN action_time FORMAT A28
SQL> COLUMN description FORMAT A70
SQL> SELECT patch_id, action, status, source_version, target_version, action_time, description FROM cdb_registry_sqlpatch ORDER BY action_time DESC;
   PATCH_ID ACTION     STATUS       SOURCE_VERSION  TARGET_VERSION  ACTION_TIME                  DESCRIPTION
----------- ---------- ------------ --------------- --------------- ---------------------------- ----------------------------------------------------------------------
   39578879 APPLY      SUCCESS      23.26.2.0.0     23.26.3.0.0     04-AUG-26 12.05.01.621942 PM Database Release Update : 23.26.3.0.0 (39578879) Gold Image
   39578879 APPLY      SUCCESS      23.26.2.0.0     23.26.3.0.0     04-AUG-26 11.45.49.858986 AM Database Release Update : 23.26.3.0.0 (39578879) Gold Image
   39093711 APPLY      SUCCESS      23.26.2.0.0     23.26.2.0.0     03-AUG-26 06.48.38.108896 PM Database Release Update : 23.26.2.0.0 (39093711) Gold Image
   39093711 APPLY      SUCCESS      23.26.2.0.0     23.26.2.0.0     03-AUG-26 06.48.37.557707 PM Database Release Update : 23.26.2.0.0 (39093711) Gold Image
SQL> exit
Disconnected from Oracle AI Database 26ai Enterprise Edition Release 23.26.3.0.0 - Production
Version 23.26.3.0.0
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ cd $ORACLE_HOME/OPatch/
[oracle@rhel10rac1 OPatch]$ pwd
/u01/app/oracle/product/26.0.0/dbhome_2/OPatch
[oracle@rhel10rac1 OPatch]$
[oracle@rhel10rac1 OPatch]$ ./opatch lspatches
39578859;OCW RELEASE UPDATE 23.26.3.0.0 (39578859) Gold Image
39578879;Database Release Update : 23.26.3.0.0 (39578879) Gold Image

OPatch succeeded.
[oracle@rhel10rac1 OPatch]$

--Post 작업
[oracle@rhel10rac1 ~]$ sqlplus "/as sysdba"
SQL> ALTER PLUGGABLE DATABASE ALL OPEN;
SQL> eixt
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rhel10rac1 ~]$ cd $ORACLE_HOME/OPatch
[oracle@rhel10rac1 OPatch]$ pwd
/u01/app/oracle/product/26.0.0/dbhome_2/OPatch
[oracle@rhel10rac1 OPatch]$
[oracle@rhel10rac1 OPatch]$ ./datapatch -verbose
SQL Patching tool version 23.26.2.0.0 Production on Mon Aug  3 20:26:08 2026
Copyright (c) 2012, 2026, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/product/26.0.0/dbhome_2/cfgtoollogs/sqlpatch/sqlpatch_sid_CDBRAC1_ts_2026_08_03_20_26_08_pid_193049/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.26.2.0.0 Release_Update 260428181725: Installed
  PDB CDB$ROOT:
    Applied 23.26.2.0.0 Release_Update 260428181725 successfully on 31-JUL-26 07.51.13.924282 PM
  PDB PDB:
    Applied 23.26.2.0.0 Release_Update 260428181725 successfully on 31-JUL-26 07.51.14.493294 PM
  PDB PDB$SEED:
    Applied 23.26.2.0.0 Release_Update 260428181725 successfully on 31-JUL-26 07.51.14.493294 PM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED PDB
    No interim patches need to be rolled back
    No release update patches need to be installed
    No interim patches need to be applied

SQL Patching tool complete on Mon Aug  3 20:27:01 2026
[oracle@rhel10rac1 OPatch]$

[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       rhel10rac1               STABLE
               ONLINE  ONLINE       rhel10rac2               STABLE
ora.chad
               ONLINE  ONLINE       rhel10rac1               STABLE
               ONLINE  ONLINE       rhel10rac2               STABLE
ora.helper
               OFFLINE OFFLINE      rhel10rac1               STABLE
               OFFLINE OFFLINE      rhel10rac2               IDLE,STABLE
ora.net1.network
               ONLINE  ONLINE       rhel10rac1               STABLE
               ONLINE  ONLINE       rhel10rac2               STABLE
ora.ons
               ONLINE  ONLINE       rhel10rac1               STABLE
               ONLINE  ONLINE       rhel10rac2               STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       rhel10rac1               STABLE
      2        ONLINE  ONLINE       rhel10rac2               STABLE
ora.DATA01.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rhel10rac1               STABLE
      2        ONLINE  ONLINE       rhel10rac2               STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rhel10rac1               STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       rhel10rac1               STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       rhel10rac2               STABLE
ora.OCRVOTE.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rhel10rac1               STABLE
      2        ONLINE  ONLINE       rhel10rac2               STABLE
ora.RECO01.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rhel10rac1               STABLE
      2        ONLINE  ONLINE       rhel10rac2               STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       rhel10rac1               Started,STABLE
      2        ONLINE  ONLINE       rhel10rac2               Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       rhel10rac1               STABLE
      2        ONLINE  ONLINE       rhel10rac2               STABLE
ora.cdbrac.cdbrac_pdb1.svc
      1        ONLINE  ONLINE       rhel10rac2               STABLE
      2        ONLINE  ONLINE       rhel10rac1               STABLE
ora.cdbrac.db
      1        ONLINE  ONLINE       rhel10rac1               Open,HOME=/u01/app/o
                                                             racle/product/26.0.0
                                                             /dbhome_2,STABLE
      2        ONLINE  ONLINE       rhel10rac2               Open,HOME=/u01/app/o
                                                             racle/product/26.0.0
                                                             /dbhome_2,STABLE
ora.cdbrac.pdb1.pdb
      1        ONLINE  ONLINE       rhel10rac1               READ WRITE,STABLE
      2        ONLINE  ONLINE       rhel10rac2               READ WRITE,STABLE
ora.cdp1.cdp
      1        OFFLINE OFFLINE                               STABLE
ora.cdp2.cdp
      1        OFFLINE OFFLINE                               STABLE
ora.cdp3.cdp
      1        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       rhel10rac1               STABLE
ora.cvuhelper
      1        OFFLINE OFFLINE                               STABLE
ora.rhel10rac1.vip
      1        ONLINE  ONLINE       rhel10rac1               STABLE
ora.rhel10rac2.vip
      1        ONLINE  ONLINE       rhel10rac2               STABLE
ora.rhpserver
      1        OFFLINE OFFLINE                               STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       rhel10rac1               STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       rhel10rac1               STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       rhel10rac2               STABLE
--------------------------------------------------------------------------------
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ srvctl status database -d CDBRAC
Instance CDBRAC1 is running on node rhel10rac1
Instance CDBRAC2 is running on node rhel10rac2
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ srvctl config database -d CDBRAC
Database unique name: CDBRAC
Database name: CDBRAC
Oracle home: /u01/app/oracle/product/26.0.0/dbhome_2
Oracle user: oracle
Spfile: +DATA01/CDBRAC/PARAMETERFILE/spfile.272.1240339719
Password file: +DATA01/CDBRAC/PASSWORD/pwdcdbrac.256.1240330395
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA01
Mount point paths:
Services: CDBRAC_PDB1
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: dba
Database instances: CDBRAC1,CDBRAC2
Configured nodes: rhel10rac1,rhel10rac2
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
[oracle@rhel10rac1 ~]$

사전 환경 점검 및 설정

--기존 Patch Level 확인
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@rhel10rac1 ~]$ cd $ORACLE_HOME/OPatch/
[oracle@rhel10rac1 OPatch]$
[oracle@rhel10rac1 OPatch]$ ./opatch lspatches
39099119;MICRONAUT RELEASE UPDATE 23.26.2.0.0 (39099119) Gold Image
39099244;RHP RELEASE UPDATE 23.26.2.0.0 (39099244) Gold Image
39099110;ACFS RELEASE UPDATE 23.26.2.0.0 (39099110) Gold Image
39093738;OCW RELEASE UPDATE 23.26.2.0.0 (39093738) Gold Image
39093711;Database Release Update : 23.26.2.0.0 (39093711) Gold Image

OPatch succeeded.
[oracle@rhel10rac1 OPatch]$
---Patch File 확인
[oracle@rhel10rac1 STAGE]$
[oracle@rhel10rac1 STAGE]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rhel10rac1 STAGE]$ pwd
/u01/app/STAGE
[oracle@rhel10rac1 STAGE]$
[oracle@rhel10rac1 STAGE]$ ls -al
total 3531012
drwxr-xr-x. 2 oracle dba        132 Aug  4 09:11 .
drwxr-xr-x. 6 root   dba         65 Aug  3 14:54 ..
-rw-r--r--. 1 oracle dba 2493354906 Aug  3 14:57 DB_Gold_Image_23.26.3_p39581612_230000_Linux-x86-64.zip
-rw-r--r--. 1 oracle dba 1122394588 Aug  3 14:58 GI_Gold_Image_23.26.3_p39581618_230000_Linux-x86-64.zip
[oracle@rhel10rac1 STAGE]$

신규 Grid Home 생성

----신규 Grid Home 생성은 Oracle RAC 전체 Node에 각각 생성 해야 함
[root@rhel10rac1 ~]#
[root@rhel10rac1 ~]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@rhel10rac1 ~]#
[root@rhel10rac1 ~]# mkdir -p /u01/app/grid/26.0.0/gdhome_2
[root@rhel10rac1 ~]#
[root@rhel10rac1 ~]# cd /u01/app/grid/26.0.0
[root@rhel10rac1 26.0.0]# ls -al
total 4
drwxr-xr-x.  4 root dba    38 Aug  4 09:13 .
drwxr-xr-x.  3 root dba    20 Aug  3 14:33 ..
drwxr-xr-x. 68 root dba  4096 Aug  3 15:23 gdhome_1
drwxr-xr-x.  2 root root    6 Aug  4 09:13 gdhome_2
[root@rhel10rac1 26.0.0]#
[root@rhel10rac1 26.0.0]# chown -R oracle:dba ./gdhome_2
[root@rhel10rac1 26.0.0]#
[root@rhel10rac1 26.0.0]# ls -al
total 4
drwxr-xr-x.  4 root   dba   38 Aug  4 09:13 .
drwxr-xr-x.  3 root   dba   20 Aug  3 14:33 ..
drwxr-xr-x. 68 root   dba 4096 Aug  3 15:23 gdhome_1
drwxr-xr-x.  2 oracle dba    6 Aug  4 09:13 gdhome_2
[root@rhel10rac1 26.0.0]#
---Gold Image Unzip
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rhel10rac1 ~]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@rhel10rac1 ~]$ cd /u01/app/STAGE/
[oracle@rhel10rac1 STAGE]$ ls -al
total 3531012
drwxr-xr-x. 2 oracle dba        132 Aug  4 09:11 .
drwxr-xr-x. 6 root   dba         65 Aug  3 14:54 ..
-rw-r--r--. 1 oracle dba 2493354906 Aug  3 14:57 DB_Gold_Image_23.26.3_p39581612_230000_Linux-x86-64.zip
-rw-r--r--. 1 oracle dba 1122394588 Aug  3 14:58 GI_Gold_Image_23.26.3_p39581618_230000_Linux-x86-64.zip
[oracle@rhel10rac1 STAGE]$
[oracle@rhel10rac1 STAGE]$ unzip -d /u01/app/grid/26.0.0/gdhome_2 GI_Gold_Image_23.26.3_p39581618_230000_Linux-x86-64.zip
Archive:  GI_Gold_Image_23.26.3_p39581618_230000_Linux-x86-64.zip
  inflating: /u01/app/grid/26.0.0/gdhome_2/META-INF/MANIFEST.MF
  inflating: /u01/app/grid/26.0.0/gdhome_2/META-INF/ORACLE_C.SF
  inflating: /u01/app/grid/26.0.0/gdhome_2/META-INF/ORACLE_C.RSA
   creating: /u01/app/grid/26.0.0/gdhome_2/OPatch/
  inflating: /u01/app/grid/26.0.0/gdhome_2/OPatch/README.txt
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  /u01/app/grid/26.0.0/gdhome_2/rdbms/mesg/ocisf.msb -> orasf.msb
  /u01/app/grid/26.0.0/gdhome_2/rdbms/mesg/ocisk.msb -> orask.msb
  /u01/app/grid/26.0.0/gdhome_2/rdbms/mesg/ocith.msb -> orath.msb
  /u01/app/grid/26.0.0/gdhome_2/rdbms/mesg/ocitr.msb -> oratr.msb
  /u01/app/grid/26.0.0/gdhome_2/rdbms/mesg/ocius.msb -> oraus.msb
  /u01/app/grid/26.0.0/gdhome_2/rdbms/mesg/ocius.msg -> ./oraus.msg
  /u01/app/grid/26.0.0/gdhome_2/rdbms/mesg/ocizhs.msb -> orazhs.msb
  /u01/app/grid/26.0.0/gdhome_2/rdbms/mesg/ocizht.msb -> orazht.msb
[oracle@rhel10rac1 STAGE]$

Grid Software Only Inteall - GUI 화면으로 진행

[root@rhel10rac1 ~]#
[root@rhel10rac1 ~]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@rhel10rac1 ~]# export DISPLAY=192.168.56.1:0.0
[root@rhel10rac1 ~]# xhost +
access control disabled, clients can connect from any host
[root@rhel10rac1 ~]#
[root@rhel10rac1 ~]# su - oracle
Last login: Tue Aug  4 09:15:00 KST 2026 on pts/0
[ORACLE_SID = CDBRAC1 ]
[oracle@rhel10rac1 ~]$ grid_env
[oracle@rhel10rac1 ~]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rhel10rac1 ~]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ export DISPLAY=192.168.56.1:0.0
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ cd /u01/app/grid/26.0.0/gdhome_2/
[oracle@rhel10rac1 gdhome_2]$ ls
addnode     crs     dbs          env.ora       has        jdbc  lib        network  oracore          perl     python   README.html  rootupgrade.sh  sqlpatch  usm           xdk
assistants  crypto  deinstall    evm           install    jdk   md         nls      oss              plsql    QOpatch  relnotes     runcluvfy.sh    sqlplus   utl
bin         css     demo         gpnp          inventory  jlib  META-INF   OPatch   oui              precomp  racg     rhp          sdk             srvm      welcome.html
clone       cv      diagnostics  gridSetup.sh  javavm     ldap  micronaut  opmn     PatchSearch.xml  pylib    rdbms    root.sh      slax            ucp       xag
[oracle@rhel10rac1 gdhome_2]$
[oracle@rhel10rac1 gdhome_2]$ ./gridSetup.sh
Launching Oracle Grid Infrastructure Setup Wizard...

The response file for this session can be found at:
 /u01/app/grid/26.0.0/gdhome_2/install/response/grid_2026-08-04_09-21-00AM.rsp

You can find the log of this install session at:
 /u01/app/oraInventory/logs/GridSetupActions2026-08-04_09-21-00AM/gridSetupActions2026-08-04_09-21-00AM.log
[oracle@rhel10rac1 gdhome_2]$



---root.sh
[root@rhel10rac1 ~]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@rhel10rac1 ~]#
[root@rhel10rac1 ~]# /u01/app/grid/26.0.0/gdhome_2/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/grid/26.0.0/gdhome_2

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

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.

To configure Grid Infrastructure for a Cluster execute the following command as oracle user:
/u01/app/grid/26.0.0/gdhome_2/gridSetup.sh
This command launches the Grid Infrastructure Setup Wizard. The wizard also supports silent operation, and the parameters can be passed through the response file that is available in the installation media.

[root@rhel10rac1 ~]#

[root@rhel10rac2 ~]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@rhel10rac2 ~]#
[root@rhel10rac2 ~]# /u01/app/grid/26.0.0/gdhome_2/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/grid/26.0.0/gdhome_2

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

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.

To configure Grid Infrastructure for a Cluster execute the following command as oracle user:
/u01/app/grid/26.0.0/gdhome_2/gridSetup.sh
This command launches the Grid Infrastructure Setup Wizard. The wizard also supports silent operation, and the parameters can be passed through the response file that is available in the installation media.

[root@rhel10rac2 ~]#

Oracle GRID Home 변경

[oracle@rhel10rac1 gdhome_2]$
[oracle@rhel10rac1 gdhome_2]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rhel10rac1 gdhome_2]$
[oracle@rhel10rac1 gdhome_2]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@rhel10rac1 gdhome_2]$
[oracle@rhel10rac1 gdhome_2]$ env | grep ORACLE_HOME
ORACLE_HOME=/u01/app/grid/26.0.0/gdhome_1
[oracle@rhel10rac1 gdhome_2]$
[oracle@rhel10rac1 gdhome_2]$ pwd
/u01/app/grid/26.0.0/gdhome_2
[oracle@rhel10rac1 gdhome_2]$
[oracle@rhel10rac1 gdhome_2]$ which crsctl
/u01/app/grid/26.0.0/gdhome_1/bin/crsctl
[oracle@rhel10rac1 gdhome_2]$
[oracle@rhel10rac1 gdhome_2]$ crsctl status res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       rhel10rac1               STABLE
               ONLINE  ONLINE       rhel10rac2               STABLE
ora.chad
               ONLINE  ONLINE       rhel10rac1               STABLE
               ONLINE  ONLINE       rhel10rac2               STABLE
ora.helper
               OFFLINE OFFLINE      rhel10rac1               IDLE,STABLE
               OFFLINE OFFLINE      rhel10rac2               IDLE,STABLE
ora.net1.network
               ONLINE  ONLINE       rhel10rac1               STABLE
               ONLINE  ONLINE       rhel10rac2               STABLE
ora.ons
               ONLINE  ONLINE       rhel10rac1               STABLE
               ONLINE  ONLINE       rhel10rac2               STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       rhel10rac1               STABLE
      2        ONLINE  ONLINE       rhel10rac2               STABLE
ora.DATA01.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rhel10rac1               STABLE
      2        ONLINE  ONLINE       rhel10rac2               STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rhel10rac1               STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       rhel10rac1               STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       rhel10rac2               STABLE
ora.OCRVOTE.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rhel10rac1               STABLE
      2        ONLINE  ONLINE       rhel10rac2               STABLE
ora.RECO01.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rhel10rac1               STABLE
      2        ONLINE  ONLINE       rhel10rac2               STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       rhel10rac1               Started,STABLE
      2        ONLINE  ONLINE       rhel10rac2               Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       rhel10rac1               STABLE
      2        ONLINE  ONLINE       rhel10rac2               STABLE
ora.cdbrac.cdbrac_pdb1.svc
      1        ONLINE  ONLINE       rhel10rac2               STABLE
      2        ONLINE  ONLINE       rhel10rac1               STABLE
ora.cdbrac.db
      1        ONLINE  ONLINE       rhel10rac1               Open,HOME=/u01/app/o
                                                             racle/product/26.0.0
                                                             /dbhome_1,STABLE
      2        ONLINE  ONLINE       rhel10rac2               Open,HOME=/u01/app/o
                                                             racle/product/26.0.0
                                                             /dbhome_1,STABLE
ora.cdbrac.pdb1.pdb
      1        ONLINE  ONLINE       rhel10rac1               READ WRITE,STABLE
      2        ONLINE  ONLINE       rhel10rac2               READ WRITE,STABLE
ora.cdp1.cdp
      1        OFFLINE OFFLINE                               STABLE
ora.cdp2.cdp
      1        OFFLINE OFFLINE                               STABLE
ora.cdp3.cdp
      1        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       rhel10rac1               STABLE
ora.cvuhelper
      1        OFFLINE OFFLINE                               STABLE
ora.rhel10rac1.vip
      1        ONLINE  ONLINE       rhel10rac1               STABLE
ora.rhel10rac2.vip
      1        ONLINE  ONLINE       rhel10rac2               STABLE
ora.rhpserver
      1        OFFLINE OFFLINE                               STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       rhel10rac1               STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       rhel10rac1               STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       rhel10rac2               STABLE
--------------------------------------------------------------------------------
[oracle@rhel10rac1 gdhome_2]$

[oracle@rhel10rac1 gdhome_2]$
[oracle@rhel10rac1 gdhome_2]$ pwd
/u01/app/grid/26.0.0/gdhome_2
[oracle@rhel10rac1 gdhome_2]$ env | grep SID
ORACLE_SID=+ASM1
Patch 39581618 - Grid Infrastructure Release Update Gold Image 23.26.3.0.0[oracle@rhel10rac1 gdhome_2]$ env | grep DISPLAY
DISPLAY=192.168.56.1:0.0
[oracle@rhel10rac1 gdhome_2]$
[oracle@rhel10rac1 gdhome_2]$ ls
addnode      clone   cv         diagnostics  gridSetup.sh  javavm  ldap  micronaut  opmn         oui              precomp  racg         rhp            rootupgrade.sh  sqlpatch  usm           xdk
assistants   crs     dbs        env.ora      has           jdbc    lib   network    oracore      PatchSearch.xml  pylib    rdbms        root.sh        runcluvfy.sh    sqlplus   utl
bin          crypto  deinstall  evm          install       jdk     log   nls        oraInst.loc  perl             python   README.html  root.sh.old    sdk             srvm      welcome.html
cfgtoollogs  css     demo       gpnp         inventory     jlib    md    OPatch     oss          plsql            QOpatch  relnotes     root.sh.old.1  slax            ucp       xag
[oracle@rhel10rac1 gdhome_2]$
[oracle@rhel10rac1 gdhome_2]$ ./gridSetup.sh -switchgridhome
Launching Oracle Grid Infrastructure Setup Wizard...

[oracle@rhel10rac1 gdhome_2]$
---root.sh
[root@rhel10rac1 ~]#
[root@rhel10rac1 ~]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@rhel10rac1 ~]#
[root@rhel10rac1 ~]# /u01/app/grid/26.0.0/gdhome_2/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/grid/26.0.0/gdhome_2

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

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.
RAC option enabled on: Linux
Executing command '/u01/app/grid/26.0.0/gdhome_2/perl/bin/perl -I/u01/app/grid/26.0.0/gdhome_2/perl/lib -I/u01/app/grid/26.0.0/gdhome_2/crs/install /u01/app/grid/26.0.0/gdhome_2/crs/install/rootcrs.pl  -dstcrshome /u01/app/grid/26.0.0/gdhome_2  -prepatch  '
Using configuration parameter file: /u01/app/grid/26.0.0/gdhome_2/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/oracle/crsdata/rhel10rac1/crsconfig/crs_prepatch_apply_oop_rhel10rac1_2026-08-04_09-36-04AM.log

 Initializing ...

 Performing following verification checks ...

   cluster upgrade state ...PASSED
   OLR Integrity ...PASSED
   Hosts File ...PASSED
   Free Space: rhel10rac1:/ ...PASSED
   ASM Integrity ...PASSED
   Software home: /u01/app/grid/26.0.0/gdhome_1 ...PASSED
   Immutable file attribute check ...PASSED

 Pre-check for Patch Application was successful.

 CVU operation performed:      stage -pre patch
 Date:                         Aug 4, 2026, 9:36:38 AM
 CVU version:                  23.26.2.0.0 (032926x8664)
 Clusterware version:          23.0.0.0.0
 CVU home:                     /u01/app/grid/26.0.0/gdhome_1
 Grid home:                    /u01/app/grid/26.0.0/gdhome_1
 User:                         oracle
 Operating system:             Linux6.12.0-211.7.3.el10_2.x86_64

2026/08/04 09:37:24 CLSRSC-671: Pre-patch steps for patching GI home successfully completed.
Executing command '/u01/app/grid/26.0.0/gdhome_2/perl/bin/perl -I/u01/app/grid/26.0.0/gdhome_2/perl/lib -I/u01/app/grid/26.0.0/gdhome_2/crs/install /u01/app/grid/26.0.0/gdhome_2/crs/install/rootcrs.pl  -dstcrshome /u01/app/grid/26.0.0/gdhome_2  -postpatch '
Using configuration parameter file: /u01/app/grid/26.0.0/gdhome_2/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/oracle/crsdata/rhel10rac1/crsconfig/crs_postpatch_apply_oop_rhel10rac1_2026-08-04_09-37-25AM.log
2026/08/04 09:38:41 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
2026/08/04 09:40:39 CLSRSC-4015: Performing install or upgrade action for Oracle Autonomous Health Framework (AHF).
2026/08/04 09:40:39 CLSRSC-4012: Shutting down Oracle Autonomous Health Framework (AHF).
2026/08/04 09:42:29 CLSRSC-4013: Successfully shut down Oracle Autonomous Health Framework (AHF).
2026/08/04 09:42:41 CLSRSC-672: Post-patch steps for patching GI home successfully completed.
[root@rhel10rac1 ~]#

[root@rhel10rac2 ~]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@rhel10rac2 ~]#
[root@rhel10rac2 ~]# /u01/app/grid/26.0.0/gdhome_2/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/grid/26.0.0/gdhome_2

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

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.
RAC option enabled on: Linux
Executing command '/u01/app/grid/26.0.0/gdhome_2/perl/bin/perl -I/u01/app/grid/26.0.0/gdhome_2/perl/lib -I/u01/app/grid/26.0.0/gdhome_2/crs/install /u01/app/grid/26.0.0/gdhome_2/crs/install/rootcrs.pl  -dstcrshome /u01/app/grid/26.0.0/gdhome_2  -prepatch  '
Using configuration parameter file: /u01/app/grid/26.0.0/gdhome_2/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/oracle/crsdata/rhel10rac2/crsconfig/crs_prepatch_apply_oop_rhel10rac2_2026-08-04_09-43-20AM.log

 Initializing ...

 Performing following verification checks ...

   cluster upgrade state ...PASSED
   OLR Integrity ...PASSED
   Hosts File ...PASSED
   Free Space: rhel10rac2:/ ...PASSED
   ASM Integrity ...PASSED
   Software home: /u01/app/grid/26.0.0/gdhome_1 ...PASSED
   Immutable file attribute check ...PASSED

 Pre-check for Patch Application was successful.

 CVU operation performed:      stage -pre patch
 Date:                         Aug 4, 2026, 9:43:57 AM
 CVU version:                  23.26.2.0.0 (032926x8664)
 Clusterware version:          23.0.0.0.0
 CVU home:                     /u01/app/grid/26.0.0/gdhome_1
 Grid home:                    /u01/app/grid/26.0.0/gdhome_1
 User:                         oracle
 Operating system:             Linux6.12.0-211.7.3.el10_2.x86_64

2026/08/04 09:44:44 CLSRSC-671: Pre-patch steps for patching GI home successfully completed.
Executing command '/u01/app/grid/26.0.0/gdhome_2/perl/bin/perl -I/u01/app/grid/26.0.0/gdhome_2/perl/lib -I/u01/app/grid/26.0.0/gdhome_2/crs/install /u01/app/grid/26.0.0/gdhome_2/crs/install/rootcrs.pl  -dstcrshome /u01/app/grid/26.0.0/gdhome_2  -postpatch '
Using configuration parameter file: /u01/app/grid/26.0.0/gdhome_2/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/oracle/crsdata/rhel10rac2/crsconfig/crs_postpatch_apply_oop_rhel10rac2_2026-08-04_09-44-45AM.log
2026/08/04 09:45:58 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
2026/08/04 09:47:37 CLSRSC-4015: Performing install or upgrade action for Oracle Autonomous Health Framework (AHF).
2026/08/04 09:47:37 CLSRSC-4012: Shutting down Oracle Autonomous Health Framework (AHF).
2026/08/04 09:49:13 CLSRSC-4013: Successfully shut down Oracle Autonomous Health Framework (AHF).

 Initializing ...

 Performing following verification checks ...

   cluster upgrade state ...PASSED

 Post-check for Patch Application was successful.

 CVU operation performed:      stage -post patch
 Date:                         Aug 4, 2026, 9:49:41 AM
 CVU version:                  23.26.3.0.0 (070426x8664)
 Clusterware version:          23.0.0.0.0
 CVU home:                     /u01/app/grid/26.0.0/gdhome_2
 Grid home:                    /u01/app/grid/26.0.0/gdhome_2
 User:                         oracle
 Operating system:             Linux6.12.0-211.7.3.el10_2.x86_64

2026/08/04 09:50:37 CLSRSC-672: Post-patch steps for patching GI home successfully completed.
[root@rhel10rac2 ~]#

변경 사항 적용 및 확인

---Oracle Grid Process 확인
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ ps -ef | grep d.bin
root       59724       1  2 09:39 ?        00:00:21 /u01/app/grid/26.0.0/gdhome_2/bin/ohasd.bin reboot _ORA_BLOCKING_STACK_LOCALE=AMERICAN_AMERICA.AL32UTF8
oracle     59946       1  0 09:39 ?        00:00:02 /u01/app/grid/26.0.0/gdhome_2/bin/mdnsd.bin
oracle     59948       1  0 09:39 ?        00:00:05 /u01/app/grid/26.0.0/gdhome_2/bin/evmd.bin
oracle     59984       1  0 09:39 ?        00:00:02 /u01/app/grid/26.0.0/gdhome_2/bin/gpnpd.bin
oracle     60038       1  0 09:39 ?        00:00:07 /u01/app/grid/26.0.0/gdhome_2/bin/gipcd.bin
root       60137       1  2 09:39 ?        00:00:24 /u01/app/grid/26.0.0/gdhome_2/bin/osysmond.bin
oracle     60301       1  2 09:39 ?        00:00:20 /u01/app/grid/26.0.0/gdhome_2/bin/onmd.bin
oracle     60305       1  1 09:39 ?        00:00:10 /u01/app/grid/26.0.0/gdhome_2/bin/ocssd.bin
root       60972       1  3 09:39 ?        00:00:28 /u01/app/grid/26.0.0/gdhome_2/bin/crsd.bin reboot
oracle    102080   27600  0 09:53 pts/0    00:00:00 grep --color=auto d.bin
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ ps -ef | grep tns
root           8       2  0 09:05 ?        00:00:00 [kworker/R-netns]
oracle     61520       1  0 09:39 ?        00:00:00 /u01/app/grid/26.0.0/gdhome_2/bin/tnslsnr LISTENER -no_crs_notify -inherit
oracle     61669       1  0 09:39 ?        00:00:00 /u01/app/grid/26.0.0/gdhome_2/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit
oracle     82961       1  0 09:45 ?        00:00:00 /u01/app/grid/26.0.0/gdhome_2/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit
oracle     83014       1  0 09:45 ?        00:00:00 /u01/app/grid/26.0.0/gdhome_2/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit
oracle    102553   27600  0 09:54 pts/0    00:00:00 grep --color=auto tns
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ /u01/app/grid/26.0.0/gdhome_2/bin/crsctl status res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       rhel10rac1               STABLE
               ONLINE  ONLINE       rhel10rac2               STABLE
ora.chad
               ONLINE  ONLINE       rhel10rac1               STABLE
               ONLINE  ONLINE       rhel10rac2               STABLE
ora.helper
               OFFLINE OFFLINE      rhel10rac1               STABLE
               OFFLINE OFFLINE      rhel10rac2               IDLE,STABLE
ora.net1.network
               ONLINE  ONLINE       rhel10rac1               STABLE
               ONLINE  ONLINE       rhel10rac2               STABLE
ora.ons
               ONLINE  ONLINE       rhel10rac1               STABLE
               ONLINE  ONLINE       rhel10rac2               STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       rhel10rac1               STABLE
      2        ONLINE  ONLINE       rhel10rac2               STABLE
ora.DATA01.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rhel10rac1               STABLE
      2        ONLINE  ONLINE       rhel10rac2               STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rhel10rac1               STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       rhel10rac1               STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       rhel10rac2               STABLE
ora.OCRVOTE.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rhel10rac1               STABLE
      2        ONLINE  ONLINE       rhel10rac2               STABLE
ora.RECO01.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rhel10rac1               STABLE
      2        ONLINE  ONLINE       rhel10rac2               STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       rhel10rac1               Started,STABLE
      2        ONLINE  ONLINE       rhel10rac2               Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       rhel10rac1               STABLE
      2        ONLINE  ONLINE       rhel10rac2               STABLE
ora.cdbrac.cdbrac_pdb1.svc
      1        ONLINE  ONLINE       rhel10rac2               STABLE
      2        ONLINE  ONLINE       rhel10rac1               STABLE
ora.cdbrac.db
      1        ONLINE  ONLINE       rhel10rac1               Open,HOME=/u01/app/o
                                                             racle/product/26.0.0
                                                             /dbhome_1,STABLE
      2        ONLINE  ONLINE       rhel10rac2               Open,HOME=/u01/app/o
                                                             racle/product/26.0.0
                                                             /dbhome_1,STABLE
ora.cdbrac.pdb1.pdb
      1        ONLINE  ONLINE       rhel10rac1               READ WRITE,STABLE
      2        ONLINE  ONLINE       rhel10rac2               READ WRITE,STABLE
ora.cdp1.cdp
      1        OFFLINE OFFLINE                               STABLE
ora.cdp2.cdp
      1        OFFLINE OFFLINE                               STABLE
ora.cdp3.cdp
      1        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       rhel10rac1               STABLE
ora.cvuhelper
      1        OFFLINE OFFLINE                               STABLE
ora.rhel10rac1.vip
      1        ONLINE  ONLINE       rhel10rac1               STABLE
ora.rhel10rac2.vip
      1        ONLINE  ONLINE       rhel10rac2               STABLE
ora.rhpserver
      1        OFFLINE OFFLINE                               STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       rhel10rac1               STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       rhel10rac1               STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       rhel10rac2               STABLE
--------------------------------------------------------------------------------
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 OPatch]$
[oracle@rhel10rac1 OPatch]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rhel10rac1 OPatch]$ cd $ORACLE_HOME
[oracle@rhel10rac1 gdhome_2]$ cd OPatch/
[oracle@rhel10rac1 OPatch]$ pwd
/u01/app/grid/26.0.0/gdhome_2/OPatch
[oracle@rhel10rac1 OPatch]$
[oracle@rhel10rac1 OPatch]$ ./opatch lspatches
39578862;MICRONAUT RELEASE UPDATE 23.26.3.0.0 (39578862) Gold Image
39578856;RHP RELEASE UPDATE 23.26.3.0.0 (39578856) Gold Image
39578865;ACFS RELEASE UPDATE 23.26.3.0.0 (39578865) Gold Image
39578859;OCW RELEASE UPDATE 23.26.3.0.0 (39578859) Gold Image
39578879;Database Release Update : 23.26.3.0.0 (39578879) Gold Image

OPatch succeeded.
[oracle@rhel10rac1 OPatch]$


--OS oracle User .bash_profile 변경
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@rhel10rac1 ~]$
[oracle@rhel10rac1 ~]$ echo $ORACLE_HOME
/u01/app/grid/26.0.0/gdhome_2
[oracle@rhel10rac1 ~]$

Oracle DB 26Ai Gold Image 23.26.3 부터 Oracle Database 26Ai Standard Edition 2 선택 가능

[ Oracle DB 26Ai Gold Image 23.26.3 ]

[환 경]

RHEL 9.6 + Oracle RAC 19c + ASM

[증 상]

$GRID_HOME/crs/install/rootcrs.sh -prepatch -nonrolling 아래와 같은 Error 발생

[root@rac1 ~]# /oradb/app/oracle/grid/19.0.0/crs/install/rootcrs.sh -prepatch -nonrolling
Using configuration parameter file: /oradb/app/oracle/grid/19.0.0/crs/install/crsconfig_params
The log of current session can be found at:
  /oradb/app/base/crsdata/rac1/crsconfig/crs_prepatch_apply_inplace_rac1_2026-07-28_11-34-15AM.log
rac2 : PRKC-1191 : Remote command execution setup check for node rac2 using shell /usr/bin/ssh failed.

load pubkey "/home/oracle/.ssh/id_rsa": Invalid key lengthoracle@rac2: Permission denied (publickey,gssapi-keyex,gssapi-with-mic,password).

2026/07/28 11:34:22 CLSRSC-180: An error occurred while executing the command '/oradb/app/oracle/grid/19.0.0/bin/cluutil -ckpt -global -oraclebase /oradb/app/base -writeckpt -name ROOTCRS_PATCHINFO -state SUCCESS -nodelist rac1,rac2 -transferfile'
2026/07/28 11:34:22 CLSRSC-175: Failed to write the checkpoint 'ROOTCRS_PATCHINFO' with status 'SUCCESS' (error code 0)
2026/07/28 11:34:22 CLSRSC-175: Failed to write the checkpoint 'ROOTCRS_PATCHINFO' with status 'SUCCESS' (error code 0)
Died at /oradb/app/oracle/grid/19.0.0/crs/install/crsutils.pm line 14422.
The command '/oradb/app/oracle/grid/19.0.0/perl/bin/perl -I/oradb/app/oracle/grid/19.0.0/perl/lib -I/oradb/app/oracle/grid/19.0.0/crs/install -I/oradb/app/oracle/grid/19.0.0/xag /oradb/app/oracle/grid/19.0.0/crs/install/rootcrs.pl -prepatch -nonrolling' execution failed
[root@rac1 ~]#

[원 인]

RHEL 9.6의 강화된 SSH 보안 규격에 맞춰 OS oracle 계정의 SSH 키(RSA 3072bit 이상)를 재발급하지 않아 노드 간 등가성(SSH Equivalence)이 깨지면서 발생한 OS 환경적 원인

[해결 방법]

RAC 1번/2번 Node 각각 수행 해야 함

그리고 다시 $GRID_HOME/crs/install/rootcrs.sh -prepatch -nonrolling 수행 하면 됨

[oracle@rac1 ~]$
[oracle@rac1 ~]$ cd ~/.ssh
[oracle@rac1 .ssh]$ ls
authorized_keys  config  config.backup  id_ecdsa  id_ecdsa.pub  id_rsa  id_rsa.pub  known_hosts
[oracle@rac1 .ssh]$ mv id_* old_keys/ 2>/dev/null
[oracle@rac1 .ssh]$ ls -al
total 36
drwxr-xr-x.  2 oracle dba  151 Jul 28 13:09 .
drwx------. 10 oracle dba 4096 Jul 28 11:26 ..
-rw-r--r--.  1 oracle dba  900 May 29 14:28 authorized_keys
-rw-r--r--.  1 oracle dba   23 May 29 14:28 config
-rw-r--r--.  1 oracle dba   21 May 29 14:28 config.backup
-rw-------   1 oracle dba  505 Jul 28 13:07 id_ecdsa
-rw-r--r--   1 oracle dba  173 Jul 28 13:07 id_ecdsa.pub
-rw-------.  1 oracle dba 1044 May 29 14:28 id_rsa
-rw-r--r--.  1 oracle dba  225 May 29 14:28 id_rsa.pub
-rw-r--r--.  1 oracle dba  540 May 29 14:28 known_hosts
[oracle@rac1 .ssh]$
[oracle@rac1 .ssh]$ ssh-keygen -t rsa -b 3072 -N "" -f ~/.ssh/id_rsa
Generating public/private rsa key pair.
/home/oracle/.ssh/id_rsa already exists.
Overwrite (y/n)? y
Your identification has been saved in /home/oracle/.ssh/id_rsa
Your public key has been saved in /home/oracle/.ssh/id_rsa.pub
The key fingerprint is:
SHA256:Jdec38lCb79RSTHTQNzeResgGSrVz+njUmXSHrVOtdQ oracle@rac1
The key's randomart image is:
+---[RSA 3072]----+
|         ... ooB+|
|        . .+o...E|
|       ...oo*o++B|
|        .+  o**X=|
|        S   ..OB+|
|             +ooo|
|            o ...|
|           . .  o|
|            .  . |
+----[SHA256]-----+
[oracle@rac1 .ssh]$ ssh-copy-id oracle@rac1
/usr/bin/ssh-copy-id: INFO: Source of key(s) to be installed: "/home/oracle/.ssh/id_rsa.pub"
/usr/bin/ssh-copy-id: INFO: attempting to log in with the new key(s), to filter out any that are alr
/usr/bin/ssh-copy-id: INFO: 1 key(s) remain to be installed -- if you are prompted now it is to inst
oracle@rac1's password:

Number of key(s) added: 1

Now try logging into the machine, with:   "ssh 'oracle@rac1'"
and check to make sure that only the key(s) you wanted were added.

[oracle@rac1 .ssh]$
[oracle@rac1 .ssh]$ ssh-copy-id oracle@rac2
/usr/bin/ssh-copy-id: INFO: Source of key(s) to be installed: "/home/oracle/.ssh/id_rsa.pub"
/usr/bin/ssh-copy-id: INFO: attempting to log in with the new key(s), to filter out any that are alr
/usr/bin/ssh-copy-id: INFO: 1 key(s) remain to be installed -- if you are prompted now it is to inst
oracle@rac2's password:

Number of key(s) added: 1

Now try logging into the machine, with:   "ssh 'oracle@rac2'"
and check to make sure that only the key(s) you wanted were added.

[oracle@rac1 .ssh]$
[oracle@rac1 ~]$
[oracle@rac1 ~]$ ssh rac1 date
Tue Jul 28 01:12:03 PM KST 2026
[oracle@rac1 ~]$
[oracle@rac1 ~]$
[oracle@rac1 ~]$ ssh rac2 date
Tue Jul 28 01:12:09 PM KST 2026
[oracle@rac1 ~]$