반응형

※RAC 전체 Node를 각각 실행 해야 함

Oracle RAC관련 필수 파일 백업

/etc 밑에 있는 File Backup

---/etc/oratab
[oracle@rac1 DATASYNCXML]$ pwd
/home/oracle/DATASYNCXML
[oracle@rac1 DATASYNCXML]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba)
[oracle@rac1 DATASYNCXML]$ ls -al /etc/oratab
-rw-rw-r--. 1 oracle dba 741 May 21 09:15 /etc/oratab
[oracle@rac1 DATASYNCXML]$ cp /etc/oratab ./oratab_backup_20260526
[oracle@rac1 DATASYNCXML]$ ls -al
total 92
drwxr-xr-x. 2 oracle dba    82 May 26 10:01 .
drwx------. 9 oracle dba  4096 May 22 09:06 ..
-rw-r-----. 1 oracle dba 27042 May 21 14:41 dbca.rsp
-rw-r--r--. 1 oracle dba 19881 May 21 10:08 db.rsp
-rw-r--r--. 1 oracle dba 36699 May 21 09:00 grid.rsp
-rw-r--r--  1 oracle dba   741 May 26 10:01 oratab_backup_20260526
[oracle@rac1 DATASYNCXML]$

---/etc/oraInst.loc,/etc/oracle.ahf.loc,/etc/oracle
[root@rac1 etc]# id
uid=0(root) gid=0(root) groups=0(root)
[root@rac1 etc]# pwd
/etc
[root@rac1 etc]# ls -al *.loc
-rw-r--r--. 1 root root 16 May 21 13:41 oracle.ahf.loc
-rw-r--r--. 1 root root 53 May 21 09:15 oraInst.loc
[root@rac1 etc]#
[root@rac1 etc]# cp oracle.ahf.loc /home/oracle/DATASYNCXML/oracle.ahf.loc_backup_20260528
[root@rac1 etc]# cp oraInst.loc /home/oracle/DATASYNCXML/oraInst.loc_20260528
[root@rac1 etc]# ls -al /home/oracle/DATASYNCXML/
total 100
drwxr-xr-x. 2 oracle dba    148 May 26 10:04 .
drwx------. 9 oracle dba   4096 May 22 09:06 ..
-rw-r-----. 1 oracle dba  27042 May 21 14:41 dbca.rsp
-rw-r--r--. 1 oracle dba  19881 May 21 10:08 db.rsp
-rw-r--r--. 1 oracle dba  36699 May 21 09:00 grid.rsp
-rw-r--r--  1 root   root    16 May 26 10:03 oracle.ahf.loc_backup_20260528
-rw-r--r--  1 root   root    53 May 26 10:04 oraInst.loc_20260528
-rw-r--r--  1 oracle dba    741 May 26 10:01 oratab_backup_20260526
[root@rac1 etc]#
[root@rac1 etc]# cd oracle
[root@rac1 oracle]# pwd
/etc/oracle
[root@rac1 oracle]# ls
lastgasp  maps  ocr.loc  ocr.loc.orig  olr.loc  olr.loc.orig  oprocd  scls_scr  setasmgid
[root@rac1 oracle]# cd ..
[root@rac1 etc]# tar -cvf /home/oracle/DATASYNCXML/etc_oracle.tar_20260528 ./oracle
./oracle/
./oracle/lastgasp/
./oracle/lastgasp/cssmonit_rac1.lgl
./oracle/lastgasp/cssagent_rac1.lgl
./oracle/oprocd/
./oracle/oprocd/check/
./oracle/oprocd/stop/
./oracle/oprocd/fatal/
./oracle/scls_scr/
./oracle/scls_scr/rac1/
./oracle/scls_scr/rac1/root/
./oracle/scls_scr/rac1/root/rdsmodld
./oracle/scls_scr/rac1/root/crsstart
./oracle/scls_scr/rac1/root/ohasdrun
./oracle/scls_scr/rac1/root/ohasdinitpid
./oracle/scls_scr/rac1/root/ohasdstr
./oracle/scls_scr/rac1/oracle/
./oracle/scls_scr/rac1/oracle/cssfatal
./oracle/maps/
./oracle/olr.loc
./oracle/ocr.loc
./oracle/ocr.loc.orig
./oracle/olr.loc.orig
./oracle/setasmgid
[root@rac1 etc]#
[root@rac1 etc]# ls -al /home/oracle/DATASYNCXML/
total 4240
drwxr-xr-x. 2 oracle dba      179 May 26 10:05 .
drwx------. 9 oracle dba     4096 May 22 09:06 ..
-rw-r-----. 1 oracle dba    27042 May 21 14:41 dbca.rsp
-rw-r--r--. 1 oracle dba    19881 May 21 10:08 db.rsp
-rw-r--r--  1 root   root 4239360 May 26 10:05 etc_oracle.tar_20260528
-rw-r--r--. 1 oracle dba    36699 May 21 09:00 grid.rsp
-rw-r--r--  1 root   root      16 May 26 10:03 oracle.ahf.loc_backup_20260528
-rw-r--r--  1 root   root      53 May 26 10:04 oraInst.loc_20260528
-rw-r--r--  1 oracle dba      741 May 26 10:01 oratab_backup_20260526
[root@rac1 etc]#

 

OS 설정 File Backup

[root@rac1 ~]#
[root@rac1 ~]# id
uid=0(root) gid=0(root) groups=0(root)
[root@rac1 ~]# cd /etc
[root@rac1 etc]# ls -al hosts
-rw-r--r--. 1 root root 407 May 20 15:27 hosts
[root@rac1 etc]#
[root@rac1 etc]# cp hosts /home/oracle/DATASYNCXML/hosts_backup_20260526
[root@rac1 etc]#
[root@rac1 etc]# cd sysctl.d/
[root@rac1 sysctl.d]# pwd
/etc/sysctl.d
[root@rac1 sysctl.d]# ls
50-libreswan.conf  98-oracle.conf  99-sysctl.conf
[root@rac1 sysctl.d]#
[root@rac1 sysctl.d]# cp 98-oracle.conf /home/oracle/DATASYNCXML/98-oracle.conf_backup_20260528
[root@rac1 sysctl.d]# cp 99-sysctl.conf /home/oracle/DATASYNCXML/99-sysctl.conf_backup_20260528
[root@rac1 sysctl.d]#
[root@rac1 sysctl.d]# cd ..
[root@rac1 etc]# ls -al sysctl.conf
-rw-r--r--. 1 root root 449 Feb  8  2022 sysctl.conf
[root@rac1 etc]#
[root@rac1 etc]# cp sysctl.conf /home/oracle/DATASYNCXML/sysctl.conf_backup_20260628
[root@rac1 etc]#
[root@rac1 etc]# cd /etc/security/limits.d
[root@rac1 limits.d]# ls
oracle-database-server-19c-preinstall.conf
[root@rac1 limits.d]#
[root@rac1 limits.d]# cp oracle-database-server-19c-preinstall.conf /home/oracle/DATASYNCXML/oracle-database-server-19c-preinstall.conf_backup_20260528
[root@rac1 limits.d]# cd /home/oracle/DATASYNCXML
[root@rac1 DATASYNCXML]# ls -al
total 4264
drwxr-xr-x. 2 oracle dba     4096 May 26 10:11 .
drwx------. 9 oracle dba     4096 May 22 09:06 ..
-rw-r--r--  1 root   root     376 May 26 10:08 98-oracle.conf_backup_20260528
-rw-r--r--  1 root   root     449 May 26 10:09 99-sysctl.conf_backup_20260528
-rw-r-----. 1 oracle dba    27042 May 21 14:41 dbca.rsp
-rw-r--r--. 1 oracle dba    19881 May 21 10:08 db.rsp
-rw-r--r--  1 root   root 4239360 May 26 10:05 etc_oracle.tar_20260528
-rw-r--r--. 1 oracle dba    36699 May 21 09:00 grid.rsp
-rw-r--r--  1 root   root     407 May 26 10:07 hosts_backup_20260526
-rw-r--r--  1 root   root      16 May 26 10:03 oracle.ahf.loc_backup_20260528
-rw-r--r--  1 root   root     261 May 26 10:11 oracle-database-server-19c-preinstall.conf_backup_20260528
-rw-r--r--  1 root   root      53 May 26 10:04 oraInst.loc_20260528
-rw-r--r--  1 oracle dba      741 May 26 10:01 oratab_backup_20260526
-rw-r--r--  1 root   root     449 May 26 10:10 sysctl.conf_backup_20260628
[root@rac1 DATASYNCXML]#

 

Oracle GRID 관련 백업

----OCR/VOTE
[root@rac1 bin]#
[root@rac1 bin]# pwd
/oradb/app/oracle/grid/19.0.0/bin
[root@rac1 bin]# ls -al ocrbackup
ls: cannot access 'ocrbackup': No such file or directory
[root@rac1 bin]#
[root@rac1 bin]#
[root@rac1 bin]# id
uid=0(root) gid=0(root) groups=0(root)
[root@rac1 bin]# pwd
/oradb/app/oracle/grid/19.0.0/bin
[root@rac1 bin]#
[root@rac1 bin]# ls -al ocrconfig
-rwxr-xr-x. 1 root dba 11567 May 21 13:36 ocrconfig
[root@rac1 bin]#
[root@rac1 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     491684
         Used space (kbytes)      :      84488
         Available space (kbytes) :     407196
         ID                       : 1590616498
         Device/File Name         :   +OCRVOTE
                                    Device/File integrity check succeeded
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
         Cluster registry integrity check succeeded
         Logical corruption check succeeded
[root@rac1 bin]#
[root@rac1 bin]# ./ocrconfig -showbackup
PROT-24: Auto backups for the Oracle Cluster Registry are not available
rac2     2026/05/22 09:58:31     +OCRVOTE:/racdb/OCRBACKUP/backup_20260522_095831.ocr.259.123391                                                                                                      4311     3669234883
rac1     2026/05/21 13:40:14     +OCRVOTE:/racdb/OCRBACKUP/backup_20260521_134014.ocr.258.123384                                                                                                      1215     526767740
[root@rac1 bin]#
[root@rac1 bin]# ./ocrconfig -manualbackup
rac1     2026/05/26 10:16:51     +OCRVOTE:/racdb/OCRBACKUP/backup_20260526_101651.ocr.260.1234261013     3669234883
rac2     2026/05/22 09:58:31     +OCRVOTE:/racdb/OCRBACKUP/backup_20260522_095831.ocr.259.1233914311     3669234883
rac1     2026/05/21 13:40:14     +OCRVOTE:/racdb/OCRBACKUP/backup_20260521_134014.ocr.258.1233841215     526767740
[root@rac1 bin]#
[root@rac1 bin]# pwd
/oradb/app/oracle/grid/19.0.0/bin
[root@rac1 bin]# cd /home/oracle/DATASYNCXML/
[root@rac1 DATASYNCXML]# pwd
/home/oracle/DATASYNCXML
[root@rac1 DATASYNCXML]# /oradb/app/oracle/grid/19.0.0/bin/ocrconfig -local -manualbackup
rac1     2026/05/26 10:22:07     /oradb/app/base/crsdata/rac1/olr/backup_20260526_102207.olr     3669234883
rac1     2026/05/22 09:58:53     /oradb/app/base/crsdata/rac1/olr/backup_20260522_095853.olr     3669234883
rac1     2026/05/21 13:39:58     /oradb/app/base/crsdata/rac1/olr/backup_20260521_133958.olr     526767740
rac1     2026/05/21 09:41:16     /oradb/app/base/crsdata/rac1/olr/backup_20260521_094116.olr     724960844
[root@rac1 DATASYNCXML]# cp /oradb/app/base/crsdata/rac1/olr/backup_20260526_102207.olr /home/oracle/DATASYNCXML/
[root@rac1 DATASYNCXML]# ls -al
total 5436
drwxr-xr-x. 2 oracle dba     4096 May 26 10:22 .
drwx------. 9 oracle dba     4096 May 22 09:06 ..
-rw-r--r--  1 root   root     376 May 26 10:08 98-oracle.conf_backup_20260528
-rw-r--r--  1 root   root     449 May 26 10:09 99-sysctl.conf_backup_20260528
-rw-------  1 root   root 1200128 May 26 10:22 backup_20260526_102207.olr
-rw-r-----. 1 oracle dba    27042 May 21 14:41 dbca.rsp
-rw-r--r--. 1 oracle dba    19881 May 21 10:08 db.rsp
-rw-r--r--  1 root   root 4239360 May 26 10:05 etc_oracle.tar_20260528
-rw-r--r--. 1 oracle dba    36699 May 21 09:00 grid.rsp
-rw-r--r--  1 root   root     407 May 26 10:07 hosts_backup_20260526
-rw-r--r--  1 root   root      16 May 26 10:03 oracle.ahf.loc_backup_20260528
-rw-r--r--  1 root   root     261 May 26 10:11 oracle-database-server-19c-preinstall.conf_backup_20260528
-rw-r--r--  1 root   root      53 May 26 10:04 oraInst.loc_20260528
-rw-r--r--  1 oracle dba      741 May 26 10:01 oratab_backup_20260526
-rw-r--r--  1 root   root     449 May 26 10:10 sysctl.conf_backup_20260628
[root@rac1 DATASYNCXML]#

----ASM 메타데이터 백업
[oracle@rac1 DATASYNCXML]$
[oracle@rac1 DATASYNCXML]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba)
[oracle@rac1 DATASYNCXML]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@rac1 DATASYNCXML]$ pwd
/home/oracle/DATASYNCXML
[oracle@rac1 DATASYNCXML]$
[oracle@rac1 DATASYNCXML]$ asmcmd md_backup /home/oracle/DATASYNCXML/asm_metadata_backup_20260526.sql
Disk group metadata to be backed up: DATA01
Disk group metadata to be backed up: OCRVOTE
Disk group metadata to be backed up: RECO01
Current alias directory path: OCPRODDB/PASSWORD
Current alias directory path: OCPRODDB/TEMPFILE
Current alias directory path: OCPRODDB/PARAMETERFILE
Current alias directory path: OCPRODDB/CONTROLFILE
Current alias directory path: OCPRODDB/DATAFILE
Current alias directory path: OCPRODDB/ONLINELOG
Current alias directory path: OCPRODDB
Current alias directory path: racdb/OCRFILE
Current alias directory path: racdb
Current alias directory path: racdb/OCRBACKUP
Current alias directory path: racdb/ASMPARAMETERFILE
Current alias directory path: ASM
Current alias directory path: ASM/PASSWORD
Current alias directory path: OCPRODDB/ONLINELOG
Current alias directory path: OCPRODDB
[oracle@rac1 DATASYNCXML]$ ls -al asm_metadata_backup_20260526.sql
-rw-r--r-- 1 oracle dba 45513 May 26 10:25 asm_metadata_backup_20260526.sql
[oracle@rac1 DATASYNCXML]$
[oracle@rac1 DATASYNCXML]$
[oracle@rac1 DATASYNCXML]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba)
[oracle@rac1 DATASYNCXML]$ pwd
/home/oracle/DATASYNCXML
[oracle@rac1 DATASYNCXML]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@rac1 DATASYNCXML]$ sqlplus "/as sysasm"
SQL> create pfile='/home/oracle/DATASYNCXML/asm_init.ora_20260526' from spfile;
File created.
SQL> exit
[oracle@rac1 DATASYNCXML]$ ls -al asm_init.ora_20260526
-rw-r--r-- 1 oracle dba 316 May 26 10:30 asm_init.ora_20260526
[oracle@rac1 DATASYNCXML]$

 

Oracle DB관련 백업

/*
추가적으로 $ORACLE_HOME/network/admin 하위의 listener.ora, tnsnames.ora, sqlnet.ora 백업 필요
*/
[oracle@rac1 DATASYNCXML]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba)
[oracle@rac1 DATASYNCXML]$ pwd
/home/oracle/DATASYNCXML
[oracle@rac1 DATASYNCXML]$ env | grep SID
ORACLE_SID=OCPRODDB1
[oracle@rac1 DATASYNCXML]$
[oracle@rac1 DATASYNCXML]$ sqlplus "/as sysdba"
SQL> create pfile='/home/oracle/DATASYNCXML/db_init.ora_backup_20260526' from spfile;
File created.
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/home/oracle/DATASYNCXML/cr_controlfile.sql_20260526';
Database altered.
SQL> exit
[oracle@rac1 DATASYNCXML]$ ls -al db_init.ora_backup_20260526
-rw-r--r-- 1 oracle dba 1840 May 26 10:28 db_init.ora_backup_20260526
[oracle@rac1 DATASYNCXML]$
[oracle@rac1 DATASYNCXML]$ ls -al cr_controlfile.sql_20260526
-rw-r--r-- 1 oracle dba 8473 May 26 10:32 cr_controlfile.sql_20260526
[oracle@rac1 DATASYNCXML]$
[oracle@rac1 app]$ pwd
/oradb/app
[oracle@rac1 app]$ ls
base  oracle  oraInventory  STAGE
[oracle@rac1 app]$ tar -cvf /home/oracle/DATASYNCXML/oraInventory.tar_backup_20260526 ./oraInventory/
./oraInventory/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
./oraInventory/backup/2026-05-21_08-47-39AM/
./oraInventory/backup/2026-05-21_08-47-39AM/ContentsXML/
./oraInventory/backup/2026-05-21_08-47-39AM/ContentsXML/inventory.xml
./oraInventory/backup/2026-05-21_08-47-39AM/ContentsXML/oui-patch.xml
./oraInventory/backup/2026-05-21_08-47-39AM/ContentsXML/comps.xml
./oraInventory/backup/2026-05-21_08-47-39AM/ContentsXML/libs.xml
./oraInventory/backup/2026-05-21_09-58-18AM/
./oraInventory/backup/2026-05-21_09-58-18AM/ContentsXML/
./oraInventory/backup/2026-05-21_09-58-18AM/ContentsXML/inventory.xml
./oraInventory/backup/2026-05-21_09-58-18AM/ContentsXML/oui-patch.xml
./oraInventory/backup/2026-05-21_09-58-18AM/ContentsXML/comps.xml
./oraInventory/backup/2026-05-21_09-58-18AM/ContentsXML/libs.xml
[oracle@rac1 app]$
[oracle@rac1 app]$ cd /home/oracle/DATASYNCXML/
[oracle@rac1 DATASYNCXML]$ ls -al oraInventory.tar_backup_20260526
-rw-r--r-- 1 oracle dba 37058560 May 26 10:34 oraInventory.tar_backup_20260526
[oracle@rac1 DATASYNCXML]$

 

Oracle DB 중지 및 Oracle CRS 중지

[oracle@rac1 ~]$ srvctl stop instance -d RACDB -i RACDB1
[oracle@rac1 ~]$ su - root
[root@rac1 bin]#
[root@rac1 bin]# id
uid=0(root) gid=0(root) groups=0(root)
[root@rac1 bin]# pwd
/oradb/app/oracle/grid/19.0.0/bin
[root@rac1 bin]#
[root@rac1 bin]# ./crsctl stop crs
[root@rac1 bin]#
[root@rac1 bin]# ./crsctl config crs
CRS-4622: Oracle High Availability Services autostart is enabled.
[root@rac1 bin]#
[root@rac1 bin]# ./crsctl disable crs
CRS-4621: Oracle High Availability Services autostart is disabled.
[root@rac1 bin]#
[root@rac1 bin]# ./crsctl config crs
CRS-4621: Oracle High Availability Services autostart is disabled.
[root@rac1 bin]#

 

OS Upgrade

Redhat 8에서 Redhat9로 OS Upgrade하는 과정에 몇차레 OS rebooting 발생 함

 

OS Upgrade 후 후속 작업

필수 RPM 존재 여부 확인

---필수 rpm 존재 여부 확인
[root@rac1 ~]#
[root@rac1 ~]# id
uid=0(root) gid=0(root) groups=0(root)
[root@rac1 ~]#
[root@rac1 ~]# rpm -qa | grep cvuqdisk
cvuqdisk-1.0.10-1.x86_64
[root@rac1 ~]#
[root@rac1 ~]# rpm -qa | grep compat-openssl11
[root@rac1 ~]#
[root@rac1 ~]# dnf install compat-openssl11 -y
Updating Subscription Management repositories.
Unable to read consumer identity

This system is not registered with an entitlement server. You can use "rhc" or "subscription-manager" to register.

Last metadata expiration check: 1:22:32 ago on Tue 26 May 2026 01:51:25 PM KST.
Dependencies resolved.
======================================================================================================================================================================================================
 Package                                            Architecture                             Version                                              Repository                                     Size
======================================================================================================================================================================================================
Installing:
 compat-openssl11                                   x86_64                                   1:1.1.1k-4.el9_0                                     AppStream96                                   1.5 M

Transaction Summary
======================================================================================================================================================================================================
Install  1 Package

Total size: 1.5 M
Installed size: 3.7 M
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                                                                              1/1
  Installing       : compat-openssl11-1:1.1.1k-4.el9_0.x86_64                                                                                                                                     1/1
  Running scriptlet: compat-openssl11-1:1.1.1k-4.el9_0.x86_64                                                                                                                                     1/1
  Verifying        : compat-openssl11-1:1.1.1k-4.el9_0.x86_64                                                                                                                                     1/1
Installed products updated.

Installed:
  compat-openssl11-1:1.1.1k-4.el9_0.x86_64

Complete!
[root@rac1 ~]#

 

Update the Oracle Clusterware operating system files

[root@rac2 bin]#
[root@rac2 bin]# id
uid=0(root) gid=0(root) groups=0(root)
[root@rac2 bin]#
[root@rac2 bin]# pwd
/oradb/app/oracle/grid/19.0.0/bin
[root@rac2 bin]#
[root@rac2 bin]# ./crsctl config crs
CRS-4621: Oracle High Availability Services autostart is disabled.
[root@rac2 bin]#
[root@rac2 bin]# cd /oradb/app/oracle/grid/19.0.0/crs/install
[root@rac2 install]#
[root@rac2 install]# ls -al rootcrs.sh
-rwxr-x---. 1 root dba 8055 May 21 09:07 rootcrs.sh
[root@rac2 install]#
[root@rac2 install]# ./rootcrs.sh -updateosfiles
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/rac2/crsconfig/crsupdate_osfiles_rac2_2026-05-26_05-19-08PM.log
Redirecting to /bin/systemctl restart rsyslog.service
2026/05/26 17:19:16 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
[root@rac2 install]#
[root@rac2 install]#
[root@rac2 install]# cd /oradb/app/oracle/grid/19.0.0/bin/
[root@rac2 bin]#
[root@rac2 bin]# ./crsctl config crs
CRS-4622: Oracle High Availability Services autostart is enabled.
[root@rac2 bin]#

 

Oracle CRS / DB 시작

[root@rac1 bin]#
[root@rac1 bin]#
[root@rac1 bin]# ./crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@rac1 bin]#
[root@rac1 bin]# su - oracle
[oracle@rac1 ~]$ id
uid=5001(oracle) gid=500(dba) groups=500(dba)
[oracle@rac1 ~]$
[oracle@rac1 ~]$ env | grep SID
ORACLE_SID=OCPRODDB1
[oracle@rac1 ~]$ srvctl stop instance -d RACDB -i RACDB1
[oracle@rac1 ~]$

 

기타사항

주의사항

 

참고문서

반응형
반응형

보안 및 감사(Security & Auditing)

  • 기존 감사(Traditional Auditing) 지원 중단
    • AUDIT_TRAIL, AUDIT_FILE_DEST, AUDIT_SYS_OPERATIONS와 같은 초기화 파라미터가 더 이상 지원 않음.
    • 기존의 `AUDIT` 명령어를 통한 설정 대신, 통합 감사(Unified Auditing)기능을 사용해야 함(기본값으로 활성화됨)
  • Oracle Wallet Manager (OWM) 지원 중단
    • GUI 기반의 OWM 툴은 더 이상 지원되지 않으며, 커맨드 라인 툴인 orapki를 사용해야 함.
  • 구버전 암호 검증기(Verifier) 지원 중단
    • Oracle Database 10g, 11g 기반의 암호 검증기(대소문자 구분 없음 등)는 더 이상 지원되지 않음. 
    • SQLNET.ALLOWED_LOGON_VERSION_SERVER 설정을 최신 보안 표준(12c 이상)에 맞게 변경 해야 함.


관리 도구 및 유틸리티(Tools & Utilities)

  • Database Upgrade Assistant (DBUA) 지원 중단
    • GUI 기반의 업그레이드 도구인 DBUA 대신, 커맨드 라인 기반의 AutoUpgrade 유틸리티를 사용해야 함.
  • EM Express (Enterprise Manager Database Express) 지원 중단
    • 데이터베이스 내장형 웹 관리 도구인 EM Express가 제거 됨. 
    • 대신 SQL Developer, OCI Database Management 서비스 또는 Oracle EM Cloud Control을 사용해야 함.
  • 기존 Export/Import 유틸리티 (EXP) 지원 중단
    • exp 유틸리티는 지원이 중단 됨 따라서 Data Pump(expdp/impdp)를 사용해야 함.
  • Data Recovery Advisor(DRA) 지원 중단
    • RMAN의 LIST FAILURE, ADVISE FAILURE, REPAIR FAILURE 명령어는 더 이상 지원되지 않음.

 

초기화 파라미터(Initialization Parameters)

  • 다음 파라미터들은 더 이상 사용할 수 없거나 무시 됨
    • DB_BIG_TABLE_CACHE_PERCENT_TARGET
    • AUDIT_TRAIL
    • CLUSTER_DATABASE_INSTANCES
    • REMOTE_OS_AUTHENT

아키텍처 및 기타(Architecture & Others)

  • Policy-Managed Databases 지원 중단
    • Oracle RAC에서 정책 기반(Policy-Managed)배포 방식은 지원되지 않으며, 관리자 기반(Admin-Managed) 방식을 사용해야 함.
  • Grid Infrastructure Management Repository(GIMR) 지원 변경
    • Oracle Standalone Cluster 등의 특정 환경에서 GIMR은 더 이상 지원되지 않거나 선택 사항이 변경 됨
  • DBMS_JOB 패키지
    • 오랫동안 사용 자제(Deprecated)권고되었던 DBMS_JOB은 지원이 중단 됨. DBMS_SCHEDULER로 변경해야 함

https://docs.oracle.com/en/database/oracle/oracle-database/26/upgrd/oracle-database-changes-deprecations-desupports.html#GUID-D82C2C1B-FC39-41CD-BE96-911E61213AA6

반응형
반응형

Oracle RAC 26 Ai Grid 

###############################################################################
## Copyright(c) Oracle Corporation 1998,2025. All rights reserved.           ##
##                                                                           ##
## Specify values for the variables listed below to customize                ##
## your installation.                                                        ##
##                                                                           ##
## Each variable is associated with a comment. The comment                   ##
## can help to populate the variables with the appropriate                   ##
## values.                                                                   ##
##                                                                           ##
## IMPORTANT NOTE: This file contains plain text passwords and               ##
## should be secured to have read permission only by oracle user             ##
## or db administrator who owns this installation.                           ##
##                                                                           ##
###############################################################################

###############################################################################
##                                                                           ##
## Instructions to fill this response file                                   ##
## To register and configure 'Grid Infrastructure for Cluster'               ##
##  - Fill out sections A,B,C,D,E,F and G                                    ##
##  - Fill out section G if OCR and Voting File should be placed on ASM      ##
##                                                                           ##
## To register and configure 'Grid Infrastructure for Standalone server'     ##
##  - Fill out sections A,B and G                                            ##
##                                                                           ##
## To register software for 'Grid Infrastructure'                            ##
##  - Fill out sections A,B and D                                            ##
##  - Provide the cluster nodes in section D when choosing CRS_SWONLY as     ##
##    installation option in section A                                       ##
##                                                                           ##
## To upgrade clusterware and/or Automatic storage management of earlier     ##
## releases                                                                  ##
##  - Fill out sections A,B,C,D and H                                        ##
##                                                                           ##
## To add more nodes to the cluster                                          ##
##  - Fill out sections A and D                                              ##
##  - Provide the cluster nodes in section D when choosing CRS_ADDNODE as    ##
##    installation option in section A                                       ##
##                                                                           ##
###############################################################################

#------------------------------------------------------------------------------
# Do not change the following system generated value. 
#------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v23.0.0

###############################################################################
#                                                                             #
#                          SECTION A - BASIC                                  #
#                                                                             #
###############################################################################
#-------------------------------------------------------------------------------
# Specify the location which holds the inventory files.
# This is an optional parameter if installing on  
# Windows based Operating System.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=/oradb/app/oraInventory

#-------------------------------------------------------------------------------
# Specify the installation option.
# Allowed values: CRS_CONFIG or HA_CONFIG or UPGRADE or CRS_SWONLY or HA_SWONLY
#   - CRS_CONFIG  : To register home and configure Grid Infrastructure for cluster
#   - HA_CONFIG   : To register home and configure Grid Infrastructure for stand alone server
#   - UPGRADE     : To register home and upgrade clusterware software of earlier release
#   - CRS_SWONLY  : To register Grid Infrastructure Software home (can be configured for cluster 
#                   or stand alone server later)
#   - HA_SWONLY   : To register Grid Infrastructure Software home (can be configured for stand 
#                   alone server later. This is only supported on Windows.)
#   - CRS_ADDNODE : To add more nodes to the cluster
#   - CRS_DELETE_NODE : To delete nodes to the cluster
#   - PATCH       : To patch Grid Infrastructure Software
#
# Deprecated: oracle.install.option
#-------------------------------------------------------------------------------
installOption=CRS_CONFIG

#-------------------------------------------------------------------------------
# Specify the complete path of the Oracle Base.
#-------------------------------------------------------------------------------
ORACLE_BASE=/oradb/app/base

#-------------------------------------------------------------------------------
# Specify the usage for the cluster.
# Allowed values: RAC or GENERAL_PURPOSE
#	- RAC             : To configure cluster to manage Oracle RAC databases
#	- GENERAL_PURPOSE : To configure cluster to manage generic applications
#
# Deprecated: oracle.install.crs.config.clusterUsage
#-------------------------------------------------------------------------------
clusterUsage=RAC

#-------------------------------------------------------------------------------
# Specify the patch options. Applicable only if PATCH is selected as install option.
# - zeroDowntimeGIPatching : Set true to use the zero downtime patching option
# - doNotUpdateDriver      : Set true to skip updating ACFS drivers
#
# Deprecated: oracle.install.crs.patch.zeroDowntimeGIPatching 
# Deprecated: oracle.install.crs.patch.doNotUpdateDriver
#-------------------------------------------------------------------------------
zeroDowntimeGIPatching=false
skipDriverUpdate=false

################################################################################
#                                                                              #
#                              SECTION B - GROUPS                              #
#                                                                              #
#   The following three groups need to be assigned for all GI installations.   #
#   OSDBA and OSOPER can be the same or different.  OSASM must be different    #
#   than the other two.                                                        #
#   The value to be specified for OSDBA, OSOPER and OSASM group is only for    #
#   Unix based Operating System.                                               #
#   These groups are not required for upgrades, as they will be determined     #
#   from the Oracle home to upgrade.                                           #
#                                                                              #
################################################################################
#-------------------------------------------------------------------------------
# The OSDBA_GROUP is the OS group which is to be granted SYSDBA privileges.
#
# Deprecated: oracle.install.asm.OSDBA
#-------------------------------------------------------------------------------
OSDBA=dba

#-------------------------------------------------------------------------------
# The OSOPER_GROUP is the OS group which is to be granted SYSOPER privileges.
# The value to be specified for OSOPER group is optional.
# Value should not be provided if configuring Client Cluster - i.e. storageOption=CLIENT_ASM_STORAGE.
#
# Deprecated: oracle.install.asm.OSOPER
#-------------------------------------------------------------------------------
OSOPER=dba

#-------------------------------------------------------------------------------
# The OSASM_GROUP is the OS group which is to be granted SYSASM privileges. This
# must be different than the previous two.
#
# Deprecated: oracle.install.asm.OSASM
#-------------------------------------------------------------------------------
OSASM=dba

################################################################################
#                                                                              #
#                           SECTION C - SCAN                                   #
#                                                                              #
################################################################################
#-------------------------------------------------------------------------------
# Specify the type of SCAN configuration for the cluster
# Allowed values : LOCAL_SCAN and SHARED_SCAN
#
# Deprecated: oracle.install.crs.config.scanType
#-------------------------------------------------------------------------------
scanType=LOCAL_SCAN

#-------------------------------------------------------------------------------
# Applicable only if SHARED_SCAN is being configured for cluster
# Specify the path to the SCAN client data file
#
# Deprecated: oracle.install.crs.config.SCANClientDataFile
#-------------------------------------------------------------------------------
scanClientDataFile=

#-------------------------------------------------------------------------------
# Specify a name for SCAN
# Applicable if LOCAL_SCAN is being configured for the cluster
# If you choose to configure the cluster with GNS with Auto assigned Node VIPs(DHCP),then the scanName should be specified in the format of 'SCAN name.Cluster name.GNS sub-domain'
#
# Deprecated: oracle.install.crs.config.gpnp.scanName
#-------------------------------------------------------------------------------
scanName=racdb-scan

#-------------------------------------------------------------------------------
# Specify a unused port number for SCAN service
#
# Deprecated: oracle.install.crs.config.gpnp.scanPort
#-------------------------------------------------------------------------------
scanPort=1521

################################################################################
#                                                                              #
#                           SECTION D - CLUSTER & GNS                          #
#                                                                              #
################################################################################
#-------------------------------------------------------------------------------
# Specify 'true' if you would like to configure the cluster as Extended, else
# specify 'false'
#
# Deprecated: oracle.install.crs.config.configureAsExtendedCluster
#-------------------------------------------------------------------------------
configureAsExtendedCluster=false

#-------------------------------------------------------------------------------
# Specify a name for the Cluster you are creating.
#
# The maximum length allowed for clustername is 63 characters. The name can be 
# any combination of lower and uppercase alphabets (A - Z), (0 - 9) and hyphens (-).
#
# Deprecated: oracle.install.crs.config.clusterName
#-------------------------------------------------------------------------------
clusterName=racdb

#-------------------------------------------------------------------------------
# Specify 'true' if you would like to configure Grid Naming Service(GNS), else
# specify 'false'
#
# Deprecated: oracle.install.crs.config.gpnp.configureGNS
#-------------------------------------------------------------------------------
configureGNS=false

#-------------------------------------------------------------------------------
# Specify 'true' if you would like to assign SCAN name VIP and Node VIPs by DHCP
# , else specify 'false'
#
# Deprecated: oracle.install.crs.config.autoConfigureClusterNodeVIP
#-------------------------------------------------------------------------------
configureDHCPAssignedVIPs=false

#-------------------------------------------------------------------------------
# Applicable only if you choose to configure GNS.
# Specify the GNS subdomain and an unused virtual hostname for GNS service
#
# Deprecated: oracle.install.crs.config.gpnp.gnsSubDomain
# Deprecated: oracle.install.crs.config.gpnp.gnsVIPAddress
#-------------------------------------------------------------------------------
gnsSubDomain=
gnsVIPAddress=

#-------------------------------------------------------------------------------
# Specify the list of sites - only if configuring an Extended Cluster
#
# Deprecated: oracle.install.crs.config.sites
#-------------------------------------------------------------------------------
sites=

#-------------------------------------------------------------------------------
# Specify the list of nodes that have to be configured to be part of the cluster.
#
# The list should a comma-separated list of tuples.  Each tuple should be a
# colon-separated string that contains
# - 1 field if you have chosen CRS_SWONLY as installation option, or
# - 2 fields if configuring a Flex Cluster
# - 2 fields if adding more nodes to the configured cluster, or
# - 3 fields if configuring an Extended Cluster
# 
# The fields should be ordered as follows:
# 1. The first field should be the public node name.
# 2. The second field should be the virtual host name
#    (Should be specified as AUTO if you have chosen 'auto configure for VIP'
#     i.e. configureDHCPAssignedVIPs=true)
# 3. The third field indicates the site designation for the node. To be specified only if configuring an Extended Cluster.
# Only the 1st field is applicable if you have chosen CRS_SWONLY as installation option

#
# Examples
# For registering GI for a cluster software: clusterNodes=node1,node2
# For adding more nodes to the configured cluster: clusterNodes=node1:node1-vip,node2:node2-vip
# For configuring Flex Cluster: clusterNodes=node1:node1-vip,node2:node2-vip
# For configuring General Purpose Cluster (GPC): clusterNodes=node1:,node2:
# For configuring Extended Cluster: clusterNodes=node1:node1-vip:site1,node2:node2-vip:site2
# You can specify a range of nodes in the tuple using colon separated fields of format
# hostnameprefix:lowerbound-upperbound:hostnamesuffix:vipsuffix
#
# Deprecated: oracle.install.crs.config.clusterNodes
#-------------------------------------------------------------------------------
clusterNodes=rac1:rac1-vip,rac2:rac2-vip

#-------------------------------------------------------------------------------
# The value should be a comma separated strings where each string is as shown below
# InterfaceName:SubnetAddress:InterfaceType
# where InterfaceType can be either "1", "2", "3", "4", or "5"
# InterfaceType stand for the following values
#   - 1 : PUBLIC
#   - 2 : PRIVATE
#   - 3 : DO NOT USE
#   - 4 : ASM
#   - 5 : ASM & PRIVATE
#   - 6 : ALL (Not available for RAC usage)
#
# For example: eth0:140.87.24.0:1,eth1:10.2.1.0:2,eth2:140.87.52.0:3
#
# Deprecated: oracle.install.crs.config.networkInterfaceList
#-------------------------------------------------------------------------------
networkInterfaceList=enp0s3:10.10.10.0:1,enp0s8:192.168.56.0:5,enp0s9:192.168.57.0:3,enp0s10:192.168.58.0:3

################################################################################
#                                                                              #
#                              SECTION E - STORAGE                             #
#                                                                              #
################################################################################
#-------------------------------------------------------------------------------
# Specify the type of storage to use for Oracle Cluster Registry(OCR) and Voting Files.
#   - FLEX_ASM_STORAGE
#   - CLIENT_ASM_STORAGE
#   - FILE_SYSTEM_STORAGE
#   - EXASCALE_STORAGE
#
# Deprecated: oracle.install.crs.config.storageOption
#-------------------------------------------------------------------------------
storageOption=FLEX_ASM_STORAGE

#-------------------------------------------------------------------------------
# These properties are applicable only if FILE_SYSTEM_STORAGE is chosen for 
# storing OCR and Voting File
# Specify the location(s) for OCR and Voting Files
# Three(3) or one(1) location(s) should be specified for OCR and Voting File, 
# separated by commas.
# Example:
#     For Unix based Operating System:
#     votingFilesLocations=/oradbocfs/storage/vfile1,/oradbocfs/storage/vfile2,/oradbocfs/storage/vfile3
#     ocrLocations=/oradbocfs/storage/ocr1,/oradbocfs/storage/ocr2,/oradbocfs/storage/ocr3
#     For Windows based Operating System OCR/VFILE on shared storage is not supported.
#
# Deprecated: oracle.install.crs.config.sharedFileSystemStorage.votingDiskLocations
# Deprecated: oracle.install.crs.config.sharedFileSystemStorage.ocrLocations
#-------------------------------------------------------------------------------
votingFilesLocations=
ocrLocations=

#-------------------------------------------------------------------------------
# Applicable only if configuring CLIENT_ASM_STORAGE for OCR/Voting File storage
# Specify the path to Client ASM Data file
#
# Deprecated: oracle.install.asm.ClientDataFile
#-------------------------------------------------------------------------------
clientDataFile=

################################################################################
#                                                                              #
#                               SECTION F - IPMI                               #
#                                                                              #
################################################################################
#-------------------------------------------------------------------------------
# Specify 'true' if you would like to configure Intelligent Power Management interface
# (IPMI), else specify 'false'
#
# Deprecated: oracle.install.crs.config.useIPMI
#-------------------------------------------------------------------------------
useIPMI=false

#-------------------------------------------------------------------------------
# Applicable only if you choose to configure IPMI
# i.e. useIPMI=true
# Specify the location of the ipmiutil binary 
# Specify the username and password for using IPMI service
#
# Deprecated: oracle.install.crs.config.ipmi.bmcBinpath
# Deprecated: oracle.install.crs.config.ipmi.bmcUsername
# Deprecated: oracle.install.crs.config.ipmi.bmcPassword
#-------------------------------------------------------------------------------
bmcBinpath=
bmcUsername=
bmcPassword=

################################################################################
#                                                                              #
#                                SECTION G - ASM                               #
#                                                                              #
################################################################################
#-------------------------------------------------------------------------------
# Password for SYS user of Oracle ASM
#
# Deprecated: oracle.install.asm.SYSASMPassword
#-------------------------------------------------------------------------------
sysasmPassword=

#-------------------------------------------------------------------------------
# The ASM DiskGroup
#
# Example: diskGroupName=data
#
# Deprecated: oracle.install.asm.diskGroup.name
#-------------------------------------------------------------------------------
diskGroupName=OCRVOTE

#-------------------------------------------------------------------------------
# Redundancy level to be used by ASM.
# It can be one of the following  
#   - NORMAL
#   - HIGH
#   - EXTERNAL
#   - FLEX
#   - EXTENDED (only if configureAsExtendedCluster=true)
# Example: redundancy=NORMAL
#
# Deprecated: oracle.install.asm.diskGroup.redundancy
#-------------------------------------------------------------------------------
redundancy=NORMAL

#-------------------------------------------------------------------------------
# Allocation unit size to be used by ASM.
# It can be one of the following values
#   - 1
#   - 2
#   - 4
#   - 8
#   - 16
#   - 32
#   - 64
# Example: auSize=4
# size unit is MB
#
# Deprecated: oracle.install.asm.diskGroup.AUSize
#-------------------------------------------------------------------------------
auSize=4

#-------------------------------------------------------------------------------
# Failure Groups for the disk group
# If configuring for Extended cluster specify as list of "failure group name:site"
# tuples.
# Else just specify as list of failure group names
#
# Deprecated: oracle.install.asm.diskGroup.FailureGroups
#-------------------------------------------------------------------------------
failureGroups=

#-------------------------------------------------------------------------------
# List of disks and their failure groups to create a ASM DiskGroup
# (Use this if each of the disks have an associated failure group)
# Failure Groups are not required if redundancy=EXTERNAL
# Example:
#     For Unix based Operating System:
#     disksWithFailureGroupNames=/oracle/asm/disk1,FGName,/oracle/asm/disk2,FGName
#     For Windows based Operating System:
#     disksWithFailureGroupNames=\\.\ORCLDISKDATA0,FGName,\\.\ORCLDISKDATA1,FGName
#
# Deprecated: oracle.install.asm.diskGroup.disksWithFailureGroupNames
#-------------------------------------------------------------------------------
disksWithFailureGroupNames=/dev/oracleasm/asm-disk01,,/dev/oracleasm/asm-disk02,,/dev/oracleasm/asm-disk03,

#-------------------------------------------------------------------------------
# List of disks to create a ASM DiskGroup
# (Use this variable only if failure groups configuration is not required)
# Example:
#     For Unix based Operating System:
#     diskList=/oracle/asm/disk1,/oracle/asm/disk2
#     For Windows based Operating System:
#     diskList=\\.\ORCLDISKDATA0,\\.\ORCLDISKDATA1
#
# Deprecated: oracle.install.asm.diskGroup.disks
#-------------------------------------------------------------------------------
diskList=/dev/oracleasm/asm-disk01,/dev/oracleasm/asm-disk02,/dev/oracleasm/asm-disk03

#-------------------------------------------------------------------------------
# List of failure groups to be marked as QUORUM.
# Quorum failure groups contain only Voting File, no user data is stored
# Example:
#	quorumFailureGroupNames=FGName1,FGName2
#
# Deprecated: oracle.install.asm.diskGroup.quorumFailureGroupNames
#-------------------------------------------------------------------------------
quorumFailureGroupNames=

#-------------------------------------------------------------------------------
# The disk discovery string to be used to discover the disks used create a ASM DiskGroup
#
# Example:
#     For Unix based Operating System:
#     diskString=/oracle/asm/*
#     For Windows based Operating System:
#     diskString=\\.\ORCLDISK*
#
# Note: Refrain from enclosing the disk discovery string with single quotes (' ') or double quotes (" ").
#
# Deprecated: oracle.install.asm.diskGroup.diskDiscoveryString
#-------------------------------------------------------------------------------
diskString=/dev/oracleasm/*

#-------------------------------------------------------------------------------
# Password for ASMSNMP account
# ASMSNMP account is used by Oracle Enterprise Manager to monitor Oracle ASM instances
#
# Deprecated: oracle.install.asm.monitorPassword
#-------------------------------------------------------------------------------
asmsnmpPassword=


################################################################################
#                                                                              #
#                             SECTION H - UPGRADE                              #
#                                                                              #
################################################################################
#-------------------------------------------------------------------------------
# Specify whether to ignore down nodes during upgrade operation.
# Value should be 'true' to ignore down nodes otherwise specify 'false'
#
# Deprecated: oracle.install.crs.config.ignoreDownNodes
#-------------------------------------------------------------------------------
ignoreDownNodes=false

################################################################################
#                                                                              #
#                               SECTION I - OCR BACKUP                         #
#                                                                              #
################################################################################
#------------------------------------------------------------------------------
# Create a separate ASM DiskGroup to store Clusterware data.
# Specify 'true' if you would like to store backup of Clusterware data, 
# else specify 'false'
# Value can be true/false.
#------------------------------------------------------------------------------
configureBackupDG=false

#-------------------------------------------------------------------------------
# Backup Storage data ASM DiskGroup
# Applicable only when 
# configureBackupDG=true
# Example: backupDGName=RECO
#-------------------------------------------------------------------------------
backupDGName=RECO

#-------------------------------------------------------------------------------
# Redundancy level to be used by ASM.
# It can be one of the following  
#   - NORMAL
#   - HIGH
#   - EXTERNAL
#   - FLEX
#   - EXTENDED (only if configureAsExtendedCluster=true)
# Example: backupDGRedundancy=NORMAL
#-------------------------------------------------------------------------------
backupDGRedundancy=NORMAL

#-------------------------------------------------------------------------------
# Allocation unit size to be used by ASM.
# It can be one of the following values
#   - 1
#   - 2
#   - 4
#   - 8
#   - 16
#   - 32
#   - 64
# Example: backupDGAUSize=4
# size unit is MB
#-------------------------------------------------------------------------------
backupDGAUSize=4

#-------------------------------------------------------------------------------
# Failure Groups for the backup storage data ASM disk group
# If configuring for Extended cluster specify as list of "failure group name:site"
# tuples.
# Else just specify as list of failure group names
#-------------------------------------------------------------------------------
backupDGFailureGroups=

#-------------------------------------------------------------------------------
# List of disks and their failure groups to create backup data ASM DiskGroup
# (Use this if each of the disks have an associated failure group)
# Failure Groups are not required if backupDGRedundancy=EXTERNAL
# Example:
#     For Unix based Operating System:
#     backupDGDisksWithFailureGroupNames=/oracle/asm/disk1,FGName,/oracle/asm/disk2,FGName
#     For Windows based Operating System:
#     backupDGDisksWithFailureGroupNames=\\.\ORCLDISKDATA0,FGName,\\.\ORCLDISKDATA1,FGName
#-------------------------------------------------------------------------------
backupDGDisksWithFailureGroupNames=

#-------------------------------------------------------------------------------
# List of disks to create backup data ASM DiskGroup
# (Use this variable only if failure groups configuration is not required)
# Example:
#     For Unix based Operating System:
#     backupDGDiskList=/oracle/asm/disk1,/oracle/asm/disk2
#     For Windows based Operating System:
#     backupDGDiskList=\\.\ORCLDISKDATA0,\\.\ORCLDISKDATA1
#-------------------------------------------------------------------------------
backupDGDiskList=

#-------------------------------------------------------------------------------
# List of failure groups to be marked as QUORUM.
# Quorum failure groups contain only Voting File, no user data is stored
# Example:
#	backupDGQuorumFailureGroups=FGName1,FGName2
#-------------------------------------------------------------------------------
backupDGQuorumFailureGroups=

             
################################################################################
#                                                                              #
#                               MANAGEMENT OPTIONS                             #
#                                                                              #
################################################################################
#-------------------------------------------------------------------------------
# Specify the management option to use for managing Oracle Grid Infrastructure
# Options are:
# 1. CLOUD_CONTROL - If you want to manage your Oracle Grid Infrastructure with Enterprise Manager Cloud Control.
# 2. NONE   -If you do not want to manage your Oracle Grid Infrastructure with Enterprise Manager Cloud Control.
#
# Deprecated: oracle.install.config.managementOption
#-------------------------------------------------------------------------------
managementOption=NONE

#-------------------------------------------------------------------------------
# Specify the OMS host to connect to Cloud Control.
# Applicable only when managementOption=CLOUD_CONTROL
#
# Deprecated: oracle.install.config.omsHost
#-------------------------------------------------------------------------------
omsHost=

#-------------------------------------------------------------------------------
# Specify the OMS port to connect to Cloud Control.
# Applicable only when oracle.install.config.managementOption=CLOUD_CONTROL
#
# Deprecated: oracle.install.config.omsPort
#-------------------------------------------------------------------------------
omsPort=0

#-------------------------------------------------------------------------------
# Specify the EM Admin user name to use to connect to Cloud Control.
# Applicable only when managementOption=CLOUD_CONTROL
#
# Deprecated: oracle.install.config.emAdminUser
#-------------------------------------------------------------------------------
emAdminUser=

#-------------------------------------------------------------------------------
# Specify the EM Admin password to use to connect to Cloud Control.
# Applicable only when managementOption=CLOUD_CONTROL
#
# Deprecated: oracle.install.config.emAdminPassword
#-------------------------------------------------------------------------------
emAdminPassword=

################################################################################
#                                                                              #
#                      Root script execution configuration                     #
#                                                                              #
################################################################################
#-------------------------------------------------------------------------------------------------------
# Specify the root script execution mode.
#
#   - true  : To run the root script automatically by using the appropriate configuration methods.
#   - false : To run the root script manually.
#
# If this option is selected, password should be specified on the console.
#
# Deprecated: oracle.install.crs.rootconfig.executeRootScript
#-------------------------------------------------------------------------------------------------------
executeRootScript=false

#--------------------------------------------------------------------------------------
# Specify the configuration method to be used for automatic root script execution.
#
# Following are the possible choices:
#   - ROOT
#   - SUDO
#
# Deprecated: oracle.install.crs.rootconfig.configMethod
#--------------------------------------------------------------------------------------
configMethod=

#--------------------------------------------------------------------------------------
# Specify the absolute path of the sudo program.
#
# Applicable only when SUDO configuration method was chosen.
#
# Deprecated: oracle.install.crs.rootconfig.sudoPath
#--------------------------------------------------------------------------------------
sudoPath=/usr/local/bin/sudo

#--------------------------------------------------------------------------------------
# Specify the name of the user who is in the sudoers list. 
# Applicable only when SUDO configuration method was chosen.
# Note:For Grid Infrastructure for Standalone server installations,the sudo user name must be the username of the user performing the installation.
#
# Deprecated: oracle.install.crs.rootconfig.sudoUserName
#--------------------------------------------------------------------------------------
sudoUserName=oracle

#--------------------------------------------------------------------------------------
# Specify the nodes batch map.
#
# This should be a comma separated list of node:batch pairs.
# During upgrade, you can sequence the automatic execution of root scripts
# by pooling the nodes into batches. 
# A maximum of three batches can be specified. 
# Installer will execute the root scripts on all the nodes in one batch before
# proceeding to next batch.
# Root script execution on the local node must be in Batch 1.
# Examples: 
# 1. batchInfo=Node1:1,Node2:2,Node3:2,Node4:3
# 2. batchInfo=Node1:1,Node2:2,Node3:2,Node4:2
# 3. batchInfo=Node1:1,Node2:1,Node3:2,Node4:3
#
# Applicable only for UPGRADE install option. 
#
# Deprecated: oracle.install.crs.config.batchinfo
#--------------------------------------------------------------------------------------
batchInfo=

#################################################################################
#										#
#			    DELETE NODE OPTIONS					#
#										#
#################################################################################
#--------------------------------------------------------------------------------
# Specify the node names to delete nodes from cluster. 
# Delete node will be performed only for the remote nodes from the cluster.
#
# Deprecated: oracle.install.crs.deleteNode.nodes
#--------------------------------------------------------------------------------
nodesToDelete=

#-------------------------------------------------------------------------------
# Specify 'true' if you would like to configure Automatic Self Correction, else
# specify 'false'
#
# Deprecated: oracle.install.crs.EnableAutoFixup
#-------------------------------------------------------------------------------
enableAutoFixup=false

 

Oracle DB 26Ai Software Only(RAC 기반)

####################################################################
## Copyright(c) Oracle Corporation 1998,2025. All rights reserved.##
##                                                                ##
## Specify values for the variables listed below to customize     ##
## your installation.                                             ##
##                                                                ##
## Each variable is associated with a comment. The comment        ##
## can help to populate the variables with the appropriate        ##
## values.                                                        ##
##                                                                ##
## IMPORTANT NOTE: This file contains plain text passwords and    ##
## should be secured to have read permission only by oracle user  ##
## or db administrator who owns this installation.                ##
##                                                                ##
####################################################################

#------------------------------------------------------------------------------
# Do not change the following system generated value. 
#------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v23.0.0

#-------------------------------------------------------------------------------
# Specify the installation option.
# It can be one of the following:
#   - INSTALL_DB_SWONLY
#   - INSTALL_DB_AND_CONFIG
#
# Deprecated: oracle.install.option
#-------------------------------------------------------------------------------
installOption=INSTALL_DB_SWONLY

#-------------------------------------------------------------------------------
# Specify the Unix group to be set for the inventory directory.  
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=dba

#-------------------------------------------------------------------------------
# Specify the location which holds the inventory files.
# This is an optional parameter if installing on
# Windows based Operating System.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=/oradb/app/oraInventory


#-------------------------------------------------------------------------------
# Specify the complete path of the Oracle Base. 
#-------------------------------------------------------------------------------
ORACLE_BASE=/oradb/app/base

#-------------------------------------------------------------------------------
# Specify the installation edition of the component.                     
#                                                             
# The value should contain only one of these choices.  
      
#   - EE     : Enterprise Edition 
#
# Deprecated: oracle.install.db.InstallEdition
#-------------------------------------------------------------------------------
installEdition=EE

###############################################################################
#                                                                             #
# PRIVILEGED OPERATING SYSTEM GROUPS                                          #
# ------------------------------------------                                  #
# Provide values for the OS groups to which SYSDBA and SYSOPER privileges     #
# needs to be granted. If the install is being performed as a member of the   #
# group "dba", then that will be used unless specified otherwise below.       #
#                                                                             #
# The value to be specified for OSDBA and OSOPER group is only for UNIX based #
# Operating System.                                                           #
#                                                                             #
###############################################################################
#------------------------------------------------------------------------------
# The OSDBA is the OS group which is to be granted SYSDBA privileges.
#
# Deprecated: oracle.install.db.OSDBA_GROUP
#-------------------------------------------------------------------------------
OSDBA=dba

#------------------------------------------------------------------------------
# The OSOPER is the OS group which is to be granted SYSOPER privileges.
# The value to be specified for OSOPER group is optional.
#
# Deprecated: oracle.install.db.OSOPER_GROUP
#------------------------------------------------------------------------------
OSOPER=dba

#------------------------------------------------------------------------------
# The OSBACKUPDBA is the OS group which is to be granted SYSBACKUP privileges.
#
# Deprecated: oracle.install.db.OSBACKUPDBA_GROUP
#------------------------------------------------------------------------------
OSBACKUPDBA=dba

#------------------------------------------------------------------------------
# The OSDGDBA is the OS group which is to be granted SYSDG privileges.
#
# Deprecated: oracle.install.db.OSDGDBA_GROUP
#------------------------------------------------------------------------------
OSDGDBA=dba

#------------------------------------------------------------------------------
# The OSKMDBA is the OS group which is to be granted SYSKM privileges.
#
# Deprecated: oracle.install.db.OSKMDBA_GROUP
#------------------------------------------------------------------------------
OSKMDBA=dba

#------------------------------------------------------------------------------
# The OSRACDBA is the OS group which is to be granted SYSRAC privileges.
#
# Deprecated: oracle.install.db.OSRACDBA_GROUP
#------------------------------------------------------------------------------
OSRACDBA=dba

################################################################################
#                                                                              #
#                      Root script execution configuration                     #
#                                                                              #
################################################################################
#-------------------------------------------------------------------------------------------------------
# Specify the root script execution mode.
#
#   - true  : To run the root script automatically by using the appropriate configuration methods.
#   - false : To run the root script manually.
#
# If this option is selected, password should be specified on the console.
#
# Deprecated: oracle.install.db.rootconfig.executeRootScript
#-------------------------------------------------------------------------------------------------------
executeRootScript=

#--------------------------------------------------------------------------------------
# Specify the configuration method to be used for automatic root script execution.
#
# Following are the possible choices:
#   - ROOT
#   - SUDO
#
# Deprecated: oracle.install.db.rootconfig.configMethod
#--------------------------------------------------------------------------------------
configMethod=

#--------------------------------------------------------------------------------------
# Specify the absolute path of the sudo program.
#
# Applicable only when SUDO configuration method was chosen.
#
# Deprecated: oracle.install.db.rootconfig.sudoPath
#--------------------------------------------------------------------------------------
sudoPath=

#--------------------------------------------------------------------------------------
# Specify the name of the user who is in the sudoers list. 
# Applicable only when SUDO configuration method was chosen.
# Note:For Single Instance database installations,the sudo user name must be the username of the user installing the database.
#
# Deprecated: oracle.install.db.rootconfig.sudoUserName
#--------------------------------------------------------------------------------------
sudoUserName=

###############################################################################
#                                                                             #
#                               Grid Options                                  #
#                                                                             #
###############################################################################
#------------------------------------------------------------------------------
# Value is required only if the specified install option is INSTALL_DB_SWONLY
# 
# Specify the cluster nodes to deploy Enterprise Edition Real Application
# Cluster Database Oracle Home software.
# 
# Example : clusterNodes=node1,node2
#
# Deprecated: oracle.install.db.CLUSTER_NODES
#------------------------------------------------------------------------------
clusterNodes=rac1,rac2

###############################################################################
#                                                                             #
#                        Database Configuration Options                       #
#                                                                             #
###############################################################################
#-------------------------------------------------------------------------------
# Specify the type of database to create.
# It can be one of the following:
#   - GENERAL_PURPOSE                       
#   - DATA_WAREHOUSE 
# GENERAL_PURPOSE: A starter database designed for general purpose use or transaction-heavy applications.
# DATA_WAREHOUSE : A starter database optimized for data warehousing applications.
#
# Deprecated: oracle.install.db.config.starterdb.type
#-------------------------------------------------------------------------------
dbType=GENERAL_PURPOSE

#-------------------------------------------------------------------------------
# Specify the Starter Database Global Database Name. 
#
# Deprecated: oracle.install.db.config.starterdb.globalDBName
#-------------------------------------------------------------------------------
gdbName=

#-------------------------------------------------------------------------------
# Specify the Starter Database SID.
#
# Deprecated: oracle.install.db.config.starterdb.SID
#-------------------------------------------------------------------------------
dbSID=

#-------------------------------------------------------------------------------
# Specify the Pluggable Database name for the pluggable database in Container Database.
#
# Deprecated: oracle.install.db.config.PDBName
#-------------------------------------------------------------------------------
pdbName=

#-------------------------------------------------------------------------------
# Specify the Starter Database character set.
#                                               
#  One of the following
#  AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2,
#  EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257,
#  BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6,
#  AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8,
#  IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE,
#  KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950,
#  ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258
#
# Deprecated: oracle.install.db.config.starterdb.characterSet
#-------------------------------------------------------------------------------
charSet=

#------------------------------------------------------------------------------
# This variable should be set to true if Automatic Memory Management 
# in Database is desired.
# If Automatic Memory Management is not desired, and memory allocation
# is to be done manually, then set it to false.
#
# Deprecated: oracle.install.db.config.starterdb.memoryOption
#------------------------------------------------------------------------------
enableAutoMemoryManagement=false

#-------------------------------------------------------------------------------
# Specify the total memory allocation for the database. Value(in MB) should be
# at least 256 MB, and should not exceed the total physical memory available 
# on the system.
# Example: memoryLimit=512
#
# Deprecated: oracle.install.db.config.starterdb.memoryLimit
#-------------------------------------------------------------------------------
memoryLimit=

###############################################################################
#                                                                             #
# Passwords can be supplied for the following four system accounts in the     #
# starter database:                                                           #
#   SYS                                                                       #
#   SYSTEM                                                                    #
#   DBSNMP (used by Enterprise Manager)                                       #
#   PDBADMIN                                                                  #
#                                                                             #
# Same password can be used for all accounts (not recommended)                #
# or different passwords for each account can be provided (recommended)       #
#                                                                             #
###############################################################################
#------------------------------------------------------------------------------
# This variable holds the password that is to be used for all schemas in the
# starter database.
#
# Deprecated: oracle.install.db.config.starterdb.password.ALL
#-------------------------------------------------------------------------------
allSchemaPassword=

#-------------------------------------------------------------------------------
# Specify the SYS password for the starter database.
#
# Deprecated: oracle.install.db.config.starterdb.password.SYS
#-------------------------------------------------------------------------------
sysPassword=

#-------------------------------------------------------------------------------
# Specify the SYSTEM password for the starter database.
#
# Deprecated: oracle.install.db.config.starterdb.password.SYSTEM
#-------------------------------------------------------------------------------
systemPassword=

#-------------------------------------------------------------------------------
# Specify the DBSNMP password for the starter database.
# Applicable only when managementOption=CLOUD_CONTROL
#
# Deprecated: oracle.install.db.config.starterdb.password.DBSNMP
#-------------------------------------------------------------------------------
dbsnmpPassword=

#-------------------------------------------------------------------------------
# Specify the PDBADMIN password required for creation of Pluggable Database in the Container Database.
#
# Deprecated: oracle.install.db.config.starterdb.password.PDBADMIN
#-------------------------------------------------------------------------------
pdbadminPassword=

#-------------------------------------------------------------------------------
# Specify the management option to use for managing the database.
# Options are:
# 1. CLOUD_CONTROL - If you want to manage your database with Enterprise Manager Cloud Control.
# 2. NONE   -If you do not want to manage your database with Enterprise Manager Cloud Control.
#
# Deprecated: oracle.install.db.config.starterdb.managementOption
#-------------------------------------------------------------------------------
managementOption=

#-------------------------------------------------------------------------------
# Specify the OMS host to connect to Cloud Control.
# Applicable only when managementOption=CLOUD_CONTROL
#
# Deprecated: oracle.install.db.config.starterdb.omsHost
#-------------------------------------------------------------------------------
omsHost=

#-------------------------------------------------------------------------------
# Specify the OMS port to connect to Cloud Control.
# Applicable only when managementOption=CLOUD_CONTROL
#
# Deprecated: oracle.install.db.config.starterdb.omsPort
#-------------------------------------------------------------------------------
omsPort=0

#-------------------------------------------------------------------------------
# Specify the EM Admin user name to use to connect to Cloud Control.
# Applicable only when managementOption=CLOUD_CONTROL
#
# Deprecated: oracle.install.db.config.starterdb.emAdminUser
#-------------------------------------------------------------------------------
emAdminUser=

#-------------------------------------------------------------------------------
# Specify the EM Admin password to use to connect to Cloud Control.
# Applicable only when managementOption=CLOUD_CONTROL
#
# Deprecated: oracle.install.db.config.starterdb.emAdminPassword
#-------------------------------------------------------------------------------
emAdminPassword=

###############################################################################
#                                                                             #
# SPECIFY RECOVERY OPTIONS                                 	                  #
# ------------------------------------		                                  #
# Recovery options for the database can be mentioned using the entries below  #
#                                                                             #
###############################################################################
#------------------------------------------------------------------------------
# This variable is to be set to false if database recovery is not required. Else 
# this can be set to true.
#
# Deprecated: oracle.install.db.config.starterdb.enableRecovery
#-------------------------------------------------------------------------------
enableRecovery=false

#-------------------------------------------------------------------------------
# Specify the type of storage to use for the database.
# It can be one of the following:
#   - FILE_SYSTEM_STORAGE
#   - ASM_STORAGE
#
# Deprecated: oracle.install.db.config.starterdb.storageType
#-------------------------------------------------------------------------------
storageType=

#-------------------------------------------------------------------------------
# Specify the database file location which is a directory for datafiles, control
# files, redo logs.         
#
# Applicable only when storageType=FILE_SYSTEM_STORAGE 
#
# Deprecated: oracle.install.db.config.starterdb.fileSystemStorage.dataLocation
#-------------------------------------------------------------------------------
dataLocation=

#-------------------------------------------------------------------------------
# Specify the recovery location.
#
# Applicable only when storageType=FILE_SYSTEM_STORAGE 
#
# Deprecated: oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation
#-------------------------------------------------------------------------------
recoveryLocation=

#-------------------------------------------------------------------------------
# Specify the existing ASM disk groups to be used for storage.
#
# Applicable only when storageType=ASM_STORAGE
#
# Deprecated: oracle.install.db.config.asm.diskGroup
#-------------------------------------------------------------------------------
diskGroup=

#-------------------------------------------------------------------------------
# Specify the password for ASMSNMP user of the ASM instance.                 
#
# Applicable only when storageType=ASM_STORAGE
#
# Deprecated: oracle.install.db.config.asm.ASMSNMPPassword 
#-------------------------------------------------------------------------------
asmsnmpPassword=

 

Oracle RAC 26 Ai DBCA

##############################################################################
##                                                                          ##
##                            DBCA response file                            ##
##                            ------------------                            ##
## Copyright(c) Oracle Corporation 1998,2025. All rights reserved.         ##
##                                                                          ##
## Specify values for the variables listed below to customize               ##
## your installation.                                         		    ##
##                                                            		    ##
## Each variable is associated with a comment. The comment    		    ##
## can help to populate the variables with the appropriate   		    ##
## values.                                                  		    ##
##                                                               	    ##
## IMPORTANT NOTE: This file contains plain text passwords and   	    ##
## should be secured to have read permission only by oracle user 	    ##
## or db administrator who owns this installation.               	    ##
##############################################################################
#-------------------------------------------------------------------------------
# Do not change the following system generated value. 
#-------------------------------------------------------------------------------
responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v23.0.0

#-----------------------------------------------------------------------------
# Name          : gdbName
# Datatype      : String
# Description   : Global database name of the database
# Valid values  : <db_name>.<db_domain> - when database domain isn't NULL
#                 <db_name>             - when database domain is NULL
# Default value : None
# Mandatory     : Yes
#-----------------------------------------------------------------------------
gdbName=CDB

#-----------------------------------------------------------------------------
# Name          : sid
# Datatype      : String
# Description   : System identifier (SID) of the database
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : <db_name> specified in GDBNAME
# Mandatory     : No
#-----------------------------------------------------------------------------
sid=CDB

#-----------------------------------------------------------------------------
# Name          : databaseConfigType
# Datatype      : String
# Description   : database conf type as Single Instance, Real Application Cluster, Real Application Cluster One Nodes database or Standard Edition High Availability
# Valid values  : SI\RAC\RACONENODE\SEHA
# Default value : SI
# Mandatory     : No
#-----------------------------------------------------------------------------
databaseConfigType=RAC

#-----------------------------------------------------------------------------
# Name          : RACOneNodeServiceName
# Datatype      : String
# Description   : Service is required by application to connect to RAC One 
#		  Node Database
# Valid values  : Service Name
# Default value : None
# Mandatory     : No [required in case DATABASECONFTYPE is set to RACONENODE ]
#-----------------------------------------------------------------------------
RACOneNodeServiceName=

#-----------------------------------------------------------------------------
# Name          : sehaServiceName
# Datatype      : String
# Description   : Service is required by application to connect to SEHA Database
# Valid values  : SEHA Service Name
# Default value : None
# Mandatory     : No [required in case DATABASECONFTYPE is set to SEHA ]
#-----------------------------------------------------------------------------
sehaServiceName=

#-----------------------------------------------------------------------------
# Name          : policyManaged
# Datatype      : Boolean
# Description   : Set to true if Database is policy managed and 
#		  set to false if  Database is admin managed
# Valid values  : TRUE\FALSE
# Default value : FALSE
# Mandatory     : No
#-----------------------------------------------------------------------------
policyManaged=false

#-----------------------------------------------------------------------------
# Name          : managementPolicy
# Datatype      : String
# Description   : Set to AUTOMATIC or RANK based on management policy.
# Valid values  : AUTOMATIC\RANK
# Default value : AUTOMATIC
# Mandatory     : No
#-----------------------------------------------------------------------------
managementPolicy=AUTOMATIC

#-----------------------------------------------------------------------------
# Name          : createServerPool
# Datatype      : Boolean
# Description   : Set to true if new server pool need to be created for database 
#		  if this option is specified then the newly created database 
#		  will use this newly created serverpool. 
#		  Multiple serverpoolname can not be specified for database
# Valid values  : TRUE\FALSE
# Default value : FALSE
# Mandatory     : No
#-----------------------------------------------------------------------------
createServerPool=false

#-----------------------------------------------------------------------------
# Name          : serverPoolName
# Datatype      : String
# Description   : Only one serverpool name need to be specified 
#		   if Create Server Pool option is specified. 
#		   Comma-separated list of Serverpool names if db need to use
#		   multiple Server pool
# Valid values  : ServerPool name

# Default value : None
# Mandatory     : No [required in case of RAC service centric database]
#-----------------------------------------------------------------------------
serverPoolName=

#-----------------------------------------------------------------------------
# Name          : cardinality
# Datatype      : Number
# Description   : Specify Cardinality for create server pool operation

# Valid values  : any positive Integer value
# Default value : Number of qualified nodes on cluster
# Mandatory     : No [Required when a new serverpool need to be created]
#-----------------------------------------------------------------------------
cardinality=

#-----------------------------------------------------------------------------
# Name          : force
# Datatype      : Boolean
# Description   : Set to true if new server pool need to be created by force 
#		  if this option is specified then the newly created serverpool
#		  will be assigned server even if no free servers are available.
#		  This may affect already running database.
#		  This flag can be specified for Admin managed as well as policy managed db.
# Valid values  : TRUE\FALSE
# Default value : FALSE
# Mandatory     : No
#-----------------------------------------------------------------------------
force=false

#-----------------------------------------------------------------------------
# Name          : pqPoolName
# Datatype      : String
# Description   : Only one serverpool name needs to be specified 
#		   if create server pool option is specified. 
#		   Comma-separated list of serverpool names if use
#		   server pool. This is required to 
#                  create Parallel Query (PQ) database. Applicable to Big Cluster
# Valid values  :  Parallel Query (PQ) pool name
# Default value : None
# Mandatory     : No [required in case of RAC service centric database]
#-----------------------------------------------------------------------------
pqPoolName=

#-----------------------------------------------------------------------------
# Name          : pqCardinality
# Datatype      : Number
# Description   : Specify Cardinality for create server pool operation.
#                 Applicable to Big Cluster 
# Valid values  : any positive Integer value
# Default value : Number of qualified nodes on cluster
# Mandatory     : No [Required when a new serverpool need to be created]
#-----------------------------------------------------------------------------
pqCardinality=

#-----------------------------------------------------------------------------
# Name          : createAsContainerDatabase 
# Datatype      : boolean
# Description   : flag to create database as container database 
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : false
# Mandatory     : No
#-----------------------------------------------------------------------------
createAsContainerDatabase=true

#-----------------------------------------------------------------------------
# Name          : numberOfPDBs
# Datatype      : Number
# Description   : Specify the number of pdb to be created
# Valid values  : 0 to 252
# Default value : 0
# Mandatory     : No
#-----------------------------------------------------------------------------
numberOfPDBs=1

#-----------------------------------------------------------------------------
# Name          : pdbName 
# Datatype      : String
# Description   : Specify the pdbname/pdbanme prefix if one or more pdb need to be created
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory     : No
#-----------------------------------------------------------------------------
pdbName=PDB1

#-----------------------------------------------------------------------------
# Name          : useLocalUndoForPDBs 
# Datatype      : boolean
# Description   : Flag to create local undo tablespace for all PDB's.
# Valid values  : TRUE\FALSE
# Default value : TRUE
# Mandatory     : No
#-----------------------------------------------------------------------------
useLocalUndoForPDBs=true

#-----------------------------------------------------------------------------
# Name          : pdbAdminPassword
# Datatype      : String
# Description   : PDB Administrator user password
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory     : No
#-----------------------------------------------------------------------------

pdbAdminPassword=

#-----------------------------------------------------------------------------
# Name          : nodelist
# Datatype      : String
# Description   : Comma-separated list of cluster nodes
# Valid values  : Cluster node names
# Default value : None
# Mandatory     : No (Yes for RAC database-centric database )
#-----------------------------------------------------------------------------
nodelist=rac1,rac2

#-----------------------------------------------------------------------------
# Name          : sehaNodeList
# Datatype      : String
# Description   : Comma-separated list of cluster nodes
# Valid values  : Cluster node names
# Default value : None
# Mandatory     : No (Yes for SEHA database)
#-----------------------------------------------------------------------------
sehaNodeList=

#-----------------------------------------------------------------------------
# Name          : templateName
# Datatype      : String
# Description   : Name of the template
# Valid values  : Template file name
# Default value : None
# Mandatory     : Yes
#-----------------------------------------------------------------------------
templateName=/oradb/app/oracle/product/26.0.0/assistants/dbca/templates/New_Database.dbt

#-----------------------------------------------------------------------------
# Name          : sysPassword
# Datatype      : String
# Description   : Password for SYS user
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory     : Yes
#-----------------------------------------------------------------------------
sysPassword=

#-----------------------------------------------------------------------------
# Name          : systemPassword
# Datatype      : String
# Description   : Password for SYSTEM user
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory     : Yes
#-----------------------------------------------------------------------------
systemPassword= 

#-----------------------------------------------------------------------------
# Name          : serviceUserPassword
# Datatype      : String
# Description   : Password for Windows Service user
# Default value : None
# Mandatory     : If Oracle home is installed with windows service user
#-----------------------------------------------------------------------------
serviceUserPassword=

#-----------------------------------------------------------------------------
# Name          : emConfiguration
# Datatype      : String
# Description   : Enterprise Manager Configuration Type
# Valid values  : CENTRAL|NONE
# Default value : NONE
# Mandatory     : No
#-----------------------------------------------------------------------------
emConfiguration=

#-----------------------------------------------------------------------------
# Name          : runCVUChecks
# Datatype      : Boolean
# Description   : Specify whether to run Cluster Verification Utility checks
#                 periodically in Cluster environment
# Valid values  : TRUE\FALSE
# Default value : FALSE
# Mandatory     : No
#-----------------------------------------------------------------------------
runCVUChecks=TRUE

#-----------------------------------------------------------------------------
# Name          : dbsnmpPassword
# Datatype      : String
# Description   : Password for DBSNMP user
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory     : Yes, if emConfiguration is specified or
#                 the value of runCVUChecks is TRUE
#-----------------------------------------------------------------------------
dbsnmpPassword=

#-----------------------------------------------------------------------------
# Name          : omsHost
# Datatype      : String
# Description   : EM management server host name
# Default value : None
# Mandatory     : Yes, if CENTRAL is specified for emConfiguration
#-----------------------------------------------------------------------------
omsHost=

#-----------------------------------------------------------------------------
# Name          : omsPort
# Datatype      : Number
# Description   : EM management server port number
# Default value : None
# Mandatory     : Yes, if CENTRAL is specified for emConfiguration
#-----------------------------------------------------------------------------
omsPort=0

#-----------------------------------------------------------------------------
# Name          : emUser
# Datatype      : String
# Description   : EM Admin username to add or modify targets
# Default value : None
# Mandatory     : Yes, if CENTRAL is specified for emConfiguration
#-----------------------------------------------------------------------------
emUser=

#-----------------------------------------------------------------------------
# Name          : emPassword
# Datatype      : String
# Description   : EM Admin user password
# Default value : None
# Mandatory     : Yes, if CENTRAL is specified for emConfiguration
#-----------------------------------------------------------------------------
emPassword=

#-----------------------------------------------------------------------------
# Name          : dvConfiguration
# Datatype      : Boolean
# Description   : Specify "True" to configure and enable Oracle Database vault
# Valid values  : True/False
# Default value : False
# Mandatory     : No
#-----------------------------------------------------------------------------
dvConfiguration=false

#-----------------------------------------------------------------------------
# Name          : dvUserName
# Datatype      : String
# Description   : DataVault Owner
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory     : Yes, if DataVault option is chosen
#-----------------------------------------------------------------------------
dvUserName=

#-----------------------------------------------------------------------------
# Name          : dvUserPassword
# Datatype      : String
# Description   : Password for DataVault Owner
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory     : Yes, if DataVault option is chosen
#-----------------------------------------------------------------------------
dvUserPassword=

#-----------------------------------------------------------------------------
# Name          : dvAccountManagerName
# Datatype      : String
# Description   : DataVault Account Manager
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory     : No
#-----------------------------------------------------------------------------
dvAccountManagerName=

#-----------------------------------------------------------------------------
# Name          : dvAccountManagerPassword
# Datatype      : String
# Description   : Password for  DataVault Account Manager
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory     : No
#-----------------------------------------------------------------------------
dvAccountManagerPassword=

#-----------------------------------------------------------------------------
# Name          : olsConfiguration
# Datatype      : Boolean
# Description   : Specify "True" to configure and enable Oracle Label Security
# Valid values  : True/False
# Default value : False
# Mandatory     : No
#-----------------------------------------------------------------------------
olsConfiguration=false

#-----------------------------------------------------------------------------
# Name          : datafileJarLocation 
# Datatype      : String
# Description   : Location of the data file jar 
# Valid values  : Directory containing compressed datafile jar
# Default value : None
# Mandatory     : No
#-----------------------------------------------------------------------------
datafileJarLocation=

#-----------------------------------------------------------------------------
# Name          : datafileDestination 
# Datatype      : String
# Description   : Location of the data file's
# Valid values  : Directory for all the database files
# Default value : $ORACLE_BASE/oradata
# Mandatory     : No
#-----------------------------------------------------------------------------
datafileDestination=+DATA01/{DB_UNIQUE_NAME}/

#-----------------------------------------------------------------------------
# Name          : recoveryAreaDestination
# Datatype      : String
# Description   : Location of the data file's
# Valid values  : Recovery Area location
# Default value : $ORACLE_BASE/flash_recovery_area
# Mandatory     : No
#-----------------------------------------------------------------------------
recoveryAreaDestination=

#-----------------------------------------------------------------------------
# Name          : recoveryAreaSize
# Datatype      : String
# Description   : Recovery area size
# Mandatory     : No
#-----------------------------------------------------------------------------
recoveryAreaSize=54525952BYTES
		
#-----------------------------------------------------------------------------
# Name          : configureWithOID
# Datatype      : Boolean
# Description   : To configure with OID or not
# Valid values  : TRUE / FALSE
# Default value : FALSE
# Mandatory     : No
#-----------------------------------------------------------------------------
configureWithOID=

#-----------------------------------------------------------------------------
# Name          : pdbOptionMap
# Datatype      : String
# Description   : Values for DB Options indicating whether they should be included in PDB
# Default value : None
# Mandatory     : No
#-----------------------------------------------------------------------------
pdbOptions=JSERVER:true,ORACLE_TEXT:true,IMEDIA:false,CWMLITE:true,SPATIAL:true,OMS:false,SAMPLE_SCHEMA:false,DV:false

#-----------------------------------------------------------------------------
# Name          : dbOptionMap
# Datatype      : String
# Description   : Values DB Options indicating whether they are enabled
# Default value : None
# Mandatory     : No
#-----------------------------------------------------------------------------
dbOptions=JSERVER:true,ORACLE_TEXT:true,IMEDIA:false,CWMLITE:true,SPATIAL:true,OMS:false,SAMPLE_SCHEMA:false,DV:false

#-----------------------------------------------------------------------------
# Name          : storageType
# Datatype      : String
# Description   : Specifies the storage on which the database is to be created
# Valid values  : FS (CFS for RAC), ASM
# Default value : FS
# Mandatory     : No
#-----------------------------------------------------------------------------
storageType=ASM

#-----------------------------------------------------------------------------
# Name          : diskGroupName
# Datatype      : String
# Description   : Specifies the disk group name for the storage
# Default value : DATA
# Mandatory     : No
#-----------------------------------------------------------------------------
diskGroupName=+DATA01/{DB_UNIQUE_NAME}/

#-----------------------------------------------------------------------------
# Name          : asmsnmpPassword
# Datatype      : String
# Description   : Password for ASM Monitoring
# Default value : None
# Mandatory     : No
#-----------------------------------------------------------------------------
asmsnmpPassword=

#-----------------------------------------------------------------------------
# Name          : recoveryGroupName
# Datatype      : String
# Description   : Specifies the disk group name for the recovery area
# Default value : RECOVERY
# Mandatory     : No
#-----------------------------------------------------------------------------
recoveryGroupName=

#-----------------------------------------------------------------------------
# Name          : characterSet
# Datatype      : String
# Description   : Character set of the database
# Valid values  : Check Oracle12c National Language Support Guide
# Default value : "US7ASCII"
# Mandatory     : NO
#-----------------------------------------------------------------------------
characterSet=AL32UTF8

#-----------------------------------------------------------------------------
# Name          : nationalCharacterSet
# Datatype      : String
# Description   : National Character set of the database
# Valid values  : "UTF8" or "AL16UTF16". For details, check Oracle12c National Language Support Guide
# Default value : "AL16UTF16"
# Mandatory     : No
#-----------------------------------------------------------------------------
nationalCharacterSet=AL16UTF16

#-----------------------------------------------------------------------------
# Name          : registerWithDirService
# Datatype      : Boolean
# Description   : Specifies whether to register with Directory Service.
# Valid values  : TRUE \ FALSE
# Default value : FALSE
# Mandatory     : No
#-----------------------------------------------------------------------------
registerWithDirService=false


#-----------------------------------------------------------------------------
# Name          : dirServiceUserName
# Datatype      : String
# Description   : Specifies the name of the directory service user
# Mandatory     : YES, if the value of registerWithDirService is TRUE
#-----------------------------------------------------------------------------
dirServiceUserName=

#-----------------------------------------------------------------------------
# Name          : dirServicePassword
# Datatype      : String
# Description   : The password of the directory service user.
#		  You can also specify the password at the command prompt instead of here.
# Mandatory     : YES, if the value of registerWithDirService is TRUE
#-----------------------------------------------------------------------------
dirServicePassword=

#-----------------------------------------------------------------------------
# Name          : walletPassword
# Datatype      : String
# Description   : The password for wallet to created or modified.
#		  You can also specify the password at the command prompt instead of here.
# Mandatory     : YES, if the value of registerWithDirService is TRUE
#-----------------------------------------------------------------------------
walletPassword=

#-----------------------------------------------------------------------------
# Name          : listeners
# Datatype      : String
# Description   : Specifies list of listeners to register the database with.
#		  By default the database is configured for all the listeners specified in the 
#		  $ORACLE_HOME/network/admin/listener.ora 	
# Valid values  : The list should be comma separated like "listener1,listener2".
# Mandatory     : NO
#-----------------------------------------------------------------------------
listeners=LISTENER

#-----------------------------------------------------------------------------
# Name          : skipListenerRegistration
# Datatype      : Boolean
# Description   : FALSE if no listener chosen for registration, else true.
# Valid values  : TRUE/FALSE
# Mandatory     : NO
#-----------------------------------------------------------------------------
skipListenerRegistration=false

#-----------------------------------------------------------------------------
# Name          : variablesFile 
# Datatype      : String
# Description   : Location of the file containing variable value pair
# Valid values  : A valid file-system file. The variable value pair format in this file 
#		  is <variable>=<value>. Each pair should be in a new line.
# Default value : None
# Mandatory     : NO
#-----------------------------------------------------------------------------
variablesFile=

#-----------------------------------------------------------------------------
# Name          : variables
# Datatype      : String
# Description   : comma separated list of name=value pairs. Overrides variables defined in variablefile and templates
# Default value : None
# Mandatory     : NO
#-----------------------------------------------------------------------------
variables=ORACLE_BASE_HOME=/oradb/app/oracle/product/26.0.0,DB_UNIQUE_NAME=CDB,ORACLE_BASE=/oradb/app/base,PDB_NAME=,DB_NAME=CDB,ORACLE_HOME=/oradb/app/oracle/product/26.0.0,SID=CDB

#-----------------------------------------------------------------------------
# Name          : initParams
# Datatype      : String
# Description   : comma separated list of name=value pairs. Overrides initialization parameters defined in templates
# Default value : None
# Mandatory     : NO
#-----------------------------------------------------------------------------
initParams=CDB1.undo_tablespace=UNDOTBS1,CDB2.undo_tablespace=UNDOTBS2,enable_pluggable_database=true,sga_target=5998MB,db_block_size=8192BYTES,cluster_database=true,family:dw_helper.instance_mode=read-only,nls_language=AMERICAN,dispatchers=(PROTOCOL=TCP) (SERVICE=CDBXDB),diagnostic_dest={ORACLE_BASE},remote_login_passwordfile=exclusive,db_create_file_dest=+DATA01/{DB_UNIQUE_NAME}/,processes=320,pga_aggregate_target=2000MB,CDB1.thread=1,CDB2.thread=2,nls_territory=AMERICA,local_listener=-oraagent-dummy-,open_cursors=300,compatible=23.6.0,db_name=CDB,CDB1.instance_number=1,CDB2.instance_number=2

#-----------------------------------------------------------------------------
# Name          : enableArchive
# Datatype      : Boolean
# Description   : Specifies whether to enable archive log.
# Valid values  : TRUE \ FALSE
# Default value : FALSE
# Mandatory     : No
#-----------------------------------------------------------------------------
enableArchive=false

#-----------------------------------------------------------------------------
# Name          : useOMF
# Datatype      : Boolean
# Description   : Specifies whether to use OMF or not.
# Valid values  : TRUE \ FALSE
# Mandatory     : No
#-----------------------------------------------------------------------------
useOMF=true

#-----------------------------------------------------------------------------
# Name          : memoryPercentage
# Datatype      : String
# Description   : percentage of physical memory for Oracle
# Default value : None
# Mandatory     : NO
#-----------------------------------------------------------------------------
memoryPercentage=40

#-----------------------------------------------------------------------------
# Name          : databaseType
# Datatype      : String
# Description   : used for memory distribution when memoryPercentage specified
# Valid values  : MULTIPURPOSE|DATA_WAREHOUSING|OLTP
# Default value : MULTIPURPOSE
# Mandatory     : NO
#-----------------------------------------------------------------------------
databaseType=MULTIPURPOSE

#-----------------------------------------------------------------------------
# Name          : automaticMemoryManagement
# Datatype      : Boolean
# Description   : flag to indicate Automatic Memory Management is used
# Valid values  : TRUE/FALSE
# Default value : TRUE
# Mandatory     : NO
#-----------------------------------------------------------------------------
automaticMemoryManagement=false

#-----------------------------------------------------------------------------
# Name          : totalMemory
# Datatype      : String
# Description   : total memory in MB to allocate to Oracle
# Valid values  : 
# Default value : 
# Mandatory     : NO
#-----------------------------------------------------------------------------
totalMemory=0

 

 

 

반응형

+ Recent posts