Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to achieve silent installation of Oracle 12cR1 RAC on VMware Workstation, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

1.1Silent installation 1.1.1 Silent installation use scripts to verify before grid installation to ensure that all failed options can be ignored.

. / runcluvfy.sh stage-pre crsinst-n raclhr-12cR1-N1,raclhr-12cR1-N2-fixup-verbose

1.1.1.1 New / etc/oraInst.loc file create a new / etc/oraInst.loc on 2 nodes, and the contents of the file are as follows:

Inventory_loc=/u01/app/oraInventory

Inst_group=oinstall

Enter the following command to set the appropriate owner, group, and permissions on the oraInst.loc file:

Chown oracle:oinstall / etc/oraInst.loc

Chmod 664 / etc/oraInst.loc

1.1.1.2 check item 1, / u01/app/oraInventory must be empty

Ls-l / u01According to oraInventorCharpy *

Rm-rf / u01According to oraInventorCharpy *

Otherwise, an error is reported:

[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.

Solution:

Create a new / etc/oraInst.loc. The contents of the file are as follows:

Inventory_loc=/u01/app/oraInventory

Inst_group=oinstall

Enter the following command to set the appropriate owner, group, and permissions on the oraInst.loc file:

Chown oracle:oinstall / etc/oraInst.loc

Chmod 664 / etc/oraInst.loc

1.1.1.3 start installation

Silent script:

. / 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

Command line mode performs silent installation, note that no more carriage returns can be added when copying the script, and no other content can be executed in the current window. No spaces after "\". The execution is a little slow at first, and I have already marked it with the background where I need to modify it. If there are other errors, you can use the-debug mode to get more information.

Second, configToolAllCommands script about this part can refer to: http://blog.itpub.net/26736162/viewspace-2129161/. After the script is executed, a single instance container database with the sid of-MGMTDB,gdbName createDatabase _ mgmtdb is created (the relevant command can be found in the log: / 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) the database belongs to grid users.

/ u01/app/12.1.0/grid/cfgtoollogs/configToolAllCommands RESPONSE_FILE=/home/grid/cfgrsp.properties

According to the official documentation, installing GRID can be configured with the following information:

Oracle.assistants.asm | S_ASMPASSWORD=password

Oracle.assistants.asm | S_ASMMONITORPASSWORD=password

Oracle.crs | S_BMCPASSWORD=password

Executed on node 1 as the grid user (exactly on the node on which the silent installation is performed, and not on node 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-17005-29-38-PM.log

[grid@raclhr-12cR1-N1 admin] $

[grid@raclhr-12cR1-N1 admin] $

1.1.2 Silent installation of database first checks the environment configuration with the following command:

/ soft/grid/runcluvfy.sh stage-pre dbinst-n raclhr-12cR1-N1,raclhr-12cR1-N2-verbose-fixup

1.1.2.1 silently install the DB software. / 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

Command line mode performs silent installation, note that no more carriage returns can be added when copying the script, and no other content can be executed in the current window. No spaces after "\". The execution is a little slow at first, and I have already marked it with the background where I need to modify it. If there are other errors, you can use the-debug mode to get more information.

[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-17009-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-17009-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-170938-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=

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).

Node 1 and node 2 perform root.sh in turn:

[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-17022-18-12.log for the output of root script

[root@raclhr-12cR1-N1 ~] #

1.2 create disk groups create DATA and FRA disk groups:

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 silently builds a library 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 other configuration 1.4.1 sqlplus prompt settings edit $ORACLE_HOME/sqlplus/admin/glogin.sql

Set linesize 9999 pagesize 9999

Set sqlprompt "_ USER'@'_CONNECT_IDENTIFIER >"

Thank you for reading this article carefully. I hope the article "how to silently install Oracle 12cR1 RAC on VMware Workstation" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and follow the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.