暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

19c-install.rsp

原创 brynden 2020-05-14
1922

19c-install.rsp
$ pwd
/ora19c/app/oracle/19c/db1/install/response
$ ls
db_install.rsp
$

$ ./runInstaller -silent -ignorePrereqFailure -responseFile /oradata/software/19c-install.rsp

cat 19c-install.rsp |grep -v “^$” |grep -v “#”

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/ora19c/app/oraInventory
ORACLE_HOME=/ora19c/app/oracle/19c/db1
ORACLE_BASE=/ora19c/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=dba2
oracle.install.db.OSOPER_GROUP=oper2
oracle.install.db.OSBACKUPDBA_GROUP=backupdba2
oracle.install.db.OSDGDBA_GROUP=dgdba2
oracle.install.db.OSKMDBA_GROUP=kmdba2
oracle.install.db.OSRACDBA_GROUP=racdba2
oracle.install.db.rootconfig.executeRootScript=false
oracle.install.db.rootconfig.configMethod=ROOT
oracle.install.db.rootconfig.sudoPath=
oracle.install.db.rootconfig.sudoUserName=
#oracle.install.db.CLUSTER_NODES=oratest

$
$ cat db_install.rsp
####################################################################

Copyright© Oracle Corporation 1998,2019. 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.

####################################################################

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0
#-------------------------------------------------------------------------------

Specify the installation option.

It can be one of the following:

- INSTALL_DB_SWONLY

- INSTALL_DB_AND_CONFIG

#-------------------------------------------------------------------------------
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/ora19c/app/oraInventory
ORACLE_HOME=/ora19c/app/oracle/19c/db1
ORACLE_BASE=/ora19c/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=dba2
oracle.install.db.OSOPER_GROUP=oper2
oracle.install.db.OSBACKUPDBA_GROUP=backupdba2
oracle.install.db.OSDGDBA_GROUP=dgdba2
oracle.install.db.OSKMDBA_GROUP=kmdba2
oracle.install.db.OSRACDBA_GROUP=racdba2

oracle.install.db.rootconfig.executeRootScript=false
oracle.install.db.rootconfig.configMethod=
oracle.install.db.rootconfig.sudoPath=
oracle.install.db.rootconfig.sudoUserName=

#oracle.install.db.CLUSTER_NODES=oratest
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE

oracle.install.db.config.starterdb.globalDBName=
oracle.install.db.config.starterdb.SID=

oracle.install.db.ConfigureAsContainerDB=false
oracle.install.db.config.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

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.characterSet=ZHS16GBK

oracle.install.db.config.starterdb.memoryOption=true
oracle.install.db.config.starterdb.memoryLimit=1024
oracle.install.db.config.starterdb.installExampleSchemas=false

oracle.install.db.config.starterdb.password.ALL=oracle
oracle.install.db.config.starterdb.password.SYS=
oracle.install.db.config.starterdb.password.SYSTEM=
oracle.install.db.config.starterdb.password.DBSNMP=
oracle.install.db.config.starterdb.password.PDBADMIN=

oracle.install.db.config.starterdb.managementOption=DEFAULT
oracle.install.db.config.starterdb.omsHost=
oracle.install.db.config.starterdb.omsPort=
oracle.install.db.config.starterdb.emAdminUser=
oracle.install.db.config.starterdb.emAdminPassword=

oracle.install.db.config.starterdb.enableRecovery=false

#-------------------------------------------------------------------------------

Specify the type of storage to use for the database.

It can be one of the following:

- FILE_SYSTEM_STORAGE

- ASM_STORAGE

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/oradata/ora19c/data
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=/oradata/ora19c/fra
oracle.install.db.config.asm.diskGroup=
oracle.install.db.config.asm.ASMSNMPPassword=
$

Usage: runInstaller [] [

$ ./runInstaller -silent -ignorePrereqFailure -responseFile /oradata/software/19c-install.rsp

cat 19c-install.rsp |grep -v “^$” |grep -v “#”

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/ora19c/app/oraInventory
ORACLE_HOME=/ora19c/app/oracle/19c/db1
ORACLE_BASE=/ora19c/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=dba2
oracle.install.db.OSOPER_GROUP=oper2
oracle.install.db.OSBACKUPDBA_GROUP=backupdba2
oracle.install.db.OSDGDBA_GROUP=dgdba2
oracle.install.db.OSKMDBA_GROUP=kmdba2
oracle.install.db.OSRACDBA_GROUP=racdba2
oracle.install.db.rootconfig.executeRootScript=false
oracle.install.db.rootconfig.configMethod=ROOT
oracle.install.db.rootconfig.sudoPath=
oracle.install.db.rootconfig.sudoUserName=
#oracle.install.db.CLUSTER_NODES=oratest

./runInstaller

/u01/u19/app/oracle/product/19.2.0/dbhome_1/runInstaller -silent -force -noconfig -ignorePrereq

$ cat db_install.rsp |grep -v "^" |grep -v "#" oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0 oracle.install.option= UNIX_GROUP_NAME= INVENTORY_LOCATION= ORACLE_HOME= ORACLE_BASE= oracle.install.db.InstallEdition= oracle.install.db.OSDBA_GROUP= oracle.install.db.OSOPER_GROUP= oracle.install.db.OSBACKUPDBA_GROUP= oracle.install.db.OSDGDBA_GROUP= oracle.install.db.OSKMDBA_GROUP= oracle.install.db.OSRACDBA_GROUP= oracle.install.db.rootconfig.executeRootScript= oracle.install.db.rootconfig.configMethod= oracle.install.db.rootconfig.sudoPath= oracle.install.db.rootconfig.sudoUserName= oracle.install.db.CLUSTER_NODES= oracle.install.db.config.starterdb.type= oracle.install.db.config.starterdb.globalDBName= oracle.install.db.config.starterdb.SID= oracle.install.db.ConfigureAsContainerDB= oracle.install.db.config.PDBName= oracle.install.db.config.starterdb.characterSet= oracle.install.db.config.starterdb.memoryOption= oracle.install.db.config.starterdb.memoryLimit= oracle.install.db.config.starterdb.installExampleSchemas= oracle.install.db.config.starterdb.password.ALL= oracle.install.db.config.starterdb.password.SYS= oracle.install.db.config.starterdb.password.SYSTEM= oracle.install.db.config.starterdb.password.DBSNMP= oracle.install.db.config.starterdb.password.PDBADMIN= oracle.install.db.config.starterdb.managementOption= oracle.install.db.config.starterdb.omsHost= oracle.install.db.config.starterdb.omsPort= oracle.install.db.config.starterdb.emAdminUser= oracle.install.db.config.starterdb.emAdminPassword= oracle.install.db.config.starterdb.enableRecovery= oracle.install.db.config.starterdb.storageType= oracle.install.db.config.starterdb.fileSystemStorage.dataLocation= oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation= oracle.install.db.config.asm.diskGroup= oracle.install.db.config.asm.ASMSNMPPassword=

$
$ pwd
/ora19c/app/oracle/19c/db1/install/response
$ ls
db_install.rsp
$
$
$ cat db_install.rsp
####################################################################

Copyright© Oracle Corporation 1998,2019. 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_v19.0.0

#-------------------------------------------------------------------------------

Specify the installation option.

It can be one of the following:

- INSTALL_DB_SWONLY

- INSTALL_DB_AND_CONFIG

#-------------------------------------------------------------------------------
oracle.install.option=

#-------------------------------------------------------------------------------

Specify the Unix group to be set for the inventory directory.

#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=

#-------------------------------------------------------------------------------

Specify the location which holds the inventory files.

This is an optional parameter if installing on

Windows based Operating System.

#-------------------------------------------------------------------------------
INVENTORY_LOCATION=
#-------------------------------------------------------------------------------

Specify the complete path of the Oracle Home.

#-------------------------------------------------------------------------------
ORACLE_HOME=

#-------------------------------------------------------------------------------

Specify the complete path of the Oracle Base.

#-------------------------------------------------------------------------------
ORACLE_BASE=

#-------------------------------------------------------------------------------

Specify the installation edition of the component.

The value should contain only one of these choices.

- EE : Enterprise Edition

- SE2 : Standard Edition 2

#-------------------------------------------------------------------------------

oracle.install.db.InstallEdition=
###############################################################################

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_GROUP is the OS group which is to be granted SYSDBA privileges.

#-------------------------------------------------------------------------------
oracle.install.db.OSDBA_GROUP=

#------------------------------------------------------------------------------

The OSOPER_GROUP is the OS group which is to be granted SYSOPER privileges.

The value to be specified for OSOPER group is optional.

#------------------------------------------------------------------------------
oracle.install.db.OSOPER_GROUP=

#------------------------------------------------------------------------------

The OSBACKUPDBA_GROUP is the OS group which is to be granted SYSBACKUP privileges.

#------------------------------------------------------------------------------
oracle.install.db.OSBACKUPDBA_GROUP=

#------------------------------------------------------------------------------

The OSDGDBA_GROUP is the OS group which is to be granted SYSDG privileges.

#------------------------------------------------------------------------------
oracle.install.db.OSDGDBA_GROUP=

#------------------------------------------------------------------------------

The OSKMDBA_GROUP is the OS group which is to be granted SYSKM privileges.

#------------------------------------------------------------------------------
oracle.install.db.OSKMDBA_GROUP=

#------------------------------------------------------------------------------

The OSRACDBA_GROUP is the OS group which is to be granted SYSRAC privileges.

#------------------------------------------------------------------------------
oracle.install.db.OSRACDBA_GROUP=
################################################################################

Root script execution configuration

################################################################################

#-------------------------------------------------------------------------------------------------------

Specify the root script execution mode.

- true : To execute the root script automatically by using the appropriate configuration methods.

- false : To execute the root script manually.

If this option is selected, password should be specified on the console.

#-------------------------------------------------------------------------------------------------------
oracle.install.db.rootconfig.executeRootScript=

#--------------------------------------------------------------------------------------

Specify the configuration method to be used for automatic root script execution.

Following are the possible choices:

- ROOT

- SUDO

#--------------------------------------------------------------------------------------
oracle.install.db.rootconfig.configMethod=
#--------------------------------------------------------------------------------------

Specify the absolute path of the sudo program.

Applicable only when SUDO configuration method was chosen.

#--------------------------------------------------------------------------------------
oracle.install.db.rootconfig.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.

#--------------------------------------------------------------------------------------
oracle.install.db.rootconfig.sudoUserName=

###############################################################################

Grid Options

###############################################################################

#------------------------------------------------------------------------------

Value is required only if the specified install option is INSTALL_DB_SWONLY

Specify the cluster node names selected during the installation.

Example : oracle.install.db.CLUSTER_NODES=node1,node2

#------------------------------------------------------------------------------
oracle.install.db.CLUSTER_NODES=

###############################################################################

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.

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.type=

#-------------------------------------------------------------------------------

Specify the Starter Database Global Database Name.

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.globalDBName=

#-------------------------------------------------------------------------------

Specify the Starter Database SID.

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.SID=

#-------------------------------------------------------------------------------

Specify whether the database should be configured as a Container database.

The value can be either “true” or “false”. If left blank it will be assumed

to be “false”.

#-------------------------------------------------------------------------------
oracle.install.db.ConfigureAsContainerDB=

#-------------------------------------------------------------------------------

Specify the Pluggable Database name for the pluggable database in Container Database.

#-------------------------------------------------------------------------------
oracle.install.db.config.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

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.characterSet=

#------------------------------------------------------------------------------

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.

#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.memoryOption=

#-------------------------------------------------------------------------------

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: oracle.install.db.config.starterdb.memoryLimit=512

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.memoryLimit=

#-------------------------------------------------------------------------------

This variable controls whether to load Example Schemas onto

the starter database or not.

The value can be either “true” or “false”. If left blank it will be assumed

to be “false”.

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.installExampleSchemas=

###############################################################################

Passwords can be supplied for the following four schemas in the

starter database:

SYS

SYSTEM

DBSNMP (used by Enterprise Manager)

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.

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.ALL=

#-------------------------------------------------------------------------------

Specify the SYS password for the starter database.

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.SYS=

#-------------------------------------------------------------------------------

Specify the SYSTEM password for the starter database.

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.SYSTEM=

#-------------------------------------------------------------------------------

Specify the DBSNMP password for the starter database.

Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.DBSNMP=

#-------------------------------------------------------------------------------

Specify the PDBADMIN password required for creation of Pluggable Database in the Container Database.

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.PDBADMIN=

#-------------------------------------------------------------------------------

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 along with Database Express.

2. DEFAULT -If you want to manage your database using the default Database Express option.

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.managementOption=

#-------------------------------------------------------------------------------

Specify the OMS host to connect to Cloud Control.

Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.omsHost=

#-------------------------------------------------------------------------------

Specify the OMS port to connect to Cloud Control.

Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.omsPort=

#-------------------------------------------------------------------------------

Specify the EM Admin user name to use to connect to Cloud Control.

Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.emAdminUser=

#-------------------------------------------------------------------------------

Specify the EM Admin password to use to connect to Cloud Control.

Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.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.

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.enableRecovery=

#-------------------------------------------------------------------------------

Specify the type of storage to use for the database.

It can be one of the following:

- FILE_SYSTEM_STORAGE

- ASM_STORAGE

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.storageType=

#-------------------------------------------------------------------------------

Specify the database file location which is a directory for datafiles, control

files, redo logs.

Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=

#-------------------------------------------------------------------------------

Specify the recovery location.

Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE

#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=

#-------------------------------------------------------------------------------

Specify the existing ASM disk groups to be used for storage.

Applicable only when oracle.install.db.config.starterdb.storageType=ASM_STORAGE

#-------------------------------------------------------------------------------
oracle.install.db.config.asm.diskGroup=

#-------------------------------------------------------------------------------

Specify the password for ASMSNMP user of the ASM instance.

Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE

#-------------------------------------------------------------------------------
oracle.install.db.config.asm.ASMSNMPPassword=
$
$
$

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论