Oracle安裝軟體及建立資料庫(字元安裝方式)

fjzcau發表於2015-01-23
------------------------------------------------------------------
--靜默安裝軟體 
1) 修改安裝配置檔案: /oracle/ora11.2.4_ee_silent.rsp
cd /tmp/oracle/ora_11.2.4/database/response
cp  db_install.rsp  /oracle/ora11.2.4_ee_silent.rs
2) 執行安裝
./runInstaller -silent -responseFile /oracle/ora11.2.4_ee_silent.rsp 
3) 安裝軟體後,root執行以下指令碼:
Please check '/oracle/oraInventory/logs/silentInstall2015-01-22_03-28-07PM.log' for more details.
As a root user, execute the following script(s):
1. /oracle/oraInventory/orainstRoot.sh
2. /oracle/product/11.2.4/root.sh

--靜默建立庫
1) cp $ORACLE_HOME/assistants/dbca/dbca.rsp   /oracle/dbca.rsp
修改 /oracle/dbca.rsp
TEMPLATENAME=/oracle/product/11.2.4/assistants/dbca/templates/General_Purpose.dbc
2) cd $ORACLE_HOME/bin 
./dbca -silent -createdatabase -responseFile /oracle/dbca.rsp


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

#-------------------------------------------------------------------------------
# ** Begin ora11.2.4_ee_silent.rsp  
#-------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=sles11
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/oracle/oraInventory
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME=/oracle/product/11.2.4
ORACLE_BASE=/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.EEOptionsSelection=false
oracle.install.db.optionalComponents=
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oper
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.memoryOption=false
oracle.install.db.config.starterdb.password.ALL=oracle
oracle.installer.autoupdates.option=SKIP_UPDATES
DECLINE_SECURITY_UPDATES=true

#-------------------修改以上引數即可-------# 
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.enableSecuritySettings=true
oracle.install.db.config.starterdb.control=DB_CONTROL
oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
oracle.install.db.config.starterdb.automatedBackup.enable=false
oracle.install.db.config.starterdb.automatedBackup.osuid=
oracle.install.db.config.starterdb.automatedBackup.ospwd=
oracle.install.db.config.starterdb.storageType=
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
oracle.install.db.config.asm.diskGroup=
oracle.install.db.config.asm.ASMSNMPPassword=
MYORACLESUPPORT_USERNAME=
MYORACLESUPPORT_PASSWORD=
SECURITY_UPDATES_VIA_MYORACLESUPPORT= 
PROXY_HOST=
PROXY_PORT=
PROXY_USER=
PROXY_PWD=
PROXY_REALM=
COLLECTOR_SUPPORTHUB_URL=
oracle.installer.autoupdates.downloadUpdatesLoc=
AUTOUPDATES_MYORACLESUPPORT_USERNAME=
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
#-------------------------------------------------------------------------------
# ** End ora11.2.4_ee_silent.rsp
#-------------------------------------------------------------------------------


#-------------------------------------------------------------------------------
# ** Begin dbca.rsp
#-------------------------------------------------------------------------------
[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"

[CREATEDATABASE]
GDBNAME = "bsbora"
SID = "bsbora"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "password"
SYSTEMPASSWORD = "password"
EMCONFIGURATION = "NONE"
SYSMANPASSWORD = "password"
DBSNMPPASSWORD = "password"
DATAFILEDESTINATION = /oradata
#STORAGETYPE=FS
CHARACTERSET = "ZHS16GBK"
NATIONALCHARACTERSET= "AL16UTF16"
LISTENERS = "listener"
MEMORYPERCENTAGE = "40"
DATABASETYPE = "MULTIPURPOSE"
AUTOMATICMEMORYMANAGEMENT = "TRUE"
#TOTALMEMORY = "800"
#-------------------------------------------------------------------------------
# ** End dbca.rsp
#-------------------------------------------------------------------------------

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22661144/viewspace-1412555/,如需轉載,請註明出處,否則將追究法律責任。

相關文章