Oracle10g R2 Installing RAC(11)

ora....c01.vip application    ONLINE    ONLINE    sles101
ora....02.lsnr application    ONLINE    ONLINE    sles102
ora....c02.gsd application    ONLINE    ONLINE    sles102
ora....c02.ons application    ONLINE    ONLINE    sles102
ora....c02.vip application    ONLINE    ONLINE    sles102

------------------------------------------------------------------------
Create ASM Storage disk group
------------------------------------------------------------------------
After Oracle 10g R2 database software is installed, the ASM storage disk groups are needed to be created before creating an RAC database.
Use "dbca" configuration assistance to manage the ASM diskgroups.
[oracle@sles101 /u01/app/oracle/product/10.2/db_1/bin]
$ dbca &
● Database Configuration Assistance：Welcome
Select "Oracle Real Application Cluster database"
Click [Next]
● Database Configuration Assistance, Step 1 of 4: Operations
Select "Configuring Automatic Storage Management"
● Database Configuration Assistance, Step 2 of 4: Node selection
Select both nodes
Click [Next]
● Database Configuration Assistance, Step 3 of 4: ASM disk groups
Select "Create new" to create new disk groups
Enter password for user "sys" to access the ASM management tool (this password is needed later when you want to create or configure ASM diskgroup), and select "Create Initialization Parameter file(IFILE)" for the "Initialization Parameter filename", use default value {ORACLE_BASE}/admin/+ASM/pfile/init.ora. (You can not create "Server Parameter file SPFILE" because it has to be on a shared disk, there is no shared disk ready to use at this example.)

Click "ASM Parameters" and input '/u02/oradata/asm/*' for "diskstring" in order for the ASM configuration program to find out the ASM disks (You can also configure this later.)

Click [Next], you will get prompt "DBCA will now create and start the ASM instance. After the ASM instance is started, you can create disk groups to use as storage for your database."

Click [OK] to continue.

● Database Configuration Assistance, ASM disk groups
There is no available ASM diskgroup by default, so click [Create New] to create new disk groups.

● Create disk group
Select disk path [/u02/oradata/asm/lun1, lun2, lun3], enter Disk Group Name, [DATA_1], and select 'External' for Redundancy.
Click [OK] to start creation of the first disk group DATA_1.

If you can not see any disks showing as CANDIDATES, select "Change Disk Discovery Path" and enter '/u02/oradata/asm/*' or any other disk path you prepared before run "dbca".

In this example, 2 diskgroups are created - DATA_1(lun1,lun2,lun3) and FLASH_RECOVERY_AREA (lun4)
Click [Finish] to exit, and continue the following steps to create new database.

-------------------------------------------------------------------------------
Database Configuration Assistance： Creating new database
-------------------------------------------------------------------------------
1.Run dbca again on sles101 as user 'oracle'
[oracle@sles101 /u01/app/oracle/product/10.2/db_1/bin]

www.ixdba.net

$dbca &
● Welcome：
Select Oracle Real Application Clusters database
Click［Next]
● Step 1 of 17: Opetations：
Select Create a Database
Click［Next]
● Step 2 of 17: Node Selection：
Select both nodes
Click［Next]
● Step 3 of 17: Database Templates：
Select General Purpose
Click［Next］
● Step 4 of 17: Database Identification：
Global Database Name: sles
SID Prefix: sles
Click［Next]
● Step 5 of 16: Management Options：
Use default,
Selctc Configure the Database with Enterprise Manager
Select Use Database Control for Database Management
Click［Next］
● Step 6 of 16: Database Credentials：
Select Use the Same Password for All Accounts
Enter Password
Click［Next]
● Step 7 of 15: Storage Options：
Select ASM
Click［Next］

Then you will be asked for "ASM Credentials", enter the password specified when you create the ASM instance. Click OK.

● Step 8 of 15: ASM DIsk Groups：
Select the disk group on that you want to install the database.
Click [OK]

● Step 9 of 15: Database File Locations：
Select Use Oracle-Managed Files
Database Area: +DATA_1, or browse to any other disk group for the "Database Area"
Meanwhile, you can also click "Multiplex Redo Logs and Control Files" to specify multiple locations spread across different disks to provide greater fault tolerance.
Click ［Next］

● Step 10 of 15: Recovery Configuration：
Select Specify Flash Recovery Area
Flash Recovery Area: +FLASH_RECOVERY_AREA
Flash Recovery Area Size: 2048 MB

Select "Enable Archiving" and specify archiving location or use default.
Click ［Next］

● Step 11 of 15: Database Content：
Use default, or select "Sample schema"
Click ［Next］
● Step 12 of 15 Database Services：
Click ［Add］， Enter RACTEST
sles1: Preferred
sles2: Preferred
TAF Policy： Basic
Click ［Next］
● Step 13 of 15: Initialization Parameters：
Memory Tab:
Use default - "Typical" - Allocate memory as a percentage of the total physical memory (1008MB) - 40%
Sizing: 150 processes by default
Character Sets: use default
Connection Mode: use default - Dediated Server Mode

Click ［Next］
● Step 14 of 15: Database Storage：
Use default
Click ［Next］
● Step 15 of 15: Create Options：
Select "Create Database"
Click ［Finish］ to start creating the database.

You can also select "Generate Databse Creation scrīpts" and save the scrīpts in directory "/u01/app/oracle/admin/<ORACLE_SID>scrīpts"

-------------------------------------------------------------------------------
Now finished all steps to create Oracle 10g R2 RAC database on SuSE10.1
-------------------------------------------------------------------------------

The "crs_stat" command will show all RAC resources (ASM instances, listeners, databases, gsd, ons) started and online on both RAC nodes.

[oracle@sles101 /u01/app/oracle/product/10.2/crs_1/bin]
$ ./crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    sles101
ora....01.lsnr application    ONLINE    ONLINE    sles101
ora....101.gsd application    ONLINE    ONLINE    sles101
ora....101.ons application    ONLINE    ONLINE    sles101
ora....101.vip application    ONLINE    ONLINE    sles101
ora....SM2.asm application    ONLINE    ONLINE    sles102
ora....02.lsnr application    ONLINE    ONLINE    sles102
ora....102.gsd application    ONLINE    ONLINE    sles102
ora....102.ons application    ONLINE    ONLINE    sles102
ora....102.vip application    ONLINE    ONLINE    sles102
ora.sles.db    application    ONLINE    ONLINE    sles101
ora....s1.inst application    ONLINE    ONLINE    sles101
ora....s2.inst application    ONLINE    ONLINE    sles102

[oracle@sles101 /u01/app/oracle/product/10.2/crs_1/bin]