Oracle Database 11g Release 2 Real Application Clusters with SLVM/RAW on HP-UX Installation Cookbook, September 2010

ManualsBrandsHP ManualsSoftwareHP Serviceguard Extension for RAC (SGeRAC)

###########################################

# Shared Server

###########################################

#dispatchers=" ( PROTOCOL = TCP ) ( SERVICE = slvmdbXDB )"

_no_recovery_through_resetlogs=true

slvmdb1.instance_number=1

slvmdb2.instance_number=2

slvmdb2.thread=2

slvmdb1.thread=1

slvmdb2.undo_tablespace=UNDOTBS2

slvmdb1.undo_tablespace=UNDOTBS1

27 Export Oracle SID with Database instance name and include Oracle HOME bin dir in PATH.

bike$ ORACLE_SID=slvmdb1

bike$ export ORACLE_SID

bike$ PATH=$ORACLE_HOME/bin:$PATH;

bike$ export PATH

Add following entry in /etc/oratab.

slvmdb:/var/opt/oracle/rac_r2:Y

28 Connect to sql through following command.

sqlplus ‘ / as sysdba’

You will get sql prompt now. Execute following commands.

• ACCEPT sysPassword CHAR PROMPT 'Enter new password for SYS: ' HIDE

• ACCEPT systemPassword CHAR PROMPT 'Enter new password for SYSTEM: ' HIDE

• ACCEPT sysmanPassword CHAR PROMPT 'Enter new password for SYSMAN: ' HIDE

• ACCEPT dbsnmpPassword CHAR PROMPT 'Enter new password for DBSNMP: ' HIDE

• host /var/opt/oracle/rac_r2/bin/orapwd file=/var/opt/oracle/rac_r2/dbs/orapwslvmdb1

force=y

• host /var/opt/oracle/rac_r2/bin/srvctl add database -d slvmdb -o

/var/opt/oracle/rac_r2 -p /dev/vg_rac/rorcl_spfile_5m -n slvmdb -m ind.hp.com

• host /var/opt/oracle/rac_r2/bin/srvctl add instance -d slvmdb -i slvmdb1 -n bike

• host /var/opt/oracle/rac_r2/bin/srvctl add instance -d slvmdb -i slvmdb2 -n cycle

• host /var/opt/oracle/rac_r2/bin/srvctl disable database -d slvmdb

29 Execute following commands to create clone datafiles and controlfiles.

• SET VERIFY OFF

• connect "SYS"/"&&sysPassword" as SYSDBA

• set echo on

• startup nomount pfile="/var/opt/oracle/admin/slvmdb/scripts/init.ora";

• set verify off;

• set echo off;

• set serveroutput on;

• select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual;

• variable devicename varchar2(255);

• declare omfname varchar2(512) := NULL;

• done boolean;

• begin

dbms_output.put_line(' ');

dbms_output.put_line(' Allocating device.... ');

dbms_output.put_line(' Specifying datafiles... ');

:devicename := dbms_backup_restore.deviceAllocate;

dbms_output.put_line(' Specifing datafiles... ');

dbms_backup_restore.restoreSetDataFile;

dbms_backup_restore.restoreDataFileTo(1,