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 :

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 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.

Wednesday, October 1, 2008

Audit Vault Agent Config Part 1

When running the verifier you are asked to export an env variable = testdba/password

of course it should be


and now avorcldb verify works

otherwise you get a username invalid error. Small typo, but reinforces the "just-out-the-door" thinking behind it .

So you are fed up with Oracle Configuration Manager

This little beastie gets installed when you run opatch now. Most of you have no need whatsoever for it. So let's get rid of it :

Metalink Note 369111.1 has the answer but in True Oracle Fashion they didn't test it properly on all platforms

They did it on Linux, but the answer they give on Windows fails for me [ they wrote up something for Windows in cscript vbs ]

however it works quite nicely if you do

cd %ORACLE_HOME%\ccr\bin

deploypackages -d %ORACLE_HOME%\ccr\inventory\core.jar

And no more OCM.

Installing Audit Vault on Windows 2003 install :

All went well for the initial phase but failed 80% of the way through. The message it complains of is being unable to find or lock ewallet.p12 in the installation log, and you can spend a very long time trying to debug this. In fact it is completely misleading, the actual problem was that I had selected avadmin as the Audit Vault Administrator name, when this comes to run the installer it conflicts much much later with a predefined username; to fix this it's necessary to remove every trace of that install

by :

1: sc delete all the services just installed
2: regedit to delete all oracle keys
3: edit path and PERL5lib to remove all oracle references
4: remove c:\program files\oracle
5: remove the oracle home, flash and data directories.

Now you can run the installer again !

this time I picked avaultadmin as the admin name and it went through just fine !



Wednesday, September 17, 2008

Installing iAS on CENTOS 5

Yes it works no problem; When selecting what bits of CentOS to install, select Server.

Then use the Metalink Note for RHEL5 564174.1 ; you will need an old libdb library as well because Apache will not start without it; Do not do as I did and try and find an ancient compat-db - instead read the above note and get the library from Metalink.

Of course you should immediately patch to as well.

More later.

Friday, September 12, 2008

generating all tablespace ddl from a database

So if you want to get the DDL for tablespaces :

SQL*Plus: Release - Production on Fri Sep 12 16:40:54 2008

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> set long 32000
SQL> set linesize 32000
SQL> set pagesize 0

SQL> exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM,'SQLTERMINATOR',true);

PL/SQL procedure successfully completed.

SQL> select dbms_metadata.get_ddl('TABLESPACE',tbs.tablespace_name) from dba_tablespaces tbs;

spool it to a file

et voila

Friday, August 22, 2008

vmware ISO mounting from a datastore

So : On to vmware, where you want to set up an OS

most people will look for the DVD's and mount them up via the console but instead you can upload the images for future use.

If you have DVDs you can use MagicISO or any such tool to make an ISO of the DVD, an ISO being an image of the DVD. Once you have all the ISOs made, you can now carry on and upload them to a VMWARE store for easy use.

In Virtual Center , click on Inventory/Datastores.

Right-Click on your datastore, then click Browse Datastore [ select the datastore with some space, you'll be hiding ISOs in here ]
On the icons at the top, there's a little green up arrow, click it, then Upload File or Folder.
Select the file or folder you want to put up, then click OK. It will take a few minutes for your files to be uploaded but once they are there you are done.

Now when installing a new VM [ not from a clone ] you can click oh the VM settings, then CD/DVD drive. now you can click Select Datastore ISO file and browse to the needed ISO file.

Once there you can connect the DVD drive to any DVD you like; this is also much fast ter when installing a new OS since it does not have to travel all the way across a possibly slow network

when getting a new test system provisioned to allow new application servers or new database servers in is your goal then this will help - any time spared is useful, and you can reuse the software images again and again

first post

Hi everyone, chris here, this hopefully will be a blog about all the things I do with Oracle etc.