I have received few e-mails asking for examples of how to install the clusterware and the RAC database using the silent method. In this post I am going to show you how to perform the silent installation of an 11.2.0.2.0 clusterware and RAC database in Linux based system.
The steps below were performed on an RAC one host, composed of one node only, but, the same commands can be performed on N nodes without problems.
1- Prerequisites:
Before clusterware installation, you have to prepare the servers (system, storage, directories, users, groups and network).
You can follow the manual available on:
http://download.oracle.com/docs/cd/E11882_01/install.112/e22489/toc.htm
http://download.oracle.com/docs/cd/E11882_01/install.112/e24660/toc.htm
2- The Cluster Verify Utility:
Run the Cluster Verification Utility (CVU) to check the nodes in preparation for installation. The CVU checks the network connectivity, the hardware and the operating system.
Try to fix all the errors that could be reported by the CVU.
[grid@bcndb01 grid]$ ./runcluvfy.sh stage -pre crsinst -n bcndb01 -verbose > /tmp/runcluvfy.log ... Pre-check for cluster services setup was successful. [grid@bcndb01 grid]$ ./runcluvfy.sh stage -post hwos -n bcndb01 Performing post-checks for hardware and operating system setup Checking node reachability... Node reachability check passed from node "bcndb01" Checking user equivalence... User equivalence check passed for user "grid" Checking node connectivity... Checking hosts config file... Verification of the hosts config file successful Node connectivity passed for subnet "192.168.35.0" with node(s) bcndb01 TCP connectivity check passed for subnet "192.168.35.0" Node connectivity passed for subnet "192.168.32.64" with node(s) bcndb01 TCP connectivity check passed for subnet "192.168.32.64" Node connectivity passed for subnet "192.168.32.0" with node(s) bcndb01 TCP connectivity check passed for subnet "192.168.32.0" Interfaces found on subnet "192.168.35.0" that are likely candidates for VIP are: bcndb01 bond0.35:192.168.35.23 Interfaces found on subnet "192.168.32.64" that are likely candidates for a private interconnect are: bcndb01 bond0.323:192.168.32.65 Interfaces found on subnet "192.168.32.0" that are likely candidates for a private interconnect are: bcndb01 bond0.321:192.168.32.1 Node connectivity check passed Check for multiple users with UID value 0 passed Time zone consistency check passed Checking shared storage accessibility... Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sda bcndb01 /dev/sdx bcndb01 /dev/sdau bcndb01 /dev/sdbr bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdb bcndb01 /dev/sdy bcndb01 /dev/sdav bcndb01 /dev/sdbs bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdc bcndb01 /dev/sdz bcndb01 /dev/sdaw bcndb01 /dev/sdbt bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdd bcndb01 /dev/sdaa bcndb01 /dev/sdax bcndb01 /dev/sdbu bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sde bcndb01 /dev/sdab bcndb01 /dev/sday bcndb01 /dev/sdbv bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdf bcndb01 /dev/sdac bcndb01 /dev/sdaz bcndb01 /dev/sdbw bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdg bcndb01 /dev/sdad bcndb01 /dev/sdba bcndb01 /dev/sdbx bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdh bcndb01 /dev/sdae bcndb01 /dev/sdbb bcndb01 /dev/sdby bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdi bcndb01 /dev/sdaf bcndb01 /dev/sdbc bcndb01 /dev/sdbz bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdj bcndb01 /dev/sdag bcndb01 /dev/sdbd bcndb01 /dev/sdca bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdk bcndb01 /dev/sdah bcndb01 /dev/sdbe bcndb01 /dev/sdcb bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdl bcndb01 /dev/sdai bcndb01 /dev/sdbf bcndb01 /dev/sdcc bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdm bcndb01 /dev/sdaj bcndb01 /dev/sdbg bcndb01 /dev/sdcd bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdn bcndb01 /dev/sdak bcndb01 /dev/sdbh bcndb01 /dev/sdce bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdo bcndb01 /dev/sdal bcndb01 /dev/sdbi bcndb01 /dev/sdcf bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdp bcndb01 /dev/sdam bcndb01 /dev/sdbj bcndb01 /dev/sdcg bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdq bcndb01 /dev/sdan bcndb01 /dev/sdbk bcndb01 /dev/sdch bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdr bcndb01 /dev/sdao bcndb01 /dev/sdbl bcndb01 /dev/sdci bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sds bcndb01 /dev/sdap bcndb01 /dev/sdbm bcndb01 /dev/sdcj bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdt bcndb01 /dev/sdaq bcndb01 /dev/sdbn bcndb01 /dev/sdck bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdu bcndb01 /dev/sdar bcndb01 /dev/sdbo bcndb01 /dev/sdcl bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdv bcndb01 /dev/sdas bcndb01 /dev/sdbp bcndb01 /dev/sdcm bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdw bcndb01 /dev/sdat bcndb01 /dev/sdbq bcndb01 /dev/sdcn bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/mapper/asm_ocrvote01_part1 bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/mapper/asm_ocrvote02_part1 bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/mapper/asm_ocrvote03_part1 bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/mapper/asm_data01_part1 bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/mapper/asm_data02_part1 bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/mapper/asm_data03_part1 bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/mapper/asm_data04_part1 bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/mapper/asm_fra01_part1 bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/mapper/asm_fra02_part1 bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/mapper/asm_fra03_part1 bcndb01 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/mapper/asm_fra04_part1 bcndb01 Shared storage check was successful on nodes "bcndb01" Post-check for hardware and operating system setup was successful. [grid@bcndb01 grid]$
3- Clusterware Silent Installation:
I have attached the response file I have used to install the Oracle clusterware, you can ignore the warnings INS-30011: The password entered does not conform to the Oracle recommended standards. The cause of this warning the password I entered does not contains at least 1 uppercase character.
http://www.oracle-class.com/wp-content/uploads/2012/05/grid-install-rsp.txt
[grid@bcndb01 grid]$ ./runInstaller -silent -responseFile /opt/11gr2Src/grid/grid/response/grid_install.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 1359 MB Passed
Checking swap space: must be greater than 150 MB. Actual 18431 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2012-02-17_01-13-36AM. Please wait ...[grid@bcndb01 grid]$ [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:
/opt/app/oraInventory/logs/installActions2012-02-17_01-13-36AM.log
As a root user, execute the following script(s):
1. /opt/app/oraInventory/orainstRoot.sh
2. /opt/11.2.0/grid/root.sh
As install user, execute the following script to complete the configuration.
1. /opt/11.2.0/grid/cfgtoollogs/configToolAllCommands
Note:
1. This script should be run in the same environment from where the installer has been run.
2. This script needs a small password properties file for configuration assistants that require passwords (refer to install guide documentation).
Successfully Setup Software.
[grid@bcndb01 grid]$
Run the root.sh scripts:
[root@bcndb01 ~]# /opt/app/oraInventory/orainstRoot.sh
Changing permissions of /opt/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /opt/app/oraInventory to oinstall.
The execution of the script is complete.
[root@bcndb01 ~]# /opt/11.2.0/grid/root.sh
Check /opt/11.2.0/grid/install/root_bcndb01.bcn.oracle-class.com_2012-02-17_01-16-15.log for the output of root script
let's check the log file:
[grid@bcndb01 install]$ cat /opt/11.2.0/grid/install/root_bcndb01.bcn.oracle-class.com_2012-02-17_01-16-15.log
Running Oracle 11g root script...
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /opt/11.2.0/grid
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /opt/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
LOCAL ADD MODE
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
OLR initialization - successful
root wallet
root wallet cert
root cert export
peer wallet
profile reader wallet
pa wallet
peer wallet keys
pa wallet keys
peer cert request
pa cert request
peer cert
pa cert
peer root cert TP
profile reader root cert TP
pa root cert TP
peer pa cert TP
pa peer cert TP
profile reader pa cert TP
profile reader peer cert TP
peer user cert
pa user cert
Adding daemon to inittab
ACFS-9200: Supported
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.
CRS-2672: Attempting to start 'ora.mdnsd' on 'bcndb01'
CRS-2676: Start of 'ora.mdnsd' on 'bcndb01' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'bcndb01'
CRS-2676: Start of 'ora.gpnpd' on 'bcndb01' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'bcndb01'
CRS-2672: Attempting to start 'ora.gipcd' on 'bcndb01'
CRS-2676: Start of 'ora.cssdmonitor' on 'bcndb01' succeeded
CRS-2676: Start of 'ora.gipcd' on 'bcndb01' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'bcndb01'
CRS-2672: Attempting to start 'ora.diskmon' on 'bcndb01'
CRS-2676: Start of 'ora.diskmon' on 'bcndb01' succeeded
CRS-2676: Start of 'ora.cssd' on 'bcndb01' succeeded
ASM created and started successfully.
Disk Group OCRVOTE created successfully.
clscfg: -install mode specified
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4256: Updating the profile
Successful addition of voting disk 30ee89a99bd94f2fbf3f322009e05d9b.
Successful addition of voting disk 2fd1b38cd3764f8abf38a41b9bd17c0e.
Successful addition of voting disk 1c0f1f6625884f98bf804cf334a615b7.
Successfully replaced voting disk group with +OCRVOTE.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 30ee89a99bd94f2fbf3f322009e05d9b (/dev/mapper/asm_ocrvote01_part1p1) [OCRVOTE]
2. ONLINE 2fd1b38cd3764f8abf38a41b9bd17c0e (/dev/mapper/asm_ocrvote02_part1p1) [OCRVOTE]
3. ONLINE 1c0f1f6625884f98bf804cf334a615b7 (/dev/mapper/asm_ocrvote03_part1p1) [OCRVOTE]
Located 3 voting disk(s).
CRS-2672: Attempting to start 'ora.asm' on 'bcndb01'
CRS-2676: Start of 'ora.asm' on 'bcndb01' succeeded
CRS-2672: Attempting to start 'ora.OCRVOTE.dg' on 'bcndb01'
CRS-2676: Start of 'ora.OCRVOTE.dg' on 'bcndb01' succeeded
ACFS-9200: Supported
ACFS-9200: Supported
CRS-2672: Attempting to start 'ora.registry.acfs' on 'bcndb01'
CRS-2676: Start of 'ora.registry.acfs' on 'bcndb01' succeeded
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
[grid@bcndb01 install]$
All looks good so far, the OCR Voting disk diskgroup was created successfully. ASM instance started successfully.
Once finish the root.sh at last node . Check:
1. $GRID_HOME/bin/crsctl stat res –t
2. $GRID_HOME/bin/crsctl stat res -t -init
3. $GRID_HOME/bin/crsctl check cluster -all
[grid@bcndb01 install]$ crsctl status res -t --------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.OCRVOTE.dg
ONLINE ONLINE bcndb01
ora.asm
ONLINE ONLINE bcndb01 Started
ora.gsd
OFFLINE OFFLINE bcndb01
ora.net1.network
ONLINE ONLINE bcndb01
ora.ons
ONLINE ONLINE bcndb01
ora.registry.acfs
ONLINE ONLINE bcndb01
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE bcndb01
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE bcndb01
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE bcndb01
ora.cvu
1 ONLINE ONLINE bcndb01
ora.oc4j
1 ONLINE ONLINE bcndb01
ora.scan1.vip
1 ONLINE ONLINE bcndb01
ora.scan2.vip
1 ONLINE ONLINE bcndb01
ora.scan3.vip
1 ONLINE ONLINE bcndb01
ora.bcndb01.vip
1 ONLINE ONLINE bcndb01
[grid@bcndb01 install]$
All should return positive results, all resources shoud be ONLINE except the gsd resources.
There is NO need to run /opt/11.2.0/grid/cfgtoollogs/configToolAllCommands on ALL nodes, You just need to execute it on node1, where the OUI started.
After running root.sh on all nodes, back to node1, as grid user, follow these steps:
To run configuration assistants with the configToolAllCommands script:
1. Create a response file using the syntax filename.properties. For example:
$ touch cfgrsp.properties
2. Open the file with a text editor, and cut and paste the password template, modifying as needed.
As per oracle documentation; http://download.oracle.com/docs/cd/E11882_01/install.112/e24660/scripts.htm, section Example B-1 Password response file for Oracle Real Application Clusters
[grid@bcndb01 ~]$ cat /opt/11.2.0/grid/cfgtoollogs/cfgrsp.properties oracle.assistants.server|S_SYSPASSWORD=wissempwd1 oracle.assistants.server|S_SYSTEMPASSWORD=wissempwd1 oracle.assistants.server|S_SYSMANPASSWORD=wissempwd1 oracle.assistants.server|S_DBSNMPPASSWORD=wissempwd1 oracle.assistants.server|S_HOSTUSERPASSWORD=wissempwd1 oracle.assistants.server|S_ASMSNMPPASSWORD=wissempwd1 [root@srvdb01 patch3]#
Change permissions to secure the file. For example:
[grid@bcndb01 ~]$ chmod 600 cfgrsp.properties
Change directory to /opt/11.2.0/grid/cfgtoollogs
Run the configuration script using the following syntax as the grid user:
[grid@bcndb01 ~]$ /opt/11.2.0/grid/cfgtoollogs/configToolAllCommands RESPONSE_FILE=/home/grid/cfgrsp.properties Setting the invPtrLoc to /opt/11.2.0/grid/oraInst.loc perform - mode is starting for action: configure perform - mode finished for action: configure You can see the log file: /opt/11.2.0/grid/cfgtoollogs/oui/configActions2012-02-17_01-35-51-AM.log [grid@bcndb01 ~]$
Check if configToolRunAllcmds ran successfully, check the generated log file ;
[grid@bcndb01 ~]$ cat /opt/11.2.0/grid/cfgtoollogs/oui/configActions2012-02-17_01-35-51-AM.log
Aggregate oracle.assistants.server not found
###################################################
The action configuration is performing
------------------------------------------------------
The plug-in Update Inventory is running
/opt/11.2.0/grid/oui/bin/runInstaller -nowait -noconsole -waitforcompletion -ignoreSysPrereqs -updateNodeList -silent CRS=true "CLUSTER_NODES={bcndb01}" ORACLE_HOME=/opt/11.2.0/grid
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 18431 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /opt/app/oraInventory
The plug-in Update Inventory has successfully been performed
------------------------------------------------------
------------------------------------------------------
The plug-in Oracle Net Configuration Assistant is running
Parsing command line arguments:
Parameter "orahome" = /opt/11.2.0/grid
Parameter "orahnam" = Ora11g_gridinfrahome1
Parameter "instype" = typical
Parameter "inscomp" = client,oraclenet,javavm,server
Parameter "insprtcl" = tcp
Parameter "cfg" = local
Parameter "authadp" = NO_VALUE
Parameter "responsefile" = /opt/11.2.0/grid/network/install/netca_typ.rsp
Parameter "silent" = true
Parameter "silent" = true
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
bcndb01...
Oracle Net Listener Startup:
Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
The plug-in Oracle Net Configuration Assistant has successfully been performed
------------------------------------------------------
------------------------------------------------------
The plug-in Automatic Storage Management Configuration Assistant is running
The plug-in Automatic Storage Management Configuration Assistant has failed its perform method
------------------------------------------------------
The action configuration has failed its perform method
###################################################
[grid@bcndb01 ~]$
[grid@bcndb01 ~]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): bcndb01
[grid@bcndb01 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE bcndb01
ora.OCRVOTE.dg
ONLINE ONLINE bcndb01
ora.asm
ONLINE ONLINE bcndb01 Started
ora.gsd
OFFLINE OFFLINE bcndb01
ora.net1.network
ONLINE ONLINE bcndb01
ora.ons
ONLINE ONLINE bcndb01
ora.registry.acfs
ONLINE ONLINE bcndb01
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE bcndb01
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE bcndb01
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE bcndb01
ora.cvu
1 ONLINE ONLINE bcndb01
ora.oc4j
1 ONLINE ONLINE bcndb01
ora.scan1.vip
1 ONLINE ONLINE bcndb01
ora.scan2.vip
1 ONLINE ONLINE bcndb01
ora.scan3.vip
1 ONLINE ONLINE bcndb01
ora.bcndb01.vip
1 ONLINE ONLINE bcndb01
[grid@bcndb01 ~]$
4- Perform diskgroup creation using asmca utility:
5- Database Software Silent installation:
I have attached the response file I used to install the software silently.
http://www.oracle-class.com/wp-content/uploads/2012/05/db-install-rsp.txt
Run the installer.
[oracle@bcndb01 database]$ ./runInstaller -silent -responseFile /opt/11gr2Src/oracle/database/response/db_install.rsp -invPtrLoc /etc/oraInst.loc
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 1358 MB Passed
Checking swap space: must be greater than 150 MB. Actual 18431 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2012-02-17_01-52-03AM. Please wait ...
You can find the log of this install session at:
/opt/app/oraInventory/logs/installActions2012-02-17_01-52-03AM.log
As a root user, execute the following script(s):
1. /opt/app/oracle/product/11.2.0/db_1/root.sh
Successfully Setup Software.
[oracle@bcndb01 database]$
Execute the root.sh on the nodes.
[root@bcndb01 ~]# /opt/app/oracle/product/11.2.0/db_1/root.sh
Check /opt/app/oracle/product/11.2.0/db_1/install/root_bcndb01.bcn.oracle-class.com_2012-02-17_02-02-22.log for the output of root script
[root@bcndb01 ~]# cat /opt/app/oracle/product/11.2.0/db_1/install/root_bcndb01.bcn.oracle-class.com_2012-02-17_02-02-22.log
Running Oracle 11g root script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /opt/app/oracle/product/11.2.0/db_1
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
[root@bcndb01 ~]#
[oracle@bcndb01 database]$ cat /opt/app/oraInventory/ContentsXML/inventory.xml
11.2.0.2.0
2.1.0.6.0
[oracle@bcndb01 database]$
6- RAC database installation using templates:
If you already have a RAC database installed and you want to use it as a template. You can run the dbca tool and create the XML template. Use the dbca with the silent option to create your new RAC database by providing the new global database name and System Identifier like I did below:
[oracle@bcndb01 templates]$ nohup time dbca -silent -nodelist bcndb01 -createDatabase -templateName "$ORACLE_HOME/assistants/dbca/templates/wiss_template.dbt" -gdbName bcndb1 -sid bcndb1 -SysPassword wissempwd1 -SystemPassword wissempwd1 -emConfiguration NONE -storageType ASM -asmSysPassword wissempwd1 -diskGroupName ORADATA -nationalCharacterSet "AL16UTF16" -characterSet "AL32UTF8" nohup: appending output to `nohup.out' [oracle@bcndb01 templates]$
Check the nohup.out file:
[oracle@bcndb01 templates]$ cat nohup.out Creating and starting Oracle instance 1% complete 4% complete Creating database files 5% complete 6% complete 7% complete 8% complete 9% complete Creating data dictionary views 10% complete 12% complete 13% complete 14% complete 15% complete 16% complete 17% complete 18% complete 21% complete 22% complete 23% complete 24% complete 25% complete Adding Oracle JVM 32% complete 39% complete 46% complete 49% complete Adding Oracle XML DB 50% complete 51% complete 52% complete 53% complete 58% complete Adding Oracle Multimedia 60% complete 72% complete Adding Enterprise Manager Repository 73% complete 75% complete 77% complete Creating cluster database views 78% complete 87% complete Completing Database Creation 88% complete 90% complete 94% complete 98% complete 100% complete Look at the log file "/opt/app/oracle/cfgtoollogs/dbca/bcndb1/bcndb10.log" for further details. 42.46user 3.15system 26:00.72elapsed 2%CPU (0avgtext+0avgdata 691744maxresident)k 0inputs+0outputs (9major+296865minor)pagefaults 0swaps [oracle@bcndb01 templates]$
Check the log file:
[oracle@bcndb01 templates]$ cat /opt/app/oracle/cfgtoollogs/dbca/bcndb1/bcndb10.log Creating and starting Oracle instance DBCA_PROGRESS : 1% DBCA_PROGRESS : 4% Creating database files DBCA_PROGRESS : 5% DBCA_PROGRESS : 6% DBCA_PROGRESS : 7% DBCA_PROGRESS : 8% DBCA_PROGRESS : 9% Creating data dictionary views DBCA_PROGRESS : 10% DBCA_PROGRESS : 12% DBCA_PROGRESS : 13% DBCA_PROGRESS : 14% DBCA_PROGRESS : 15% DBCA_PROGRESS : 16% DBCA_PROGRESS : 17% DBCA_PROGRESS : 18% DBCA_PROGRESS : 21% DBCA_PROGRESS : 22% DBCA_PROGRESS : 23% DBCA_PROGRESS : 24% DBCA_PROGRESS : 25% Adding Oracle JVM DBCA_PROGRESS : 32% DBCA_PROGRESS : 39% DBCA_PROGRESS : 46% DBCA_PROGRESS : 49% Adding Oracle XML DB DBCA_PROGRESS : 50% DBCA_PROGRESS : 51% DBCA_PROGRESS : 52% DBCA_PROGRESS : 53% DBCA_PROGRESS : 58% Adding Oracle Multimedia DBCA_PROGRESS : 60% DBCA_PROGRESS : 72% Adding Enterprise Manager Repository DBCA_PROGRESS : 73% DBCA_PROGRESS : 75% DBCA_PROGRESS : 77% Creating cluster database views DBCA_PROGRESS : 78% DBCA_PROGRESS : 87% Completing Database Creation DBCA_PROGRESS : 88% DBCA_PROGRESS : 90% DBCA_PROGRESS : 94% DBCA_PROGRESS : 98% DBCA_PROGRESS : 100% Database creation complete. For details check the logfiles at: /opt/app/oracle/cfgtoollogs/dbca/bcndb1. Database Information: Global Database Name:bcndb1 System Identifier(SID) Prefix:bcndb1 [oracle@bcndb01 templates]$ [oracle@bcndb01 ~]$ ps -edf | grep pmon grid 9021 1 0 Apr27 ? 00:00:25 asm_pmon_+ASM1 oracle 10342 1 0 Apr27 ? 00:00:52 ora_pmon_bcndb11 oracle 20246 12275 0 11:45 pts/0 00:00:00 grep pmon [oracle@bcndb01 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Mon May 14 11:45:45 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Real Application Clusters and Automatic Storage Management options SQL>
Hope it helps!
Wissem
Blog's RSS Feed
Loading ...