Author Archives: compitionpoint - Page 3
Resolve archive gap between PRIMARY and STANDBY
A Physical Standby database synchs with Primary by continuous apply of archive logs from a Primary Database. When the logs are missing on standby is less than 10-15 numbers, We…
Resolve huge archive gap between PRIMARY and STANDBY
A Physical Standby database synchs with Primary by continuous apply of archive logs from a Primary Database. When the logs are missing on standby difference is huge (say more than…
Concurrent Manager Issue : FND_DCP.REQUEST_SESSION_LOCK / DBMS_LOCK.Request
Error in Concurrent manager logfile : ========================= Routine received a result code of 1 from the call to Possible resultCall to establish_icm failed The Internal Concurrent Manager has encountered an…
Enable/Disable Maintenanace Mode from SQLPLUS Session (Without adadmin)
We can enable or disable maintenance mode without using adutility (adadmin), Perform the same from SQLPLUS session. Check the current status of Maintenance Mode: select (‘APPS_MAINTENANCE_MODE’) from dual; MAINT = …
RMAN : Perform Block Recovery
We can perform BLOCK RECOVERY with or without RMAN BACKUP, Here is the demonstration of block media recovery with HOT BACKUP and RMAN BACKUP as well. 1) Create tablespace, user…
TRACE IN ORACLE DATABASE
Current session trace: NORMAL TRACE: alter session set tracefile_identifer=’XXX’; — trace identifier alter session set sql_trace = true; FULL LEVEL TARCE with WAIT and BIND : alter session set tracefile_identifer=’XXX’;…
cmclean.sql : Cleaning the Concurrent Manager tables
To cleanup running and pending requests we use , If we stop concurrent managers using abort options then concurrent requests will be in running state ,Next when we start concurrent…
HOW TO FIND APPS PASSWORD – R12
Simple way to find out apps password in R12, Please review below for the same 1) Connect to SYSTEM or SYS USER 2) Create Function for to decrypt the encrypted…
DATABASE SIZE (datafiles + tempfiles + redologfiles)
To get accurate size of the database, We have to combined the sizes of all datafiles, tempfiles and redologfiles. select round ((++)/1024/1024/1024,2) “DB_size_in_GB” from ( select sum(bytes) data_size from dba_data_files…
Function not available to this responsibility : When accessing CUSTOM FORM
After fresh clone, Application technical team used to report that ‘Function not available to this responsibility’ error when they are trying to access custom form. CAUSE: Missing the entry of…