前言:
如今你们对“centos732位库”都比较着重,小伙伴们都想要学习一些“centos732位库”的相关知识。那么小编在网络上汇集了一些对于“centos732位库””的相关知识,希望同学们能喜欢,朋友们一起来了解一下吧!环境准备
centos 7.9
Oracle 11g R2 64位安装介质下载地址:
安装前准备
### **查看主机名**[root@easytong]# hostname #在hosts中添加主机名对应记录### **关闭Selinux**[root@easytong]# vi /etc/selinux/config设置 SELINUX=disabled安装 Oracle 依赖包及环境配置
### **这里通过安装Oracle YUM 源安装所依赖的包**cd /etc/yum.repos.dwget -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracleyum install oracle-rdbms-server-11gR2-preinstall -y#oracle-rdbms-server-11gR2-preinstall包所干的事情(1)自动安装oracle所需的RPM包(2)自动创建oracle用户和group组 (3)自动配置/etc/sysctl.conf内核参数 (4)自动配置/etc/security/limits.conf参数 (5)关闭NUMA=OFF (关闭非一致内存访问)more /var/log/oracle-rdbms-server-11gR2-preinstall/results/orakernel.log #最后可以看到备份文件的位置,什么参数、内核等等统统都配置好了开始安装
创建安装的目录
-----------mkdir -p /opt/oracle/product/11.2.0/db_1mkdir -p /OracleData/easytongmkdir -p /OracleArch/archivelog#### **_#更改oracle目录的权限_**chown oracle:oinstall -R /opt/oraclechown oracle:oinstall -R /OracleData/easytongchown oracle:oinstall -R /OracleArch/archivelogchmod 755 -R /opt/oraclechmod 755 -R /OracleData/chmod 755 -R /OracleArch/设置Oracle环境变量
### **#追加内容**su - oraclevim .bash_profileexport ORACLE_BASE=/opt/oracleexport ORACLE_HOME=/opt/oracle/product/11.2.0/db_1export ORACLE_SID=easytongexport PATH=$ORACLE_HOME/bin:/usr/sbin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/libexport TNS_ADMIN=$ORACLE_HOME/network/adminsource .bash_profile数据库安装#上传安装包到服务器
cd /opt/oracleunzip linux.x64_11gR2_database_1of2.zip unzip linux.x64_11gR2_database_2of2.zipOracle静默安装需要用到的应答文件
vim /opt/oracle/database/response/db_install.rsp----复制粘贴以下内容---###################################################################### Copyright(c) Oracle Corporation 1998,2013. All rights reserved.#### #### Specify values for the variables listed below to customize #### your installation. #### #### Each variable is associated with a comment. The comment #### can help to populate the variables with the appropriate #### values. #### #### IMPORTANT NOTE: This file contains plain text passwords and #### should be secured to have read permission only by oracle user #### or db administrator who owns this installation. #### #######################################################################------------------------------------------------------------------------------# Do not change the following system generated value. #------------------------------------------------------------------------------oracle.install.responseFileVersion=/opt/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0#------------------------------------------------------------------------------# Specify the installation option.# It can be one of the following:# - INSTALL_DB_SWONLY# - INSTALL_DB_AND_CONFIG# - UPGRADE_DB#-------------------------------------------------------------------------------oracle.install.option=INSTALL_DB_SWONLY#-------------------------------------------------------------------------------# Specify the hostname of the system as set during the install. It can be used# to force the installation to use an alternative hostname rather than using the# first hostname found on the system. (e.g., for systems with multiple hostnames # and network interfaces)#-------------------------------------------------------------------------------ORACLE_HOSTNAME=sql#-------------------------------------------------------------------------------# Specify the Unix group to be set for the inventory directory. #-------------------------------------------------------------------------------UNIX_GROUP_NAME=oinstall#-------------------------------------------------------------------------------# Specify the location which holds the inventory files.# This is an optional parameter if installing on# Windows based Operating System.#-------------------------------------------------------------------------------INVENTORY_LOCATION=/opt/oracle/oraInventory#-------------------------------------------------------------------------------# Specify the languages in which the components will be installed. # # en : English ja : Japanese # fr : French ko : Korean # ar : Arabic es : Latin American Spanish # bn : Bengali lv : Latvian # pt_BR: Brazilian Portuguese lt : Lithuanian # bg : Bulgarian ms : Malay # fr_CA: Canadian French es_MX: Mexican Spanish # ca : Catalan no : Norwegian # hr : Croatian pl : Polish # cs : Czech pt : Portuguese # da : Danish ro : Romanian # nl : Dutch ru : Russian # ar_EG: Egyptian zh_CN: Simplified Chinese # en_GB: English (Great Britain) sk : Slovak # et : Estonian sl : Slovenian # fi : Finnish es_ES: Spanish # de : German sv : Swedish # el : Greek th : Thai # iw : Hebrew zh_TW: Traditional Chinese # hu : Hungarian tr : Turkish # is : Icelandic uk : Ukrainian # in : Indonesian vi : Vietnamese # it : Italian ## all_langs : All languages## Specify value as the following to select any of the languages.# Example : SELECTED_LANGUAGES=en,zh_CN## Specify value as the following to select all the languages.# Example : SELECTED_LANGUAGES=all_langs #------------------------------------------------------------------------------SELECTED_LANGUAGES=en,zh_CN#------------------------------------------------------------------------------# Specify the complete path of the Oracle Home.#------------------------------------------------------------------------------ORACLE_HOME=/opt/oracle/product/11.2.0/db_1#------------------------------------------------------------------------------# Specify the complete path of the Oracle Base. #------------------------------------------------------------------------------ORACLE_BASE=/opt/oracle#------------------------------------------------------------------------------# Specify the installation edition of the component. # # The value should contain only one of these choices. # - EE : Enterprise Edition # - SE : Standard Edition # - SEONE : Standard Edition One# - PE : Personal Edition (WINDOWS ONLY)#------------------------------------------------------------------------------oracle.install.db.InstallEdition=EE#------------------------------------------------------------------------------# This variable is used to enable or disable custom install and is considered# only if InstallEdition is EE.## true : Components mentioned as part of 'optionalComponents' property# are considered for install.# false : Value for 'optionalComponents' is not considered.#------------------------------------------------------------------------------oracle.install.db.EEOptionsSelection=true#------------------------------------------------------------------------------# This variable is considered only if 'EEOptionsSelection' is set to true. ## Description: List of Enterprise Edition Options you would like to enable.## The following choices are available. You may specify any# combination of these choices. The components you choose should# be specified in the form "internal-component-name:version"# Below is a list of components you may specify to enable.# # oracle.oraolap:11.2.0.4.0 - Oracle OLAP# oracle.rdbms.dm:11.2.0.4.0 - Oracle Data Mining# oracle.rdbms.dv:11.2.0.4.0 - Oracle Database Vault# oracle.rdbms.lbac:11.2.0.4.0 - Oracle Label Security# oracle.rdbms.partitioning:11.2.0.4.0 - Oracle Partitioning# oracle.rdbms.rat:11.2.0.4.0 - Oracle Real Application Testing#------------------------------------------------------------------------------oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.dv:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0################################################################################ ## PRIVILEGED OPERATING SYSTEM GROUPS ## ------------------------------------------ ## Provide values for the OS groups to which OSDBA and OSOPER privileges ## needs to be granted. If the install is being performed as a member of the # # group "dba", then that will be used unless specified otherwise below. ## ## The value to be specified for OSDBA and OSOPER group is only for UNIX based ## Operating System. ## #################################################################################------------------------------------------------------------------------------# The DBA_GROUP is the OS group which is to be granted OSDBA privileges.#------------------------------------------------------------------------------oracle.install.db.DBA_GROUP=dba#------------------------------------------------------------------------------# The OPER_GROUP is the OS group which is to be granted OSOPER privileges.# The value to be specified for OSOPER group is optional.#------------------------------------------------------------------------------oracle.install.db.OPER_GROUP=oinstall#------------------------------------------------------------------------------# Specify the cluster node names selected during the installation.# Example : oracle.install.db.CLUSTER_NODES=node1,node2#------------------------------------------------------------------------------oracle.install.db.CLUSTER_NODES=#------------------------------------------------------------------------------# This variable is used to enable or disable RAC One Node install.## - true : Value of RAC One Node service name is used.# - false : Value of RAC One Node service name is not used.## If left blank, it will be assumed to be false#------------------------------------------------------------------------------oracle.install.db.isRACOneInstall=#------------------------------------------------------------------------------# Specify the name for RAC One Node Service. #------------------------------------------------------------------------------oracle.install.db.racOneServiceName=#------------------------------------------------------------------------------# Specify the type of database to create.# It can be one of the following:# - GENERAL_PURPOSE/TRANSACTION_PROCESSING # - DATA_WAREHOUSE #------------------------------------------------------------------------------oracle.install.db.config.starterdb.type=#------------------------------------------------------------------------------# Specify the Starter Database Global Database Name. #------------------------------------------------------------------------------oracle.install.db.config.starterdb.globalDBName=#------------------------------------------------------------------------------# Specify the Starter Database SID.#------------------------------------------------------------------------------oracle.install.db.config.starterdb.SID=easytong#------------------------------------------------------------------------------# Specify the Starter Database character set.# # It can be one of the following:# AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2,# EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257,# BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6,# AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8,# IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE,# KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950,# ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258#------------------------------------------------------------------------------oracle.install.db.config.starterdb.characterSet=ZHS16GBK#------------------------------------------------------------------------------# This variable should be set to true if Automatic Memory Management # in Database is desired.# If Automatic Memory Management is not desired, and memory allocation# is to be done manually, then set it to false.#------------------------------------------------------------------------------oracle.install.db.config.starterdb.memoryOption=true#------------------------------------------------------------------------------# Specify the total memory allocation for the database. Value(in MB) should be# at least 256 MB, and should not exceed the total physical memory available # on the system.# Example: oracle.install.db.config.starterdb.memoryLimit=512#------------------------------------------------------------------------------oracle.install.db.config.starterdb.memoryLimit=#------------------------------------------------------------------------------# This variable controls whether to load Example Schemas onto# the starter database or not.#------------------------------------------------------------------------------oracle.install.db.config.starterdb.installExampleSchemas=false#------------------------------------------------------------------------------# This variable includes enabling audit settings, configuring password profiles# and revoking some grants to public. These settings are provided by default. # These settings may also be disabled. #------------------------------------------------------------------------------oracle.install.db.config.starterdb.enableSecuritySettings=true################################################################################ ## Passwords can be supplied for the following four schemas in the ## starter database: ## SYS ## SYSTEM ## SYSMAN (used by Enterprise Manager) ## DBSNMP (used by Enterprise Manager) ## ## Same password can be used for all accounts (not recommended) ## or different passwords for each account can be provided (recommended) ## #################################################################################------------------------------------------------------------------------------# This variable holds the password that is to be used for all schemas in the# starter database.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.password.ALL=everhigh#-------------------------------------------------------------------------------# Specify the SYS password for the starter database.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.password.SYS=#-------------------------------------------------------------------------------# Specify the SYSTEM password for the starter database.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.password.SYSTEM=#-------------------------------------------------------------------------------# Specify the SYSMAN password for the starter database.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.password.SYSMAN=#-------------------------------------------------------------------------------# Specify the DBSNMP password for the starter database.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.password.DBSNMP=#-------------------------------------------------------------------------------# Specify the management option to be selected for the starter database. # It can be one of the following:# - GRID_CONTROL# - DB_CONTROL#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.control=DB_CONTROL#-------------------------------------------------------------------------------# Specify the Management Service to use if Grid Control is selected to manage # the database. #-------------------------------------------------------------------------------oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=################################################################################ ## SPECIFY BACKUP AND RECOVERY OPTIONS ## ------------------------------------ ## Out-of-box backup and recovery options for the database can be mentioned ## using the entries below. # # #################################################################################------------------------------------------------------------------------------# This variable is to be set to false if automated backup is not required. Else # this can be set to true.#------------------------------------------------------------------------------oracle.install.db.config.starterdb.automatedBackup.enable=false#------------------------------------------------------------------------------# Regardless of the type of storage that is chosen for backup and recovery, if # automated backups are enabled, a job will be scheduled to run daily to backup # the database. This job will run as the operating system user that is # specified in this variable.#------------------------------------------------------------------------------oracle.install.db.config.starterdb.automatedBackup.osuid=#-------------------------------------------------------------------------------# Regardless of the type of storage that is chosen for backup and recovery, if # automated backups are enabled, a job will be scheduled to run daily to backup # the database. This job will run as the operating system user specified by the # above entry. The following entry stores the password for the above operating # system user.#-------------------------------------------------------------------------------oracle.install.db.config.starterdb.automatedBackup.ospwd=#-------------------------------------------------------------------------------# Specify the type of storage to use for the database.# It can be one of the following:# - FILE_SYSTEM_STORAGE# - ASM_STORAGE#------------------------------------------------------------------------------oracle.install.db.config.starterdb.storageType=#-------------------------------------------------------------------------------# Specify the database file location which is a directory for datafiles, control# files, redo logs. ## Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE #-------------------------------------------------------------------------------oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=#-------------------------------------------------------------------------------# Specify the backup and recovery location.## Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE #-------------------------------------------------------------------------------oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=#-------------------------------------------------------------------------------# Specify the existing ASM disk groups to be used for storage.## Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE#-------------------------------------------------------------------------------oracle.install.db.config.asm.diskGroup=#-------------------------------------------------------------------------------# Specify the password for ASMSNMP user of the ASM instance. ## Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE #-------------------------------------------------------------------------------oracle.install.db.config.asm.ASMSNMPPassword=#------------------------------------------------------------------------------# Specify the My Oracle Support Account Username.## Example : MYORACLESUPPORT_USERNAME=abc@oracle.com#------------------------------------------------------------------------------MYORACLESUPPORT_USERNAME=#------------------------------------------------------------------------------# Specify the My Oracle Support Account Username password.## Example : MYORACLESUPPORT_PASSWORD=password#------------------------------------------------------------------------------MYORACLESUPPORT_PASSWORD=#------------------------------------------------------------------------------# Specify whether to enable the user to set the password for# My Oracle Support credentials. The value can be either true or false.# If left blank it will be assumed to be false.## Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true#------------------------------------------------------------------------------SECURITY_UPDATES_VIA_MYORACLESUPPORT=#------------------------------------------------------------------------------# Specify whether user doesn't want to configure Security Updates.# The value for this variable should be true if you don't want to configure# Security Updates, false otherwise. ## The value can be either true or false. If left blank it will be assumed# to be false.## Example : DECLINE_SECURITY_UPDATES=false#------------------------------------------------------------------------------DECLINE_SECURITY_UPDATES=true#------------------------------------------------------------------------------# Specify the Proxy server name. Length should be greater than zero.## Example : PROXY_HOST=proxy.domain.com #------------------------------------------------------------------------------PROXY_HOST=#------------------------------------------------------------------------------# Specify the proxy port number. Should be Numeric and at least 2 chars.## Example : PROXY_PORT=25 #------------------------------------------------------------------------------PROXY_PORT=#------------------------------------------------------------------------------# Specify the proxy user name. Leave PROXY_USER and PROXY_PWD # blank if your proxy server requires no authentication.## Example : PROXY_USER=username #------------------------------------------------------------------------------PROXY_USER=#------------------------------------------------------------------------------# Specify the proxy password. Leave PROXY_USER and PROXY_PWD # blank if your proxy server requires no authentication.## Example : PROXY_PWD=password #------------------------------------------------------------------------------PROXY_PWD=#------------------------------------------------------------------------------# Specify the proxy realm. This value is used if auto-updates option is selected.## Example : PROXY_REALM=metalink #------------------------------------------------------------------------------PROXY_REALM=#------------------------------------------------------------------------------# Specify the Oracle Support Hub URL. # # Example : COLLECTOR_SUPPORTHUB_URL= Specify the auto-updates option. It can be one of the following:# - MYORACLESUPPORT_DOWNLOAD# - OFFLINE_UPDATES# - SKIP_UPDATES#------------------------------------------------------------------------------oracle.installer.autoupdates.option=SKIP_UPDATES#------------------------------------------------------------------------------# In case MYORACLESUPPORT_DOWNLOAD option is chosen, specify the location where# the updates are to be downloaded.# In case OFFLINE_UPDATES option is chosen, specify the location where the updates # are present.#------------------------------------------------------------------------------oracle.installer.autoupdates.downloadUpdatesLoc=#------------------------------------------------------------------------------# Specify the My Oracle Support Account Username which has the patches download privileges # to be used for software updates.# Example : AUTOUPDATES_MYORACLESUPPORT_USERNAME=abc@oracle.com#------------------------------------------------------------------------------AUTOUPDATES_MYORACLESUPPORT_USERNAME=#------------------------------------------------------------------------------# Specify the My Oracle Support Account Username password which has the patches download privileges # to be used for software updates.## Example : AUTOUPDATES_MYORACLESUPPORT_PASSWORD=password#------------------------------------------------------------------------------AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
修改dbca.rsp
vim /opt/oracle/database/response/dbca.rsp----复制粘贴以下内容--- ################################################################################ #### DBCA response file #### ------------------ #### Copyright 1998, 2013, Oracle Corporation. All Rights Reserved. #### #### Specify values for the variables listed below to customize Oracle #### Database Configuration installation. #### #### Each variable is associated with a comment. The comment identifies the #### variable type. #### #### Please specify the values in the following format : #### Type : Example #### String : "<value>" #### Boolean : True or False #### Number : <numeric value> #### StringList : {"<value1>","<value2>"} #### #### Examples : #### 1. dbca -progress_only -responseFile <response file> #### Display a progress bar depicting progress of database creation #### process. #### #### 2. dbca -silent -responseFile <response file> #### Creates database silently. No user interface is displayed. #### #### 3. dbca -silent -createDatabase -cloneTemplate #### -responseFile <response file> #### Creates database silently with clone template. The template in #### responsefile is a clone template. #### #### 4. dbca -silent -deleteDatabase -responseFile <response file> #### Deletes database silently. #################################################################################-----------------------------------------------------------------------------# GENERAL section is required for all types of database creations.#-----------------------------------------------------------------------------[GENERAL]#-----------------------------------------------------------------------------# Name : RESPONSEFILE_VERSION# Datatype : String# Description : Version of the database to create# Valid values : "11.1.0"# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------RESPONSEFILE_VERSION = "11.2.0"#-----------------------------------------------------------------------------# Name : OPERATION_TYPE# Datatype : String# Description : Type of operation# Valid values : "createDatabase" \ "createTemplateFromDB" \ "createCloneTemplate" \ "deleteDatabase" \ "configureDatabase" \ "addInstance" (RAC-only) \ "deleteInstance" (RAC-only)# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------OPERATION_TYPE = "createDatabase"#-----------------------*** End of GENERAL section ***------------------------#-----------------------------------------------------------------------------# CREATEDATABASE section is used when OPERATION_TYPE is defined as "createDatabase". #-----------------------------------------------------------------------------[CREATEDATABASE]#-----------------------------------------------------------------------------# Name : GDBNAME# Datatype : String# Description : Global database name of the database# Valid values : <db_name>.<db_domain> - when database domain isn't NULL# <db_name> - when database domain is NULL# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------GDBNAME = "easytong"#-----------------------------------------------------------------------------# Name : RACONENODE# Datatype : Boolean# Description : Set to true for RAC One Node database# Valid values : TRUE\FALSE# Default value : FALSE# Mandatory : No#-----------------------------------------------------------------------------#RACONENODE = "false"#-----------------------------------------------------------------------------# Name : RACONENODESERVICENAME# Datatype : String# Description : Service is required by application to connect to RAC One # Node Database# Valid values : Service Name# Default value : None# Mandatory : No [required in case RACONENODE flag is set to true]#-----------------------------------------------------------------------------#RACONENODESERVICENAME = #-----------------------------------------------------------------------------# Name : POLICYMANAGED# Datatype : Boolean# Description : Set to true if Database is policy managed and # set to false if Database is admin managed# Valid values : TRUE\FALSE# Default value : FALSE# Mandatory : No#-----------------------------------------------------------------------------#POLICYMANAGED = "false"#-----------------------------------------------------------------------------# Name : CREATESERVERPOOL# Datatype : Boolean# Description : Set to true if new server pool need to be created for database # if this option is specified then the newly created database # will use this newly created serverpool. # Multiple serverpoolname can not be specified for database# Valid values : TRUE\FALSE# Default value : FALSE# Mandatory : No#-----------------------------------------------------------------------------#CREATESERVERPOOL = "false"#-----------------------------------------------------------------------------# Name : FORCE# Datatype : Boolean# Description : Set to true if new server pool need to be created by force # if this option is specified then the newly created serverpool# will be assigned server even if no free servers are available.# This may affect already running database.# This flag can be specified for Admin managed as well as policy managed db.# Valid values : TRUE\FALSE# Default value : FALSE# Mandatory : No#-----------------------------------------------------------------------------#FORCE = "false"#-----------------------------------------------------------------------------# Name : SERVERPOOLNAME# Datatype : String# Description : Only one serverpool name need to be specified # if Create Server Pool option is specified. # Comma-separated list of Serverpool names if db need to use# multiple Server pool# Valid values : ServerPool name# Default value : None# Mandatory : No [required in case of RAC service centric database]#-----------------------------------------------------------------------------#SERVERPOOLNAME = #-----------------------------------------------------------------------------# Name : CARDINALITY# Datatype : Number# Description : Specify Cardinality for create server pool operation# Valid values : any positive Integer value# Default value : Number of qualified nodes on cluster# Mandatory : No [Required when a new serverpool need to be created]#-----------------------------------------------------------------------------#CARDINALITY = #-----------------------------------------------------------------------------# Name : SID# Datatype : String# Description : System identifier (SID) of the database# Valid values : Check Oracle11g Administrator's Guide# Default value : <db_name> specified in GDBNAME# Mandatory : No#-----------------------------------------------------------------------------SID = "easytong"#-----------------------------------------------------------------------------# Name : NODELIST# Datatype : String# Description : Comma-separated list of cluster nodes# Valid values : Cluster node names# Default value : None# Mandatory : No (Yes for RAC database-centric database )#-----------------------------------------------------------------------------#NODELIST=#-----------------------------------------------------------------------------# Name : TEMPLATENAME# Datatype : String# Description : Name of the template# Valid values : Template file name# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------TEMPLATENAME = "General_Purpose.dbc"#-----------------------------------------------------------------------------# Name : OBFUSCATEDPASSWORDS# Datatype : Boolean# Description : Set to true if passwords are encrypted# Valid values : TRUE\FALSE# Default value : FALSE# Mandatory : No#-----------------------------------------------------------------------------#OBFUSCATEDPASSWORDS = FALSE#-----------------------------------------------------------------------------# Name : SYSPASSWORD# Datatype : String# Description : Password for SYS user# Valid values : Check Oracle11g Administrator's Guide# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------#SYSPASSWORD = "password"#-----------------------------------------------------------------------------# Name : SYSTEMPASSWORD# Datatype : String# Description : Password for SYSTEM user# Valid values : Check Oracle11g Administrator's Guide# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------#SYSTEMPASSWORD = "password"#-----------------------------------------------------------------------------# Name : EMCONFIGURATION# Datatype : String# Description : Enterprise Manager Configuration Type# Valid values : CENTRAL|LOCAL|ALL|NONE# Default value : NONE# Mandatory : No#-----------------------------------------------------------------------------#EMCONFIGURATION = "NONE"#-----------------------------------------------------------------------------# Name : DISABLESECURITYCONFIGURATION# Datatype : String# Description : Database Security Settings# Valid values : ALL|NONE|AUDIT|PASSWORD_PROFILE# Default value : NONE# Mandatory : No#-----------------------------------------------------------------------------#DISABLESECURITYCONFIGURATION = "NONE"#-----------------------------------------------------------------------------# Name : SYSMANPASSWORD# Datatype : String# Description : Password for SYSMAN user# Valid values : Check Oracle11g Administrator's Guide# Default value : None# Mandatory : Yes, if LOCAL specified for EMCONFIGURATION#-----------------------------------------------------------------------------#SYSMANPASSWORD = "password"#-----------------------------------------------------------------------------# Name : DBSNMPPASSWORD# Datatype : String# Description : Password for DBSNMP user# Valid values : Check Oracle11g Administrator's Guide# Default value : None# Mandatory : Yes, if EMCONFIGURATION is specified#-----------------------------------------------------------------------------#DBSNMPPASSWORD = "password"#-----------------------------------------------------------------------------# Name : CENTRALAGENT# Datatype : String# Description : Grid Control Central Agent Oracle Home# Default value : None# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION#-----------------------------------------------------------------------------#CENTRALAGENT = #-----------------------------------------------------------------------------# Name : HOSTUSERNAME# Datatype : String# Description : Host user name for EM backup job# Default value : None# Mandatory : Yes, if ALL is specified for EMCONFIGURATION#-----------------------------------------------------------------------------#HOSTUSERNAME = #-----------------------------------------------------------------------------# Name : HOSTUSERPASSWORD# Datatype : String# Description : Host user password for EM backup job# Default value : None# Mandatory : Yes, if ALL is specified for EMCONFIGURATION#-----------------------------------------------------------------------------#HOSTUSERPASSWORD= #-----------------------------------------------------------------------------# Name : BACKUPSCHEDULE# Datatype : String# Description : Daily backup schedule in the form of hh:mm# Default value : 2:00# Mandatory : Yes, if ALL is specified for EMCONFIGURATION#-----------------------------------------------------------------------------#BACKUPSCHEDULE=#-----------------------------------------------------------------------------# Name : DVOWNERNAME# Datatype : String# Description : DataVault Owner# Valid values : Check Oracle11g Administrator's Guide# Default value : None# Mandatory : Yes, if DataVault option is chosen#-----------------------------------------------------------------------------#DVOWNERNAME = ""#-----------------------------------------------------------------------------# Name : DVOWNERPASSWORD# Datatype : String# Description : Password for DataVault Owner# Valid values : Check Oracle11g Administrator's Guide# Default value : None# Mandatory : Yes, if DataVault option is chosen#-----------------------------------------------------------------------------#DVOWNERPASSWORD = ""#-----------------------------------------------------------------------------# Name : DVACCOUNTMANAGERNAME# Datatype : String# Description : DataVault Account Manager# Valid values : Check Oracle11g Administrator's Guide# Default value : None# Mandatory : No#-----------------------------------------------------------------------------#DVACCOUNTMANAGERNAME = ""#-----------------------------------------------------------------------------# Name : DVACCOUNTMANAGERPASSWORD# Datatype : String# Description : Password for DataVault Account Manager# Valid values : Check Oracle11g Administrator's Guide# Default value : None# Mandatory : No#-----------------------------------------------------------------------------#DVACCOUNTMANAGERPASSWORD = ""#-----------------------------------------------------------------------------# Name : DATAFILEJARLOCATION # Datatype : String# Description : Location of the data file jar # Valid values : Directory containing compressed datafile jar# Default value : None# Mandatory : No#-----------------------------------------------------------------------------#DATAFILEJARLOCATION =#-----------------------------------------------------------------------------# Name : DATAFILEDESTINATION # Datatype : String# Description : Location of the data file's# Valid values : Directory for all the database files# Default value : $ORACLE_BASE/oradata# Mandatory : No#-----------------------------------------------------------------------------#DATAFILEDESTINATION =#-----------------------------------------------------------------------------# Name : RECOVERYAREADESTINATION# Datatype : String# Description : Location of the data file's# Valid values : Recovery Area location# Default value : $ORACLE_BASE/flash_recovery_area# Mandatory : No#-----------------------------------------------------------------------------#RECOVERYAREADESTINATION=#-----------------------------------------------------------------------------# Name : STORAGETYPE# Datatype : String# Description : Specifies the storage on which the database is to be created# Valid values : FS (CFS for RAC), ASM# Default value : FS# Mandatory : No#-----------------------------------------------------------------------------#STORAGETYPE=FS#-----------------------------------------------------------------------------# Name : DISKGROUPNAME# Datatype : String# Description : Specifies the disk group name for the storage# Default value : DATA# Mandatory : No#-----------------------------------------------------------------------------#DISKGROUPNAME=DATA#-----------------------------------------------------------------------------# Name : ASMSNMP_PASSWORD# Datatype : String# Description : Password for ASM Monitoring# Default value : None# Mandatory : No#-----------------------------------------------------------------------------#ASMSNMP_PASSWORD=""#-----------------------------------------------------------------------------# Name : RECOVERYGROUPNAME# Datatype : String# Description : Specifies the disk group name for the recovery area# Default value : RECOVERY# Mandatory : No#-----------------------------------------------------------------------------#RECOVERYGROUPNAME=RECOVERY#-----------------------------------------------------------------------------# Name : CHARACTERSET# Datatype : String# Description : Character set of the database# Valid values : Check Oracle11g National Language Support Guide# Default value : "US7ASCII"# Mandatory : NO#-----------------------------------------------------------------------------#CHARACTERSET = "ZHS16GBK"#-----------------------------------------------------------------------------# Name : NATIONALCHARACTERSET# Datatype : String# Description : National Character set of the database# Valid values : "UTF8" or "AL16UTF16". For details, check Oracle11g National Language Support Guide# Default value : "AL16UTF16"# Mandatory : No#-----------------------------------------------------------------------------#NATIONALCHARACTERSET= "UTF8"#-----------------------------------------------------------------------------# Name : REGISTERWITHDIRSERVICE# Datatype : Boolean# Description : Specifies whether to register with Directory Service.# Valid values : TRUE \ FALSE# Default value : FALSE# Mandatory : No#-----------------------------------------------------------------------------#REGISTERWITHDIRSERVICE= TRUE#-----------------------------------------------------------------------------# Name : DIRSERVICEUSERNAME# Datatype : String# Description : Specifies the name of the directory service user# Mandatory : YES, if the value of registerWithDirService is TRUE#-----------------------------------------------------------------------------#DIRSERVICEUSERNAME= "name"#-----------------------------------------------------------------------------# Name : DIRSERVICEPASSWORD# Datatype : String# Description : The password of the directory service user.# You can also specify the password at the command prompt instead of here.# Mandatory : YES, if the value of registerWithDirService is TRUE#-----------------------------------------------------------------------------#DIRSERVICEPASSWORD= "password"#-----------------------------------------------------------------------------# Name : WALLETPASSWORD# Datatype : String# Description : The password for wallet to created or modified.# You can also specify the password at the command prompt instead of here.# Mandatory : YES, if the value of registerWithDirService is TRUE#-----------------------------------------------------------------------------#WALLETPASSWORD= "password"#-----------------------------------------------------------------------------# Name : LISTENERS# Datatype : String# Description : Specifies list of listeners to register the database with.# By default the database is configured for all the listeners specified in the # $ORACLE_HOME/network/admin/listener.ora # Valid values : The list should be space separated names like "listener1 listener2".# Mandatory : NO#-----------------------------------------------------------------------------#LISTENERS = "listener1 listener2"#-----------------------------------------------------------------------------# Name : VARIABLESFILE # Datatype : String# Description : Location of the file containing variable value pair# Valid values : A valid file-system file. The variable value pair format in this file # is <variable>=<value>. Each pair should be in a new line.# Default value : None# Mandatory : NO#-----------------------------------------------------------------------------#VARIABLESFILE =#-----------------------------------------------------------------------------# Name : VARIABLES# Datatype : String# Description : comma separated list of name=value pairs. Overrides variables defined in variablefile and templates# Default value : None# Mandatory : NO#-----------------------------------------------------------------------------#VARIABLES =#-----------------------------------------------------------------------------# Name : INITPARAMS# Datatype : String# Description : comma separated list of name=value pairs. Overrides initialization parameters defined in templates# Default value : None# Mandatory : NO#-----------------------------------------------------------------------------#INITPARAMS =#-----------------------------------------------------------------------------# Name : SAMPLESCHEMA# Datatype : Boolean# Description : Specifies whether or not to add the Sample Schemas to your database# Valid values : TRUE \ FALSE# Default value : FASLE# Mandatory : No#-----------------------------------------------------------------------------#SAMPLESCHEMA=TRUE#-----------------------------------------------------------------------------# Name : MEMORYPERCENTAGE# Datatype : String# Description : percentage of physical memory for Oracle# Default value : None# Mandatory : NO#-----------------------------------------------------------------------------#MEMORYPERCENTAGE = "40"#-----------------------------------------------------------------------------# Name : DATABASETYPE# Datatype : String# Description : used for memory distribution when MEMORYPERCENTAGE specified# Valid values : MULTIPURPOSE|DATA_WAREHOUSING|OLTP# Default value : MULTIPURPOSE# Mandatory : NO#-----------------------------------------------------------------------------#DATABASETYPE = "MULTIPURPOSE"#-----------------------------------------------------------------------------# Name : AUTOMATICMEMORYMANAGEMENT# Datatype : Boolean# Description : flag to indicate Automatic Memory Management is used# Valid values : TRUE/FALSE# Default value : TRUE# Mandatory : NO#-----------------------------------------------------------------------------#AUTOMATICMEMORYMANAGEMENT = "TRUE"#-----------------------------------------------------------------------------# Name : TOTALMEMORY# Datatype : String# Description : total memory in MB to allocate to Oracle# Valid values : # Default value : # Mandatory : NO#-----------------------------------------------------------------------------#TOTALMEMORY = "800"#-----------------------*** End of CREATEDATABASE section ***------------------------#-----------------------------------------------------------------------------# createTemplateFromDB section is used when OPERATION_TYPE is defined as "createTemplateFromDB". #-----------------------------------------------------------------------------[createTemplateFromDB]#-----------------------------------------------------------------------------# Name : SOURCEDB # Datatype : String# Description : The source database from which to create the template# Valid values : The format is <host>:<port>:<sid># Default value : none# Mandatory : YES#-----------------------------------------------------------------------------SOURCEDB = "myhost:1521:orcl"#-----------------------------------------------------------------------------# Name : SYSDBAUSERNAME # Datatype : String# Description : A user with DBA role.# Default value : none# Mandatory : YES#-----------------------------------------------------------------------------SYSDBAUSERNAME = "system"#-----------------------------------------------------------------------------# Name : SYSDBAPASSWORD # Datatype : String# Description : The password of the DBA user.# You can also specify the password at the command prompt instead of here.# Default value : none# Mandatory : YES#-----------------------------------------------------------------------------#SYSDBAPASSWORD = "password"#-----------------------------------------------------------------------------# Name : TEMPLATENAME# Datatype : String# Description : Name for the new template.# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------TEMPLATENAME = "My Copy TEMPLATE"#-----------------------*** End of createTemplateFromDB section ***------------------------#-----------------------------------------------------------------------------# createCloneTemplate section is used when OPERATION_TYPE is defined as "createCloneTemplate". #-----------------------------------------------------------------------------[createCloneTemplate]#-----------------------------------------------------------------------------# Name : SOURCEDB# Datatype : String# Description : The source database is the SID from which to create the template. # This database must be local and on the same ORACLE_HOME.# Default value : none# Mandatory : YES#-----------------------------------------------------------------------------SOURCEDB = "orcl"#-----------------------------------------------------------------------------# Name : SYSDBAUSERNAME# Datatype : String# Description : A user with DBA role.# Default value : none# Mandatory : YES, if no OS authentication#-----------------------------------------------------------------------------#SYSDBAUSERNAME = "sys"#-----------------------------------------------------------------------------# Name : SYSDBAPASSWORD# Datatype : String# Description : The password of the DBA user.# You can also specify the password at the command prompt instead of here.# Default value : none# Mandatory : YES#-----------------------------------------------------------------------------#SYSDBAPASSWORD = "password"#-----------------------------------------------------------------------------# Name : TEMPLATENAME# Datatype : String# Description : Name for the new template.# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------TEMPLATENAME = "My Clone TEMPLATE"#-----------------------------------------------------------------------------# Name : DATAFILEJARLOCATION# Datatype : String# Description : Location of the data file jar # Valid values : Directory where the new compressed datafile jar will be placed# Default value : $ORACLE_HOME/assistants/dbca/templates# Mandatory : NO#-----------------------------------------------------------------------------#DATAFILEJARLOCATION = #-----------------------*** End of createCloneTemplate section ***------------------------#-----------------------------------------------------------------------------# DELETEDATABASE section is used when DELETE_TYPE is defined as "deleteDatabase". #-----------------------------------------------------------------------------[DELETEDATABASE]#-----------------------------------------------------------------------------# Name : SOURCEDB# Datatype : String# Description : The source database is the SID # This database must be local and on the same ORACLE_HOME.# Default value : none# Mandatory : YES#-----------------------------------------------------------------------------SOURCEDB = "orcl"#-----------------------------------------------------------------------------# Name : SYSDBAUSERNAME# Datatype : String# Description : A user with DBA role.# Default value : none# Mandatory : YES, if no OS authentication#-----------------------------------------------------------------------------#SYSDBAUSERNAME = "sys"#-----------------------------------------------------------------------------# Name : SYSDBAPASSWORD# Datatype : String# Description : The password of the DBA user.# You can also specify the password at the command prompt instead of here.# Default value : none# Mandatory : YES, if no OS authentication#-----------------------------------------------------------------------------#SYSDBAPASSWORD = "password"#-----------------------*** End of deleteDatabase section ***------------------------#-----------------------------------------------------------------------------# GENERATESCRIPTS section #-----------------------------------------------------------------------------[generateScripts]#-----------------------------------------------------------------------------# Name : TEMPLATENAME# Datatype : String# Description : Name of the template# Valid values : Template name as seen in DBCA# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------TEMPLATENAME = "New Database"#-----------------------------------------------------------------------------# Name : GDBNAME# Datatype : String# Description : Global database name of the database# Valid values : <db_name>.<db_domain> - when database domain isn't NULL# <db_name> - when database domain is NULL# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------GDBNAME = "orcl11.us.oracle.com"#-----------------------------------------------------------------------------# Name : SCRIPTDESTINATION # Datatype : String# Description : Location of the scripts# Valid values : Directory for all the scripts# Default value : None# Mandatory : No#-----------------------------------------------------------------------------#SCRIPTDESTINATION =#-----------------------*** End of deleteDatabase section ***------------------------#-----------------------------------------------------------------------------# CONFIGUREDATABASE section is used when OPERATION_TYPE is defined as "configureDatabase". #-----------------------------------------------------------------------------[CONFIGUREDATABASE]#-----------------------------------------------------------------------------# Name : SOURCEDB# Datatype : String# Description : The source database is the SID # This database must be local and on the same ORACLE_HOME.# Default value : none# Mandatory : YES#-----------------------------------------------------------------------------#SOURCEDB = "orcl"#-----------------------------------------------------------------------------# Name : SYSDBAUSERNAME# Datatype : String# Description : A user with DBA role.# Default value : none# Mandatory : YES, if no OS authentication#-----------------------------------------------------------------------------#SYSDBAUSERNAME = "sys"#-----------------------------------------------------------------------------# Name : SYSDBAPASSWORD# Datatype : String# Description : The password of the DBA user.# You can also specify the password at the command prompt instead of here.# Default value : none# Mandatory : YES, if no OS authentication#-----------------------------------------------------------------------------#SYSDBAPASSWORD =#-----------------------------------------------------------------------------# Name : REGISTERWITHDIRSERVICE# Datatype : Boolean# Description : Specifies whether to register with Directory Service.# Valid values : TRUE \ FALSE# Default value : FALSE# Mandatory : No#-----------------------------------------------------------------------------#REGISTERWITHDIRSERVICE= TRUE#-----------------------------------------------------------------------------# Name : UNREGISTERWITHDIRSERVICE# Datatype : Boolean# Description : Specifies whether to unregister with Directory Service.# Valid values : TRUE \ FALSE# Default value : FALSE# Mandatory : No#-----------------------------------------------------------------------------#UNREGISTERWITHDIRSERVICE= TRUE#-----------------------------------------------------------------------------# Name : REGENERATEDBPASSWORD# Datatype : Boolean# Description : Specifies whether regenerate database password in OID/Wallet# Valid values : TRUE \ FALSE# Default value : FALSE# Mandatory : No#-----------------------------------------------------------------------------#REGENERATEDBPASSWORD= TRUE#-----------------------------------------------------------------------------# Name : DIRSERVICEUSERNAME# Datatype : String# Description : Specifies the name of the directory service user# Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified#-----------------------------------------------------------------------------#DIRSERVICEUSERNAME= "name"#-----------------------------------------------------------------------------# Name : DIRSERVICEPASSWORD# Datatype : String# Description : The password of the directory service user.# You can also specify the password at the command prompt instead of here.# Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified#-----------------------------------------------------------------------------#DIRSERVICEPASSWORD= "password"#-----------------------------------------------------------------------------# Name : WALLETPASSWORD# Datatype : String# Description : The password for wallet to created or modified.# You can also specify the password at the command prompt instead of here.# Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified#-----------------------------------------------------------------------------#WALLETPASSWORD= "password"#-----------------------------------------------------------------------------# Name : DISABLESECURITYCONFIGURATION# Datatype : String# Description : Database Security Settings# Valid values : ALL|NONE|AUDIT|PASSWORD_PROFILE# Default value : NONE# Mandatory : No#-----------------------------------------------------------------------------#DISABLESECURITYCONFIGURATION = "NONE"#-----------------------------------------------------------------------------# Name : ENABLESECURITYCONFIGURATION# Datatype : String# Description : Database Security Settings# Valid values : true|false# Default value : true# Mandatory : No#-----------------------------------------------------------------------------#ENABLESECURITYCONFIGURATION = "true"#-----------------------------------------------------------------------------# Name : EMCONFIGURATION# Datatype : String# Description : Enterprise Manager Configuration Type# Valid values : CENTRAL|LOCAL|ALL|NONE# Default value : NONE# Mandatory : No#-----------------------------------------------------------------------------#EMCONFIGURATION = "NONE"#-----------------------------------------------------------------------------# Name : SYSMANPASSWORD# Datatype : String# Description : Password for SYSMAN user# Valid values : Check Oracle11g Administrator's Guide# Default value : None# Mandatory : Yes, if LOCAL specified for EMCONFIGURATION#-----------------------------------------------------------------------------#SYSMANPASSWORD = "password"#-----------------------------------------------------------------------------# Name : DBSNMPPASSWORD# Datatype : String# Description : Password for DBSNMP user# Valid values : Check Oracle11g Administrator's Guide# Default value : None# Mandatory : Yes, if EMCONFIGURATION is specified#-----------------------------------------------------------------------------#DBSNMPPASSWORD = "password"#-----------------------------------------------------------------------------# Name : CENTRALAGENT# Datatype : String# Description : Grid Control Central Agent Oracle Home# Default value : None# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION#-----------------------------------------------------------------------------#CENTRALAGENT = #-----------------------------------------------------------------------------# Name : HOSTUSERNAME# Datatype : String# Description : Host user name for EM backup job# Default value : None# Mandatory : Yes, if ALL is specified for EMCONFIGURATION#-----------------------------------------------------------------------------#HOSTUSERNAME = #-----------------------------------------------------------------------------# Name : HOSTUSERPASSWORD# Datatype : String# Description : Host user password for EM backup job# Default value : None# Mandatory : Yes, if ALL is specified for EMCONFIGURATION#-----------------------------------------------------------------------------#HOSTUSERPASSWORD= #-----------------------------------------------------------------------------# Name : BACKUPSCHEDULE# Datatype : String# Description : Daily backup schedule in the form of hh:mm# Default value : 2:00# Mandatory : Yes, if ALL is specified for EMCONFIGURATION#-----------------------------------------------------------------------------#BACKUPSCHEDULE=#-----------------------*** End of CONFIGUREDATABASE section ***------------------------#-----------------------------------------------------------------------------# ADDINSTANCE section is used when OPERATION_TYPE is defined as "addInstance". #-----------------------------------------------------------------------------[ADDINSTANCE]#-----------------------------------------------------------------------------# Name : DB_UNIQUE_NAME# Datatype : String# Description : DB Unique Name of the RAC database# Valid values : <db_unique_name># Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------DB_UNIQUE_NAME = "orcl11g.us.oracle.com"#-----------------------------------------------------------------------------# Name : INSTANCENAME# Datatype : String# Description : RAC instance name to be added# Valid values : Check Oracle11g Administrator's Guide# Default value : <sid_prefix>+<highest_current_thread+1># Mandatory : No#-----------------------------------------------------------------------------#INSTANCENAME = "orcl1"#-----------------------------------------------------------------------------# Name : NODELIST# Datatype : String# Description : Node on which to add new instance # (in 10gR2, instance addition is supported on 1 node at a time)# Valid values : Cluster node name# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------NODELIST=#-----------------------------------------------------------------------------# Name : OBFUSCATEDPASSWORDS# Datatype : Boolean# Description : Set to true if passwords are encrypted# Valid values : TRUE\FALSE# Default value : FALSE# Mandatory : No#-----------------------------------------------------------------------------#OBFUSCATEDPASSWORDS = FALSE#-----------------------------------------------------------------------------# Name : SYSDBAUSERNAME # Datatype : String# Description : A user with DBA role.# Default value : none# Mandatory : YES#-----------------------------------------------------------------------------SYSDBAUSERNAME = "sys"#-----------------------------------------------------------------------------# Name : SYSDBAPASSWORD # Datatype : String# Description : The password of the DBA user.# Default value : none# Mandatory : YES#-----------------------------------------------------------------------------#SYSDBAPASSWORD = "password"#-----------------------*** End of ADDINSTANCE section ***------------------------#-----------------------------------------------------------------------------# DELETEINSTANCE section is used when OPERATION_TYPE is defined as "deleteInstance". #-----------------------------------------------------------------------------[DELETEINSTANCE]#-----------------------------------------------------------------------------# Name : DB_UNIQUE_NAME# Datatype : String# Description : DB Unique Name of the RAC database# Valid values : <db_unique_name># Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------DB_UNIQUE_NAME = "orcl11g.us.oracle.com"#-----------------------------------------------------------------------------# Name : INSTANCENAME# Datatype : String# Description : RAC instance name to be deleted# Valid values : Check Oracle11g Administrator's Guide# Default value : None# Mandatory : Yes#-----------------------------------------------------------------------------INSTANCENAME = "orcl11g"#-----------------------------------------------------------------------------# Name : NODELIST# Datatype : String# Description : Node on which instance to be deleted (SID) is located# Valid values : Cluster node name# Default value : None# Mandatory : No#-----------------------------------------------------------------------------#NODELIST=#-----------------------------------------------------------------------------# Name : OBFUSCATEDPASSWORDS# Datatype : Boolean# Description : Set to true if passwords are encrypted# Valid values : TRUE\FALSE# Default value : FALSE# Mandatory : No#-----------------------------------------------------------------------------#OBFUSCATEDPASSWORDS = FALSE#-----------------------------------------------------------------------------# Name : SYSDBAUSERNAME # Datatype : String# Description : A user with DBA role.# Default value : none# Mandatory : YES#-----------------------------------------------------------------------------SYSDBAUSERNAME = "sys"#-----------------------------------------------------------------------------# Name : SYSDBAPASSWORD # Datatype : String# Description : The password of the DBA user.# Default value : none# Mandatory : YES#-----------------------------------------------------------------------------#SYSDBAPASSWORD = "password"#-----------------------*** End of DELETEINSTANCE section ***------------------------开始执行安装文件
cd /opt/oracle/database/#执行建库脚本按照要求输入数据库密码,执行文件./runInstaller -silent -force -ignorePrereq -responseFile /opt/oracle/database/response/db_install.rsp等待安装#新建ssh链接在root用户下执行提示我们的两个脚本 [root@easytong database]# /opt/oracle/oraInventory/orainstRoot.sh [root@easytong database]# /opt/oracle/product/11.2.0/db_1/root.sh #配置监听#切换到oracle用户 [root@easytong database]# su - oracle [oracle@easytong database]$ netca /silent /responseFile /opt/oracle/database/response/netca.rsp#启动监听 [oracle@easytong database]$ lsnrctl start [oracle@easytong database]$ lsnrctl status #静默dbca建立数据库dbca -silent -responseFile /opt/oracle/database/response/dbca.rsp按照提示输入密码
完成安装
标签: #centos732位库