Shulou(Shulou.com)06/01 Report--

Installation steps:

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

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

Annex db_instal_xayw.rsp

#

# # Copyright (c) Oracle Corporation 1998 pint 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. 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:. -when database domain isn't NULL

#-when database domain is NULL

# Default value: None

# Mandatory: Yes

#-

GdbName=ORCL

#-

# Name: sid

# Datatype: String

# Description: System identifier (SID) of the database

# Valid values: Check Oracle12c Administrator's Guide

# Default value: specified in GDBNAME

# Mandatory: No

#-

Sid=ORCL

#-

# Name: databaseConfigType

# Datatype: String

# Description: database conf type as Single Instance, Real Application Cluster 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 =. 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=

Reference link

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

Note that the dbca create database command parameters are missing in this link.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.