Installation and Configuration of Oracle 10g RAC Database Cluster with Error/Bug Fix

[milind]

14) If you don't face above BUG window will ask for Virtual IP else You can manually execute /u01/app/oracle/product/10.2.0/clust/bin/vipca. Welcome Screen will appear; press Next

15) Network Interfaces: Select all the Network Interfaces and Press Next

16) Virtual IP for Cluster Node: Mention Virtual IP, IP Alias Name, IP address of all the clustered nodes and Press next to continue.

17) Summary: It will show the summary of VIP configuration. Press Finish to complete VIP Configuration.

18) Once everything done, return to Oracle Cluster installation windows (following) Press OK:

19) Configure Assistants: Please allow sometime for configuration assistance to configure post installation configurations.

20) Oracle Cluster Installation has been completed.

[milind]

1) Login as oracle user (connect to VNC if you are doing remote installation). Then go to database directory (Where CLuster and database software were downloaded) and execute "./runinstaller"

cd /u02/10gR2/database
./runInstaller

2) Welcome Screen: Press Next to continue

3) Select Installation Type: Select "Enterprise Edition" and Press Next.

4) Specify Home Details: Set Name and keep the path as it is (as we have mentioned that path while Setting User Profile)

5) Specify Hardware Cluster Installation Mode: Select "Cluster Installation" and then select all clustered nodes. Press Next

6) Product-Specification Prerequisite Check: Oracle will scan your system and check for Prerequisites. Press Next once its complete.

7) Select Database Configuration Option: Select "Install Database Software Only" and press Next

8) Summary: It will show the summary of database installation. Press Install

9) Once Installation gets completed following window will appear asking execute following command from root user on all clustered nodes

/u01/app/oracle/product/10.2.0/db_1/root.sh

10) End of Installation: Once you run above command Press OK and it will show End of Installation window. Press Exit to complete installation.

[milind]

1) Login to Node1 as Oracle user and execute following command on shell.

[oracle@rac2 ~]$ dbca

2) Welcome: Select "Oracle Real Application Cluster Database" and press Next

3) Operations: "Create Database" >> Press Next

4) Node Selection: Select all the Listed nodes and press Next.

5) Database templates: Select "Cluster Database" >> Next.

6) Database Identification: Enter RAC.anything like we have used RAC.ESDS and prefix as RAC. Press Next.

7) Management Options: If you want to configure Enterprise Manager to manage Oracle you can configure it here else just press Next.

8) Database Credentials: Enter Password and press Next.

9) Storage Option: Select "Cluster File System" and then press Next

Continue in Next Post

[milind]

Continue From Above

10) Database File Locations: Select "Use Oracle-Managed Files" option and enter "/u01/oradata/" as the database location, then click the "Next" button.

11) Recovery Configuration: Check "Specify Flash Recovery Area" option and keep all other settings as it is and then click on Next.

12) Database Content: Un-check all except "Enterprise Manager Repository" option, then click the "Standard Database Components..." button.

On Standard Database Components uncheck all but the "Oracle JVM" option, then click the "OK" button, followed by the "Next" button

13) Database Services: Keep the default Settings and hit Next Button.

14) Initialization Parameters: Click "Custom" and Press Next with automatic configuration.

15) Database Storage: Keep the default Settings and hit Next.

16) Creation Options: Select "Create Database" and press Finish

Continue in Next Post

[milind]

Continue From Above

17) Summary: Complete Summary of configuration.

18) Now Configuration of Database Assistance will start.

19) Once it get complete you will get following screen. Press Exit to finish.

[milind]

The srvctl utility shows the current configuration and status of the RAC database. Login as oracle user and execute following command to check the current configuration of RAC.

[oracle@rac2 ~]$srvctl config database -d RAC

BUG FIX:- While Executing srvctl you might get following error

[oracle@rac2 ~]$srvctl config database -d RAC
/u01/app/oracle/product/10.2.0/db_1/jdk/jre/bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory

To fix this bug open and edit following files

/u01/app/oracle/product/clust/bin/srvctl
/u01/app/oracle/product/10.2.0/db_1/bin/srvctl

add following (Red colored):

#Remove this workaround when the bug 3937317 is fixed
LD_ASSUME_KERNEL=2.4.19
export LD_ASSUME_KERNEL
unset LD_ASSUME_KERNEL

Now Execute following commands to check the current configuration and status of the RAC database

[oracle@rac1 ~]$ srvctl config database -d RAC
rac1 RAC1 /u01/app/oracle/product/10.2.0/db_1
rac2 RAC2 /u01/app/oracle/product/10.2.0/db_1
[oracle@rac1 ~]$ srvctl status database -d RAC
Instance RAC1 is running on node rac1
Instance RAC2 is running on node rac2

The V$ACTIVE_INSTANCES view can also display the current status of the instances.

[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 14 02:04:11 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SELECT * FROM v$active_instances;

INST_NUMBER INST_NAME
----------- ------------------------------------------------------------
1 rac1.esds.co.in:RAC1
2 rac2.esds.co.in:RAC2

SQL>

If you get above results !!! Congratulations !!! you have successfully installed Oracle 10g R2 RAC (Database Cluster).

[Vish]

Bravo Really nice and informative post

[chinmay]

Yes, it is. Very well documented Thanks Milind

[rishikesh]

Very good work Milind.
Really nice documentation of Oracle 10g.

[Prajakta]

Very descriptive.
Thanks for the info