Showing posts from 2014

Database opening with RESETLOGS

Whenever we perform incomplete recovery or recovery with a backup control file, you must…

Read more

Granting select access to v$ Tables

To provide grant select access on v$ tables (like v$session,V$ASM_DISK etc) error will e…

Read more

Oracle Grid Home Clone Guide

Oracle GRID home cloning can be done using  below steps Steps: 1.Copy source GRID Ho…

Read more

Finding session using UNDO tablespace

The below query can be used to find the session which is consuming more UNDO tablespace.…

Read more

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

Error : Function not available for this responsibility in R12

If there is an error " Function not avaibale for this responsibility" then the…

Read more