共計 11862 個字符，預計需要花費 30 分鐘才能閱讀完成。
這篇文章主要介紹了 Oracle 12cR1 RAC 在 VMware Workstation 上如何實現靜默安裝，具有一定借鑒價值，感興趣的朋友可以參考下，希望大家閱讀完這篇文章之后大有收獲，下面讓丸趣 TV 小編帶著大家一起了解一下。
1.1 靜默安裝 1.1.1 靜默安裝 grid
安裝之前使用腳本進行校驗，確保所有的 failed 選項都可以忽略。
./runcluvfy.sh stage -pre crsinst -n raclhr-12cR1-N1,raclhr-12cR1-N2 -fixup -verbose
1.1.1.1 新建 /etc/oraInst.loc 文件
在 2 個節點上新建 /etc/oraInst.loc，文件中的內容如下：
inventory_loc=/u01/app/oraInventory
inst_group=oinstall
輸入下面的命令在 oraInst.loc 文件上設置合適的擁有者，組和權限：
chown oracle:oinstall /etc/oraInst.loc
chmod 664 /etc/oraInst.loc
1.1.1.2 檢查項
1、/u01/app/oraInventory 必須為空
ls -l /u01/app/oraInventory/*
rm -rf /u01/app/oraInventory/*
否則報錯：
[FATAL] [INS-32035] Unable to create a new central inventory directory : /u01/app/oraInventory.
CAUSE: The central inventory location provided is not empty.
ACTION: Please provide another location for the inventory, or clean up the current location.
2、INS-32040
[FATAL] [INS-32040] The central inventory location provided is not empty on remote nodes [raclhr-12cr1-n1].
ACTION: Please provide another location for the inventory, or clean up the current location.
解決辦法：
新建 /etc/oraInst.loc，文件中的內容如下：
inventory_loc=/u01/app/oraInventory
inst_group=oinstall
輸入下面的命令在 oraInst.loc 文件上設置合適的擁有者，組和權限：
chown oracle:oinstall /etc/oraInst.loc
chmod 664 /etc/oraInst.loc
1.1.1.3 開始安裝
靜默腳本：
./runInstaller -silent -force -noconfig -IgnoreSysPreReqs -ignorePrereq -showProgress \
INVENTORY_LOCATION=/u01/app/oraInventory \
SELECTED_LANGUAGES=en \
ORACLE_BASE=/u01/app/grid \
ORACLE_HOME=/u01/app/12.1.0/grid \
oracle.install.asm.OSDBA=asmdba \
oracle.install.asm.OSOPER=asmoper \
oracle.install.asm.OSASM=asmadmin \
oracle.install.crs.config.storageOption=ASM_STORAGE \
oracle.install.crs.config.sharedFileSystemStorage.votingDiskRedundancy=EXTERNAL \
oracle.install.crs.config.sharedFileSystemStorage.ocrRedundancy=EXTERNAL \
oracle.install.crs.config.useIPMI=false \
oracle.install.asm.diskGroup.name=OCR \
oracle.install.asm.diskGroup.redundancy=EXTERNAL \
oracle.installer.autoupdates.option=SKIP_UPDATES \
oracle.install.crs.config.gpnp.scanPort=1521 \
oracle.install.crs.config.gpnp.configureGNS=false \
oracle.install.crs.config.autoConfigureClusterNodeVIP=false \
oracle.install.option=CRS_CONFIG \
oracle.install.crs.config.ClusterType=STANDARD \
oracle.install.asm.SYSASMPassword=lhr \
oracle.install.asm.monitorPassword=lhr \
oracle.install.config.managementOption=NONE \
oracle.install.crs.config.ignoreDownNodes=false \
oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asm-disk* \
oracle.install.asm.diskGroup.disks=/dev/asm-diskc \
oracle.install.crs.config.gpnp.scanName=raclhr-12cR1-scan \
oracle.install.crs.config.clusterName=raclhr-cluster \
oracle.install.crs.config.clusterNodes=raclhr-12cr1-n1:raclhr-12cr1-n1-vip,raclhr-12cr1-n2:raclhr-12cr1-n2-vip \
oracle.install.crs.config.networkInterfaceList=eth0:192.168.59.0:1,eth2:192.168.2.0:2 \
ORACLE_HOSTNAME=raclhr-12cR1-N1
命令行模式執行靜默安裝，注意復制腳本的時候最后不能多加回車符號，當前窗口不要執行其他內容。“\”后不能有空格。開始執行有點慢，需要修改的地方我已經用×××背景標注了。若有其他錯誤可以采用 -debug 模式獲取更多信息。
二、 configToolAllCommands 腳本
關于該部分可參考：http://blog.itpub.net/26736162/viewspace-2129161/。該腳本執行完畢會創建一個 sid 為 -MGMTDB，gdbName 為_mgmtdb 的單實例容器數據庫（從日志可以找到相關命令：/u01/app/12.1.0/grid/bin/dbca -silent -createDatabase -createAsContainerDatabase true -templateName MGMTSeed_Database.dbc -sid -MGMTDB -gdbName _mgmtdb -storageType ASM -diskGroupName OCR -datafileJarLocation /u01/app/12.1.0/grid/assistants/dbca/templates -characterset AL32UTF8 -autoGeneratePasswords -skipUserTemplateCheck -oui_internal）該數據庫屬于 grid 用戶。
/u01/app/12.1.0/grid/cfgtoollogs/configToolAllCommands RESPONSE_FILE=/home/grid/cfgrsp.properties
根據官方文檔內容，安裝 GRID 可以配置如下的信息：
oracle.assistants.asm|S_ASMPASSWORD=password
oracle.assistants.asm|S_ASMMONITORPASSWORD=password
oracle.crs|S_BMCPASSWORD=password
以 grid 用戶在節點 1 上執行（準確來說應該在執行靜默安裝的節點上執行，且節點 2 上不需要執行）：
[grid@raclhr-12cR1-N1 ~]$ more /home/grid/cfgrsp.properties
oracle.assistants.asm|S_ASMPASSWORD=lhr
oracle.assistants.asm|S_ASMMONITORPASSWORD=lhr
oracle.crs|S_BMCPASSWORD=lhr
[grid@raclhr-12cR1-N1 ~]$ /u01/app/12.1.0/grid/cfgtoollogs/configToolAllCommands RESPONSE_FILE=/home/grid/cfgrsp.properties
[grid@raclhr-12cR1-N1 admin]$ /u01/app/12.1.0/grid/cfgtoollogs/configToolAllCommands RESPONSE_FILE=/home/grid/cfgrsp.properties
Setting the invPtrLoc to /u01/app/12.1.0/grid/oraInst.loc
perform – mode is starting for action: configure
perform – mode finished for action: configure
You can see the log file: /u01/app/12.1.0/grid/cfgtoollogs/oui/configActions2017-01-17_05-29-38-PM.log
[grid@raclhr-12cR1-N1 admin]$
[grid@raclhr-12cR1-N1 admin]$
1.1.2 靜默安裝 database
首先通過如下的命令進行檢查環境配置：
/soft/grid/runcluvfy.sh stage -pre dbinst -n raclhr-12cR1-N1,raclhr-12cR1-N2 -verbose -fixup
1.1.2.1 靜默安裝 DB 軟件
./runInstaller -silent -force -noconfig -IgnoreSysPreReqs -ignorePrereq -showProgress \
oracle.install.option=INSTALL_DB_SWONLY \
DECLINE_SECURITY_UPDATES=true \
UNIX_GROUP_NAME=oinstall \
INVENTORY_LOCATION=/u01/app/oraInventory \
SELECTED_LANGUAGES=en \
oracle.install.db.InstallEdition=EE \
oracle.install.db.isCustomInstall=false \
oracle.install.db.EEOptionsSelection=false \
oracle.install.db.DBA_GROUP=dba \
oracle.install.db.OPER_GROUP=asmoper \
oracle.install.db.isRACOneInstall=false \
oracle.install.db.BACKUPDBA_GROUP=dba \
oracle.install.db.DGDBA_GROUP=dba \
oracle.install.db.KMDBA_GROUP=dba \
oracle.install.db.rac.serverpoolCardinality=0 \
oracle.install.db.ConfigureAsContainerDB=false \
oracle.install.db.config.starterdb.memoryOption=false \
oracle.install.db.config.starterdb.installExampleSchemas=true \
oracle.install.db.config.starterdb.managementOption=DEFAULT \
oracle.install.db.config.starterdb.enableRecovery=false \
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE \
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \
oracle.installer.autoupdates.option=SKIP_UPDATES \
ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 \
ORACLE_BASE=/u01/app/oracle \
oracle.install.db.CLUSTER_NODES=raclhr-12cr1-n1,raclhr-12cr1-n2 \
ORACLE_HOSTNAME=raclhr-12cR1-N1
命令行模式執行靜默安裝，注意復制腳本的時候最后不能多加回車符號，當前窗口不要執行其他內容。“\”后不能有空格。開始執行有點慢，需要修改的地方我已經用×××背景標注了。若有其他錯誤可以采用 -debug 模式獲取更多信息。
[oracle@raclhr-12cR1-N1 ~]$ cd /soft/database/
[oracle@raclhr-12cR1-N1 database]$ ll
total 72
drwxr-xr-x 4 root root 4096 Jan 16 17:04 install
-rwxr-xr-x 1 root root 34132 Jul 11 2014 readme.html
drwxrwxr-x 2 root root 4096 Jul 7 2014 response
drwxr-xr-x 2 root root 4096 Jul 7 2014 rpm
-rwxr-xr-x 1 root root 8533 Jul 7 2014 runInstaller
drwxrwxr-x 2 root root 4096 Jul 7 2014 sshsetup
drwxr-xr-x 14 root root 4096 Jul 7 2014 stage
-rwxr-xr-x 1 root root 500 Feb 7 2013 welcome.html
[oracle@raclhr-12cR1-N1 database]$ ./runInstaller -silent -force -noconfig -IgnoreSysPreReqs -ignorePrereq -showProgress \
oracle.install.option=INSTALL_DB_SWONLY \
DECLINE_SECURITY_UPDATES=true \
UNIX_GROUP_NAME=oinstall \
INVENTORY_LOCATION=/u01/app/oraInventory \
SELECTED_LANGUAGES=en \
oracle.install.db.InstallEdition=EE \
oracle.install.db.isCustomInstall=false \
oracle.install.db.EEOptionsSelection=false \
oracle.install.db.DBA_GROUP=dba \
oracle.install.db.OPER_GROUP=asmoper \
oracle.install.db.isRACOneInstall=false \
oracle.install.db.BACKUPDBA_GROUP=dba \
oracle.install.db.DGDBA_GROUP=dba \
oracle.install.db.KMDBA_GROUP=dba \
oracle.install.db.rac.serverpoolCardinality=0 \
oracle.install.db.ConfigureAsContainerDB=false \
oracle.install.db.config.starterdb.memoryOption=false \
oracle.install.db.config.starterdb.installExampleSchemas=true \
oracle.install.db.config.starterdb.managementOption=DEFAULT \
oracle.install.db.config.starterdb.enableRecovery=false \
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE \
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \
oracle.installer.autoupdates.option=SKIP_UPDATES \
ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 \
ORACLE_BASE=/u01/app/oracle \
oracle.install.db.CLUSTER_NODES=raclhr-12cr1-n1,raclhr-12cr1-n2 \
ORACLE_HOSTNAME=raclhr-12cR1-N1
Starting Oracle Universal Installer…
Checking Temp space: must be greater than 500 MB. Actual 2287 MB Passed
Checking swap space: must be greater than 150 MB. Actual 1785 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-01-17_09-38-20PM. Please wait …[oracle@raclhr-12cR1-N1 database]$
[oracle@raclhr-12cR1-N1 database]$
[oracle@raclhr-12cR1-N1 database]$
[oracle@raclhr-12cR1-N1 database]$
[oracle@raclhr-12cR1-N1 database]$ You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2017-01-17_09-38-20PM.log
Prepare in progress.
………………………………………….. 8% Done.
Prepare successful.
Copy files in progress.
………………………………………….. 13% Done.
………………………………………….. 18% Done.
………………………………………….. 23% Done.
………………………………………….. 28% Done.
………………………………………….. 33% Done.
………………………………………….. 38% Done.
………………………………………….. 43% Done.
……….
Copy files successful.
Link binaries in progress.
……….
Link binaries successful.
………………………………………….. 53% Done.
Setup files in progress.
Setup files successful.
………………………………………….. 59% Done.
Setup Inventory in progress.
Setup Inventory successful.
………………………………………….. 65% Done.
Finish Setup successful.
Perform remote operations in progress.
Perform remote operations successful.
………………………………………….. 72% Done.
Saving Cluster Inventory in progress.
……….
Saving Cluster Inventory successful.
The installation of Oracle Database 12c was successful.
Please check /u01/app/oraInventory/logs/silentInstall2017-01-17_09-38-20PM.log for more details.
Setup Oracle Base in progress.
Setup Oracle Base successful.
………………………………………….. 86% Done.
Update Inventory in progress.
Update Inventory successful.
………………………………………….. 95% Done.
As a root user, execute the following script(s):
1. /u01/app/oracle/product/12.1.0/dbhome_1/root.sh
Execute /u01/app/oracle/product/12.1.0/dbhome_1/root.sh on the following nodes:
[raclhr-12cr1-n1, raclhr-12cr1-n2]
………………………………………….. 100% Done.
Successfully Setup Software.
As install user, execute the following script to complete the configuration.
1. /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/configToolAllCommands RESPONSE_FILE= response_file
Note:
1. This script must be run on the same host from where installer was run.
2. This script needs a small password properties file for configuration assistants that require passwords (refer to install guide documentation).
節點 1 和節點 2 依次執行 root.sh：
[root@raclhr-12cR1-N1 ~]# /u01/app/oracle/product/12.1.0/dbhome_1/root.sh
Check /u01/app/oracle/product/12.1.0/dbhome_1/install/root_raclhr-12cR1-N1_2017-01-17_22-18-12.log for the output of root script
[root@raclhr-12cR1-N1 ~]#
1.2 建立磁盤組
創建 DATA 和 FRA 磁盤組：
CREATE DISKGROUP DATA external redundancy DISK /dev/asm-diskd ATTRIBUTE compatible.rdbms = 12.1 , compatible.asm = 12.1
CREATE DISKGROUP FRA external redundancy DISK /dev/asm-diske ATTRIBUTE compatible.rdbms = 12.1 , compatible.asm = 12.1
[grid@raclhr-12cR1-N1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jan 17 22:41:42 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL CREATE DISKGROUP DATA external redundancy DISK /dev/asm-diskd ATTRIBUTE compatible.rdbms = 12.1 , compatible.asm = 12.1
Diskgroup created.
SQL CREATE DISKGROUP FRA external redundancy DISK /dev/asm-diske ATTRIBUTE compatible.rdbms = 12.1 , compatible.asm = 12.1
Diskgroup created.
SQL
1.3 dbca 靜默方式建庫
dbca -silent -createDatabase -templateName General_Purpose.dbc -responseFile NO_VALUE \
-gdbname lhrrac -sid lhrrac \
-createAsContainerDatabase false \
-sysPassword lhr -systemPassword lhr -serviceUserPassword lhr \
-datafileDestination DATA/ -recoveryAreaDestination FRA/ \
-storageType ASM -asmsnmpPassword oracle -diskGroupName DATA \
-characterset ZHS16GBK -nationalCharacterSet AL16UTF16 \
-sampleSchema true \
-memoryPercentage 30 \
-databaseType OLTP \
-emConfiguration NONE \
-nodeinfo raclhr-12cR1-N1,raclhr-12cR1-N2
1.4 其它配置 1.4.1 sqlplus 提示符設置
編輯 $ORACLE_HOME/sqlplus/admin/glogin.sql
set linesize 9999 pagesize 9999
set sqlprompt _USER @ _CONNECT_IDENTIFIER
感謝你能夠認真閱讀完這篇文章，希望丸趣 TV 小編分享的“Oracle 12cR1 RAC 在 VMware Workstation 上如何實現靜默安裝”這篇文章對大家有幫助，同時也希望大家多多支持丸趣 TV，關注丸趣 TV 行業資訊頻道，更多相關知識等著你來學習!
