Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Sunday, 9 September 2012

Setup and Configuration of Oracle 9i RAC

Database: Oracle 9i
Environment: Windows 2000
Oracle 9i Enterprise Edition, RAC pre-configured Database or Create New Database
Additional Redo logs (for operating clustered database).
Clusterware (OS dependent),
Oracle Universal Installer (OUI)
1.      Install the operating system-dependent (OSD) Clusterware.
2.      Configure the shared disk if you are not using cluster file system (CFS). If your system support CSF and do not want to use raw devices then proceed to next step.
3.      Run the OUI to install the Oracle 9i Enterprises Edition and the Oracle9i Real Application Clusters software.
4.      Create or Configure your Database either through DBCA or Manually.
Hardware/Software/File System:
The Hardware and Software requirement is as per to handle the RAC database. For more details if you need must check Installation guide and the file system must be automated file system that controls the use of files within Oracle. Oracle Managed Files requires a clustered file system.
Note: 32-bit instances cannot share the same 9.0.1 database with 64-bit instances.
Oracle 9i Enterprise Edition
The Oracle 9i Enterprise Edition, which is required for Real Application Clusters, provides single instance database software and additional component to operate RAC database. Some of the Component includes:
  • OSD Clusterware
  • RAC enable ORACLE-HOME
  • SRVM for RAC
Install (OSD) Clusterware
The OSD Clusterware controls the operating systems and Clusterware services required for RAC. It has two component Cluster Manager and Inter process Communication (IPC) software.
The Cluster Manager monitors the state of all nodes and broadcasts information about the nodes throughout the cluster. This includes information about which nodes are active or inactive members of the cluster where as the IPC layer controls messaging functions so the nodes can communicate with each other through the interconnect.
Note: The OSD Clusterware installation process varies according to platform. Check the installation guide for Windows. For UNIX your Vendor provide the OSD Clusterware. For SUNClusters Oracle Provides a UDLM patch that you must install to each node in the Cluster from the /racpatch directory before installing  and configuring RAC
Configure the Shared Disk/Raw Device:
As all instances in RAC environment share the controlfiles, spfiles and each datafiles. These files reside on shared disk that are accessed by multiple nodes and each instance has its own discrete set of redo log files that also reside on shared disks thus during failures this shared redo log files allows instance to perform recovery for failed instances.
You must create at least one shared raw device as an information repository for the database server configuration. The Enterprise Manager (EM) uses this device called (SVRM) to perform RAC specific operations.
You must create shared raw device for SVRM:
  • If this installation is the first Oracle9i Server installation on your cluster.
  • To migrate from a pre-release 1 (9.0.1) Oracle9i Real Application Clusters
  • database to Oracle9i Release 2 (9.2)
  • To manually create your database
OEM, DBCA, SRVCTL utility and other management tools use this raw device to store configuration information about: RAC database instances, The node that each instances run, ORACLE-HOME within which database run, SPFILE for each Cluster database.
Note: The configuration process for raw devices depend on your OS: On UNIX, the OUI prompts you for the name of this shared file and On Windows NT and Windows 2000, Label this raw partition as srvcfg by creating an Object Link Manager (OLM) symbolic link to a raw partition that is at least 100MB in size. For Example: db_name_system for system tablespace, db_name_redo_thread_number for redolog files and db_name_spfile for spefile
Additional Raw Devices Required by the DBCA
Use the DBCA to configure additional raw devices if you plan to use the DBCA to create your database. Plan your partition before installing the oracle software, The DBCA cannot create RAC database unless you have properly configured these devices. Create partition as to support your database and leave some spare partition for future expansion.
Datafiles (As per the number of datafiles)
Controlfiles (At Least)
Automatic Undo Management or Rollback segment (for each instance)
Redo logfiles (At least for each instance)
Spfile (Recommended)
Oracle 9i Intermedia

Note: Datafiles, control files, and redo log files must reside on unformatted raw devices on Windows NT and Windows 2000 platforms.
Using OUI to Install Oracle 9i Enterprise Edition and the RAC Software
1.      Before running the OUI, from the node where you intended to run the Installer, verify that you have administrative privileges on the other nodes.
2.      In windows directly run the installer and wait for the Node selection page where as in UNIX you have to set following environment variable:
setenv SRVM_SHARED_CONFIG shared_filename
Where shared_filename is the name of the configuration raw device file. If you are using a cluster file system, then make sure the partition on which this file resides has least 100MB of free space.
setenv DBCA_RAW_CONFIG filename
If this is the first installation on your cluster and you have not set the environment variable, then the Installer prompts you for the name of the 100MB file by displaying the Shared Configuration File Name page.
Note: If this is the first installation on your cluster and you have not set the environment variable, then the Installer prompts you for the name of the 100MB file by displaying the Shared Configuration File Name page.
3.      Select the nodes to include as part of your Real Application Clusters database. Click Next. The Installer displays the File Locations page.
Note that the local node is always selected even though it may not be highlighted on the Node Selection page.
4.      On the File Locations page in the Path field under the Destination heading, enter the name of the Oracle home into which you are going to install the Oracle Enterprise Edition and Real Application Clusters software. Click Next. The Installer displays the Available Products page.
5.      On the Available Products page, select Oracle9i and click Next. The Installer displays the Install Types page.
6.      On the Install Types page, select Enterprise Edition and click Next. The Installer displays the Database Configuration page.
7.      On the database configuration page either you can proceed with “Pre-Configured Database or Create New Database” or “Customized Database or Manual Creation” Option. If you go with first option then after you complete the following steps DBCA verify that you correctly configured the shared disks for each tablespace and automatically create a starter database and configure the network service too. If you select the Customized configuration, then you must enter specific information. To manually configure your environment, select Software Only. Oracle Corp. strongly recommends you use one of pre-configured database option or use the New Database option and the DBCA. The pre-configured template include datafiles and specially configured option for each environment. However, the New Database template does not include datafiles or the specially configured options.
i.         When you proceed with Pre-Configured Database Option then select either of any option: General Purpose, Transaction Processing or Data warehouse or Create a New Database.
ii.       The Installer displays the Upgrading or Migrating an Existing Database page if it discovers an Oracle database installation on the node on which it is running. Click Next.
iii.      Enter Global database name. This is a name that comprises the database name and database domain, such as SADHAN.WORLD. Accept or change the common prefix for the oracle SID for each instance.
iv.     The Installer displays the Database Character Set page. Select characters set and click Next.
v.       The Installer displays a summary page. Review the components to be installed and click Install to begin the installation.
i.         When you wish to proceed with “Customized Database” Option then select Customized and move next.
ii.       If you have not already set the raw device environment variable and if this is the first Oracle installation on this cluster, then the Installer displays the Shared Configuration File Name page. Enter the name of a raw device that is at least 100MB in size, or a cluster file system file and click Next.
iii.      If the Installer detects a pre-existing Oracle database, then the Installer displays the Upgrading or Migrating an Existing Database page. Click Next.
iv.     On the database identification page you must enter the global database name and click Next.
v.       On the database character set page, select a character set and click Next.
vi.     Finally Review the Summary page and click Install to begin installation.

After installing, the OUI invokes the post-installation configuration tools such as the Cluster Configuration Assistant (ClustCA), Net Configuration Assistant (NetCA), and the DBCA to set up and configure your Real Application Clusters database. If you do not create a database during installation then you can create on later using DBCA in standalone mode. To do this without cluster file system, you must have configure each row device as described earlier, you must have run the oracle Net Configuration to configure your listener or you can configure manually, The Global service Daemon (GSD) must be running on each node in your cluster before you create the database in standalone mode.


  1. Quantum Binary Signals

    Get professional trading signals sent to your cell phone every day.

    Follow our signals NOW and earn up to 270% a day.

  2. BlueHost is definitely the best hosting provider for any hosting services you need.