{"id":918,"date":"2022-09-07T15:24:29","date_gmt":"2022-09-07T07:24:29","guid":{"rendered":"https:\/\/www.dd-home.top\/?p=918"},"modified":"2022-09-07T15:26:36","modified_gmt":"2022-09-07T07:26:36","slug":"centos-%e5%ae%89%e8%a3%85oracle","status":"publish","type":"post","link":"https:\/\/www.dd-home.top\/?p=918","title":{"rendered":"Centos \u5b89\u88c5Oracle"},"content":{"rendered":"<p><!--more--><\/p>\n<h4>1\u3001\u67e5\u770bSwap\u5206\u533a\u5927\u5c0f\uff08\u4e0d\u80fd\u5c0f\u4e8e2G\uff09<\/h4>\n<pre><code class=\"language-shell\">grep SwapTotal \/proc\/meminfo<\/code><\/pre>\n<h4>2\u3001\u4fee\u6539Centos\u7cfb\u7edf\u6807\u8bc6\uff08Oracle\u4e0d\u652f\u6301Centos\uff09<\/h4>\n<pre><code class=\"language-shell\">vi \/etc\/redhat-release\r\n\r\n#\u5220\u9664CentOS Linux release 7.9.2009 (Core)\uff08\u5feb\u6377\u952edd\uff09\uff0c\u6539\u6210 redhat-7<\/code><\/pre>\n<h4>3\u3001\u4fee\u6539sysctl.conf<\/h4>\n<pre><code class=\"language-shell\">vi \/etc\/sysctl.conf<\/code><\/pre>\n<pre><code class=\"language-shell\">#\u589e\u52a0\u4e00\u4e0b\u5185\u5bb9\r\nfs.aio-max-nr = 1048576\r\nfs.file-max = 6815744\r\nkernel.shmmni = 4096\r\nkernel.sem = 250 32000 100 128\r\nkernel.shmall = 2097152\r\nkernel.shmmax = 2147483648\r\nnet.ipv4.ip_local_port_range = 9000 65500\r\nnet.ipv4.icmp_echo_ignore_broadcasts = 1\r\nnet.ipv4.conf.all.rp_filter = 1\r\nnet.core.rmem_default = 262144\r\nnet.core.rmem_max= 4194304\r\nnet.core.wmem_default= 262144\r\nnet.core.wmem_max= 1048576<\/code><\/pre>\n<h4>4\u3001\u5237\u65b0\u914d\u7f6e<\/h4>\n<pre><code class=\"language-shell\">sysctl -p<\/code><\/pre>\n<h4>5\u3001\u5b89\u88c5\u524d\u7f6e\u8f6f\u4ef6<\/h4>\n<pre><code class=\"language-shell\">yum -y install binutils* compat-libcap1* compat-libstdc++* gcc* gcc-c++* glibc* glibc-devel* ksh* libaio* libaio-devel* libgcc* libstdc++* libstdc++-devel* libXi* libXtst* make* sysstat* elfutils* unixODBC* unzip lrzsz<\/code><\/pre>\n<h4>6\u3001\u521b\u5efa\u7528\u6237\u7ec4<\/h4>\n<pre><code class=\"language-shell\">#\u521b\u5efa\u5b89\u88c5oracle \u7a0b\u5e8f\u7528\u6237\u7ec4\r\ngroupadd oinstall\r\n\r\n#\u521b\u5efaDBA\u7528\u6237\u7ec4\r\ngroupadd dba\r\n\r\n#\u521b\u5efa\u7528\u6237oracle \u5e76\u52a0\u5165\u5230dba\u7ec4\r\nuseradd -g dba -m oracle\r\n\r\n#\u5c06\u7528\u6237oracle \u52a0\u5165\u5230oinstall\u7ec4\r\nusermod -a -G oinstall oracle\r\n\r\n#\u4fee\u6539\u7528\u6237oracle\u5bc6\u7801\uff08\u8bb0\u4f4f\u5bc6\u7801\uff0c\u6211\u7528\u7684\u662froot\uff09\r\npasswd oracle\r\n\r\n#\u67e5\u770b\u7528\u6237Oracle\u4fe1\u606f\r\nid oracle\r\n<\/code><\/pre>\n<h4>7\u3001Oracle\u76ee\u5f55\u914d\u7f6e<\/h4>\n<pre><code class=\"language-shell\">#\u521b\u5efaoracle\u4e3b\u76ee\u5f55\r\nmkdir -p \/data\/oracle\r\n#\u521b\u5efaoracle\u914d\u7f6e\u76ee\u5f55\r\nmkdir -p \/data\/inventory\r\n#\u521b\u5efaOracle\u538b\u7f29\u5305\u89e3\u538b\u76ee\u5f55\r\nmkdir -p \/data\/src\r\n\r\n#\u4fee\u6539\u76ee\u5f55\u6743\u9650\r\nchown -R oracle:oinstall \/data\/oracle\r\nchown -R oracle:oinstall \/data\/inventory\r\nchown -R oracle:oinstall \/data\/src\r\n\r\n#\u67e5\u770b\u76ee\u5f55\u6743\u9650\r\nll \/data<\/code><\/pre>\n<h4>8\u3001\u4fee\u6539Oracle\u7528\u6237\u7684\u5b89\u5168\u6027<\/h4>\n<pre><code class=\"language-shell\">vi \/etc\/security\/limits.conf\r\n\r\n#\u6dfb\u52a0\u4ee5\u4e0b\u5185\u5bb9\r\noracle soft nproc 2047\r\noracle hard nproc 16384\r\noracle soft nofile 1024\r\noracle hard nofile 65536<\/code><\/pre>\n<h4>9\u3001\u4fee\u6539\u7528\u6237\u7684\u73af\u5883\u53d8\u91cf<\/h4>\n<pre><code class=\"language-shell\">vi \/home\/oracle\/.bashrc\r\n\r\n#\u6dfb\u52a0\u4ee5\u4e0b\u5185\u5bb9\r\n\r\nexport PATH\r\nexport ORACLE_BASE=\/data\/oracle\r\nexport ORACLE_HOME=$ORACLE_BASE\/product\/11.2.0\/db_1\r\nexport ORACLE_SID=orcl\r\nexport ORACLE_UNQNAME=orcl\r\nexport PATH=$ORACLE_HOME\/bin:\/usr\/sbin:$PATH\r\nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib\r\nexport LANG=C\r\nexport NLS_LANG=AMERICAN_AMERICA.AL32UTF8\r\n\r\n#\u5237\u65b0oracle\u73af\u5883\u53d8\u91cf\r\nsource \/home\/oracle\/.bashrc<\/code><\/pre>\n<h4>10.\u5b89\u88c5\u5305\u5904\u7406<\/h4>\n<pre><code class=\"language-shell\">#\u4e0a\u4f20linux.x64_11gR2_database_1of2.zip\u548clinux.x64_11gR2_database_2of2.zip\u4e24\u4e2a\u538b\u7f29\u5305\u5230\u670d\u52a1\u5668\/root\u76ee\u5f55\u4e0b\r\n\r\n#\u89e3\u538b\u4e24\u4e2a\u538b\u7f29\u5305\r\nunzip linux.x64_11gR2_database_1of2.zip -d \/data\/src\/\r\nunzip linux.x64_11gR2_database_2of2.zip -d \/data\/src\/\r\n#\u4fee\u6539\u6587\u4ef6\u6743\u9650\r\nchown -R oracle:oinstall \/data\/src\/\r\nll \/data\/src\/<\/code><\/pre>\n<h4>11\u3001\u5904\u7406selinux<\/h4>\n<pre><code class=\"language-shell\">vi \/etc\/selinux\/config\r\n#\u4fee\u6539SELINUX=disabled\r\n\r\n#\u91cd\u542f\u670d\u52a1\u5668\r\nreboot<\/code><\/pre>\n<h4>12\u3001Oracle\u5b89\u88c5<\/h4>\n<pre><code class=\"language-shell\">#\u5207\u6362\u7528\u6237\r\nsu oracle\r\n\r\n#\u7f16\u8f91\u6570\u636e\u5e93\u5b89\u88c5\u6587\u4ef6\r\nvi \/data\/src\/database\/response\/db_install.rsp\r\n\r\n#\u9700\u8981\u4fee\u6539\u5982\u4e0b\r\noracle.install.option=INSTALL_DB_SWONLY     \u3000\u3000\u3000\u3000\u3000\u3000     # \u5b89\u88c5\u7c7b\u578b\r\nORACLE_HOSTNAME=oracle.server                    \u3000\u3000\u3000     # \u4e3b\u673a\u540d\u79f0\r\nUNIX_GROUP_NAME=oinstall                                   # \u5b89\u88c5\u7ec4\r\nINVENTORY_LOCATION=\/data\/inventory                         # INVENTORY\u76ee\u5f55\r\nSELECTED_LANGUAGES=en,zh_CN                                # \u9009\u62e9\u8bed\u8a00\r\nORACLE_HOME=\/data\/oracle\/product\/11.2.0\/db_1               # oracle_home\r\nORACLE_BASE=\/data\/oracle                                   # oracle_base\r\noracle.install.db.InstallEdition=EE                        # oracle\u7248\u672c\r\noracle.install.db.DBA_GROUP=dba                            # dba\u7528\u6237\u7ec4\r\noracle.install.db.OPER_GROUP=oinstall                      # oper\u7528\u6237\u7ec4\r\noracle.install.db.config.starterdb.type=GENERAL_PURPOSE    # \u6570\u636e\u5e93\u7c7b\u578b\r\noracle.install.db.config.starterdb.globalDBName=orcl       # globalDBName\r\noracle.install.db.config.starterdb.SID=orcl                # SID\r\noracle.install.db.config.starterdb.characterSet=AL32UTF8   # \u9ed8\u8ba4\u6570\u636e\u5e93\u7f16\u7801\r\noracle.install.db.config.starterdb.memoryLimit=800         # \u81ea\u52a8\u7ba1\u7406\u5185\u5b58\u7684\u6700\u5c0f\u5185\u5b58(M)\r\noracle.install.db.config.starterdb.password.ALL=oracle     # \u8bbe\u5b9a\u6240\u6709\u6570\u636e\u5e93\u7528\u6237\u4f7f\u7528\u540c\u4e00\u4e2a\u5bc6\u7801\r\nDECLINE_SECURITY_UPDATES=true                              # \u8bbe\u7f6e\u5b89\u5168\u66f4\u65b0\r\n\r\n#\u5982\u4e0b\u4e3a\u5df2\u4fee\u6539\u6587\u4ef6\r\n<\/code><\/pre>\n<pre><code class=\"language-shell\">####################################################################\r\n## Copyright(c) Oracle Corporation 1998,2008. All rights reserved.##\r\n##                                                                ##\r\n## Specify values for the variables listed below to customize     ##\r\n## your installation.                                             ##\r\n##                                                                ##\r\n## Each variable is associated with a comment. The comment        ##\r\n## can help to populate the variables with the appropriate        ##\r\n## values.                            ##\r\n##                                                                ##\r\n## IMPORTANT NOTE: This file contains plain text passwords and    ##\r\n## should be secured to have read permission only by oracle user  ##\r\n## or db administrator who owns this installation.                ##\r\n##                                                                ##\r\n####################################################################\r\n\r\n#------------------------------------------------------------------------------\r\n# Do not change the following system generated value. \r\n#------------------------------------------------------------------------------\r\noracle.install.responseFileVersion=\/oracle\/install\/rspfmt_dbinstall_response_schema_v11_2_0\r\n\r\n#------------------------------------------------------------------------------\r\n# Specify the installation option.\r\n# It can be one of the following:\r\n# 1. INSTALL_DB_SWONLY\r\n# 2. INSTALL_DB_AND_CONFIG\r\n# 3. UPGRADE_DB\r\n#-------------------------------------------------------------------------------\r\noracle.install.option=INSTALL_DB_SWONLY\r\n\r\n#-------------------------------------------------------------------------------\r\n# Specify the hostname of the system as set during the install. It can be used\r\n# to force the installation to use an alternative hostname rather than using the\r\n# first hostname found on the system. (e.g., for systems with multiple hostnames \r\n# and network interfaces)\r\n#-------------------------------------------------------------------------------\r\nORACLE_HOSTNAME=oracle.server\r\n\r\n#-------------------------------------------------------------------------------\r\n# Specify the Unix group to be set for the inventory directory.  \r\n#-------------------------------------------------------------------------------\r\nUNIX_GROUP_NAME=oinstall\r\n\r\n#-------------------------------------------------------------------------------\r\n# Specify the location which holds the inventory files.\r\n#-------------------------------------------------------------------------------\r\nINVENTORY_LOCATION=\/data\/inventory\r\n\r\n#-------------------------------------------------------------------------------\r\n# Specify the languages in which the components will be installed.             \r\n#\r\n# en   : English                  ja   : Japanese                  \r\n# fr   : French                   ko   : Korean                    \r\n# ar   : Arabic                   es   : Latin American Spanish    \r\n# bn   : Bengali                  lv   : Latvian                   \r\n# pt_BR: Brazilian Portuguese     lt   : Lithuanian                \r\n# bg   : Bulgarian                ms   : Malay                     \r\n# fr_CA: Canadian French          es_MX: Mexican Spanish           \r\n# ca   : Catalan                  no   : Norwegian                 \r\n# hr   : Croatian                 pl   : Polish                    \r\n# cs   : Czech                    pt   : Portuguese                \r\n# da   : Danish                   ro   : Romanian                  \r\n# nl   : Dutch                    ru   : Russian                   \r\n# ar_EG: Egyptian                 zh_CN: Simplified Chinese        \r\n# en_GB: English (Great Britain)  sk   : Slovak                    \r\n# et   : Estonian                 sl   : Slovenian                 \r\n# fi   : Finnish                  es_ES: Spanish                   \r\n# de   : German                   sv   : Swedish                   \r\n# el   : Greek                    th   : Thai                      \r\n# iw   : Hebrew                   zh_TW: Traditional Chinese       \r\n# hu   : Hungarian                tr   : Turkish                   \r\n# is   : Icelandic                uk   : Ukrainian                 \r\n# in   : Indonesian               vi   : Vietnamese                \r\n# it   : Italian                                                   \r\n#\r\n# Example : SELECTED_LANGUAGES=en,fr,ja\r\n#------------------------------------------------------------------------------\r\nSELECTED_LANGUAGES=en,zh_CN\r\n\r\n#------------------------------------------------------------------------------\r\n# Specify the complete path of the Oracle Home.\r\n#------------------------------------------------------------------------------\r\nORACLE_HOME=\/data\/oracle\/product\/11.2.0\/db_1\r\n\r\n#------------------------------------------------------------------------------\r\n# Specify the complete path of the Oracle Base. \r\n#------------------------------------------------------------------------------\r\nORACLE_BASE=\/data\/oracle\r\n\r\n#------------------------------------------------------------------------------\r\n# Specify the installation edition of the component.                        \r\n#                                                             \r\n# The value should contain only one of these choices.        \r\n# EE     : Enterprise Edition                                \r\n# SE     : Standard Edition                                  \r\n# SEONE  : Standard Edition One\r\n# PE     : Personal Edition (WINDOWS ONLY)\r\n#------------------------------------------------------------------------------\r\noracle.install.db.InstallEdition=EE\r\n\r\n#------------------------------------------------------------------------------\r\n# This variable is used to enable or disable custom install.\r\n#\r\n# true  : Components mentioned as part of 'customComponents' property\r\n#         are considered for install.\r\n# false : Value for 'customComponents' is not considered.\r\n#------------------------------------------------------------------------------\r\noracle.install.db.isCustomInstall=false\r\n\r\n#------------------------------------------------------------------------------\r\n# This variable is considered only if 'IsCustomInstall' is set to true. \r\n#\r\n# Description: List of Enterprise Edition Options you would like to install.\r\n#\r\n#              The following choices are available. You may specify any\r\n#              combination of these choices.  The components you choose should\r\n#              be specified in the form \"internal-component-name:version\"\r\n#              Below is a list of components you may specify to install.\r\n#        \r\n#              oracle.rdbms.partitioning:11.2.0.1.0 - Oracle Partitioning\r\n#              oracle.rdbms.dm:11.2.0.1.0 - Oracle Data Mining\r\n#              oracle.rdbms.dv:11.2.0.1.0 - Oracle Database Vault \r\n#              oracle.rdbms.lbac:11.2.0.1.0 - Oracle Label Security\r\n#              oracle.rdbms.rat:11.2.0.1.0 - Oracle Real Application Testing \r\n#              oracle.oraolap:11.2.0.1.0 - Oracle OLAP\r\n#------------------------------------------------------------------------------\r\noracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11.2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms.partitioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1.0,oracle.rdbms.rat:11.2.0.1.0\r\n\r\n###############################################################################\r\n#                                                                             #\r\n# PRIVILEGED OPERATING SYSTEM GROUPS                                          #\r\n# ------------------------------------------                                  #\r\n# Provide values for the OS groups to which OSDBA and OSOPER privileges       #\r\n# needs to be granted. If the install is being performed as a member of the   #     \r\n# group \"dba\", then that will be used unless specified otherwise below.         #\r\n#                                                                             #\r\n###############################################################################\r\n\r\n#------------------------------------------------------------------------------\r\n# The DBA_GROUP is the OS group which is to be granted OSDBA privileges.\r\n#------------------------------------------------------------------------------\r\noracle.install.db.DBA_GROUP=dba\r\n\r\n#------------------------------------------------------------------------------\r\n# The OPER_GROUP is the OS group which is to be granted OSOPER privileges.\r\n#------------------------------------------------------------------------------\r\noracle.install.db.OPER_GROUP=oinstall\r\n\r\n#------------------------------------------------------------------------------\r\n# Specify the cluster node names selected during the installation.\r\n#------------------------------------------------------------------------------\r\noracle.install.db.CLUSTER_NODES=\r\n\r\n#------------------------------------------------------------------------------\r\n# Specify the type of database to create.\r\n# It can be one of the following:\r\n# - GENERAL_PURPOSE\/TRANSACTION_PROCESSING          \r\n# - DATA_WAREHOUSE                                \r\n#------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.type=GENERAL_PURPOSE\r\n\r\n#------------------------------------------------------------------------------\r\n# Specify the Starter Database Global Database Name. \r\n#------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.globalDBName=orcl\r\n\r\n#------------------------------------------------------------------------------\r\n# Specify the Starter Database SID.\r\n#------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.SID=orcl\r\n\r\n#------------------------------------------------------------------------------\r\n# Specify the Starter Database character set.\r\n#                                              \r\n# It can be one of the following:\r\n# AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2,\r\n# EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257,\r\n# BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6,\r\n# AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8,\r\n# IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE,\r\n# KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950,\r\n# ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258\r\n#------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.characterSet=AL32UTF8\r\n\r\n#------------------------------------------------------------------------------\r\n# This variable should be set to true if Automatic Memory Management \r\n# in Database is desired.\r\n# If Automatic Memory Management is not desired, and memory allocation\r\n# is to be done manually, then set it to false.\r\n#------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.memoryOption=true\r\n\r\n#------------------------------------------------------------------------------\r\n# Specify the total memory allocation for the database. Value(in MB) should be\r\n# at least 256 MB, and should not exceed the total physical memory available \r\n# on the system.\r\n# Example: oracle.install.db.config.starterdb.memoryLimit=512\r\n#------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.memoryLimit=800\r\n\r\n#------------------------------------------------------------------------------\r\n# This variable controls whether to load Example Schemas onto the starter\r\n# database or not.\r\n#------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.installExampleSchemas=false\r\n\r\n#------------------------------------------------------------------------------\r\n# This variable includes enabling audit settings, configuring password profiles\r\n# and revoking some grants to public. These settings are provided by default. \r\n# These settings may also be disabled.    \r\n#------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.enableSecuritySettings=true\r\n\r\n###############################################################################\r\n#                                                                             #\r\n# Passwords can be supplied for the following four schemas in the         #\r\n# starter database:                                   #\r\n#   SYS                                                                       #\r\n#   SYSTEM                                                                    #\r\n#   SYSMAN (used by Enterprise Manager)                                       #\r\n#   DBSNMP (used by Enterprise Manager)                                       #\r\n#                                                                             #\r\n# Same password can be used for all accounts (not recommended)            #\r\n# or different passwords for each account can be provided (recommended)       #\r\n#                                                                             #\r\n###############################################################################\r\n\r\n#------------------------------------------------------------------------------\r\n# This variable holds the password that is to be used for all schemas in the\r\n# starter database.\r\n#-------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.password.ALL=oracle\r\n\r\n#-------------------------------------------------------------------------------\r\n# Specify the SYS password for the starter database.\r\n#-------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.password.SYS=\r\n\r\n#-------------------------------------------------------------------------------\r\n# Specify the SYSTEM password for the starter database.\r\n#-------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.password.SYSTEM=\r\n\r\n#-------------------------------------------------------------------------------\r\n# Specify the SYSMAN password for the starter database.\r\n#-------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.password.SYSMAN=\r\n\r\n#-------------------------------------------------------------------------------\r\n# Specify the DBSNMP password for the starter database.\r\n#-------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.password.DBSNMP=\r\n\r\n#-------------------------------------------------------------------------------\r\n# Specify the management option to be selected for the starter database. \r\n# It can be one of the following:\r\n# 1. GRID_CONTROL\r\n# 2. DB_CONTROL\r\n#-------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.control=DB_CONTROL\r\n\r\n#-------------------------------------------------------------------------------\r\n# Specify the Management Service to use if Grid Control is selected to manage \r\n# the database.      \r\n#-------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=\r\n\r\n#-------------------------------------------------------------------------------\r\n# This variable indicates whether to receive email notification for critical \r\n# alerts when using DB control.   \r\n#-------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false\r\n\r\n#-------------------------------------------------------------------------------\r\n# Specify the email address to which the notifications are to be sent.\r\n#-------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.dbcontrol.emailAddress=\r\n\r\n#-------------------------------------------------------------------------------\r\n# Specify the SMTP server used for email notifications.\r\n#-------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.dbcontrol.SMTPServer=\r\n\r\n###############################################################################\r\n#                                                                             #\r\n# SPECIFY BACKUP AND RECOVERY OPTIONS                                         #\r\n# ------------------------------------                                    #\r\n# Out-of-box backup and recovery options for the database can be mentioned    #\r\n# using the entries below.                            # \r\n#                                                                             #\r\n###############################################################################\r\n\r\n#------------------------------------------------------------------------------\r\n# This variable is to be set to false if automated backup is not required. Else \r\n# this can be set to true.\r\n#------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.automatedBackup.enable=false\r\n\r\n#------------------------------------------------------------------------------\r\n# Regardless of the type of storage that is chosen for backup and recovery, if \r\n# automated backups are enabled, a job will be scheduled to run daily at\r\n# 2:00 AM to backup the database. This job will run as the operating system \r\n# user that is specified in this variable.\r\n#------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.automatedBackup.osuid=\r\n\r\n#-------------------------------------------------------------------------------\r\n# Regardless of the type of storage that is chosen for backup and recovery, if \r\n# automated backups are enabled, a job will be scheduled to run daily at\r\n# 2:00 AM to backup the database. This job will run as the operating system user\r\n# specified by the above entry. The following entry stores the password for the\r\n# above operating system user.\r\n#-------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.automatedBackup.ospwd=\r\n\r\n#-------------------------------------------------------------------------------\r\n# Specify the type of storage to use for the database.\r\n# It can be one of the following:\r\n# - FILE_SYSTEM_STORAGE\r\n# - ASM_STORAGE\r\n#------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.storageType=\r\n\r\n#-------------------------------------------------------------------------------\r\n# Specify the database file location which is a directory for datafiles, control\r\n# files, redo logs.         \r\n#\r\n# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM \r\n#-------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.fileSystemStorage.dataLocation=\r\n\r\n#-------------------------------------------------------------------------------\r\n# Specify the backup and recovery location.\r\n#\r\n# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM \r\n#-------------------------------------------------------------------------------\r\noracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=\r\n\r\n#-------------------------------------------------------------------------------\r\n# Specify the existing ASM disk groups to be used for storage.\r\n#\r\n# Applicable only when oracle.install.db.config.starterdb.storage=ASM\r\n#-------------------------------------------------------------------------------\r\noracle.install.db.config.asm.diskGroup=\r\n\r\n#-------------------------------------------------------------------------------\r\n# Specify the password for ASMSNMP user of the ASM instance.                  \r\n#\r\n# Applicable only when oracle.install.db.config.starterdb.storage=ASM_SYSTEM \r\n#-------------------------------------------------------------------------------\r\noracle.install.db.config.asm.ASMSNMPPassword=\r\n\r\n#------------------------------------------------------------------------------\r\n# Specify the My Oracle Support Account Username.\r\n#\r\n#  Example   : MYORACLESUPPORT_USERNAME=metalink\r\n#------------------------------------------------------------------------------\r\nMYORACLESUPPORT_USERNAME=\r\n\r\n#------------------------------------------------------------------------------\r\n# Specify the My Oracle Support Account Username password.\r\n#\r\n# Example    : MYORACLESUPPORT_PASSWORD=password\r\n#------------------------------------------------------------------------------\r\nMYORACLESUPPORT_PASSWORD=\r\n\r\n#------------------------------------------------------------------------------\r\n# Specify whether to enable the user to set the password for\r\n# My Oracle Support credentials. The value can be either true or false.\r\n# If left blank it will be assumed to be false.\r\n#\r\n# Example    : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true\r\n#------------------------------------------------------------------------------\r\nSECURITY_UPDATES_VIA_MYORACLESUPPORT=\r\n\r\n#------------------------------------------------------------------------------\r\n# Specify whether user wants to give any proxy details for connection. \r\n# The value can be either true or false. If left blank it will be assumed\r\n# to be false.\r\n#\r\n# Example    : DECLINE_SECURITY_UPDATES=false\r\n#------------------------------------------------------------------------------\r\nDECLINE_SECURITY_UPDATES=true\r\n\r\n#------------------------------------------------------------------------------\r\n# Specify the Proxy server name. Length should be greater than zero.\r\n#\r\n# Example    : PROXY_HOST=proxy.domain.com \r\n#------------------------------------------------------------------------------\r\nPROXY_HOST=\r\n\r\n#------------------------------------------------------------------------------\r\n# Specify the proxy port number. Should be Numeric and atleast 2 chars.\r\n#\r\n# Example    : PROXY_PORT=25 \r\n#------------------------------------------------------------------------------\r\nPROXY_PORT=\r\n\r\n#------------------------------------------------------------------------------\r\n# Specify the proxy user name. Leave PROXY_USER and PROXY_PWD \r\n# blank if your proxy server requires no authentication.\r\n#\r\n# Example    : PROXY_USER=username \r\n#------------------------------------------------------------------------------\r\nPROXY_USER=\r\n\r\n#------------------------------------------------------------------------------\r\n# Specify the proxy password. Leave PROXY_USER and PROXY_PWD  \r\n# blank if your proxy server requires no authentication.\r\n#\r\n# Example    : PROXY_PWD=password \r\n#------------------------------------------------------------------------------\r\nPROXY_PWD=<\/code><\/pre>\n<pre><code class=\"language-shell\"># \u5b89\u88c5Oracle\r\n\/data\/src\/database\/runInstaller -silent -responseFile \/data\/src\/database\/response\/db_install.rsp -ignorePrereq\r\n\r\n#\u7a97\u53e3\u51fa\u73b0 Successfully Setup Software.\r\n#1.\u65b0\u5efa\u4e00\u4e2a\u7a97\u53e3\r\n#2.\u4f7f\u7528root\u8d26\u6237\u767b\u9646\r\n#3.\u8fd0\u884c\u811a\u672c\r\n\/data\/oracle\/product\/11.2.0\/db_1\/root.sh\r\n#4.\u56de\u5230\u539f\u7a97\u53e3\u6309\u56de\u8f66\u952e<\/code><\/pre>\n<pre><code class=\"language-shell\">#\u7f16\u8f91\u76d1\u542c\u914d\u7f6e\u6587\u4ef6\r\nvim \/data\/src\/database\/response\/netca.rsp\r\n\r\n#\u9700\u8981\u4fee\u6539\u7684\u5730\u65b9\r\nINSTALL_TYPE=\"\"custom\"\"                               # \u5b89\u88c5\u7684\u7c7b\u578b\r\nLISTENER_NUMBER=1                                     # \u76d1\u542c\u5668\u6570\u91cf\r\nLISTENER_NAMES={\"LISTENER\"}                           # \u76d1\u542c\u5668\u7684\u540d\u79f0\u5217\u8868\r\nLISTENER_PROTOCOLS={\"TCP;1521\"}                       # \u76d1\u542c\u5668\u4f7f\u7528\u7684\u901a\u8baf\u534f\u8bae\u5217\u8868\r\nLISTENER_START=\"\"LISTENER\"\"                           # \u76d1\u542c\u5668\u542f\u52a8\u7684\u540d\u79f0\r\n\r\n#\u4e0b\u9762\u4e3a\u5df2\u4fee\u6539\u6587\u4ef6<\/code><\/pre>\n<pre><code class=\"language-shell\">############################################################### \r\n## Copyright(c) Oracle Corporation 2002. All rights reserved.## \r\n##                                                           ## \r\n## Specify values for the variables listed below to customize## \r\n## your installation.                                        ## \r\n##                                                           ## \r\n## Each variable is associated with a comment. The comment   ## \r\n## identifies the variable type.                             ## \r\n##                                                           ## \r\n## Please specify the values in the following format:        ## \r\n##                                                           ## \r\n##         Type         Example                              ## \r\n##         String       \"Sample Value\"                       ## \r\n##         Boolean      True or False                        ## \r\n##         Number       1000                                 ## \r\n##         StringList   {\"String value 1\",\"String Value 2\"}  ## \r\n##                                                           ## \r\n############################################################### \r\n##                                                           ## \r\n## This sample response file causes the Oracle Net           ##\r\n## Configuration Assistant (NetCA) to complete an Oracle Net ##\r\n## configuration during a custom install of the Oracle11g    ##\r\n## server which is similar to what would be created by the   ##\r\n## NetCA during typical Oracle11g install. It also documents ##\r\n## all of the NetCA response files variables so you can      ##\r\n## create your own response file to configure Oracle Net     ##\r\n## during an install the way you wish.                       ##\r\n##                                                           ## \r\n############################################################### \r\n\r\n[GENERAL]\r\nRESPONSEFILE_VERSION=\"11.2\"\r\nCREATE_TYPE=\"CUSTOM\"\r\n\r\n#-------------------------------------------------------------------------------\r\n# Name       : SHOW_GUI\r\n# Datatype   : Boolean\r\n# Description: This variable controls appearance\/suppression of the NetCA GUI,\r\n# Pre-req    : N\/A\r\n# Default    : TRUE\r\n# Note:\r\n# This must be set to false in order to run NetCA in silent mode. \r\n# This is a substitute of \"\/silent\" flag in the NetCA command line.\r\n# The command line flag has precedence over the one in this response file.\r\n# This feature is present since 10.1.0.3.\r\n#-------------------------------------------------------------------------------\r\n#SHOW_GUI=false\r\n\r\n#-------------------------------------------------------------------------------\r\n# Name       : LOG_FILE\r\n# Datatype   : String\r\n# Description: If present, NetCA will log output to this file in addition to the\r\n#          standard out.\r\n# Pre-req    : N\/A\r\n# Default    : NONE\r\n# Note:\r\n#   This is a substitute of \"\/log\" in the NetCA command line.\r\n# The command line argument has precedence over the one in this response file.\r\n# This feature is present since 10.1.0.3.\r\n#-------------------------------------------------------------------------------\r\n#LOG_FILE=\"\"\/oracle11gHome\/network\/tools\/log\/netca.log\"\"\r\n\r\n[oracle.net.ca]\r\n#INSTALLED_COMPONENTS;StringList;list of installed components\r\n# The possible values for installed components are:\r\n# \"net8\",\"server\",\"client\",\"aso\", \"cman\", \"javavm\" \r\nINSTALLED_COMPONENTS={\"server\",\"net8\",\"javavm\"}\r\n\r\n#INSTALL_TYPE;String;type of install\r\n# The possible values for install type are:\r\n# \"typical\",\"minimal\" or \"custom\"\r\nINSTALL_TYPE=\"\"custom\"\"\r\n\r\n#LISTENER_NUMBER;Number;Number of Listeners\r\n# A typical install sets one listener \r\nLISTENER_NUMBER=1\r\n\r\n#LISTENER_NAMES;StringList;list of listener names\r\n# The values for listener are:\r\n# \"LISTENER\",\"LISTENER1\",\"LISTENER2\",\"LISTENER3\", ...\r\n# A typical install sets only \"LISTENER\" \r\nLISTENER_NAMES={\"LISTENER\"}\r\n\r\n#LISTENER_PROTOCOLS;StringList;list of listener addresses (protocols and parameters separated by semicolons)\r\n# The possible values for listener protocols are:\r\n# \"TCP;1521\",\"TCPS;2484\",\"NMP;ORAPIPE\",\"IPC;IPCKEY\",\"VI;1521\" \r\n# A typical install sets only \"TCP;1521\" \r\nLISTENER_PROTOCOLS={\"TCP;1521\"}\r\n\r\n#LISTENER_START;String;name of the listener to start, in double quotes\r\nLISTENER_START=\"\"LISTENER\"\"\r\n\r\n#NAMING_METHODS;StringList;list of naming methods\r\n# The possible values for naming methods are: \r\n# LDAP, TNSNAMES, ONAMES, HOSTNAME, NOVELL, NIS, DCE\r\n# A typical install sets only: \"TNSNAMES\",\"ONAMES\",\"HOSTNAMES\" \r\n# or \"LDAP\",\"TNSNAMES\",\"ONAMES\",\"HOSTNAMES\" for LDAP\r\nNAMING_METHODS={\"TNSNAMES\",\"ONAMES\",\"HOSTNAME\"}\r\n\r\n#NOVELL_NAMECONTEXT;String;Novell Directory Service name context, in double quotes\r\n# A typical install does not use this variable. \r\n#NOVELL_NAMECONTEXT = \"\"NAMCONTEXT\"\"\r\n\r\n#SUN_METAMAP;String; SUN meta map, in double quotes\r\n# A typical install does not use this variable. \r\n#SUN_METAMAP = \"\"MAP\"\"\r\n\r\n#DCE_CELLNAME;String;DCE cell name, in double quotes\r\n# A typical install does not use this variable. \r\n#DCE_CELLNAME = \"\"CELL\"\"\r\n\r\n#NSN_NUMBER;Number;Number of NetService Names\r\n# A typical install sets one net service name\r\nNSN_NUMBER=1\r\n\r\n#NSN_NAMES;StringList;list of Net Service names\r\n# A typical install sets net service name to \"EXTPROC_CONNECTION_DATA\"\r\nNSN_NAMES={\"EXTPROC_CONNECTION_DATA\"}\r\n\r\n#NSN_SERVICE;StringList;Oracle11g database's service name\r\n# A typical install sets Oracle11g database's service name to \"PLSExtProc\"\r\nNSN_SERVICE={\"PLSExtProc\"}\r\n\r\n#NSN_PROTOCOLS;StringList;list of coma separated strings of Net Service Name protocol parameters\r\n# The possible values for net service name protocol parameters are:\r\n# \"TCP;HOSTNAME;1521\",\"TCPS;HOSTNAME;2484\",\"NMP;COMPUTERNAME;ORAPIPE\",\"VI;HOSTNAME;1521\",\"IPC;IPCKEY\"  \r\n# A typical install sets parameters to \"IPC;EXTPROC\"\r\nNSN_PROTOCOLS={\"TCP;HOSTNAME;1521\"}\r\n<\/code><\/pre>\n<pre><code class=\"language-shell\">#\u6267\u884c\u76d1\u542c\u914d\u7f6e\u6587\u4ef6\r\n\/data\/oracle\/product\/11.2.0\/db_1\/bin\/netca \/silent \/responseFile \/data\/src\/database\/response\/netca.rsp<\/code><\/pre>\n<pre><code class=\"language-shell\">#\u7f16\u8f91\u6570\u636e\u5e93\u5b9e\u4f8b\r\nvim \/data\/src\/database\/response\/dbca.rsp\r\n\r\n#\u4fee\u6539\u7684\u5730\u65b9\r\nRESPONSEFILE_VERSION =\"11.2.0\"                              \/\/ \u4e0d\u8981\u53d8\u54e6\r\nOPERATION_TYPE =\"createDatabase\"                            \/\/ \u64cd\u4f5c\u4e3a\u521b\u5efa\u5b9e\u4f8b  \r\nGDBNAME =\"orcl\"                                             \/\/ \u6570\u636e\u5e93\u5b9e\u4f8b\u540d\r\nSID =\"orcl\"                                                 \/\/ \u5b9e\u4f8b\u540d\u5b57\r\nTEMPLATENAME = \"General_Purpose.dbc\"                        \/\/ \u5efa\u5e93\u7528\u7684\u6a21\u677f\u6587\u4ef6\r\nSYSPASSWORD = \"oracle\"                                      \/\/ SYS\u7ba1\u7406\u5458\u5bc6\u7801\r\nSYSTEMPASSWORD = \"oracle\"                                   \/\/ SYSTEM\u7ba1\u7406\u5458\u5bc6\u7801\r\nSYSMANPASSWORD= \"oracle\"\r\nDBSNMPPASSWORD= \"oracle\"\r\nDATAFILEDESTINATION =\/data\/oracle\/oradata                   \/\/ \u6570\u636e\u6587\u4ef6\u5b58\u653e\u76ee\u5f55\r\nRECOVERYAREADESTINATION=\/data\/oracle\/flash_recovery_area    \/\/ \u6062\u590d\u6570\u636e\u5b58\u653e\u76ee\u5f55\r\nCHARACTERSET =\"AL32UTF8\"                                    \/\/ \u5b57\u7b26\u96c6\r\nNATIONALCHARACTERSET= \"AL16UTF16\"                           \/\/ \u5b57\u7b26\u96c6\r\nTOTALMEMORY =\"1638\"                                         \/\/ 1638MB\uff0c\u7269\u7406\u5185\u5b582G*80%\r\n\r\n#\u4e0b\u65b9\u4e3a\u5df2\u7ecf\u4fee\u6539\u7684<\/code><\/pre>\n<pre><code class=\"language-shell\">##############################################################################\r\n##                                                                          ##\r\n##                            DBCA response file                            ##\r\n##                            ------------------                            ##\r\n## Copyright   1998, 2007, Oracle Corporation. All Rights Reserved.         ##\r\n##                                                                          ##\r\n## Specify values for the variables listed below to customize Oracle        ##\r\n## Database Configuration installation.                                     ##\r\n##                                                                          ##\r\n## Each variable is associated with a comment. The comment identifies the   ##\r\n## variable type.                                                           ##\r\n##                                                                          ##\r\n## Please specify the values in the following format :                      ##\r\n##          Type       :  Example                                           ##\r\n##          String     :  \"&lt;value&gt;\"                                         ##\r\n##          Boolean    :  True or False                                     ##\r\n##          Number     :  &lt;numeric value&gt;                                   ##\r\n##          StringList :  {\"&lt;value1&gt;\",\"&lt;value2&gt;\"}                           ##\r\n##                                                                          ##\r\n## Examples :                                                               ##\r\n##     1. dbca -progress_only -responseFile &lt;response file&gt;                 ##\r\n##        Display a progress bar depicting progress of database creation    ##\r\n##        process.                                                          ##\r\n##                                                                          ##\r\n##     2. dbca -silent -responseFile &lt;response file&gt;                        ##\r\n##        Creates database silently. No user interface is displayed.        ##\r\n##                                                                          ##\r\n##     3. dbca -silent -createDatabase -cloneTemplate                       ##\r\n##           -responseFile &lt;response file&gt;                      ##\r\n##        Creates database silently with clone template. The template in    ##\r\n##    responsefile is a clone template.                         ##\r\n##                                                                          ##\r\n##     4. dbca -silent -deleteDatabase -responseFile &lt;response file&gt;        ##\r\n##        Deletes database silently.                                        ##\r\n##############################################################################\r\n\r\n#-----------------------------------------------------------------------------\r\n# GENERAL section is required for all types of database creations.\r\n#-----------------------------------------------------------------------------\r\n[GENERAL]\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : RESPONSEFILE_VERSION\r\n# Datatype      : String\r\n# Description   : Version of the database to create\r\n# Valid values  : \"11.1.0\"\r\n# Default value : None\r\n# Mandatory     : Yes\r\n#-----------------------------------------------------------------------------\r\nRESPONSEFILE_VERSION = \"11.2.0\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : OPERATION_TYPE\r\n# Datatype      : String\r\n# Description   : Type of operation\r\n# Valid values  : \"createDatabase\" \\ \"createTemplateFromDB\" \\ \"createCloneTemplate\" \\ \"deleteDatabase\" \\ \"configureDatabase\" \\ \"addInstance\" (RAC-only) \\ \"deleteInstance\" (RAC-only)\r\n# Default value : None\r\n# Mandatory     : Yes\r\n#-----------------------------------------------------------------------------\r\nOPERATION_TYPE = \"createDatabase\"\r\n\r\n#-----------------------*** End of GENERAL section ***------------------------\r\n\r\n#-----------------------------------------------------------------------------\r\n# CREATEDATABASE section is used when OPERATION_TYPE is defined as \"createDatabase\". \r\n#-----------------------------------------------------------------------------\r\n[CREATEDATABASE]\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : GDBNAME\r\n# Datatype      : String\r\n# Description   : Global database name of the database\r\n# Valid values  : &lt;db_name&gt;.&lt;db_domain&gt; - when database domain isn't NULL\r\n#                 &lt;db_name&gt;             - when database domain is NULL\r\n# Default value : None\r\n# Mandatory     : Yes\r\n#-----------------------------------------------------------------------------\r\nGDBNAME = \"orcl\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : POLICYMANAGED\r\n# Datatype      : Boolean\r\n# Description   : Set to true if Database is policy managed and \r\n#         set to false if  Database is admin managed\r\n# Valid values  : TRUE\\FALSE\r\n# Default value : FALSE\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#POLICYMANAGED = \"false\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : CREATESERVERPOOL\r\n# Datatype      : Boolean\r\n# Description   : Set to true if new server pool need to be created for database \r\n#         if this option is specified then the newly created database \r\n#         will use this newly created serverpool. \r\n#         Multiple serverpoolname can not be specified for database\r\n# Valid values  : TRUE\\FALSE\r\n# Default value : FALSE\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#CREATESERVERPOOL = \"false\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : FORCE\r\n# Datatype      : Boolean\r\n# Description   : Set to true if new server pool need to be created by force \r\n#         if this option is specified then the newly created serverpool\r\n#         will be assigned server even if no free servers are available.\r\n#         This may affect already running database.\r\n#         This flag can be specified for Admin managed as well as policy managed db.\r\n# Valid values  : TRUE\\FALSE\r\n# Default value : FALSE\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#FORCE = \"false\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SERVERPOOLNAME\r\n# Datatype      : String\r\n# Description   : Only one serverpool name need to be specified \r\n#          if Create Server Pool option is specified. \r\n#          Comma-separated list of Serverpool names if db need to use\r\n#          multiple Server pool\r\n# Valid values  : ServerPool name\r\n# Default value : None\r\n# Mandatory     : No [required in case of RAC service centric database]\r\n#-----------------------------------------------------------------------------\r\n#SERVERPOOLNAME = \r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : CARDINALITY\r\n# Datatype      : Number\r\n# Description   : Specify Cardinality for create server pool operation\r\n# Valid values  : any positive Integer value\r\n# Default value : Number of qualified nodes on cluster\r\n# Mandatory     : No [Required when a new serverpool need to be created]\r\n#-----------------------------------------------------------------------------\r\n#CARDINALITY = \r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SID\r\n# Datatype      : String\r\n# Description   : System identifier (SID) of the database\r\n# Valid values  : Check Oracle11g Administrator's Guide\r\n# Default value : &lt;db_name&gt; specified in GDBNAME\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\nSID = \"orcl\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : NODELIST\r\n# Datatype      : String\r\n# Description   : Comma-separated list of cluster nodes\r\n# Valid values  : Cluster node names\r\n# Default value : None\r\n# Mandatory     : No (Yes for RAC database-centric database )\r\n#-----------------------------------------------------------------------------\r\n#NODELIST=\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : TEMPLATENAME\r\n# Datatype      : String\r\n# Description   : Name of the template\r\n# Valid values  : Template file name\r\n# Default value : None\r\n# Mandatory     : Yes\r\n#-----------------------------------------------------------------------------\r\nTEMPLATENAME = \"General_Purpose.dbc\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : OBFUSCATEDPASSWORDS\r\n# Datatype      : Boolean\r\n# Description   : Set to true if passwords are encrypted\r\n# Valid values  : TRUE\\FALSE\r\n# Default value : FALSE\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#OBFUSCATEDPASSWORDS = FALSE\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SYSPASSWORD\r\n# Datatype      : String\r\n# Description   : Password for SYS user\r\n# Valid values  : Check Oracle11g Administrator's Guide\r\n# Default value : None\r\n# Mandatory     : Yes\r\n#-----------------------------------------------------------------------------\r\nSYSPASSWORD = \"oracle\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SYSTEMPASSWORD\r\n# Datatype      : String\r\n# Description   : Password for SYSTEM user\r\n# Valid values  : Check Oracle11g Administrator's Guide\r\n# Default value : None\r\n# Mandatory     : Yes\r\n#-----------------------------------------------------------------------------\r\nSYSTEMPASSWORD = \"oracle\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : EMCONFIGURATION\r\n# Datatype      : String\r\n# Description   : Enterprise Manager Configuration Type\r\n# Valid values  : CENTRAL|LOCAL|ALL|NOBACKUP|NOEMAIL|NONE\r\n# Default value : NONE\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#EMCONFIGURATION = \"NONE\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : DISABLESECURITYCONFIGURATION\r\n# Datatype      : String\r\n# Description   : Database Security Settings\r\n# Valid values  : ALL|NONE|AUDIT|PASSWORD_PROFILE\r\n# Default value : NONE\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#DISABLESECURITYCONFIGURATION = \"NONE\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SYSMANPASSWORD\r\n# Datatype      : String\r\n# Description   : Password for SYSMAN user\r\n# Valid values  : Check Oracle11g Administrator's Guide\r\n# Default value : None\r\n# Mandatory     : Yes, if LOCAL specified for EMCONFIGURATION\r\n#-----------------------------------------------------------------------------\r\nSYSMANPASSWORD = \"oracle\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : DBSNMPPASSWORD\r\n# Datatype      : String\r\n# Description   : Password for DBSNMP user\r\n# Valid values  : Check Oracle11g Administrator's Guide\r\n# Default value : None\r\n# Mandatory     : Yes, if EMCONFIGURATION is specified\r\n#-----------------------------------------------------------------------------\r\nDBSNMPPASSWORD = \"oracle\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : CENTRALAGENT\r\n# Datatype      : String\r\n# Description   : Grid Control Central Agent Oracle Home\r\n# Default value : None\r\n# Mandatory     : Yes, if CENTRAL is specified for EMCONFIGURATION\r\n#-----------------------------------------------------------------------------\r\n#CENTRALAGENT = \r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : HOSTUSERNAME\r\n# Datatype      : String\r\n# Description   : Host user name for EM backup job\r\n# Default value : None\r\n# Mandatory     : Yes, if ALL or NOEMAIL are specified for EMCONFIGURATION\r\n#-----------------------------------------------------------------------------\r\n#HOSTUSERNAME = \r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : HOSTUSERPASSWORD\r\n# Datatype      : String\r\n# Description   : Host user password for EM backup job\r\n# Default value : None\r\n# Mandatory     : Yes, if ALL or NOEMAIL are specified for EMCONFIGURATION\r\n#-----------------------------------------------------------------------------\r\n#HOSTUSERPASSWORD= \r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : BACKUPSCHEDULE\r\n# Datatype      : String\r\n# Description   : Daily backup schedule in the form of hh:mm\r\n# Default value : 2:00\r\n# Mandatory     : Yes, if ALL or NOEMAIL are specified for EMCONFIGURATION\r\n#-----------------------------------------------------------------------------\r\n#BACKUPSCHEDULE=\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SMTPSERVER\r\n# Datatype      : String\r\n# Description   : Outgoing mail (SMTP) server for email notifications\r\n# Default value : None\r\n# Mandatory     : Yes, if ALL or NOBACKUP are specified for EMCONFIGURATION\r\n#-----------------------------------------------------------------------------\r\n#SMTPSERVER =\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : EMAILADDRESS\r\n# Datatype      : String\r\n# Description   : Email address for email notifications\r\n# Default value : None\r\n# Mandatory     : Yes, if ALL or NOBACKUP are specified for EMCONFIGURATION\r\n#-----------------------------------------------------------------------------\r\n#EMAILADDRESS =\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : DVOWNERNAME\r\n# Datatype      : String\r\n# Description   : DataVault Owner\r\n# Valid values  : Check Oracle11g Administrator's Guide\r\n# Default value : None\r\n# Mandatory     : Yes, if DataVault option is chosen\r\n#-----------------------------------------------------------------------------\r\n#DVOWNERNAME = \"\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : DVOWNERPASSWORD\r\n# Datatype      : String\r\n# Description   : Password for DataVault Owner\r\n# Valid values  : Check Oracle11g Administrator's Guide\r\n# Default value : None\r\n# Mandatory     : Yes, if DataVault option is chosen\r\n#-----------------------------------------------------------------------------\r\n#DVOWNERPASSWORD = \"\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : DVACCOUNTMANAGERNAME\r\n# Datatype      : String\r\n# Description   : DataVault Account Manager\r\n# Valid values  : Check Oracle11g Administrator's Guide\r\n# Default value : None\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#DVACCOUNTMANAGERNAME = \"\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : DVACCOUNTMANAGERPASSWORD\r\n# Datatype      : String\r\n# Description   : Password for  DataVault Account Manager\r\n# Valid values  : Check Oracle11g Administrator's Guide\r\n# Default value : None\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#DVACCOUNTMANAGERPASSWORD = \"\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : DATAFILEJARLOCATION \r\n# Datatype      : String\r\n# Description   : Location of the data file jar \r\n# Valid values  : Directory containing compressed datafile jar\r\n# Default value : None\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#DATAFILEJARLOCATION =\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : DATAFILEDESTINATION \r\n# Datatype      : String\r\n# Description   : Location of the data file's\r\n# Valid values  : Directory for all the database files\r\n# Default value : $ORACLE_BASE\/oradata\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\nDATAFILEDESTINATION =\/data\/oracle\/oradata\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : RECOVERYAREADESTINATION\r\n# Datatype      : String\r\n# Description   : Location of the data file's\r\n# Valid values  : Recovery Area location\r\n# Default value : $ORACLE_BASE\/flash_recovery_area\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\nRECOVERYAREADESTINATION=\/data\/oracle\/flash_recovery_area\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : STORAGETYPE\r\n# Datatype      : String\r\n# Description   : Specifies the storage on which the database is to be created\r\n# Valid values  : FS (CFS for RAC), ASM\r\n# Default value : FS\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#STORAGETYPE=FS\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : DISKGROUPNAME\r\n# Datatype      : String\r\n# Description   : Specifies the disk group name for the storage\r\n# Default value : DATA\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#DISKGROUPNAME=DATA\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : ASMSNMP_PASSWORD\r\n# Datatype      : String\r\n# Description   : Password for ASM Monitoring\r\n# Default value : None\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#ASMSNMP_PASSWORD=\"\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : RECOVERYGROUPNAME\r\n# Datatype      : String\r\n# Description   : Specifies the disk group name for the recovery area\r\n# Default value : RECOVERY\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#RECOVERYGROUPNAME=RECOVERY\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : CHARACTERSET\r\n# Datatype      : String\r\n# Description   : Character set of the database\r\n# Valid values  : Check Oracle11g National Language Support Guide\r\n# Default value : \"US7ASCII\"\r\n# Mandatory     : NO\r\n#-----------------------------------------------------------------------------\r\nCHARACTERSET = \"AL32UTF8\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : NATIONALCHARACTERSET\r\n# Datatype      : String\r\n# Description   : National Character set of the database\r\n# Valid values  : \"UTF8\" or \"AL16UTF16\". For details, check Oracle11g National Language Support Guide\r\n# Default value : \"AL16UTF16\"\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\nNATIONALCHARACTERSET= \"AL16UTF16\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : REGISTERWITHDIRSERVICE\r\n# Datatype      : Boolean\r\n# Description   : Specifies whether to register with Directory Service.\r\n# Valid values  : TRUE \\ FALSE\r\n# Default value : FALSE\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#REGISTERWITHDIRSERVICE= TRUE\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : DIRSERVICEUSERNAME\r\n# Datatype      : String\r\n# Description   : Specifies the name of the directory service user\r\n# Mandatory     : YES, if the value of registerWithDirService is TRUE\r\n#-----------------------------------------------------------------------------\r\n#DIRSERVICEUSERNAME= \"name\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : DIRSERVICEPASSWORD\r\n# Datatype      : String\r\n# Description   : The password of the directory service user.\r\n#         You can also specify the password at the command prompt instead of here.\r\n# Mandatory     : YES, if the value of registerWithDirService is TRUE\r\n#-----------------------------------------------------------------------------\r\n#DIRSERVICEPASSWORD= \"password\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : WALLETPASSWORD\r\n# Datatype      : String\r\n# Description   : The password for wallet to created or modified.\r\n#         You can also specify the password at the command prompt instead of here.\r\n# Mandatory     : YES, if the value of registerWithDirService is TRUE\r\n#-----------------------------------------------------------------------------\r\n#WALLETPASSWORD= \"password\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : LISTENERS\r\n# Datatype      : String\r\n# Description   : Specifies list of listeners to register the database with.\r\n#         By default the database is configured for all the listeners specified in the \r\n#         $ORACLE_HOME\/network\/admin\/listener.ora   \r\n# Valid values  : The list should be space separated names like \"listener1 listener2\".\r\n# Mandatory     : NO\r\n#-----------------------------------------------------------------------------\r\n#LISTENERS = \"listener1 listener2\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : VARIABLESFILE \r\n# Datatype      : String\r\n# Description   : Location of the file containing variable value pair\r\n# Valid values  : A valid file-system file. The variable value pair format in this file \r\n#         is &lt;variable&gt;=&lt;value&gt;. Each pair should be in a new line.\r\n# Default value : None\r\n# Mandatory     : NO\r\n#-----------------------------------------------------------------------------\r\n#VARIABLESFILE =\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : VARIABLES\r\n# Datatype      : String\r\n# Description   : comma separated list of name=value pairs. Overrides variables defined in variablefile and templates\r\n# Default value : None\r\n# Mandatory     : NO\r\n#-----------------------------------------------------------------------------\r\n#VARIABLES =\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : INITPARAMS\r\n# Datatype      : String\r\n# Description   : comma separated list of name=value pairs. Overrides initialization parameters defined in templates\r\n# Default value : None\r\n# Mandatory     : NO\r\n#-----------------------------------------------------------------------------\r\n#INITPARAMS =\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : MEMORYPERCENTAGE\r\n# Datatype      : String\r\n# Description   : percentage of physical memory for Oracle\r\n# Default value : None\r\n# Mandatory     : NO\r\n#-----------------------------------------------------------------------------\r\n#MEMORYPERCENTAGE = \"40\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : DATABASETYPE\r\n# Datatype      : String\r\n# Description   : used for memory distribution when MEMORYPERCENTAGE specified\r\n# Valid values  : MULTIPURPOSE|DATA_WAREHOUSING|OLTP\r\n# Default value : MULTIPURPOSE\r\n# Mandatory     : NO\r\n#-----------------------------------------------------------------------------\r\n#DATABASETYPE = \"MULTIPURPOSE\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : AUTOMATICMEMORYMANAGEMENT\r\n# Datatype      : Boolean\r\n# Description   : flag to indicate Automatic Memory Management is used\r\n# Valid values  : TRUE\/FALSE\r\n# Default value : TRUE\r\n# Mandatory     : NO\r\n#-----------------------------------------------------------------------------\r\n#AUTOMATICMEMORYMANAGEMENT = \"TRUE\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : TOTALMEMORY\r\n# Datatype      : String\r\n# Description   : total memory in MB to allocate to Oracle\r\n# Valid values  : \r\n# Default value : \r\n# Mandatory     : NO\r\n#-----------------------------------------------------------------------------\r\nTOTALMEMORY = \"1638\"\r\n\r\n#-----------------------*** End of CREATEDATABASE section ***------------------------\r\n\r\n#-----------------------------------------------------------------------------\r\n# createTemplateFromDB section is used when OPERATION_TYPE is defined as \"createTemplateFromDB\". \r\n#-----------------------------------------------------------------------------\r\n[createTemplateFromDB]\r\n#-----------------------------------------------------------------------------\r\n# Name          : SOURCEDB \r\n# Datatype      : String\r\n# Description   : The source database from which to create the template\r\n# Valid values  : The format is &lt;host&gt;:&lt;port&gt;:&lt;sid&gt;\r\n# Default value : none\r\n# Mandatory     : YES\r\n#-----------------------------------------------------------------------------\r\nSOURCEDB = \"myhost:1521:orcl\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SYSDBAUSERNAME \r\n# Datatype      : String\r\n# Description   : A user with DBA role.\r\n# Default value : none\r\n# Mandatory     : YES\r\n#-----------------------------------------------------------------------------\r\nSYSDBAUSERNAME = \"system\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SYSDBAPASSWORD \r\n# Datatype      : String\r\n# Description   : The password of the DBA user.\r\n#         You can also specify the password at the command prompt instead of here.\r\n# Default value : none\r\n# Mandatory     : YES\r\n#-----------------------------------------------------------------------------\r\n#SYSDBAPASSWORD = \"password\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : TEMPLATENAME\r\n# Datatype      : String\r\n# Description   : Name for the new template.\r\n# Default value : None\r\n# Mandatory     : Yes\r\n#-----------------------------------------------------------------------------\r\nTEMPLATENAME = \"My Copy TEMPLATE\"\r\n\r\n#-----------------------*** End of createTemplateFromDB section ***------------------------\r\n\r\n#-----------------------------------------------------------------------------\r\n# createCloneTemplate section is used when OPERATION_TYPE is defined as \"createCloneTemplate\". \r\n#-----------------------------------------------------------------------------\r\n[createCloneTemplate]\r\n#-----------------------------------------------------------------------------\r\n# Name          : SOURCEDB\r\n# Datatype      : String\r\n# Description   : The source database is the SID from which to create the template. \r\n#         This database must be local and on the same ORACLE_HOME.\r\n# Default value : none\r\n# Mandatory     : YES\r\n#-----------------------------------------------------------------------------\r\nSOURCEDB = \"orcl\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SYSDBAUSERNAME\r\n# Datatype      : String\r\n# Description   : A user with DBA role.\r\n# Default value : none\r\n# Mandatory     : YES, if no OS authentication\r\n#-----------------------------------------------------------------------------\r\n#SYSDBAUSERNAME = \"sys\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SYSDBAPASSWORD\r\n# Datatype      : String\r\n# Description   : The password of the DBA user.\r\n#         You can also specify the password at the command prompt instead of here.\r\n# Default value : none\r\n# Mandatory     : YES\r\n#-----------------------------------------------------------------------------\r\n#SYSDBAPASSWORD = \"password\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : TEMPLATENAME\r\n# Datatype      : String\r\n# Description   : Name for the new template.\r\n# Default value : None\r\n# Mandatory     : Yes\r\n#-----------------------------------------------------------------------------\r\nTEMPLATENAME = \"My Clone TEMPLATE\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : DATAFILEJARLOCATION\r\n# Datatype      : String\r\n# Description   : Location of the data file jar \r\n# Valid values  : Directory where the new compressed datafile jar will be placed\r\n# Default value : $ORACLE_HOME\/assistants\/dbca\/templates\r\n# Mandatory     : NO\r\n#-----------------------------------------------------------------------------\r\n#DATAFILEJARLOCATION = \r\n\r\n#-----------------------*** End of createCloneTemplate section ***------------------------\r\n\r\n#-----------------------------------------------------------------------------\r\n# DELETEDATABASE section is used when DELETE_TYPE is defined as \"deleteDatabase\". \r\n#-----------------------------------------------------------------------------\r\n[DELETEDATABASE]\r\n#-----------------------------------------------------------------------------\r\n# Name          : SOURCEDB\r\n# Datatype      : String\r\n# Description   : The source database is the SID \r\n#         This database must be local and on the same ORACLE_HOME.\r\n# Default value : none\r\n# Mandatory     : YES\r\n#-----------------------------------------------------------------------------\r\nSOURCEDB = \"orcl\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SYSDBAUSERNAME\r\n# Datatype      : String\r\n# Description   : A user with DBA role.\r\n# Default value : none\r\n# Mandatory     : YES, if no OS authentication\r\n#-----------------------------------------------------------------------------\r\n#SYSDBAUSERNAME = \"sys\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SYSDBAPASSWORD\r\n# Datatype      : String\r\n# Description   : The password of the DBA user.\r\n#         You can also specify the password at the command prompt instead of here.\r\n# Default value : none\r\n# Mandatory     : YES, if no OS authentication\r\n#-----------------------------------------------------------------------------\r\n#SYSDBAPASSWORD = \"password\"\r\n#-----------------------*** End of deleteDatabase section ***------------------------\r\n\r\n#-----------------------------------------------------------------------------\r\n# GENERATESCRIPTS section \r\n#-----------------------------------------------------------------------------\r\n[generateScripts]\r\n#-----------------------------------------------------------------------------\r\n# Name          : TEMPLATENAME\r\n# Datatype      : String\r\n# Description   : Name of the template\r\n# Valid values  : Template name as seen in DBCA\r\n# Default value : None\r\n# Mandatory     : Yes\r\n#-----------------------------------------------------------------------------\r\nTEMPLATENAME = \"New Database\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : GDBNAME\r\n# Datatype      : String\r\n# Description   : Global database name of the database\r\n# Valid values  : &lt;db_name&gt;.&lt;db_domain&gt; - when database domain isn't NULL\r\n#                 &lt;db_name&gt;             - when database domain is NULL\r\n# Default value : None\r\n# Mandatory     : Yes\r\n#-----------------------------------------------------------------------------\r\nGDBNAME = \"orcl11.us.oracle.com\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SCRIPTDESTINATION \r\n# Datatype      : String\r\n# Description   : Location of the scripts\r\n# Valid values  : Directory for all the scripts\r\n# Default value : None\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#SCRIPTDESTINATION =\r\n\r\n#-----------------------*** End of deleteDatabase section ***------------------------\r\n\r\n#-----------------------------------------------------------------------------\r\n# CONFIGUREDATABASE section is used when OPERATION_TYPE is defined as \"configureDatabase\". \r\n#-----------------------------------------------------------------------------\r\n[CONFIGUREDATABASE]\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SOURCEDB\r\n# Datatype      : String\r\n# Description   : The source database is the SID \r\n#         This database must be local and on the same ORACLE_HOME.\r\n# Default value : none\r\n# Mandatory     : YES\r\n#-----------------------------------------------------------------------------\r\n#SOURCEDB = \"orcl\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SYSDBAUSERNAME\r\n# Datatype      : String\r\n# Description   : A user with DBA role.\r\n# Default value : none\r\n# Mandatory     : YES, if no OS authentication\r\n#-----------------------------------------------------------------------------\r\n#SYSDBAUSERNAME = \"sys\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SYSDBAPASSWORD\r\n# Datatype      : String\r\n# Description   : The password of the DBA user.\r\n#         You can also specify the password at the command prompt instead of here.\r\n# Default value : none\r\n# Mandatory     : YES, if no OS authentication\r\n#-----------------------------------------------------------------------------\r\n#SYSDBAPASSWORD =\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : REGISTERWITHDIRSERVICE\r\n# Datatype      : Boolean\r\n# Description   : Specifies whether to register with Directory Service.\r\n# Valid values  : TRUE \\ FALSE\r\n# Default value : FALSE\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#REGISTERWITHDIRSERVICE= TRUE\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : UNREGISTERWITHDIRSERVICE\r\n# Datatype      : Boolean\r\n# Description   : Specifies whether to unregister with Directory Service.\r\n# Valid values  : TRUE \\ FALSE\r\n# Default value : FALSE\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#UNREGISTERWITHDIRSERVICE= TRUE\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : REGENERATEDBPASSWORD\r\n# Datatype      : Boolean\r\n# Description   : Specifies whether regenerate database password in OID\/Wallet\r\n# Valid values  : TRUE \\ FALSE\r\n# Default value : FALSE\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#REGENERATEDBPASSWORD= TRUE\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : DIRSERVICEUSERNAME\r\n# Datatype      : String\r\n# Description   : Specifies the name of the directory service user\r\n# Mandatory     : YES, if the any of the reg\/unreg\/regenPasswd options specified\r\n#-----------------------------------------------------------------------------\r\n#DIRSERVICEUSERNAME= \"name\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : DIRSERVICEPASSWORD\r\n# Datatype      : String\r\n# Description   : The password of the directory service user.\r\n#         You can also specify the password at the command prompt instead of here.\r\n# Mandatory     : YES, if the any of the reg\/unreg\/regenPasswd options specified\r\n#-----------------------------------------------------------------------------\r\n#DIRSERVICEPASSWORD= \"password\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : WALLETPASSWORD\r\n# Datatype      : String\r\n# Description   : The password for wallet to created or modified.\r\n#         You can also specify the password at the command prompt instead of here.\r\n# Mandatory     : YES, if the any of the reg\/unreg\/regenPasswd options specified\r\n#-----------------------------------------------------------------------------\r\n#WALLETPASSWORD= \"password\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : DISABLESECURITYCONFIGURATION\r\n# Datatype      : String\r\n# Description   : Database Security Settings\r\n# Valid values  : ALL|NONE|AUDIT|PASSWORD_PROFILE\r\n# Default value : NONE\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#DISABLESECURITYCONFIGURATION = \"NONE\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : ENABLESECURITYCONFIGURATION\r\n# Datatype      : String\r\n# Description   : Database Security Settings\r\n# Valid values  : true|false\r\n# Default value : true\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#ENABLESECURITYCONFIGURATION = \"true\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : EMCONFIGURATION\r\n# Datatype      : String\r\n# Description   : Enterprise Manager Configuration Type\r\n# Valid values  : CENTRAL|LOCAL|ALL|NOBACKUP|NOEMAIL|NONE\r\n# Default value : NONE\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#EMCONFIGURATION = \"NONE\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SYSMANPASSWORD\r\n# Datatype      : String\r\n# Description   : Password for SYSMAN user\r\n# Valid values  : Check Oracle11g Administrator's Guide\r\n# Default value : None\r\n# Mandatory     : Yes, if LOCAL specified for EMCONFIGURATION\r\n#-----------------------------------------------------------------------------\r\n#SYSMANPASSWORD = \"password\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : DBSNMPPASSWORD\r\n# Datatype      : String\r\n# Description   : Password for DBSNMP user\r\n# Valid values  : Check Oracle11g Administrator's Guide\r\n# Default value : None\r\n# Mandatory     : Yes, if EMCONFIGURATION is specified\r\n#-----------------------------------------------------------------------------\r\n#DBSNMPPASSWORD = \"password\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : CENTRALAGENT\r\n# Datatype      : String\r\n# Description   : Grid Control Central Agent Oracle Home\r\n# Default value : None\r\n# Mandatory     : Yes, if CENTRAL is specified for EMCONFIGURATION\r\n#-----------------------------------------------------------------------------\r\n#CENTRALAGENT = \r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : HOSTUSERNAME\r\n# Datatype      : String\r\n# Description   : Host user name for EM backup job\r\n# Default value : None\r\n# Mandatory     : Yes, if ALL or NOEMAIL are specified for EMCONFIGURATION\r\n#-----------------------------------------------------------------------------\r\n#HOSTUSERNAME = \r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : HOSTUSERPASSWORD\r\n# Datatype      : String\r\n# Description   : Host user password for EM backup job\r\n# Default value : None\r\n# Mandatory     : Yes, if ALL or NOEMAIL are specified for EMCONFIGURATION\r\n#-----------------------------------------------------------------------------\r\n#HOSTUSERPASSWORD= \r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : BACKUPSCHEDULE\r\n# Datatype      : String\r\n# Description   : Daily backup schedule in the form of hh:mm\r\n# Default value : 2:00\r\n# Mandatory     : Yes, if ALL or NOEMAIL are specified for EMCONFIGURATION\r\n#-----------------------------------------------------------------------------\r\n#BACKUPSCHEDULE=\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SMTPSERVER\r\n# Datatype      : String\r\n# Description   : Outgoing mail (SMTP) server for email notifications\r\n# Default value : None\r\n# Mandatory     : Yes, if ALL or NOBACKUP are specified for EMCONFIGURATION\r\n#-----------------------------------------------------------------------------\r\n#SMTPSERVER =\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : EMAILADDRESS\r\n# Datatype      : String\r\n# Description   : Email address for email notifications\r\n# Default value : None\r\n# Mandatory     : Yes, if ALL or NOBACKUP are specified for EMCONFIGURATION\r\n#-----------------------------------------------------------------------------\r\n#EMAILADDRESS =\r\n\r\n#-----------------------*** End of CONFIGUREDATABASE section ***------------------------\r\n\r\n#-----------------------------------------------------------------------------\r\n# ADDINSTANCE section is used when OPERATION_TYPE is defined as \"addInstance\". \r\n#-----------------------------------------------------------------------------\r\n[ADDINSTANCE]\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : DB_UNIQUE_NAME\r\n# Datatype      : String\r\n# Description   : DB Unique Name of the RAC database\r\n# Valid values  : &lt;db_unique_name&gt;\r\n# Default value : None\r\n# Mandatory     : Yes\r\n#-----------------------------------------------------------------------------\r\nDB_UNIQUE_NAME = \"orcl11g.us.oracle.com\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : INSTANCENAME\r\n# Datatype      : String\r\n# Description   : RAC instance name to be added\r\n# Valid values  : Check Oracle11g Administrator's Guide\r\n# Default value : &lt;sid_prefix&gt;+&lt;highest_current_thread+1&gt;\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#INSTANCENAME = \"orcl1\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : NODELIST\r\n# Datatype      : String\r\n# Description   : Node on which to add new instance \r\n#                 (in 10gR2, instance addition is supported on 1 node at a time)\r\n# Valid values  : Cluster node name\r\n# Default value : None\r\n# Mandatory     : Yes\r\n#-----------------------------------------------------------------------------\r\nNODELIST=\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : OBFUSCATEDPASSWORDS\r\n# Datatype      : Boolean\r\n# Description   : Set to true if passwords are encrypted\r\n# Valid values  : TRUE\\FALSE\r\n# Default value : FALSE\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#OBFUSCATEDPASSWORDS = FALSE\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SYSDBAUSERNAME \r\n# Datatype      : String\r\n# Description   : A user with DBA role.\r\n# Default value : none\r\n# Mandatory     : YES\r\n#-----------------------------------------------------------------------------\r\nSYSDBAUSERNAME = \"sys\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SYSDBAPASSWORD \r\n# Datatype      : String\r\n# Description   : The password of the DBA user.\r\n# Default value : none\r\n# Mandatory     : YES\r\n#-----------------------------------------------------------------------------\r\n#SYSDBAPASSWORD = \"password\"\r\n\r\n#-----------------------*** End of ADDINSTANCE section ***------------------------\r\n\r\n#-----------------------------------------------------------------------------\r\n# DELETEINSTANCE section is used when OPERATION_TYPE is defined as \"deleteInstance\". \r\n#-----------------------------------------------------------------------------\r\n[DELETEINSTANCE]\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : DB_UNIQUE_NAME\r\n# Datatype      : String\r\n# Description   : DB Unique Name of the RAC database\r\n# Valid values  : &lt;db_unique_name&gt;\r\n# Default value : None\r\n# Mandatory     : Yes\r\n#-----------------------------------------------------------------------------\r\nDB_UNIQUE_NAME = \"orcl11g.us.oracle.com\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : INSTANCENAME\r\n# Datatype      : String\r\n# Description   : RAC instance name to be deleted\r\n# Valid values  : Check Oracle11g Administrator's Guide\r\n# Default value : None\r\n# Mandatory     : Yes\r\n#-----------------------------------------------------------------------------\r\nINSTANCENAME = \"orcl11g\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : NODELIST\r\n# Datatype      : String\r\n# Description   : Node on which instance to be deleted (SID) is located\r\n# Valid values  : Cluster node name\r\n# Default value : None\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#NODELIST=\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : OBFUSCATEDPASSWORDS\r\n# Datatype      : Boolean\r\n# Description   : Set to true if passwords are encrypted\r\n# Valid values  : TRUE\\FALSE\r\n# Default value : FALSE\r\n# Mandatory     : No\r\n#-----------------------------------------------------------------------------\r\n#OBFUSCATEDPASSWORDS = FALSE\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SYSDBAUSERNAME \r\n# Datatype      : String\r\n# Description   : A user with DBA role.\r\n# Default value : none\r\n# Mandatory     : YES\r\n#-----------------------------------------------------------------------------\r\nSYSDBAUSERNAME = \"sys\"\r\n\r\n#-----------------------------------------------------------------------------\r\n# Name          : SYSDBAPASSWORD \r\n# Datatype      : String\r\n# Description   : The password of the DBA user.\r\n# Default value : none\r\n# Mandatory     : YES\r\n#-----------------------------------------------------------------------------\r\n#SYSDBAPASSWORD = \"password\"\r\n\r\n#-----------------------*** End of DELETEINSTANCE section ***------------------------\r\n<\/code><\/pre>\n<pre><code class=\"language-shell\">#\u521d\u59cb\u5316\u6570\u636e\u5e93\r\n\/data\/oracle\/product\/11.2.0\/db_1\/bin\/dbca -silent -responseFile \/data\/src\/database\/response\/dbca.rsp<\/code><\/pre>\n<pre><code class=\"language-shell\">#\u67e5\u770b\u6570\u636e\u5e93\u8fd0\u884c\u72b6\u6001\r\nps -ef | grep ora_ | grep -v grep\r\n\r\n#\u4fee\u6539\u542f\u52a8\u548c\u7ba1\u7406\u6570\u636e\u5e93\u7684\u7a0b\u5e8f\uff08root\u89d2\u8272\u4e0b\uff09\r\n\r\nvi \/data\/oracle\/product\/11.2.0\/db_1\/bin\/dbstart\r\n#\u5c06ORACLE_HOME_LISTNER=$1\u4fee\u6539\u4e3aORACLE_HOME_LISTNER=\/data\/oracle\/product\/11.2.0\/db_1\r\nvi \/data\/oracle\/product\/11.2.0\/db_1\/bin\/dbshut\r\n#\u5c06ORACLE_HOME_LISTNER=$1\u4fee\u6539\u4e3aORACLE_HOME_LISTNER=\/data\/oracle\/product\/11.2.0\/db_1\r\n\r\n#\u4fee\u6539\/etc\/oratab\r\nvi \/etc\/oratab\r\n#\u5c06orcl:\/data\/oracle\/product\/11.2.0:N\u4fee\u6539\u4e3aorcl:\/data\/oracle\/product\/11.2.0:Y\r\n\r\n#\u542f\u52a8\u5b9e\u4f8b\r\n\/data\/oracle\/product\/11.2.0\/db_1\/bin\/dbstart<\/code><\/pre>\n<h4>\u914d\u7f6e\u5f00\u673a\u542f\u52a8<\/h4>\n<pre><code class=\"language-shell\">#\u5728root\u7528\u6237\u4e0b\r\nchmod +x \/etc\/rc.d\/rc.local\r\nvi \/etc\/rc.d\/rc.local\r\n\r\n#\u6dfb\u52a0\u4ee5\u4e0b\u5185\u5bb9\r\nsu oracle -lc \"\/data\/oracle\/product\/11.2.0\/db_1\/bin\/lsnrctl start\"\r\nsu oracle -lc \"\/data\/oracle\/product\/11.2.0\/db_1\/bin\/dbstart\"<\/code><\/pre>\n<h4>\u6dfb\u52a0\u7aef\u53e3<\/h4>\n<pre><code class=\"language-shell\">firewall-cmd --list-all\r\nfirewall-cmd --zone=public --permanent --add-port=1521\/tcp \r\nfirewall-cmd --zone=public --permanent --add-port=5500\/tcp\r\nfirewall-cmd --reload<\/code><\/pre>\n<h4>\u6d4b\u8bd5\u6570\u636e\u5e93<\/h4>\n<pre><code class=\"language-shell\">#navicat\u94fe\u63a5\u6d4b\u8bd5\r\n# oracle\u7528\u6237\u4e0b\uff0c\u8f93\u5165\u4e0b\u9762\u7684\u547d\u4ee4\u884c\uff0c\u67e5\u770b\u662f\u5426\u53ef\u4ee5\u94fe\u63a5\r\nsqlplus \/ as sysdba<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,5],"tags":[72],"class_list":["post-918","post","type-post","status-publish","format-standard","hentry","category-4","category-5","tag-oracle"],"_links":{"self":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts\/918","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=918"}],"version-history":[{"count":2,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts\/918\/revisions"}],"predecessor-version":[{"id":922,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts\/918\/revisions\/922"}],"wp:attachment":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=918"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}