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

34 Execute following commands to lock account.

• SET VERIFY OFF

• set echo on

• BEGIN

FOR item IN ( SELECT USERNAME FROM DBA_USERS WHERE ACCOUNT_STATUS

IN ('OPEN', 'LOCKED', 'EXPIRED') AND USERNAME

NOT IN ('SYS','SYSTEM') )

LOOP

dbms_output.put_line('Locking and Expiring: ' || item.USERNAME);

execute immediate 'alter user ' ||

sys.dbms_assert.enquote_name(

sys.dbms_assert.schema_name(

item.USERNAME),false) || ' password expire account lock' ;

END LOOP;

END;

35 Execute following commands for Post Database creation steps.

• SET VERIFY OFF

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

• set echo on

• select 'utl_recomp_begin: ' || to_char(sysdate, 'HH:MI:SS') from dual;

• execute utl_recomp.recomp_serial();

• select 'utl_recomp_end: ' || to_char(sysdate, 'HH:MI:SS') from dual;

• execute dbms_swrf_internal.cleanup_database(cleanup_local => FALSE);

• commit;

• shutdown immediate;

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

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

• alter database archivelog;

• alter database open;

• select group# from v$log where group# =3;

• select group# from v$log where group# =4;

• ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 3

('/dev/vg_rac/rorcl_redo2_1_128m') SIZE 51200K,

• GROUP 4 ('/dev/vg_rac/rorcl_redo2_2_128m') SIZE 51200K;

• ALTER DATABASE ENABLE PUBLIC THREAD 2;

• host echo cluster_database=true >>/var/opt/oracle/admin/slvmdb/scripts/init.ora;

• host echo remote_listener=auto-cluster-

scan:1521>>/var/opt/oracle/admin/slvmdb/scripts/init.ora;

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

• set echo on

• create spfile='/dev/vg_rac/rorcl_spfile_raw_5m' FROM

pfile='/var/opt/oracle/admin/slvmdb/scripts/init.ora';

• shutdown immediate;

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

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

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