Oracle Database 23ai（最新の26aiを含む）の導入において、GUIを使用せずコマンドラインのみで構築を完結させる「サイレントインストール」は、実務で最も多用される手法です。本記事では、シングル構成用の runInstaller.rsp と dbca.rsp の設定ポイント、および自動化のメリット・注意点を解説します。
導入（要約）
大量のサーバー構築や、検証環境の素早い作り直しに悩んでいませんか？Oracleのサイレントインストールなら、レスポンスファイルを事前に定義するだけで、同一構成のDBをミスなく量産できます。本記事ではOracle 26ai シングル構成を例に、実機で通るレスポンスファイルの書き方と、運用の落とし穴をまとめました。
サイレントインストールの最短手順
インストール手順の詳細は別記事に譲りますが、レスポンスファイルを用いた流れは以下の通りです。
- OS事前設定:
oracle-database-preinstall-23c等でパッケージとカーネル値を更新。 - ファイル準備:
runInstaller.rspとdbca.rspを作成・編集。 - SWインストール:
runInstaller -silent -responseFile <パス>を実行。 - rootスクリプト実行:
orainstRoot.shおよびroot.shを実行。 - DB作成:
dbca -silent -createDatabase -responseFile <パス>を実行。
サイレントインストールで行うメリットと注意点
GUI（Oracle Universal Installer）を使わない手法には、明確な利点とリスクがあります。
メリット
- 構築の均一化: 複数の環境で、初期化パラメータやディレクトリ構成を完全に一致させることができます。
- 工数削減と自動化: Ansible や Terraform と組み合わせることで、DB構築をコード管理（IaC）に組み込めます。
- リモート作業の容易さ: X-Window（GUI転送）の設定が不要なため、低帯域な環境や踏み台経由でも安定して作業可能です。
注意点
- 構文エラーに厳しい: GUIのような「次へ」ボタンでのバリデーションがないため、パラメータの1文字ミスでインストールが即座に中断されます。
- 環境依存のパス: 環境に応じて設定する値を変更してください。特に
ORACLE_HOMEやtemplateNameのパスが1箇所でもズレると失敗します。 - ログ確認の重要性: エラー時は画面に詳細が出ないため、
/u01/app/oraInventory/logs下のログファイルを自力で解析するスキルが求められます。
レスポンスファイルの主要設定ポイント
提供された 26ai 用のファイルをベースに、実務で必ず書き換えるべき重要箇所を解説します。
1. runInstaller.rsp（ソフトウェア・インストール）
ソフトウェアの展開を制御するファイルです。
| パラメータ名 | 設定のポイント |
installOption | INSTALL_DB_SWONLY を指定。DB作成はDBCAで行うのがベストプラクティスです。 |
ORACLE_BASE | 本体のベースディレクトリ。 /u01/app/oracle 等。 |
UNIX_GROUP_NAME | インベントリ所有グループ。通常は oinstall。 |
OSDBA | SYSDBA権限を持つグループ。通常は dba。 |
🖥️ runInstallerのレスポンスファイル
レスポンスファイルを表示(ここをクリック)
####################################################################
## 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=oinstall
#-------------------------------------------------------------------------------
# Specify the location which holds the inventory files.
# This is an optional parameter if installing on
# Windows based Operating System.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=/u01/app/oraInventory
#-------------------------------------------------------------------------------
# Specify the complete path of the Oracle Base.
#-------------------------------------------------------------------------------
ORACLE_BASE=/u01/app/oracle
#-------------------------------------------------------------------------------
# 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=oper
#------------------------------------------------------------------------------
# The OSBACKUPDBA is the OS group which is to be granted SYSBACKUP privileges.
#
# Deprecated: oracle.install.db.OSBACKUPDBA_GROUP
#------------------------------------------------------------------------------
OSBACKUPDBA=backupdba
#------------------------------------------------------------------------------
# The OSDGDBA is the OS group which is to be granted SYSDG privileges.
#
# Deprecated: oracle.install.db.OSDGDBA_GROUP
#------------------------------------------------------------------------------
OSDGDBA=dgdba
#------------------------------------------------------------------------------
# The OSKMDBA is the OS group which is to be granted SYSKM privileges.
#
# Deprecated: oracle.install.db.OSKMDBA_GROUP
#------------------------------------------------------------------------------
OSKMDBA=kmdba
#------------------------------------------------------------------------------
# The OSRACDBA is the OS group which is to be granted SYSRAC privileges.
#
# Deprecated: oracle.install.db.OSRACDBA_GROUP
#------------------------------------------------------------------------------
OSRACDBA=racdba
################################################################################
# #
# 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=
###############################################################################
# #
# 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=
2. dbca.rsp（データベース作成）
インスタンスとPDBの構成を制御します。
| パラメータ名 | 設定のポイント |
gdbName / sid | グローバルDB名とSID。シングル構成なら同一（例: orcl）でOK。 |
createAsContainerDatabase | 23ai以降は CDB構成が標準 です。true を強く推奨。 |
templateName | 重要。 .dbc ファイルへのフルパスが必要です。 |
pdbName | PDBを作成する場合の名前（例: pdb01）。 |
🖥️ 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 : . - when database domain isn't NULL
# - when database domain is NULL
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
gdbName=orcl
#-----------------------------------------------------------------------------
# Name : sid
# Datatype : String
# Description : System identifier (SID) of the database
# Valid values : Check Oracle12c Administrator's Guide
# Default value : specified in GDBNAME
# Mandatory : No
#-----------------------------------------------------------------------------
sid=orcl
#-----------------------------------------------------------------------------
# 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=SI
#-----------------------------------------------------------------------------
# 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=pdb01
#-----------------------------------------------------------------------------
# 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=
#-----------------------------------------------------------------------------
# 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=/u01/app/oracle/product/23.0.0/dbhome_1/assistants/dbca/templates/General_Purpose.dbc
#-----------------------------------------------------------------------------
# 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=FALSE
#-----------------------------------------------------------------------------
# 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={ORACLE_HOME}/assistants/dbca/templates/
#-----------------------------------------------------------------------------
# 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={ORACLE_BASE}/oradata/{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=OMS:true,ORACLE_TEXT:true,DV:true,IMEDIA:false,JSERVER:true,CWMLITE:true,SPATIAL:true,SAMPLE_SCHEMA:false
#-----------------------------------------------------------------------------
# Name : dbOptionMap
# Datatype : String
# Description : Values DB Options indicating whether they are enabled
# Default value : None
# Mandatory : No
#-----------------------------------------------------------------------------
dbOptions=OMS:true,ORACLE_TEXT:true,DV:true,IMEDIA:false,JSERVER:true,CWMLITE:true,SPATIAL:true,SAMPLE_SCHEMA: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=FS
#-----------------------------------------------------------------------------
# Name : diskGroupName
# Datatype : String
# Description : Specifies the disk group name for the storage
# Default value : DATA
# Mandatory : No
#-----------------------------------------------------------------------------
diskGroupName=
#-----------------------------------------------------------------------------
# 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=
#-----------------------------------------------------------------------------
# Name : skipListenerRegistration
# Datatype : Boolean
# Description : FALSE if no listener chosen for registration, else true.
# Valid values : TRUE/FALSE
# Mandatory : NO
#-----------------------------------------------------------------------------
skipListenerRegistration=true
#-----------------------------------------------------------------------------
# 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 =. 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=/u01/app/oracle/product/23.0.0/dbhome_1,DB_UNIQUE_NAME=orcl,ORACLE_BASE=/u01/app/oracle,PDB_NAME=,DB_NAME=orcl,ORACLE_HOME=/u01/app/oracle/product/23.0.0/dbhome_1,SID=orcl
#-----------------------------------------------------------------------------
# Name : initParams
# Datatype : String
# Description : comma separated list of name=value pairs. Overrides initialization parameters defined in templates
# Default value : None
# Mandatory : NO
#-----------------------------------------------------------------------------
initParams=undo_tablespace=UNDOTBS1,enable_pluggable_database=true,db_block_size=8192BYTES,nls_language=AMERICAN,dispatchers=(PROTOCOL=TCP) (SERVICE=orclXDB),diagnostic_dest={ORACLE_BASE},control_files=("{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl", "{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control02.ctl"),remote_login_passwordfile=EXCLUSIVE,processes=300,nls_territory=AMERICA,memory_target=1451MB,open_cursors=300,compatible=23.6.0,db_name=orcl
#-----------------------------------------------------------------------------
# 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=false
#-----------------------------------------------------------------------------
# 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=true
#-----------------------------------------------------------------------------
# Name : totalMemory
# Datatype : String
# Description : total memory in MB to allocate to Oracle
# Valid values :
# Default value :
# Mandatory : NO
#-----------------------------------------------------------------------------
totalMemory=0
実行例：コピー＆ペースト用設定項目
レスポンスファイル内を検索し、以下の値を自身の環境に合わせて書き換えてください。
前提条件
- 実行ユーザー:
oracle- 権限:
oinstall,dbaグループに所属- OS: Oracle Linux 8/9
- パスワードに「@」は使用しない（スクリプト実行時のエラー防止）
# --- runInstaller.rsp の抜粋 ---
installOption=INSTALL_DB_SWONLY
ORACLE_BASE=/u01/app/oracle
INVENTORY_LOCATION=/u01/app/oraInventory
UNIX_GROUP_NAME=oinstall
installEdition=EE
OSDBA=dba
# --- dbca.rsp の抜粋 ---
gdbName=orcl
sid=orcl
createAsContainerDatabase=true
numberOfPDBs=1
pdbName=pdb01
# 注意：環境によりパスが異なります。必ず実機で確認してください
templateName=/u01/app/oracle/product/23.0.0/dbhome_1/assistants/dbca/templates/General_Purpose.dbc
sysPassword=YourSecurePassword123
systemPassword=YourSecurePassword123
pdbAdminPassword=YourSecurePassword123
トラブルシューティング
| 発生する事象・ORAエラー | 原因 | 確認・対処方法 |
| 致命的なエラー: インベントリが… | 以前のインストール失敗の残骸 | /etc/oraInst.loc を確認し、残っているディレクトリを削除。 |
| Template not found | templateName のパス不正 | ls -l で指定の .dbc ファイルが実在するか確認。 |
| OSグループの不一致 | RSP記述とOSユーザーの状態が違う | id oracle コマンドで所属グループを再確認。 |
運用・監視・セキュリティ上の注意
- パスワード漏洩: レスポンスファイルには平文パスワードを記載します。インストール後は必ずファイルを削除するか、
chmod 600で保護してください。 - 戻し方: インストール途中で失敗した場合は、
$ORACLE_HOME/deinstall/deinstallを使用して完全にクリーンアップしてから再試行してください。中途半端な状態で再実行すると、インベントリが破損する恐れがあります。
FAQ
Q1: dbca.rsp でメモリ割り当てを自動にできますか？
A: はい。automaticMemoryManagement=true に設定した上で、totalMemory (MB単位) または memoryPercentage を指定してください。
Q2: 23ai/26ai で旧来のパラメータ名は使えませんか？
A: Deprecated（非推奨）とコメントにあるものは将来削除されます。新しい名称（例: oracle.install.option → installOption）への移行を推奨します。
Q3: 1つのレスポンスファイルで複数台構築できますか？
A: はい。IPアドレスやホスト名に依存する設定（リスナー等）を外しておけば、同一構成の雛形として使い回せます。
まとめ
- サイレントインストールは構築の正確性と効率を劇的に向上させる。
- レスポンスファイルはソフトウェア用(runInstaller)とDB作成用(dbca)の2段階で管理する。
- 環境依存のパス（特にテンプレートの場所）は、必ず実行環境の絶対パスに書き換える。
- パスワード管理を徹底し、インストール後のファイル扱いに注意する。
[参考]
Oracle AI Databaseデータベース・インストレーション・ガイド, 26ai for Linux
💰 【PR】Oracleエンジニアの市場価値、調べてみませんか？
Oracleのスキルは需要が高く、特定の資格や経験を持っていると年収が大幅にアップするケースがあります。まずはIT専門のエージェントで非公開求人をチェックしてみませんか？
コメント