Silent Install Oracle 12cR2 Rac on Centos7
1. 配置操作系统
参考博客 https://blog.csdn.net/wanbin6470398/article/details/84615454
2. 准备Oracle RAC的集群节点
参考博客 https://blog.csdn.net/wanbin6470398/article/details/84615454
3. 准备Oracle RAC的共享存储
参考博客 https://blog.csdn.net/wanbin6470398/article/details/84615454
4. 配置互信
参考博客 https://blog.csdn.net/wanbin6470398/article/details/84615454
5. 静默安装 GI 软件
- 编辑grid安装响应文件
cat grid.rsp |grep -v "^$"|grep -v "^#" oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v12.2.0 INVENTORY_LOCATION=/u01/app/oraInventory oracle.install.option=CRS_CONFIG ORACLE_BASE=/u01/app/grid oracle.install.asm.OSDBA=asmdba oracle.install.asm.OSOPER=asmoper oracle.install.asm.OSASM=asmadmin oracle.install.crs.config.gpnp.scanName=scanip oracle.install.crs.config.gpnp.scanPort=1521 oracle.install.crs.config.ClusterConfiguration=STANDALONE oracle.install.crs.config.configureAsExtendedCluster=false oracle.install.crs.config.memberClusterManifestFile= oracle.install.crs.config.clusterName=raccluster oracle.install.crs.config.gpnp.configureGNS=false oracle.install.crs.config.autoConfigureClusterNodeVIP=false oracle.install.crs.config.gpnp.gnsOption= oracle.install.crs.config.gpnp.gnsClientDataFile= oracle.install.crs.config.gpnp.gnsSubDomain= oracle.install.crs.config.gpnp.gnsVIPAddress= oracle.install.crs.config.sites= oracle.install.crs.config.clusterNodes=rac1:rac1vip:HUB,rac2:rac2vip:HUB oracle.install.crs.config.networkInterfaceList=enp0s3:192.168.56.0:1,enp0s8:10.10.10.0:5,virbr0:192.168.122.0:3 oracle.install.asm.configureGIMRDataDG=false oracle.install.crs.config.storageOption= oracle.install.crs.config.useIPMI=false oracle.install.crs.config.ipmi.bmcUsername= oracle.install.crs.config.ipmi.bmcPassword= oracle.install.asm.storageOption=ASM oracle.install.asmOnNAS.ocrLocation= oracle.install.asmOnNAS.configureGIMRDataDG=false oracle.install.asmOnNAS.gimrLocation= oracle.install.asm.SYSASMPassword=oracle oracle.install.asm.diskGroup.name=OCR_GIMR_DG oracle.install.asm.diskGroup.redundancy=EXTERNAL oracle.install.asm.diskGroup.AUSize=1 oracle.install.asm.diskGroup.FailureGroups= oracle.install.asm.diskGroup.disksWithFailureGroupNames=/dev/raw/raw3, oracle.install.asm.diskGroup.disks=/dev/raw/raw3 oracle.install.asm.diskGroup.quorumFailureGroupNames= oracle.install.asm.diskGroup.diskDiscoveryString=/dev/raw/raw* oracle.install.asm.monitorPassword=oracle oracle.install.asm.gimrDG.name= oracle.install.asm.gimrDG.redundancy= oracle.install.asm.gimrDG.AUSize=1 oracle.install.asm.gimrDG.FailureGroups= oracle.install.asm.gimrDG.disksWithFailureGroupNames= oracle.install.asm.gimrDG.disks= oracle.install.asm.gimrDG.quorumFailureGroupNames= oracle.install.asm.configureAFD=false oracle.install.crs.configureRHPS=false oracle.install.crs.config.ignoreDownNodes=false oracle.install.config.managementOption=NONE oracle.install.config.omsHost= oracle.install.config.omsPort=0 oracle.install.config.emAdminUser= oracle.install.config.emAdminPassword= oracle.install.crs.rootconfig.executeRootScript=false oracle.install.crs.rootconfig.configMethod= oracle.install.crs.rootconfig.sudoPath= oracle.install.crs.rootconfig.sudoUserName= oracle.install.crs.config.batchinfo= oracle.install.crs.app.applicationAddress=
- 以grid用户,执行以下命令进行静默安装GI软件
$ ./gridSetup.sh -silent -responsefile /home/grid/grid.rsp -skipprereqs Launching Oracle Grid Infrastructure Setup Wizard... [WARNING] [INS-30011] The SYS password entered does not conform to the Oracle recommended standards. CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. ACTION: Provide a password that conforms to the Oracle recommended standards. [WARNING] [INS-30011] The ASMSNMP password entered does not conform to the Oracle recommended standards. CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. ACTION: Provide a password that conforms to the Oracle recommended standards. You can find the log of this install session at: /tmp/GridSetupActions2018-11-30_02-29-58PM/gridSetupActions2018-11-30_02-29-58PM.log As a root user, execute the following script(s): 1. /u01/app/oraInventory/orainstRoot.sh 2. /u01/app/12.2.0/grid/root.sh Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes: [rac1, rac2] Execute /u01/app/12.2.0/grid/root.sh on the following nodes: [rac1, rac2] Run the script on the local node first. After successful completion, you can start the script in parallel on all other nodes. Successfully Setup Software. As install user, execute the following command to complete the configuration. /u01/app/12.2.0/grid/gridSetup.sh -executeConfigTools -responseFile /home/grid/grid.rsp [-silent]
- 运行脚本
#使用root用户执行以下脚本,首先在本地节点上运行脚本。 成功完成后,您可以在所有其他节点上并行启动脚本。 1) /u01/app/oraInventory/orainstRoot.sh 2) /u01/app/12.2.0/grid/root.sh
- 完成mgmtdb的配置:
#使用grid用户运行以下脚本 /u01/app/12.2.0/grid/gridSetup.sh -executeConfigTools -responseFile /home/grid/grid.rsp -silent Launching Oracle Grid Infrastructure Setup Wizard... You can find the logs of this session at: /u01/app/oraInventory/logs/GridSetupActions2018-11-30_03-08-17PM [WARNING] [INS-43080] Some of the configuration assistants failed, were cancelled or skipped. ACTION: Refer to the logs or contact Oracle Support Services.
6. 静默安装 Oracle DB软件
- 编辑oracle安装响应文件
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.2.0 oracle.install.option=INSTALL_DB_SWONLY UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/app/oraInventory ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1 ORACLE_BASE=/u01/app/oracle oracle.install.db.InstallEdition=EE oracle.install.db.OSDBA_GROUP=dba oracle.install.db.OSOPER_GROUP=dba oracle.install.db.OSBACKUPDBA_GROUP=dba oracle.install.db.OSDGDBA_GROUP=dba oracle.install.db.OSKMDBA_GROUP=dba oracle.install.db.OSRACDBA_GROUP=dba oracle.install.db.rac.configurationType= oracle.install.db.CLUSTER_NODES=rac2,rac1 oracle.install.db.isRACOneInstall=false oracle.install.db.racOneServiceName= oracle.install.db.rac.serverpoolName= oracle.install.db.rac.serverpoolCardinality=0 oracle.install.db.config.starterdb.type=GENERAL_PURPOSE oracle.install.db.config.starterdb.globalDBName= oracle.install.db.config.starterdb.SID= oracle.install.db.ConfigureAsContainerDB=false oracle.install.db.config.PDBName= oracle.install.db.config.starterdb.characterSet= oracle.install.db.config.starterdb.memoryOption=false oracle.install.db.config.starterdb.memoryLimit= oracle.install.db.config.starterdb.installExampleSchemas=false oracle.install.db.config.starterdb.password.ALL= oracle.install.db.config.starterdb.password.SYS= oracle.install.db.config.starterdb.password.SYSTEM= oracle.install.db.config.starterdb.password.DBSNMP= oracle.install.db.config.starterdb.password.PDBADMIN= oracle.install.db.config.starterdb.managementOption=DEFAULT oracle.install.db.config.starterdb.omsHost= oracle.install.db.config.starterdb.omsPort=0 oracle.install.db.config.starterdb.emAdminUser= oracle.install.db.config.starterdb.emAdminPassword= oracle.install.db.config.starterdb.enableRecovery=false 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=false DECLINE_SECURITY_UPDATES=true PROXY_HOST= PROXY_PORT= PROXY_USER= PROXY_PWD= COLLECTOR_SUPPORTHUB_URL=
- 以oracle用户,执行以下命令进行静默安装DB软件:
$ ./runInstaller -silent -responsefile /home/oracle/db.rsp -ignoresysprereqs -skipprereqs Starting Oracle Universal Installer... Checking Temp space: must be greater than 500 MB. Actual 23305 MB Passed Checking swap space: must be greater than 150 MB. Actual 3244 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2018-11-30_03-41-09PM. Please wait ...
- 以root用户,运行以下脚本
As a root user, execute the following script(s): 1. /u01/app/oracle/product/12.2.0/db_1/root.sh Execute /u01/app/oracle/product/12.2.0/db_1/root.sh on the following nodes: [rac2, rac1]
7. 创建asm磁盘组
以grid用户登录ASM实例,创建磁盘组
[root@rac1 ~]# su - grid
Last login: Sun Dec 2 09:28:08 CST 2018
[grid@rac1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 12.2.0.1.0 Production on Sun Dec 2 09:37:34 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> set lines 1000
SQL> set pages 1000
SQL> col path for a50
SQL> select group_number,header_status,state,name,path,redundancy from v$asm_disk;
GROUP_NUMBER HEADER_STATU STATE NAME PATH REDUNDA
------------ ------------ -------- ------------------------------ -------------------------------------------------- -------
0 CANDIDATE NORMAL /dev/raw/raw2 UNKNOWN
0 CANDIDATE NORMAL /dev/raw/raw4 UNKNOWN
0 CANDIDATE NORMAL /dev/raw/raw1 UNKNOWN
1 MEMBER NORMAL OCR_GIMR_DG_0000 /dev/raw/raw3 UNKNOWN
SQL> select group_number,name,state,compatibility,database_compatibility from v$asm_diskgroup;
GROUP_NUMBER NAME STATE COMPATIBILITY DATABASE_COMPATIBILITY
------------ ------------------------------ ----------- ------------------------------------------------------------ ------------------------------------------------------------
1 OCR_GIMR_DG MOUNTED 12.2.0.1.0 10.1.0.0.0
SQL> create diskgroup DATA external redundancy disk '/dev/raw/raw4' attribute 'compatible.asm' = '12.2.0.1';
Diskgroup created.
SQL> create diskgroup ARCH external redundancy disk '/dev/raw/raw1','/dev/raw/raw2' attribute 'compatible.asm' = '12.2.0.1';
Diskgroup created.
SQL> select group_number,header_status,state,name,path,redundancy from v$asm_disk;
GROUP_NUMBER HEADER_STATU STATE NAME PATH REDUNDA
------------ ------------ -------- ------------------------------ -------------------------------------------------- -------
1 MEMBER NORMAL OCR_GIMR_DG_0000 /dev/raw/raw3 UNKNOWN
3 MEMBER NORMAL ARCH_0000 /dev/raw/raw1 UNKNOWN
3 MEMBER NORMAL ARCH_0001 /dev/raw/raw2 UNKNOWN
2 MEMBER NORMAL DATA_0000 /dev/raw/raw4 UNKNOWN
SQL> select group_number,name,state,compatibility,database_compatibility from v$asm_diskgroup;
GROUP_NUMBER NAME STATE COMPATIBILITY DATABASE_COMPATIBILITY
------------ ------------------------------ ----------- ------------------------------------------------------------ ------------------------------------------------------------
1 OCR_GIMR_DG MOUNTED 12.2.0.1.0 10.1.0.0.0
2 DATA MOUNTED 12.2.0.1.0 10.1.0.0.0
3 ARCH MOUNTED 12.2.0.1.0 10.1.0.0.0
8. 静默创建数据库
- 编辑dbca响应文件
responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0 gdbName=orcl sid=orcl databaseConfigType=RAC RACOneNodeServiceName= policyManaged=false createServerPool=false serverPoolName= cardinality= force=false pqPoolName= pqCardinality= createAsContainerDatabase=true numberOfPDBs=1 pdbName=orclpdb useLocalUndoForPDBs=true pdbAdminPassword=oracle nodelist=rac1,rac2 templateName=/u01/app/oracle/product/12.2.0/db_1/assistants/dbca/templates/General_Purpose.dbc sysPassword=oracle systemPassword=oracle serviceUserPassword= emConfiguration=DBEXPRESS emExpressPort=5500 runCVUChecks=true dbsnmpPassword=oracle omsHost= omsPort=0 emUser= emPassword= dvConfiguration=false dvUserName= dvUserPassword= dvAccountManagerName= dvAccountManagerPassword= olsConfiguration=false datafileJarLocation={ORACLE_HOME}/assistants/dbca/templates/ datafileDestination=+OCR_GIMR_DG/{DB_UNIQUE_NAME}/ recoveryAreaDestination= storageType=ASM diskGroupName=+OCR_GIMR_DG/{DB_UNIQUE_NAME}/ asmsnmpPassword= recoveryGroupName= characterSet=AL32UTF8 nationalCharacterSet=UTF8 registerWithDirService=false dirServiceUserName= dirServicePassword= walletPassword= listeners=LISTENER variablesFile= variables=DB_UNIQUE_NAME=orcl,ORACLE_BASE=/u01/app/oracle,PDB_NAME=,DB_NAME=orcl,ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1,SID=orcl initParams=orcl2.undo_tablespace=UNDOTBS2,family:dw_helper.instance_mode=read-only,processes=300,orcl2.instance_number=2,nls_language=AMERICAN,pga_aggregate_target=256MB,sga_target=768MB,dispatchers=(PROTOCOL=TCP) (SERVICE=orclXDB),db_block_size=8192BYTES,orcl1.undo_tablespace=UNDOTBS1,orcl2.thread=2,diagnostic_dest={ORACLE_BASE},cluster_database=true,orcl1.thread=1,audit_file_dest={ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump,db_create_file_dest=+OCR_GIMR_DG/{DB_UNIQUE_NAME}/,nls_territory=AMERICA,local_listener=-oraagent-dummy-,compatible=12.2.0,db_name=orcl,audit_trail=db,orcl1.instance_number=1,remote_login_passwordfile=exclusive,open_cursors=300 sampleSchema=false memoryPercentage=40 databaseType=MULTIPURPOSE automaticMemoryManagement=false totalMemory=0
- 以oracle用户,执行以下命令,用来创建数据库
[oracle@rac1 ~]$ dbca -silent -ignoreprereqs -ignoreprereqfailure -createdatabase -responsefile /home/oracle/dbca.rsp [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. Copying database files 1% complete 11% complete 21% complete Creating and starting Oracle instance 23% complete 25% complete 26% complete 27% complete 30% complete 33% complete 34% complete 35% complete Creating cluster database views 37% complete 50% complete Completing Database Creation 51% complete 53% complete 54% complete 56% complete 57% complete Creating Pluggable Databases 61% complete 78% complete Executing Post Configuration Actions 100% complete Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl0.log" for further details.