Tuesday, February 24, 2009

Workarounds when installing Database Vault on 10.2.0.3 RAC

1. create user SYSMAN (to avoid ORA-29504: invalid or missing schema name when running DVSYS.AUTHORIZE_EVENT )

create user sysman identified by password default tablespace users temporary tablespace temp;

2. install Database Vault 10.2.0.3. The wizard will fail to run dvca due to srvctl not understanding "sys/password as sysdba". (Actual error in the log is PRKO-2002 : Invalid command line option: AS) Exit at this point.

cd datavault_10203/Disk1
./runInstaller

3. use Opatch to install patch 7175473 to reenable "connect / as sysdba" (relink on second node may fail - if so then re-run manually)

cd 7175473
opatch apply

4. copy catmacc.sql back from the 7175473 patch storage area. This script is called from catmac.sql, and if it does not exist then we will get "table or view does not exist" errors.

cp .patch_storage/7175473_Sep_15_2008_08_20_45/backup/rdbms/admin/catmacc.sql $ORACLE_HOME/rdbms/admin/

5. manually run dvca

dvca -action option -oh /opt/oracle/product/10.2.0/db_1 -s_path /tmp -logfile dvca_install.log -owner_account dvowner -owner_passwd password -jdbc_str jdbc:oracle:oci:@tl01cfd1 -sys_passwd password -lockout -nodecrypt -silent