Friday, December 5, 2008

database vault install.

Just installed DB Vault at a customer site. Had to do 12 reinstalls before we found the cause of the error.

symptom : 10.2.0.4

AUD$ was owned by SYS. This is wrong. In 10.2 AUD$ is owned by SYSTEM and a synonym points to it. [ Yes I know it's all unsupported ]

Theoretically there is no recreate for AUD$, so only supported solution is to export, recreate DB, import, re run vault config [ As If ]

Hacked by obtaining AUD$ DDL from a known good 10.2.0.4 and recreating the table

Database vault then went in without a worry....

So there you are !

Edit : found out later there is something wrong somewhere for this to have been caused.