18000 single db installation on CENTOS 6 x64

安装步骤：

# cd /etc/yum.repos.d/

wget Http://yum.oracle.com/public-yum-ol6.repo

# yum install oracle-database-preinstall-18c

#######Creating Oracle Users and groups

groupadd  oinstall

groupadd  dba

useradd  -g oinstall -G dba -c "Oracle software owner" oracle

####### Creating Environment variables for Oracle & Grid User ####

login as the oracle user:

cat .bash_profile

umask 022

export ORACLE_BASE=/oraclesoftware/app

export ORACLE_HOME=$ORACLE_BASE/product/18.3/dbhome_1

export ORACLE_PATH=$ORACLE_HOME/bin:/usr/bin:$GRID_HOME/bin

export ORACLE_SID=ORCL

export PATH=$PATH:$ORACLE_HOME/bin:$GRID_HOME/bin

export TMPDIR=/var/tmp

export TNS_ADMIN=$ORACLE_HOME/network/admin

# Oracle custom commands

set -o vi

PS1="

`hostname`@\${ORACLE_SID}-\${PWD}

>"

####### Setting the user security limits

edit /etc/security/limits.conf

* soft nofile 131072

* hard nofile 131072

* soft nproc 131072

* hard nproc 131072

* soft core unlimited

* hard core unlimited

* soft memlock unlimited

* hard memlock unlimited

####### Setting sysctl parameters

# Controls the default maximum size of a message queue

kernel.msgmnb = 65536

# Controls the maximum size of a message, in bytes

kernel.msgmax = 65536

# Controls the maximum shared segment size, in bytes

kernel.shmmax = 6011532288

# Controls the maximum number of shared memory segments, in pages

kernel.shmall = 2935318

kernel.shmmni = 4096

# Kernel tuning for semaphores, values are in order

kernel.sem = "SEMMSL SEMMNS SEMOPM SEMMNI"

kernel.sem = 250 32000 100 128

# Number of Open file descriptors

fs.file-max = 6815744

# Maximum number of allowable concurrent requests

fs.aio-max-nr = 1048576

# NETWORK TUNING PARAMETERS FOR THROUGHPUT

#Tune Receive Socket buffer size

net.core.rmem_default=262144

net.core.rmem_max=4194304

#Send socket buffer size

net.core.wmem_default=262144

net.core.wmem_max=4194304

#tcp Socket buffer size

net.ipv4.tcp_rmem=4096 262144 4194304

net.ipv4.tcp_wmem=4096 262144 4194304

#Network port range

net.ipv4.ip_local_port_range=9000 65000

# NETWORK PERFORMANCE TUNING FOR ORACLE

# How often to send keep alive packets when a connection is unused

net.ipv4.tcp_keepalive_time=30

# How long the kernel waits in between probes

net.ipv4.tcp_keepalive_intvl=60

# How many probes are sent before a connection is considered broken

net.ipv4.tcp_keepalive_probes=9

# How many times to retry before killing the connection

net.ipv4.tcp_retries2=3

# How many times to retry transmitting the syn packet

net.ipv4.tcp_syn_retries=2

# Kernel Tuning parameters for Virtual Memory

# Turn off Swapping. Swapping for Oracle is not recommended

vm.swappiness=0

# Maximum percentage of active memory that can have dirty pages

vm.dirty_background_ratio=3

# Maximum percentage of total memory that can have dirty pages

vm.dirty_ratio=15

#How long data can be in page cache before being expired(hundreths of a second)

vm.dirty_expire_centisecs=500

# How often pdflush is activated to clean dirty pages (hundredths of a second)###

vm.dirty_writeback_centisecs=100

# Setup the oracle user to be able to use hugepages - Typically the output of command`id -g oracle` should be given.

vm.hugetlb_shm_group=1001

# huge page settings - derived from running the hugepages.sh script, typically provide 1 or 2 pages additional to the recommended value from the script

vm.nr_hugepages = 114

#######install software & database

$ORACLE_HOME/runInstaller -silent -responseFile /home/oracle/db_instal_xayw.rsp

$ORACLE_HOME/bin/netca -silent -responsefile /home/oracle/netca_xayw.rsp

$ORACLE_HOME/bin/dbca -silent  -createDatabase -responseFile /home/oracle/dbca_xayw.rsp

附件

db_instal_xayw.rsp

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

## Copyright(c) Oracle Corporation 1998,2018. 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_v18.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

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

# 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=/home/oracle/oraInventory

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

# Specify the complete path of the Oracle Home.

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

ORACLE_HOME=/home/oracle/product/18.3/dbhome_1

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

# Specify the complete path of the Oracle Base.

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

ORACLE_BASE=/home/oracle/product

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

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

#                                                                             #

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

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

# 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

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

netca_xayw.rsp

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

## Copyright(c) 1998, 2018 Oracle Corporation. All rights reserved. ##

##                                                                  ##

## Specify values for the variables listed below to customize your  ##

## installation.                                                    ##

##                                                                  ##

## Each variable is associated with a comment. The comment          ##

## identifies the variable type.                                    ##

##                                                                  ##

## Please specify the values in the following format:               ##

##                                                                  ##

##         Type         Example                                     ##

##         String       "Sample Value"                              ##

##         Boolean      True or False                               ##

##         Number       1000                                        ##

##         StringList   {"String value 1","String Value 2"}         ##

##                                                                  ##

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

##                                                                  ##

## This sample response file causes the Oracle Net Configuration    ##

## Assistant (NetCA) to complete an Oracle Net configuration during ##

## a custom install of the Oracle12c server which is similar to     ##

## what would be created by the NetCA during typical Oracle12c      ##

## install. It also documents all of the NetCA response file        ##

## variables so you can create your own response file to configure  ##

## Oracle Net during an install the way you wish.                   ##

##                                                                  ##

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

[GENERAL]

RESPONSEFILE_VERSION="12.2"

CREATE_TYPE="CUSTOM"

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

# Name       : SHOW_GUI

# Datatype   : Boolean

# Description: This variable controls appearance/suppression of the NetCA GUI,

# Pre-req    : N/A

# Default    : TRUE

# Note:

# This must be set to false in order to run NetCA in silent mode.

# This is a substitute of "/silent" flag in the NetCA command line.

# The command line flag has precedence over the one in this response file.

# This feature is present since 10.1.0.3.

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

SHOW_GUI=false

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

# Name       : LOG_FILE

# Datatype   : String

# Description: If present, NetCA will log output to this file in addition to the

#              standard out.

# Pre-req    : N/A

# Default    : NONE

# Note:

#       This is a substitute of "/log" in the NetCA command line.

# The command line argument has precedence over the one in this response file.

# This feature is present since 10.1.0.3.

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

#LOG_FILE=""/oracle12cHome/network/tools/log/netca.log""

[oracle.net.ca]

#INSTALLED_COMPONENTS;StringList;list of installed components

# The possible values for installed components are:

# "net8","server","client","aso", "cman", "javavm"

INSTALLED_COMPONENTS={"server","net8","javavm"}

#INSTALL_TYPE;String;type of install

# The possible values for install type are:

# "typical","minimal" or "custom"

INSTALL_TYPE=""typical""

#LISTENER_NUMBER;Number;Number of Listeners

# A typical install sets one listener

LISTENER_NUMBER=1

#LISTENER_NAMES;StringList;list of listener names

# The values for listener are:

# "LISTENER","LISTENER1","LISTENER2","LISTENER3", ...

# A typical install sets only "LISTENER"

LISTENER_NAMES={"LISTENER"}

#LISTENER_PROTOCOLS;StringList;list of listener addresses (protocols and parameters separated by semicolons)

# The possible values for listener protocols are:

# "TCP;1521","TCPS;2484","NMP;ORapiPE","IPC;IPCKEY","VI;1521"

# For multiple listeners, separate them with commas ex "TCP;1521","TCPS;2484"

# For multiple protocols in single listener, separate them with "&" ex  "TCP;1521&TCPS;2484"

# A typical install sets only "TCP;1521"

LISTENER_PROTOCOLS={"TCP;1521"}

#LISTENER_START;String;name of the listener to start, in double quotes

LISTENER_START=""LISTENER""

#NAMING_METHODS;StringList;list of naming methods

# The possible values for naming methods are:

# LDAP, TNSNAMES, ONAMES, HOSTNAME, NOVELL, NIS, DCE

# A typical install sets only: "TNSNAMES","ONAMES","HOSTNAMES"

# or "LDAP","TNSNAMES","ONAMES","HOSTNAMES" for LDAP

NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}

#NOVELL_NAMECONTEXT;String;Novell Directory Service name context, in double quotes

# A typical install does not use this variable.

#NOVELL_NAMECONTEXT = ""NAMCONTEXT""

#SUN_METAMAP;String; SUN meta map, in double quotes

# A typical install does not use this variable.

#SUN_METAMAP = ""MAP""

#DCE_CELLNAME;String;DCE cell name, in double quotes

# A typical install does not use this variable.

#DCE_CELLNAME = ""CELL""

#NSN_NUMBER;Number;Number of NetService Names

# A typical install sets one net service name

NSN_NUMBER=1

#NSN_NAMES;StringList;list of Net Service names

# A typical install sets net service name to "EXTPROC_CONNECTION_DATA"

NSN_NAMES={"EXTPROC_CONNECTION_DATA"}

#NSN_SERVICE;StringList;Oracle12c database's service name

# A typical install sets Oracle12c database's service name to "PLSExtProc"

NSN_SERVICE={"PLSExtProc"}

#NSN_PROTOCOLS;StringList;list of coma separated strings of Net Service Name protocol parameters

# The possible values for net service name protocol parameters are:

# "TCP;HOSTNAME;1521","TCPS;HOSTNAME;2484","NMP;COMPUTERNAME;ORAPIPE","VI;HOSTNAME;1521","IPC;IPCKEY"

# A typical install sets parameters to "IPC;EXTPROC"

NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}

#SERVICEUSERPASSWORD;String;Windows service user password

# If the oracle home is installed as secure user, supply the password

#SERVICEUSERPASSWORD=""svcpassword""

dbca_xayw.rsp

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

##                                                                          ##

##                            DBCA response file                            ##

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

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

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

responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0

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

# Name          : gdbName

# Datatype      : String

# Description   : Global database name of the database

# Valid values  : <db_name>.<db_domain> - when database domain isn't NULL

#                 <db_name>             - when database domain is NULL

# Default value : None

# Mandatory     : Yes

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

gdbName=ORCL

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

# Name          : sid

# Datatype      : String

# Description   : System identifier (SID) of the database

# Valid values  : Check Oracle12c Administrator's Guide

# Default value : <db_name> specified in GDBNAME

# Mandatory     : No

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

sid=ORCL

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

# Name          : databaseConfigType

# Datatype      : String

# Description   : database conf type as Single Instance, Real Application Cluster or Real Application Cluster One Nodes database

# Valid values  : SI\RAC\RACONENODE

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

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

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

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

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

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

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

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

# Name          : numberOfPDBs

# Datatype      : Number

# Description   : Specify the number of pdb to be created

# Valid values  : 0 to 4094

# Default value : 0

# Mandatory     : No

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

numberOfPDBs=

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

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

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

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

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

# 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          : templateName

# Datatype      : String

# Description   : Name of the template

# Valid values  : Template file name

# Default value : None

# Mandatory     : Yes

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

templateName=/home/oracle/product/18.3/dbhome_1/assistants/dbca/templates/New_Database.dbt

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

# Name          : sysPassword

# Datatype      : String

# Description   : Password for SYS user

# Valid values  : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory     : Yes

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

sysPassword=oracle

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

# Name          : systemPassword

# Datatype      : String

# Description   : Password for SYSTEM user

# Valid values  : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory     : Yes

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

systemPassword=oracle

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

# Name          : oracleHomeUserPassword

# Datatype      : String

# Description   : Password for Windows Service user

# Default value : None

# Mandatory     : If Oracle home is installed with windows service user

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

oracleHomeUserPassword=

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

# Name          : emConfiguration

# Datatype      : String

# Description   : Enterprise Manager Configuration Type

# Valid values  : CENTRAL|DBEXPRESS|BOTH|NONE

# Default value : NONE

# Mandatory     : No

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

emConfiguration=

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

# Name          : emExpressPort

# Datatype      : Number

# Description   : Enterprise Manager Configuration Type

# Valid values  : Check Oracle12c Administrator's Guide

# Default value : NONE

# Mandatory     : No, will be picked up from DBEXPRESS_https_PORT env variable

#                 or auto generates a free port between 5500 and 5599

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

emExpressPort=5500

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

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

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

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

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

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

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

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

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

# Name          : datafilejarLocation

# Datatype      : String

# Description   : Location of the data file jar

# Valid values  : Directory containing compressed datafile jar

# Default value : None

# Mandatory     : No

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

datafileJarLocation=

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

# Name          : datafileDestination

# Datatype      : String

# Description   : Location of the data file's

# Valid values  : Directory for all the database files

# Default value : $ORACLE_BASE/oradata

# Mandatory     : No

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

datafileDestination=/home/oracle/product/oradata

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

# 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=/home/oracle/product/flash_recovery_area

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

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

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

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

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

# Name          : reGISterWithDirService

# Datatype      : Boolean

# Description   : Specifies whether to register with Directory Service.

# Valid values  : TRUE \ FALSE

# Default value : FALSE

# Mandatory     : No

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

registerWithDirService=

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

# 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          : variablesFile

# Datatype      : String

# Description   : Location of the file containing variable value pair

# Valid values  : A valid file-system file. The variable value pair format in this file

#                 is <variable>=<value>. Each pair should be in a new line.

# Default value : None

# Mandatory     : NO

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

variablesFile=

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

# Name          : variables

# Datatype      : String

# Description   : comma separated list of name=value pairs. Overrides variables defined in variablefile and templates

# Default value : None

# Mandatory     : NO

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

variables=

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

# Name          : initParams

# Datatype      : String

# Description   : comma separated list of name=value pairs. Overrides initialization parameters defined in templates

# Default value : None

# Mandatory     : NO

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

initParams=

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

# Name          : sampleSchema

# Datatype      : Boolean

# Description   : Specifies whether or not to add the Sample Schemas to your database

# Valid values  : TRUE \ FALSE

# Default value : FASLE

# Mandatory     : No

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

sampleSchema=

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

# Name          : memoryPercentage

# Datatype      : String

# Description   : percentage of physical memory for Oracle

# Default value : None

# Mandatory     : NO

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

memoryPercentage=50

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

# Name          : databaseType

# Datatype      : String

# Description   : used for memory distribution when memoryPercentage specified

# Valid values  : MULTIPURPOSE|DATA_WAREHOUSING|OLTP

# Default value : MULTIPURPOSE

# Mandatory     : NO

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

databaseType=

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

# Name          : automaticMemoryManagement

# Datatype      : Boolean

# Description   : flag to indicate Automatic Memory Management is used

# Valid values  : TRUE/FALSE

# Default value : TRUE

# Mandatory     : NO

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

automaticMemoryManagement=

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

# Name          : totalMemory

# Datatype      : String

# Description   : total memory in MB to allocate to Oracle

# Valid values  :

# Default value :

# Mandatory     : NO

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

totalMemory=

参考链接

https://docs.oracle.com/en/database/oracle/oracle-database/18/ladbi/running-database-configuration-assistant-using-response-files.html#GUID-E84CE996-B30C-4DCA-AE4C-1E90201317C2

注意此链接中dbca创建数据库命令参数有遗漏。