专栏首页TidbOracle 12c 静默应答文件 模板
原创

Oracle 12c 静默应答文件 模板

**导读**

> 作者:杨漆

> 16年关系型数据库管理,从oracle 9i 、10g、11g、12c到Mysql5.5、5.6、5.7、8.0 到TiDB获得3个OCP、2个OCM;运维路上不平坦,跌过不少坑、熬过许多夜。把工作笔记整理出来分享给大伙儿,希望帮到大家少走弯路、少熬夜。

cat  db.rsp

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

## Copyright(c) Oracle Corporation 1998,2017. 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_v12.2.0

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

# Specify the installation option.

# It can be one of the following:

#   - INSTALL_DB_SWONLY

#   - INSTALL_DB_AND_CONFIG

#   - UPGRADE_DB

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

oracle.install.option=INSTALL_DB_AND_CONFIG

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

# 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 Home.

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

ORACLE_HOME=/u01/app/oracle/product

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

# 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

#   - SE2     : Standard Edition 2

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

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

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

oracle.install.db.OSDBA_GROUP=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.

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

oracle.install.db.OSOPER_GROUP=dba

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

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

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

oracle.install.db.OSBACKUPDBA_GROUP=dba

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

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

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

oracle.install.db.OSDGDBA_GROUP=dba

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

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

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

oracle.install.db.OSKMDBA_GROUP=dba

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

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

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

oracle.install.db.OSRACDBA_GROUP=dba

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

#                                                                             #

#                               Grid Options                                  #

#                                                                             #

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

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

# Specify the type of Real Application Cluster Database

#

#   - ADMIN_MANAGED: Admin-Managed

#   - POLICY_MANAGED: Policy-Managed

#

# If left unspecified, default will be ADMIN_MANAGED

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

oracle.install.db.rac.configurationType=

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

# Value is required only if RAC database type is ADMIN_MANAGED

#

# Specify the cluster node names selected during the installation.

# Leaving it blank will result in install on local server only (Single Instance)

#

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

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

oracle.install.db.CLUSTER_NODES=

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

# This variable is used to enable or disable RAC One Node install.

#

#   - true  : Value of RAC One Node service name is used.

#   - false : Value of RAC One Node service name is not used.

#

# If left blank, it will be assumed to be false.

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

oracle.install.db.isRACOneInstall=false

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

# Value is required only if oracle.install.db.isRACOneInstall is true.

#

# Specify the name for RAC One Node Service

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

oracle.install.db.racOneServiceName=

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

# Value is required only if RAC database type is POLICY_MANAGED

#

# Specify a name for the new Server pool that will be configured

# Example : oracle.install.db.rac.serverpoolName=pool1

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

oracle.install.db.rac.serverpoolName=

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

# Value is required only if RAC database type is POLICY_MANAGED

#

# Specify a number as cardinality for the new Server pool that will be configured

# Example : oracle.install.db.rac.serverpoolCardinality=2

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

oracle.install.db.rac.serverpoolCardinality=0

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

#                                                                             #

#                        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=GENERAL_PURPOSE

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

# Specify the Starter Database Global Database Name.

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

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

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

# Specify the Starter Database SID.

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

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

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

# 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=false

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

# 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=AL32UTF8

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

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

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

oracle.install.db.config.starterdb.memoryLimit=12869

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

# 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=true

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

#                                                                             #

# 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=Oracle_123

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

# 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=DEFAULT

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

# 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=0

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

# 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=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

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

# 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=/u01/app/oracle/oradata

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

# 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=

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

# Specify the My Oracle Support Account Username.

#

#  Example   : MYORACLESUPPORT_USERNAME=abc@oracle.com

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

MYORACLESUPPORT_USERNAME=

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

# Specify the My Oracle Support Account Username password.

#

# Example    : MYORACLESUPPORT_PASSWORD=password

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

MYORACLESUPPORT_PASSWORD=

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

# Specify whether to enable the user to set the password for

# My Oracle Support credentials. The value can be either true or false.

# If left blank it will be assumed to be false.

#

# Example    : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true

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

SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

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

# Specify whether user doesn't want to configure Security Updates.

# The value for this variable should be true if you don't want to configure

# Security Updates, false otherwise.

#

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

# to be true.

#

# Example    : DECLINE_SECURITY_UPDATES=false

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

DECLINE_SECURITY_UPDATES=true

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

# Specify the Proxy server name. Length should be greater than zero.

#

# Example    : PROXY_HOST=proxy.domain.com

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

PROXY_HOST=

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

# Specify the proxy port number. Should be Numeric and at least 2 chars.

#

# Example    : PROXY_PORT=25

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

PROXY_PORT=

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

# Specify the proxy user name. Leave PROXY_USER and PROXY_PWD

# blank if your proxy server requires no authentication.

#

# Example    : PROXY_USER=username

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

PROXY_USER=

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

# Specify the proxy password. Leave PROXY_USER and PROXY_PWD

# blank if your proxy server requires no authentication.

#

# Example    : PROXY_PWD=password

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

PROXY_PWD=

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

# Specify the Oracle Support Hub URL.

#

# Example    : COLLECTOR_SUPPORTHUB_URL=https://orasupporthub.company.com:8080/

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

COLLECTOR_SUPPORTHUB_URL=

原创声明,本文系作者授权云+社区发表,未经许可,不得转载。

如有侵权,请联系 yunjia_community@tencent.com 删除。

我来说两句

0 条评论
登录 后参与评论

相关文章

  • CentOS7上静默(silent)模式安装Oracle12C Release 2 (12.2)

    版权声明:本文为木偶人shaon原创文章,转载请注明原文地址,非常感谢。 https://b...

    shaonbean
  • 20万DBA都在关注的12个问题

    近期我们在DBASK小程序新关联了韩锋频道、互联网侦察、数据库SQL、SQL数据库开发、跨界架构师、石杉的架构笔记等数据领域的公众号,聚合更新展示,欢迎大家阅读...

    数据和云
  • 【静默】Oracle各类响应文件何在?

    1、创建数据库的响应文件:$ORACLE_HOME/assistants/dbca/dbca.rsp

    小麦苗DBA宝典
  • GoldenGate安装简记(r10笔记第78天)

    GoldenGate这些年在数据迁移中是大放光彩,简称OGG,对于很多DBA来说,学会这项技能也会给自己加分不少。 Oracle在10g开始推出的GRID的概念...

    jeanron100
  • Oracle 12cR2初体验(r11笔记第91天)

    对于很多Oracle DBA来说,12c最期待人心的就是12c Release 2的发布了,而Linux64位版本的发布则是一个重头戏。详情可以关注公众号dba...

    jeanron100
  • Oracle GoldenGate 19 Microservices完整高可用安装、配置与测试

    大神们在群里讨论微服务的高可用,主要是XAG不支持adminclient接口,只支持ggsci接口,经过查看官方文档说明,最新版本XAG已经支持admin...

    徐靖
  • Oracle 18c初体验

    如果有一段时间不接触Oracle或者是不大了解Oracle,其实很容易会产生误解。以为12c到18c之间差距的版本应该还有13c,14c,...17c等...

    jeanron100
  • Oracle 19c的examples静默安装

    Oracle 11g的examples示例schema安装,在这篇文章《Oracle 11g的examples静默安装》介绍过了,Oracle 19c的exam...

    bisal
  • Oracle 19c的examples静默安装

    Oracle 11g的examples示例schema安装,在这篇文章《Oracle 11g的examples静默安装》介绍过了,Oracle 19c的exam...

    bisal
  • YH9:Oracle Multitenant 知识库

    Oracle 12c的多租户特性是Oracle Database历史上最重要的革新之一,在云时代这一特性展现出强大的整合威力。 基础简介 插接式数据库由一个使用...

    数据和云
  • 【DB笔试面试851】在Oracle中,造成“ORA-28040: No matching ...”错误的原因是什么?

    在Oracle中,造成“ORA-28040: No matching authentication protocol”错误的原因是什么?

    小麦苗DBA宝典
  • 【DB笔试面试522】在Oracle中,数据库和实例的关系是什么?

    数据库(DATABASE)是一个数据集合,Oracle数据库都将其数据存放在数据文件中。在物理结构上,Oracle数据库必须的3类文件分别是数据文件、控制文件和...

    小麦苗DBA宝典
  • 【DB笔试面试433】在Oracle 12c中,在数据泵(expdp)方面有哪些增强的新特性?

    (1)在Data Pump中引入了新的TRANSFORM的选项DISABLE_ARCHIVE_LOGGING,这对于表和索引在导入期间提供了关闭Redo日志生成...

    小麦苗DBA宝典
  • 20万DBA都在关注的11个问题(超有料)

    描述: 目前一个12.2的库,数据库种有大量course: mutex X和course: mutex S等待事件,请问_cursor_obsolete_thr...

    数据和云
  • 你该知道的 Oracle 认证那些事儿

    https://education.oracle.com/oracle-certification-exams-list

    JiekeXu之路
  • 如何在半个工作日内完成20套以上Oracle DB的部署?

    最近新项目建设需要(外部开发商程序限制),要求部署20套独立Oracle数据库(缘何如此设计不详,接到任务只能执行)。

    杨漆
  • Oracle 11g静默安装简明版

    $ more /u02/soft/database/response/db_install.rsp

    Alfred Zhao
  • Oracle 12c PDB浅析(r9笔记第10天)

    不管怎么样,12c出来这么久,总是因为各种各样的原因没有开始学习,现在似乎还是有些晚了。总是耳闻PDB在12c是一种全新的架构模式,在各种技术聊 天也大概知道是...

    jeanron100
  • 回答了这四个问题,少踩12c 多租户的好多坑

    在ACOUG的年终大会上,我分享了一个主题,列举了使用Oracle 12c多租户的过程中可能遇到的各种坑,当你使用一个新产品或者新特性时,如果你不了解,就可能是...

    数据和云

扫码关注云+社区

领取腾讯云代金券