Call (800) 766-1884 for Oracle support & training
Free Oracle Tips


Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 

HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

 

Donald K. Burleson

Oracle RAC Tips

Oracle Installation

Assuming the raw devices are used, create an ASCII file identifying the raw volume objects on the node from which the Oracle Universal Installer is run. The DBCA requires that these objects exist during installation and database creation. When creating the ASCII file content for the objects, name them using the format:

database_object=raw_device_file_path

When the ASCII file is created, separate the database objects from the paths with equals (=) signs as shown in the example below:

system1=/dev/rdb_name_system_400m

spfile1=/dev/rdb_name_spfile_5m

users1=/dev/rdb_name_users_120m

temp1=/dev/rdb_name_emp_100m

undotbs1=/dev/rdb_name_undotbs1_312m

undotbs2=/dev/rdb_name_undotbs2_312m

example1=/dev/rdb_name_example_160m

cwmlite1=/dev/rdb_name_cwmlite_100m

indx1=/dev/rdb_name_indx_70m

tools1=/dev/rdb_name_tools_12m

drsys1=/dev/rdb_name_drsys_90m

control1=/dev/rdb_name_cntrl1_110m

control2=/dev/rdb_name_cntrl2_110m

redo1_1=/dev/rdb_name_log11_120m

redo1_2=/dev/rdb_name_log12_120m

redo2_1=/dev/rdb_name_log21_120m

redo2_2=/dev/rdb_name_log22_120m

Specify that Oracle use this file to determine the raw device volume names by setting the following environment variable where filename is the name of the ASCII file that contains the entries shown in the example above:

csh:

setenv DBCA_RAW_CONFIG filename

ksh, bash or sh:

DBCA_RAW_CONFIG=filename;

export DBCA_RAW_CONFIG

Add the Oracle User account

An osdba group must be defined in the /etc/group file on all nodes of the cluster. To designate an osdba group name and group number and osoper group during installation, these group names must be identical on all nodes of the UNIX cluster that will be part of the Real Application Clusters database. The default UNIX group name for the osdba and osoper groups is dba. There also needs to be an oinstall group that the software owner should have as its primary group

  1. Use smit group to create groups like dba, oinstall, etc.

  2. Use smit user to create user ‘oracle’. User oracle should be part of the primary group of dba and the secondary group oinstall.

  3. Set the Environment Variables

  4. Set the following Oracle environment variables:

Environment Variable Suggested value

ORACLE_BASE eg /u01/app/oracle

ORACLE_HOME eg /u01/app/oracle/product/901

ORACLE_TERM xterm

NLS_LANG AMERICAN-AMERICA.UTF8 for example

ORA_NLS33 $ORACLE_HOME/ocommon/nls/admin/data

PATH Should contain $ORACLE_HOME/bin

CLASSPATH $ORACLE_HOME/JRE:$ORACLE_HOME/jlib \

$ORACLE_HOME/rdbms/jlib: \

$ORACLE_HOME/network/jlib

For more details, refer to ‘Oracle Installation Guide Release 2 (9.X.X.X.0) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel and Sun SPARC Solaris documentation’.

  1. Run the Oracle installation.

  2. Login as the oracle user and execute the runInstaller:

$ /<Location_Of_Install_Media>/runInstaller

  1. Then proceed with prompts and responses.

 


For more information, see the book Oracle 11g Grid and Real Application Clusters 30% off if you buy it directly from Rampant TechPress . 

Written by top Oracle experts, this RAC book has a complete online code depot with ready to use RAC scripts.  

 


  ”call


Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

  
 

Oracle performance tuning software 
 
 
 
 

Oracle performance tuning book

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 
   

Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.