Database Sync

전체 글

Oracle RAC 26Ai RU3 Gold Image Patch - DB_HOME 09:05:34
Oracle RAC 26Ai RU3 Gold Image Patch - GRID_HOME 2026.08.24
Oracle Database 26Ai Standard Edition 2 2026.08.10
PRKC-1191 : Remote command execution setup check for node rac2 using shell /usr/bin/ssh failed. 2026.08.03
Oracle DB 26Ai Read-Only Oracle Home 2026.07.27

Oracle RAC 26Ai RU3 Gold Image Patch - DB_HOME

2026. 8. 31. 09:05

사전 환경 설정

---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 ~]$

Oracle RAC 26Ai RU3 Gold Image Patch - GRID_HOME

2026. 8. 24. 09:05

사전 환경 점검 및 설정

--기존 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 Database 26Ai Standard Edition 2

2026. 8. 10. 09:05

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

[ Oracle DB 26Ai Gold Image 23.26.3 ]

PRKC-1191 : Remote command execution setup check for node rac2 using shell /usr/bin/ssh failed.

2026. 8. 3. 09:05

[환 경]

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 ~]$

Oracle DB 26Ai Read-Only Oracle Home

2026. 7. 27. 09:02

Read-Only 오라클 홈 아키텍처는 순수한 소프트웨어 바이너리(설치본) 영역과 시스템 운영 중에 변경되는 설정 및 로그 데이터 영역을 완벽하게 분리하는 구조를 의미.

주의: '읽기 전용'이라는 표현이 운영체제(OS) 레벨에서 디렉터리나 파일 시스템 자체가 Read-Only로 마운트되어야 함을 뜻하는 것은 아닙니다. 파일 시스템과 마운트 포인트는 항상 읽기/쓰기(Read/Write)가 가능한 상태여야 합

Oracle Home 상태 확인(변경 전)

[oracle@ai26readonly dbhome_1]$
[oracle@ai26readonly dbhome_1]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@ai26readonly dbhome_1]$
[oracle@ai26readonly dbhome_1]$ env | grep SID
ORACLE_SID=CDB1
[oracle@ai26readonly dbhome_1]$ cd $ORACLE_HOME/bin
[oracle@ai26readonly bin]$ pwd
/u01/app/oracle/product/26.0.0/dbhome_1/bin
[oracle@ai26readonly bin]$
[oracle@ai26readonly bin]$ ./orabasehome
/u01/app/oracle/product/26.0.0/dbhome_1
[oracle@ai26readonly bin]$

반환된 경로가 $ORACLE_HOME과 같다면 ➔ Read/Write 모드
반환된 경로가 $ORACLE_BASE/homes/HOME_NAME 형태라면 ➔ Read-Only 모드

Read Only로 변경

[oracle@ai26readonly bin]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@ai26readonly bin]$ pwd
/u01/app/oracle/product/26.0.0/dbhome_1/bin
[oracle@ai26readonly bin]$
[oracle@ai26readonly bin]$ ls -al roohctl
-rwxr-x---. 1 oracle dba 5250 Jul  1 15:04 roohctl
[oracle@ai26readonly bin]$
[oracle@ai26readonly bin]$ ./roohctl -enable
Enabling Read-Only Oracle home.
Update orabasetab file to enable Read-Only Oracle home.
Orabasetab file has been updated successfully.
Create bootstrap directories for Read-Only Oracle home.
Bootstrap directories have been created successfully.
Bootstrap files have been processed successfully.
Bootstrap files have been processed successfully.
Read-Only Oracle home has been enabled successfully.
Check the log file /u01/app/oracle/cfgtoollogs/roohctl/roohctl-260701PM033927.log for more details.
[oracle@ai26readonly bin]$
[oracle@ai26readonly bin]$ ./orabasehome
/u01/app/oracle/homes/OraDB23Home1
[oracle@ai26readonly bin]$
[oracle@ai26readonly bin]$ cd /u01/app/oracle/homes/OraDB23Home1
[oracle@ai26readonly OraDB23Home1]$ ls
assistants  dbs  drdaas  hs  install  mgw  network  rdbms
[oracle@ai26readonly OraDB23Home1]$

Oracle DB,리스너 생성 후 확인

[oracle@ai26readonly ~]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@ai26readonly ~]$ env | grep SID
ORACLE_SID=CDB1
[oracle@ai26readonly ~]$
[oracle@ai26readonly ~]$ ps -ef | grep tns
root           8       2  0 08:48 ?        00:00:00 [kworker/R-netns]
oracle     30580       1  0 13:00 ?        00:00:00 /u01/app/oracle/product/26.0.0/dbhome_1/bin/tnslsnr LISTENER -inherit
oracle     30625    4282  0 13:01 pts/0    00:00:00 grep --color=auto tns
[oracle@ai26readonly ~]$
[oracle@ai26readonly ~]$
[oracle@ai26readonly ~]$ lsnrctl status

LSNRCTL for Linux: Version 23.26.1.0.0 - Production on 02-JUL-2026 13:01:51

Copyright (c) 1991, 2026, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ai26readonly)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 23.26.1.0.0 - Production
Start Date                02-JUL-2026 13:00:49
Uptime                    0 days 0 hr. 1 min. 1 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/homes/OraDB23Home1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/ai26readonly/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ai26readonly)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "5598f6714447661ae0636538a8c0b5af" has 1 instance(s).
  Instance "CDB1", status READY, has 1 handler(s) for this service...
Service "CDB1" has 1 instance(s).
  Instance "CDB1", status READY, has 1 handler(s) for this service...
Service "CDB1XDB" has 1 instance(s).
  Instance "CDB1", status READY, has 1 handler(s) for this service...
Service "pdb1" has 1 instance(s).
  Instance "CDB1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@ai26readonly ~]$
[oracle@ai26readonly ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 23.26.1.0.0 - Production on Thu Jul 2 13:01:57 2026
Version 23.26.1.0.0

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


Connected to:
Oracle AI Database 26ai Enterprise Edition Release 23.26.1.0.0 - Production
Version 23.26.1.0.0

SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/app/oracle/dbs/spfileCDB1.ora
SQL> exit
Disconnected from Oracle AI Database 26ai Enterprise Edition Release 23.26.1.0.0 - Production
Version 23.26.1.0.0
[oracle@ai26readonly ~]$

PREV 1 2 3 4 ···12 NEXT