18000 single db installation on CENTOS 6 x64

发布时间：2020-08-18 07:36:14 来源：ITPUB博客阅读：196 作者：ilsyx 栏目：关系型数据库

安装步骤：

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

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

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

## ##

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

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

## ##

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

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

## ##

## 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创建数据库命令参数有遗漏。

向AI问一下细节

18000 single db installation on CENTOS 6 x64

安装步骤：

附件

db_instal_xayw.rsp

netca_xayw.rsp

dbca_xayw.rsp

参考链接

猜你喜欢

最新资讯

相关推荐

相关标签