Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Sunday, February 05, 2012

Create the database - RAC 11g

Run ASMCA to create diskgroups
Prior to creating a database on the cluster, the ASM diskgroups that will house the database must be created.
In an earlier chapter, the ASM disks for the database diskgroups were stamped for ASM usage. We will now

use the ASM Configuration Assistant to create the diskgroups:
Run the ASM Configuration Assistant (ASMCA) from the ASM Home by executing the following:
cmd> %GI_HOME%\bin\asmca

After launching ASMCA, click the DiskGroups tab.

While on the DiskGroups? tab, click the Create button to display the Create DiskGroup window.
NOTE: To reduce the complexity of managing ASM and its diskgroups, Oracle recommends that generally
no more than two diskgroups be maintained for database storage, a Database Area DiskGroup? and a Flash
Recovery Area DiskGroup . The Database Area Diskgroup will house active database files such as datafiles,
control files, online redo logs, and change tracking files (used in incremental backups) are stored. The Flash
Recovery Area will house recovery-related files are created, such as multiplexed copies of the current control
file and online redo logs, archived redo logs, backup sets, and flashback log files

Within the Create DiskGroup window perform the following:
  • Enter the desired DiskGroup Name (e.g. DBDATA or DBFLASH)
  • Choose External Redundancy (assuming redundancy is provided at the SAN level).
  • Select the candidate disks to include in the DiskGroup
 Click OK to create the ¨ DiskGroup


Repeat the previous two steps to create all necessary diskgroups.
Once all the necessary DiskGroups have been created click Exit to exit from ASMCA.

Note:
It is Oracle's Best Practise to have an OCR mirror stored in a second disk group. To follow this
recommendation add an OCR mirror. Mind that you can only have one OCR in a diskgroup.
Action:

1. To add OCR mirror to an Oracle ASM disk group, ensure that the Oracle Clusterware stack is running and run the following command as administrator:
2. D:\OraGrid\BIN>ocrconfig -add +DBFLASH
3. D:\OraGrid\BIN>ocrcheck -config

Run DBCA to create the database
To help to verify that the system is prepared to successfully create a RAC database, use the following Cluster
Verification Utility command syntax:
cmd> runcluvfy stage -pre dbcfg -n all -d c:\app\11.2.0\grid -verbose

cluvfy stage -pre dbcfg -n all -d D:\app\11.2.0\grid -verbose > c:\temp\dbcfg.txt

Performing pre-checks for database configuration

Checking node reachability...

Check: Node reachability from node "OR-11"
  Destination Node                      Reachable?             
  ------------------------------------  ------------------------
  or-12                         yes                    
  or-11                         yes                    
Result: Node reachability check passed from node "OR-11"


Checking user equivalence...

Check: User equivalence for user "Inam"
  Node Name                             Comment                
  ------------------------------------  ------------------------
  or-12                         passed                 
  or-11                         passed                 
Result: User equivalence check passed for user "Inam"

Checking node connectivity...


Interface information for node "or-12"
 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU  
 ------ --------------- --------------- --------------- --------------- ----------------- ------
 public 192.168.26.12   192.168.26.0    On-link         UNKNOWN         00:1A:A0:34:91:0A 1500 
 public 192.168.26.14   192.168.26.0    On-link         UNKNOWN         00:1A:A0:34:91:0A 1500 
 public 192.168.26.66   192.168.26.0    On-link         UNKNOWN         00:1A:A0:34:91:0A 1500 
 private 10.11.11.2      10.11.11.0      On-link         UNKNOWN         00:1A:A0:34:91:0C 1500 


Interface information for node "or-11"
 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU  
 ------ --------------- --------------- --------------- --------------- ----------------- ------
 public 192.168.26.11   192.168.26.0    On-link         UNKNOWN         00:1D:09:0C:B4:CD 1500 
 public 192.168.26.13   192.168.26.0    On-link         UNKNOWN         00:1D:09:0C:B4:CD 1500 
 public 192.168.26.64   192.168.26.0    On-link         UNKNOWN         00:1D:09:0C:B4:CD 1500 
 public 192.168.26.65   192.168.26.0    On-link         UNKNOWN         00:1D:09:0C:B4:CD 1500 
 private 10.11.11.1      10.11.11.0      On-link         UNKNOWN         00:1D:09:0C:B4:CF 1500 


Check: Node connectivity for interface "public"
  Source                          Destination                     Connected?     
  ------------------------------  ------------------------------  ----------------
  or-12[192.168.26.12]    or-12[192.168.26.14]    yes            
  or-12[192.168.26.12]    or-12[192.168.26.66]    yes            
  or-12[192.168.26.12]    or-11[192.168.26.11]    yes            
  or-12[192.168.26.12]    or-11[192.168.26.13]    yes            
  or-12[192.168.26.12]    or-11[192.168.26.64]    yes            
  or-12[192.168.26.12]    or-11[192.168.26.65]    yes            
  or-12[192.168.26.14]    or-12[192.168.26.66]    yes            
  or-12[192.168.26.14]    or-11[192.168.26.11]    yes            
  or-12[192.168.26.14]    or-11[192.168.26.13]    yes            
  or-12[192.168.26.14]    or-11[192.168.26.64]    yes            
  or-12[192.168.26.14]    or-11[192.168.26.65]    yes            
  or-12[192.168.26.66]    or-11[192.168.26.11]    yes            
  or-12[192.168.26.66]    or-11[192.168.26.13]    yes            
  or-12[192.168.26.66]    or-11[192.168.26.64]    yes            
  or-12[192.168.26.66]    or-11[192.168.26.65]    yes            
  or-11[192.168.26.11]    or-11[192.168.26.13]    yes            
  or-11[192.168.26.11]    or-11[192.168.26.64]    yes            
  or-11[192.168.26.11]    or-11[192.168.26.65]    yes            
  or-11[192.168.26.13]    or-11[192.168.26.64]    yes            
  or-11[192.168.26.13]    or-11[192.168.26.65]    yes            
  or-11[192.168.26.64]    or-11[192.168.26.65]    yes            
Result: Node connectivity passed for interface "public"

Check: Node connectivity for interface "private"
  Source                          Destination                     Connected?     
  ------------------------------  ------------------------------  ----------------
  or-12[10.11.11.2]       or-11[10.11.11.1]       yes            
Result: Node connectivity passed for interface "private"

Result: Node connectivity check passed


Check: Total memory
  Node Name     Available                 Required                  Comment  
  ------------  ------------------------  ------------------------  ----------
  or-12  15.9951GB (1.6772032E7KB)  922MB (944128.0KB)        passed   
  or-11  15.9951GB (1.6772032E7KB)  922MB (944128.0KB)        passed   
Result: Total memory check passed

Check: Available memory
  Node Name     Available                 Required                  Comment  
  ------------  ------------------------  ------------------------  ----------
  or-12  13.4504GB (1.4103796E7KB)  50MB (51200.0KB)          passed   
  or-11  13.1159GB (1.3752996E7KB)  50MB (51200.0KB)          passed   
Result: Available memory check passed

Check: Swap space
  Node Name     Available                 Required                  Comment  
  ------------  ------------------------  ------------------------  ----------
  or-12  31.9883GB (3.3542216E7KB)  15.9951GB (1.6772032E7KB)  passed   
  or-11  31.9883GB (3.3542216E7KB)  15.9951GB (1.6772032E7KB)  passed   
Result: Swap space check passed

Check: Free disk space for "or-12:D:\app\11.2.0\grid"
  Path              Node Name     Mount point   Available     Required      Comment    
  ----------------  ------------  ------------  ------------  ------------  ------------
  D:\app\11.2.0\grid  or-12  D             552.7979GB    3.4GB         passed     
Result: Free disk space check passed for "or-12:D:\app\11.2.0\grid"

Check: Free disk space for "or-11:D:\app\11.2.0\grid"
  Path              Node Name     Mount point   Available     Required      Comment    
  ----------------  ------------  ------------  ------------  ------------  ------------
  D:\app\11.2.0\grid  or-11  D             534.7236GB    3.4GB         passed     
Result: Free disk space check passed for "or-11:D:\app\11.2.0\grid"

Check: Free disk space for "or-12:C:\Windows\temp"
  Path              Node Name     Mount point   Available     Required      Comment    
  ----------------  ------------  ------------  ------------  ------------  ------------
  C:\Windows\temp   or-12  C             35.8696GB     500MB         passed     
Result: Free disk space check passed for "or-12:C:\Windows\temp"

Check: Free disk space for "or-11:C:\Windows\temp"
  Path              Node Name     Mount point   Available     Required      Comment    
  ----------------  ------------  ------------  ------------  ------------  ------------
  C:\Windows\temp   or-11  C             42.3473GB     500MB         passed     
Result: Free disk space check passed for "or-11:C:\Windows\temp"

Check: System architecture
  Node Name     Available                 Required                  Comment  
  ------------  ------------------------  ------------------------  ----------
  or-12  64-bit                    64-bit                    passed   
  or-11  64-bit                    64-bit                    passed   
Result: System architecture check passed

Checking length of value of environment variable "PATH"
Check: Length of value of environment variable "PATH"
  Node Name         Set?          Maximum Length  Actual Length  Comment        
  ----------------  ------------  ------------  ------------  ----------------
  or-12     yes           1023          399           passed         
  or-11     yes           1023          368           passed         
Result: Check for length of value of environment variable "PATH" passed.

Checking for Media Sensing status of TCP/IP
  Node Name     Enabled?                  Comment                
  ------------  ------------------------  ------------------------
  or-12  no                        passed                 
  or-11  no                        passed                 
Result: Media Sensing status of TCP/IP check passed

Checking CRS integrity...
The Oracle Clusterware is healthy on node "or-12"
The Oracle Clusterware is healthy on node "or-11"

CRS integrity check passed

Checking node application existence...

Checking existence of VIP node application (required)
  Node Name     Required                  Running?                  Comment  
  ------------  ------------------------  ------------------------  ----------
  or-12  yes                       yes                       passed   
  or-11  yes                       yes                       passed   
VIP node application check passed

Checking existence of NETWORK node application (required)
  Node Name     Required                  Running?                  Comment  
  ------------  ------------------------  ------------------------  ----------
  or-12  yes                       yes                       passed   
  or-11  yes                       yes                       passed   
NETWORK node application check passed

Checking existence of GSD node application (optional)
  Node Name     Required                  Running?                  Comment  
  ------------  ------------------------  ------------------------  ----------
  or-12  no                        no                        exists   
  or-11  no                        no                        exists   
GSD node application is offline on nodes "cl-or-12,or-11"

Checking existence of ONS node application (optional)
  Node Name     Required                  Running?                  Comment  
  ------------  ------------------------  ------------------------  ----------
  or-12  no                        yes                       passed   
  or-11  no                        yes                       passed   
ONS node application check passed

Check: Time zone consistency
Result: Time zone consistency check passed

Pre-check for database configuration was successful.

Perform the following to create an 11gR2 RAC database on the cluster:
Run the Database Configuration Assistant (DBCA) from the ASM Home by executing the following:
cmd> %ORACLE_HOME\bin\dbca
On the Welcome screen, select Oracle Real Application Clusters and click Next


On the Operation screen, select Create Database and click Next

The Database Templates screen will now be displayed. Select the General Purpose or Transaction
Processing database template and click Next to continue.

On the Database Identification screen perform the following:
  • Select the Admin Managed configuration type.
  • Enter the desired Global Database Name.
  • Enter the desired SID prefix.
  • Select ALL the nodes in the cluster.
  • Click Next to continue.
 On the Management Options screen, choose Configure Enterprise Manager. Once Grid Control
has been installed on the system this option may be unselected to allow the database to be managed by
Grid Control. Click Next to continue.


 Enter the appropriate database credentials for the default user accounts and click Next to continue.

 On the Database File Locations screen perform the following:
Choose Automatic Storage Management (ASM).
  • Select Use Oracle-Managed Files and specify the ASM Disk Group that will house the
    database files (e.g. +DBDATA)
  • Click Next and enter the ASMSNMP password when prompted.
  • Click OK after entering the ASMSNMP password to continue.

    For the Recovery Configuration, select Specify Flash Recovery Area, enter +DBFLASH for the location and choose an appropriate size. It is also recommended to select Enable Archiving at this point. Click Next to continue.


    On the Database Content screen, you are able create the sample schemas. Check the check box if the
    sample schemas are to be loaded into the database and click Next to continue.


     Enter the desired memory configuration and initialization parameters on the Initialization Parameters
    screen and click Next to continue.


    On the Database Storage screen, review the file layout and click Next to continue.
    NOTE: At this point you may want to increase the number of redo logs per thread to 3 and increase the size
    of the logs from the default of 50MB.

    On the Last screen, ensure that Create Database is checked and click Finish to review the summary of the pending database creation.







    1 comment:

    Zini said...

    Hi,

    I am facing a problem while I am trying to add one more node into existing two node oracle 11g R2 on Windows 2008 enterprise 64 bit with SP1.

    I build the racnode3 on same platform as similar as existing two node RAC is running and the third node has been passed all the pre requisites for the RAC installation. after getting successful pre requisites check I run the addnode.bat for adding another node into two node existing running RAC then I OUI is not running in GUI mode, it runs for short while in command line interface but OUI GUI interface is not coming. then I try to find the causes in log file at C:\Program Files\Oracle\Inventory\logs\addNodeActions2013-05-17_01-16-25AM.log . And the same thing is happening with addnode -silent mode.



    Log file Content is -------------------------------------------------

    INFO: Environment Variables:

    INFO: ORACLE_HOME =

    INFO: PATH = C:\app\Administrator\product\11.2.0\dbhome_1\bin;C:\app\11.2.0\grid\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\

    INFO: CLASSPATH =

    INFO: Username:Administrator

    INFO: Install area Control created with access level 1

    INFO: Oracle Universal Installer version is 11.2.0.1.0

    INFO: Setting variable 'ORACLE_HOME' to 'C:\app\11.2.0\grid'. Received the value from the command line.
    INFO: Setting variable 'PREREQ_CONFIG_LOCATION' to ''. Received the value from variable association.
    INFO: Setting variable 'FROM_LOCATION' to 'C:\app\11.2.0\grid/inventory/ContentsXML/comps.xml'. Received the value from a code block.
    INFO: Setting variable 'ROOTSH_LOCATION' to 'C:\app\11.2.0\grid/root.sh'. Received the value from a code block.
    INFO: Setting variable 'ROOTSH_STATUS' to '3'. Received the value from a code block.
    SEVERE: Abnormal program termination. An internal error has occured. Please provide the following files to Oracle Support :

    "C:\Program Files\Oracle\Inventory\logs\addNodeActions2013-05-17_01-16-25AM.log"
    "Unknown"
    "Unknown"
    INFO: User Selected: Yes/OK

    Log file Content --------------------------------------------------------



    Kindly help me to over come from this problem. I would be thankful to you