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

LOGFILE GROUP 1 ('/dev/vg_rac/rorcl_redo1_1_128m') SIZE 51200K,

GROUP 2 ('/dev/vg_rac/rorcl_redo1_2_128m') SIZE 51200K RESETLOGS;

• alter system enable restricted session;

• alter database "slvmdb" open resetlogs;

• exec dbms_service.delete_service('seeddata');

• exec dbms_service.delete_service('seeddataXDB');

• alter database rename global_name to "slvmdb.ind.hp.com";

• ALTER TABLESPACE TEMP ADD TEMPFILE '/dev/vg_rac/rorcl_temp_256m'

• SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED;

• select tablespace_name from dba_tablespaces where tablespace_name='USERS';

• alter system disable restricted session;

• connect "SYS"/" shutdown immediate;

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

• startup restrict

• pfile="/var/opt/oracle/admin/slvmdb/scripts/initslvmdbTemp.ora";

• select sid, program, serial#, username from v$session;

• alter database character set INTERNAL_CONVERT WE8MSWIN1252;

• alter database national character set INTERNAL_CONVERT AL16UTF16;

• alter user sys account unlock identified by "&&sysPassword";

• alter user system account unlock identified by "&&systemPassword";

• alter system disable restricted session;&&sysPassword" as SYSDBA

31 Execute post script commands.

• SET VERIFY OFF

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

• set echo on

• @/var/opt/oracle/rac_r2/rdbms/admin/dbmssml.sql;

• execute dbms_datapump_utl.replace_default_dir;

• commit;

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

• alter session set current_schema=ORDSYS;

• @/var/opt/oracle/rac_r2/ord/im/admin/ordlib.sql;

• alter session set current_schema=SYS;

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

• execute ORACLE_OCM.MGMT_CONFIG_UTL.create_replace_dir_obj;

• CREATE UNDO TABLESPACE "UNDOTBS2" DATAFILE '/dev/vg_rac/rorcl_undotbs2_512m' SIZE

25600K REUSE AUTOEXTEND ON MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;

32 Execute following commands to create Cluster DB views.

• SET VERIFY OFF

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

• set echo on

• @/var/opt/oracle/rac_r2/rdbms/admin/catclust.sql;

33 Execute following commands to update SPFILE info.

• host echo "SPFILE='/dev/vg_rac/rorcl_spfile_raw_5m'"

• /var/opt/oracle/rac_r2/dbs/initslvmdb1.ora