Showing posts from March, 2014

Configure Flashback Database and Create Restore Point

Flashback can be used to revert back database to previous point in time.    How to Set…

Read more

Difference between dbtechstack,dbtier and dbconfig

When running adcfgclone on database node we had three modes in which it can be executed.…

Read more

Gather Schema Program not running for Custom Schema

To gather schema statistics we have program in Oracle Apps (Gather Schema Statistics). …

Read more

Privileges issue while starting database with SRVCTL

Running srvctl command giving insufficient privileges issue.   ./srvctl start database…

Read more

Few Oracle Apps Patching Related Tables

Below are few tables that are might come handy and useful .These are used by ADPATCH uti…

Read more

/tmp filesystem 100% fill but no files visible

Recently I observed that the /tmp on my Oracle Apps web tier (linux server) was 100% fil…

Read more

ERROR: failed to establish dependency between database and diskgroup resource

If we observe the below error in the database alert log file ERROR: failed to establis…

Read more

Query to Check Workflow Mailer Status

Below query can be used to check the workflow mailer status.   Query:   SELECT compo…

Read more

SUPERVISOR user password change in Oracle Data Integrator

To change the supervisor password of ODI we need to follow below steps First Method …

Read more