Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Create Oracle RAC and Oracle RAC ONE Node Database using dbca in Oracle 11g R2 (11.2.0.2)

Create Oracle RAC and Oracle RAC ONE Node Database using dbca in Oracle 11g R2 (11.2.0.2)
  

In this article we will look at creating Oracle RAC and RAC ONE Node database using dbca. For install/upgrade to Oracle 11.2.0.2 look here.
  

Create Oracle RAC ONE Node database using dbca
  

Start dbca and select Oracle RAC One Node database and press Next to continue.
  


  

Select ‘Create a Database’ and press Next to continue.
  


  

Select Custom Database and press Next to continue.
  


  

Select Admin-Managed, enter database global name, SID prefix and service name and press Next to continue. DBCA will create one database with one instance which can be migrated across the nodes selected.
  


  

Enter and confirm the password(s) and press Next to continue.
  


  

Specify storage type and storage location and press Next to continue.
  


  

Specify the Fast recovery area (formerly flash recovery area) and press Next to continue.
  


  

Select the database components and component location and press Next to continue.
  


  

Select the init parameters. In this case use AMM is selected and the memory size is specified. Press Next to continue.
  


  

Keep the defaults and press Next to continue.
  


  

Select the options for dbca to generate a template and generation scripts and press Next to continue.
  


  

Review the summary and press OK to continue.
  


  

Wait for the dbca to complete.
  


  

Optionally choose the password management to change the passwords and unlock the accounts and once done press Exit to exit from dbca.
  


  

Create Oracle RAC database using dbca
  

Start dbca and select Oracle RAC database and press Next to continue.
  


  

Select ‘Create a Database’ and press Next to continue.
  


  

Select General Purpose or Transaction Processing Database and press Next to continue.
  


  

Select Admin-Managed, enter database global name, SID prefix and press Next to continue. DBCA will create one database with two instances on each node respectively.
  


  

Select Configure Enterprise Manager and select Automatic Maintenance Tasks Tab.
  


  

Select Enable automatic maintenance tasks and press Next to continue.
  


  

Enter and confirm the password(s) and press Next to continue.
  


  

Specify storage type and storage location and press Next to continue.
  


  

Specify the Fast recovery area (formerly flash recovery area) and press Next to continue.
  


  

Select the database components and component location and press Next to continue.
  


  

Select the init parameters. In this case use AMM is selected and the memory size is specified. Press Next to continue.
  


  

Keep the defaults and press Next to continue.
  


  

Select the options for dbca to generate a template and generation scripts and press Next to continue.
  


  

Review the summary and press OK to continue.
  


  

Wait for the dbca to complete.
  


  

Wait for the dbca to complete.
  


  

Wait for the dbca to complete. Optionally choose the password management to change the passwords and unlock the accounts and once done press Exit to exit from dbca.
  


  

Verify RACDB installation
  

 

 [oracle@raclinux1 ~]$ srvctl status database -d RACDB
 

Instance RACDB1 is not running on node raclinux1
 

Instance RACDB2 is not running on node raclinux2
 

[oracle@raclinux1 ~]$ srvctl start database -d RACDB
 

[oracle@raclinux1 ~]$ srvctl status database -d RACDB
 

Instance RACDB1 is running on node raclinux1
 

Instance RACDB2 is running on node raclinux2
 

[oracle@raclinux1 ~]$ srvctl config database -d RACDB
 

Database unique name: RACDB
 

Database name: RACDB
 

Oracle home: /u01/app/oracle/product/11.2.0/db_10
 

Oracle user: oracle
 

Spfile: +DGDUP/RACDB/spfileRACDB.ora
 

Domain:
 

Start options: open
 

Stop options: immediate
 

Database role: PRIMARY
 

Management policy: AUTOMATIC
 

Server pools: RACDB
 

Database instances: RACDB1,RACDB2
 

Disk Groups: DGDUP,DATA
 

Mount point paths:
 

Services:
 

Type: RAC
 

Database is administrator managed
 

[oracle@raclinux1 ~]$
 

 
 

[oracle@raclinux1 ~]$ sqlplus system/sys1@racdb
 

 
 

SQL*Plus: Release 11.2.0.2.0 Production on Tue Oct 5 14:26:32 2010
 

 
 

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 Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
 

Data Mining and Real Application Testing options
 

 
 

SQL> select * from gv$instance;
 

 
 

   INST_ID INSTANCE_NUMBER INSTANCE_NAME
 

---------- --------------- ----------------
 

HOST_NAME
 

----------------------------------------------------------------
 

VERSION           STARTUP_T STATUS       PAR    THREAD# ARCHIVE LOG_SWITCH_WAIT
 

----------------- --------- ------------ --- ---------- ------- ---------------
 

LOGINS     SHU DATABASE_STATUS   INSTANCE_ROLE      ACTIVE_ST BLO
 

---------- --- ----------------- ------------------ --------- ---
 

         1               1 RACDB1
 

raclinux1.gj.com
 

11.2.0.2.0        05-OCT-10 OPEN         YES          1 STOPPED
 

ALLOWED    NO  ACTIVE            PRIMARY_INSTANCE   NORMAL    NO
 

 
 

 
 

   INST_ID INSTANCE_NUMBER INSTANCE_NAME
 

---------- --------------- ----------------
 

HOST_NAME
 

----------------------------------------------------------------
 

VERSION           STARTUP_T STATUS       PAR    THREAD# ARCHIVE LOG_SWITCH_WAIT
 

----------------- --------- ------------ --- ---------- ------- ---------------
 

LOGINS     SHU DATABASE_STATUS   INSTANCE_ROLE      ACTIVE_ST BLO
 

---------- --- ----------------- ------------------ --------- ---
 

         2               2 RACDB2
 

raclinux2.gj.com
 

11.2.0.2.0        05-OCT-10 OPEN         YES          2 STOPPED
 

ALLOWED    NO  ACTIVE            PRIMARY_INSTANCE   NORMAL    NO
 

 
 

 
 

SQL>
 

 

 

 

  

   

   

   

   

   

Verify RONE installation
  

   

 

 [oracle@raclinux2 admin]$ srvctl status database -d rone 

Instance RONE_1 is running on node raclinux2 

Online relocation: INACTIVE 

[oracle@raclinux2 admin]$ srvctl config database -d rone 

Database unique name: RONE 

Database name: RONE 

Oracle home: /u01/app/oracle/product/11.2.0/db_20 

Oracle user: oracle 

Spfile: +DATA/RONE/spfileRONE.ora 

Domain: 

Start options: open 

Stop options: immediate 

Database role: PRIMARY 

Management policy: AUTOMATIC 

Server pools: RONE 

Database instances: 

Disk Groups: DATA 

Mount point paths: 

Services: RACONE 

Type: RACOneNode 

Online relocation timeout: 30 

Instance name prefix: RONE 

Candidate servers: raclinux2,raclinux1 

Database is administrator managed 

[oracle@raclinux2 admin]$ 

[oracle@raclinux2 admin]$ sqlplus system/sys1@ronetaf 

SQL*Plus: Release 11.2.0.2.0 Production on Tue Oct 5 14:21:50 2010 

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 Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, 

Data Mining and Real Application Testing options 

SQL> select * from gv$instance; 

   INST_ID INSTANCE_NUMBER INSTANCE_NAME 

---------- --------------- ---------------- 

HOST_NAME 

---------------------------------------------------------------- 

VERSION           STARTUP_T STATUS       PAR    THREAD# ARCHIVE LOG_SWITCH_WAIT 

----------------- --------- ------------ --- ---------- ------- --------------- 

LOGINS     SHU DATABASE_STATUS   INSTANCE_ROLE      ACTIVE_ST BLO 

---------- --- ----------------- ------------------ --------- --- 

         1               1 RONE_1 

raclinux2.gj.com 

11.2.0.2.0        05-OCT-10 OPEN         YES          1 STOPPED 

ALLOWED    NO  ACTIVE            PRIMARY_INSTANCE   NORMAL    NO 

SQL> 

 

 

Summary
  

We looked at creating RAC and RAC ONE Node databases using dbca in Oracle 11gR2 11.2.0.2. We verified that the databases was successfully created. 

October 5, 2010 Posted by | oracle | 5 Comments

Upgrade to Oracle 11.2.0.2 from Oracle 11.2.0.1

Upgrade to Oracle 11.2.0.2 from Oracle 11.2.0.1
   

Starting with the first patch set for Oracle Database 11g Release 2 (11.2.0.2), Oracle Database patch sets are full installations of the Oracle Database software. In past releases, Oracle Database patch sets consisted of a set of files that replaced files in an existing Oracle home. Beginning with Oracle Database 11g Release 2, patch sets are full installations that replace existing installations as per MOS Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2 [ID 1189783.1]
   

In this article we will look at how to upgrade existing Oracle GI and will install new Oracle RDBMS. For information on installing fresh Oracle 11.2.0.2 GI see here.
   

Prerequisites for Oracle 11gR2 11.2.0.2 installation is to install patch 9655006 to the 11.2.0.1 GI home before upgrading to 11.2.0.2 from 11.2.0.1. See Bug 9413827 on MOS.
   

If not patched upon running ./rootupgrade.sh will fail as shown below.
   

    

 
[root@raclinux1 grid]# ./rootupgrade.sh 
Running Oracle 11g root script... 
The following environment variables are set as: 
<p>    ORACLE_OWNER= oracle </p>
    ORACLE_HOME=  /u01/app/11.2.0.2/grid 
Enter the full pathname of the local bin directory: [/usr/local/bin]: 
<p>The contents of &quot;dbhome&quot; have not changed. No need to overwrite. </p>
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
<p>[n]: </p>
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
<p>[n]: </p>
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: /u01/app/11.2.0.2/grid/crs/install/crsconfig_params 
<p>Creating trace directory </p>
<p>Failed to add (property/value):('OLD_OCR_ID/'-1') for checkpoint:ROOTCRS_OLDHOMEINFO.Error code is 256 </p>
The fixes for bug 9413827 are not present in the 11.2.0.1 crs home 
Apply the patches for these bugs in the 11.2.0.1 crs home and then run rootupgrade.sh 
/u01/app/11.2.0.2/grid/perl/bin/perl -I/u01/app/11.2.0.2/grid/perl/lib -I/u01/app/11.2.0.2/grid/crs/install /u01/app/11.2.0.2/grid/crs/install/rootcrs.pl execution failed 
[root@raclinux1 grid]# 
<strong>

   

    

    

Patching 11.2.0.1 to 9655006
   

  1. Download and unzip latest OPatch utility with patch number 6880880 in $GI_HOME
  2. Download and unzip patch 9655006 in a stage directory in my case in /u01/stage. This will create two directories 9655006 and 9654983.
  3. Invoke OPatch from $GI_HOME/OPatch as root

    ./opatch auto /u01/stage -och /u01/app/11.2.0/grid
       

  4. Verify patching with opatch lsinventory. See the ANNEX for sample output.
  5. Refer to MOS ‘How to Manually Apply A Grid Infrastructure PSU Without Opatch Auto’ [ID 1210964.1] in case of problems.

        

Patching Oracle GI to 11.2.0.2
   

Create a new directory /u01/app/11.2.0.2/grid for Oracle 11.2.0.2 GI on all nodes.
   

mkdir –p /u01/app/11.2.0.2/grid
   

chmod –R 775 /u01/app/11.2.0.2/
   

chown –R oracle:oinstall /u01/app/11.2.0.2/
   

Download and unzip patch 10098816 into a stage directory in my case /u01/stage/11.2.0.2.
   

Start the installer from /u01/stage/11.2.0.2/grid. Either enter MOS credentials to check for updates or select ‘Skip software updates’. Press Next to continue.
   


   

Select Upgrade Oracle Grid Infrastructure or Oracle ASM and press Next to continue.
   


   

Select the languages and press Next to continue.
   


   

Make sure that all nodes are selected and press Next to continue.
   


   

Keep the defaults and press Next to continue.
   


   

Enter the new location for Oracle GI 11.2.0.2 as /u01/app/11.2.0.2/grid and press Next to continue.
   


   

Wait for the prerequisite checks to complete.
   


   

Review the Summary and press Install to continue.
   


   

Wait for the installation to complete.
   


   


   

Run rootupgrade.sh script first on raclinux1 and after that on raclinux2. Look at the output of the script in the Annex.
   

Wait for the Oracle GI installation to complete.
   

Verify that the GI is upgraded successfully from the new GI home
   

    

    

 [root@raclinux1 bin]# pwd
/u01/app/11.2.0.2/grid/bin
[root@raclinux1 bin]# ./crsctl check cluster -all
**************************************************************
raclinux1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
raclinux2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
[root@raclinux1 bin]#

  

    

Install new Oracle 11.2.0.2 RDBMS binaries
   

Start the installer from /u01/stage/11.2.0.2/database. Press Next to continue.
   


   

Acknowledge that you do not want at present to provide MOS credentials and continue.
   


   

Either enter MOS credentials to check for updates or select ‘Skip software updates’. Press Next to continue.
   


   

Select ‘Install database software only’ and press Next to continue.
   


   

Select Oracle Real Application clusters database installation, select all nodes on the cluster and press Next to continue. We will show in later articles Oracle RAC and RAC ONE node database creation using dbca. Here we are installing only Oracle RDBMS binaries.
   


   

Optionally select the language and press Next to continue.
   


   

Select Enterprise Edition and press Next to continue.
   


   

Select the location for the New Oracle RDBMS home and press Next to continue.
   


   

Chose the defaults and press Next to continue.
   


   

Check the errors and fix them. In this case I select the Ignore All and press Next to continue.
   


   

Verify the Summary and press Install to continue.
   


   

Wait for the installation to complete.
   


   

Press Close upon successful completion.
   


   

In the next posts we will look into creating RAC and RAC ONE Node databases using dbca. If you have an existing database and you want to upgrade it using dbua.
   

Annex
   

Sample opach lsinventory ouput
   

  

 [oracle@raclinux2 OPatch]$ ./opatch lsinventory Invoking OPatch 11.2.0.1.3   Oracle Interim Patch Installer version 11.2.0.1.3 Copyright (c) 2010, Oracle Corporation.  All rights reserved.   Oracle Home       : /u01/app/11.2.0/grid Central Inventory : /u01/app/oraInventory    from           : /etc/oraInst.loc OPatch version    : 11.2.0.1.3 OUI version       : 11.2.0.1.0 OUI location      : /u01/app/11.2.0/grid/oui Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2010-09-23_19-45-20PM.log   Patch history file: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch_history.txt   Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2010-09-23_19-45-20PM.txt   -------------------------------------------------------------------------------- Installed Top-level Products (1):   Oracle Grid Infrastructure                                           11.2.0.1.0 There are 1 products installed in this Oracle Home.   Interim patches (2) :   Patch  9655006      : applied on Thu Sep 23 19:34:31 EDT 2010 Unique Patch ID:  12651761    Created on 6 Jul 2010, 12:00:17 hrs PST8PDT    Bugs fixed:      9655006, 9778840, 9343627, 9783609, 9262748, 9262722   Patch  9654983      : applied on Thu Sep 23 19:20:20 EDT 2010 Unique Patch ID:  12651761    Created on 18 Jun 2010, 00:16:02 hrs PST8PDT    Bugs fixed:      9068088, 9363384, 8865718, 8898852, 8801119, 9054253, 8725286, 8974548      9093300, 8909984, 8755082, 8780372, 8664189, 8769569, 7519406, 8822531      7705591, 8650719, 9637033, 8639114, 8723477, 8729793, 8919682, 8856478      9001453, 8733749, 8565708, 8735201, 8684517, 8870559, 8773383, 8981059      8812705, 9488887, 8813366, 9242411, 8822832, 8897784, 8760714, 8775569      8671349, 8898589, 9714832, 8642202, 9011088, 9170608, 9369797, 9165206      8834636, 8891037, 8431487, 8570322, 8685253, 8872096, 8718952, 8799099      9032717, 9399090, 9546223, 9713537, 8588519, 8783738, 8834425, 9454385      8856497, 8890026, 8721315, 8818175, 8674263, 9145541, 8720447, 9272086      9467635, 9010222, 9197917, 8991997, 8661168, 8803762, 8769239, 9654983      8706590, 8778277, 8815639, 9027691, 9454036, 9454037, 9454038, 9255542      8761974, 9275072, 8496830, 8702892, 8818983, 8475069, 8875671, 9328668      8798317, 8891929, 8774868, 8820324, 8544696, 8702535, 8268775, 9036013      9363145, 8933870, 8405205, 9467727, 8822365, 9676419, 8761260, 8790767      8795418, 8913269, 8717461, 8607693, 8861700, 8330783, 8780281, 8780711      8784929, 9341448, 9015983, 9119194, 8828328, 8665189, 8717031, 8832205      9676420, 8633358, 9321701, 9655013, 8796511, 9167285, 8782971, 8756598      8703064, 9066116, 9007102, 9461782, 9352237, 8505803, 8753903, 9216806      8918433, 9057443, 8790561, 8733225, 9067282, 8928276, 9210925, 8837736       Rac system comprising of multiple nodes   Local node = raclinux2   Remote node = raclinux1   --------------------------------------------------------------------------------   OPatch succeeded. [oracle@raclinux2 OPatch]$       [oracle@raclinux1 OPatch]$ ./opatch lsinventory Invoking OPatch 11.2.0.1.3   Oracle Interim Patch Installer version 11.2.0.1.3 Copyright (c) 2010, Oracle Corporation.  All rights reserved.   Oracle Home       : /u01/app/11.2.0/grid Central Inventory : /u01/app/oraInventory    from           : /etc/oraInst.loc OPatch version    : 11.2.0.1.3 OUI version       : 11.2.0.1.0 OUI location      : /u01/app/11.2.0/grid/oui Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2010-09-23_19-41-01PM.log   Patch history file: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch_history.txt   Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2010-09-23_19-41-01PM.txt   -------------------------------------------------------------------------------- Installed Top-level Products (1):   Oracle Grid Infrastructure                                           11.2.0.1.0 There are 1 products installed in this Oracle Home.   Interim patches (2) :   Patch  9655006      : applied on Thu Sep 23 19:39:38 EDT 2010 Unique Patch ID:  12651761    Created on 6 Jul 2010, 12:00:17 hrs PST8PDT    Bugs fixed:      9655006, 9778840, 9343627, 9783609, 9262748, 9262722   Patch  9654983      : applied on Thu Sep 23 19:20:43 EDT 2010 Unique Patch ID:  12651761    Created on 18 Jun 2010, 00:16:02 hrs PST8PDT    Bugs fixed:      9068088, 9363384, 8865718, 8898852, 8801119, 9054253, 8725286, 8974548      9093300, 8909984, 8755082, 8780372, 8664189, 8769569, 7519406, 8822531      7705591, 8650719, 9637033, 8639114, 8723477, 8729793, 8919682, 8856478      9001453, 8733749, 8565708, 8735201, 8684517, 8870559, 8773383, 8981059      8812705, 9488887, 8813366, 9242411, 8822832, 8897784, 8760714, 8775569      8671349, 8898589, 9714832, 8642202, 9011088, 9170608, 9369797, 9165206      8834636, 8891037, 8431487, 8570322, 8685253, 8872096, 8718952, 8799099      9032717, 9399090, 9546223, 9713537, 8588519, 8783738, 8834425, 9454385      8856497, 8890026, 8721315, 8818175, 8674263, 9145541, 8720447, 9272086      9467635, 9010222, 9197917, 8991997, 8661168, 8803762, 8769239, 9654983      8706590, 8778277, 8815639, 9027691, 9454036, 9454037, 9454038, 9255542      8761974, 9275072, 8496830, 8702892, 8818983, 8475069, 8875671, 9328668      8798317, 8891929, 8774868, 8820324, 8544696, 8702535, 8268775, 9036013      9363145, 8933870, 8405205, 9467727, 8822365, 9676419, 8761260, 8790767      8795418, 8913269, 8717461, 8607693, 8861700, 8330783, 8780281, 8780711      8784929, 9341448, 9015983, 9119194, 8828328, 8665189, 8717031, 8832205      9676420, 8633358, 9321701, 9655013, 8796511, 9167285, 8782971, 8756598      8703064, 9066116, 9007102, 9461782, 9352237, 8505803, 8753903, 9216806      8918433, 9057443, 8790561, 8733225, 9067282, 8928276, 9210925, 8837736       Rac system comprising of multiple nodes   Local node = raclinux1   Remote node = raclinux2   --------------------------------------------------------------------------------   OPatch succeeded. [oracle@raclinux1 OPatch]$   Output of running rootupgrade.sh on raclinux1   [root@raclinux1 grid]# ./rootupgrade.sh Running Oracle 11g root script...   The following environment variables are set as:     ORACLE_OWNER= oracle     ORACLE_HOME=  /u01/app/11.2.0.2/grid   Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) [n]: y    Copying oraenv to /usr/local/bin ... The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) [n]: y    Copying coraenv to /usr/local/bin ...   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: /u01/app/11.2.0.2/grid/crs/install/crsconfig_params Creating trace directory Failed to add (property/value):('OLD_OCR_ID/'-1') for checkpoint:ROOTCRS_OLDHOMEINFO.Error code is 256   ASM upgrade has started on first node.   CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'raclinux1' CRS-2673: Attempting to stop 'ora.crsd' on 'raclinux1' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'raclinux1' CRS-2673: Attempting to stop 'ora.DATA.dg' on 'raclinux1' CRS-2673: Attempting to stop 'ora.registry.acfs' on 'raclinux1' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'raclinux1' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'raclinux1' CRS-2677: Stop of 'ora.DATA.dg' on 'raclinux1' succeeded CRS-2677: Stop of 'ora.registry.acfs' on 'raclinux1' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'raclinux1' CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'raclinux1' succeeded CRS-2673: Attempting to stop 'ora.scan1.vip' on 'raclinux1' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'raclinux1' succeeded CRS-2673: Attempting to stop 'ora.raclinux1.vip' on 'raclinux1' CRS-2677: Stop of 'ora.scan1.vip' on 'raclinux1' succeeded CRS-2672: Attempting to start 'ora.scan1.vip' on 'raclinux2' CRS-2677: Stop of 'ora.asm' on 'raclinux1' succeeded CRS-2677: Stop of 'ora.raclinux1.vip' on 'raclinux1' succeeded CRS-2672: Attempting to start 'ora.raclinux1.vip' on 'raclinux2' CRS-2676: Start of 'ora.scan1.vip' on 'raclinux2' succeeded CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'raclinux2' CRS-2676: Start of 'ora.raclinux1.vip' on 'raclinux2' succeeded CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'raclinux2' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'raclinux1' CRS-2673: Attempting to stop 'ora.eons' on 'raclinux1' CRS-2677: Stop of 'ora.ons' on 'raclinux1' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'raclinux1' CRS-2677: Stop of 'ora.net1.network' on 'raclinux1' succeeded CRS-2677: Stop of 'ora.eons' on 'raclinux1' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'raclinux1' has completed CRS-2677: Stop of 'ora.crsd' on 'raclinux1' succeeded CRS-2673: Attempting to stop 'ora.mdnsd' on 'raclinux1' CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'raclinux1' CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'raclinux1' CRS-2673: Attempting to stop 'ora.ctssd' on 'raclinux1' CRS-2673: Attempting to stop 'ora.evmd' on 'raclinux1' CRS-2673: Attempting to stop 'ora.asm' on 'raclinux1' CRS-2677: Stop of 'ora.cssdmonitor' on 'raclinux1' succeeded CRS-2677: Stop of 'ora.evmd' on 'raclinux1' succeeded CRS-2677: Stop of 'ora.mdnsd' on 'raclinux1' succeeded CRS-2677: Stop of 'ora.ctssd' on 'raclinux1' succeeded CRS-2677: Stop of 'ora.drivers.acfs' on 'raclinux1' succeeded CRS-2677: Stop of 'ora.asm' on 'raclinux1' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'raclinux1' CRS-2677: Stop of 'ora.cssd' on 'raclinux1' succeeded CRS-2673: Attempting to stop 'ora.gpnpd' on 'raclinux1' CRS-2673: Attempting to stop 'ora.diskmon' on 'raclinux1' CRS-2677: Stop of 'ora.gpnpd' on 'raclinux1' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'raclinux1' CRS-2677: Stop of 'ora.diskmon' on 'raclinux1' succeeded CRS-2677: Stop of 'ora.gipcd' on 'raclinux1' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'raclinux1' has completed CRS-4133: Oracle High Availability Services has been stopped. Successfully deleted 1 keys from OCR. Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. OLR initialization - successful Adding daemon to inittab ACFS-9200: Supported ACFS-9300: ADVM/ACFS distribution files found. ACFS-9312: Existing ADVM/ACFS installation detected. ACFS-9314: Removing previous ADVM/ACFS installation. ACFS-9315: Previous ADVM/ACFS components successfully removed. 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. clscfg: EXISTING configuration version 5 detected. clscfg: version 5 is 11g Release 2. Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. Configure Oracle Grid Infrastructure for a Cluster ... succeeded [root@raclinux1 grid]#       Output of running rootupgrade.sh on raclinux2.   [root@raclinux2 grid]# ./rootupgrade.sh Running Oracle 11g root script...   The following environment variables are set as:     ORACLE_OWNER= oracle     ORACLE_HOME=  /u01/app/11.2.0.2/grid   Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite.   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: /u01/app/11.2.0.2/grid/crs/install/crsconfig_params clscfg: EXISTING configuration version 5 detected. clscfg: version 5 is 11g Release 2. Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. CRS-1115: Oracle Clusterware has already been upgraded.   ASM upgrade has finished on last node.   Configure Oracle Grid Infrastructure for a Cluster ... succeeded [root@raclinux2 grid]# 

    

 

October 5, 2010 Posted by | oracle | 54 Comments