Export oracle METADATA_ONLY

steps
1. create dump directory (CREATE DIRECTORY metadata_export AS '/opt/app/oracle';
2. make sure the directory has got read and write permssion
3. create shell script as follows
4. schedule the script to run

#!/bin/sh
. envfile.env
$ORACLE_HOME/bin/expdp \"/ as sysdba\" SCHEMAS=shcema1, schema2, schema3 content='METADATA_ONLY' directory=met
adata_export NOLOGFILE=Y dumpfile=metadata_export:metadata.dmp compression=metadata_only

Invoking oracle ESB API through http protocol

If you want to see the service status of esb in one xml file you can invoke oracle esb API through http protocol. For instance you can use http://hostname:port/esb/esbConfiguration/executeCommand?action=ExploreServices to list all your esb services and statuses in one xml document

This is documented very well @ One of soa blog

Optimizing Oracle on VMware

I have been looking into the issues of running RDMS on vmware and found the following articles to be useful.

optmising oracle on vmware

Deployment of Oracle Databases on VMware Infrastructure

virtual machines versus bare metal

RAC on virtual machines

nice -n 19 rm -rf directory

nice -n 19 rm -rf directory

this command will allow you to run a rm if your directory has got many files. It will run with lowest priority.

Integrating Oracle BIEE and Oracle Analytic Workspaces

Very nice paper on how integrate oracle OBIEE and Oracle Analytic WorkspacesIntegrating Oracle BIEE and Oracle Analytic Workspaces