Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
Oracle AD Controller ADCTRL is used to manage worker processes that perform a pivotal role in the function of batch processing for patching and many other Applications activities. ADCTRL is …
Read More »Oracle AD Controller
Undo Related Queries Part 2
List of All active Transactions
Read More »ORACLE APPLICATIONS R12 ARCHITECTURE
ORACLE APPLICATIONS R12 ARCHITECTURE Oracle E-Business Suite Release-12 have a Multi-tiered Architecture, that supports Oracle Applications products. They are comprised of a Database Tier which manages the Oracle Database and stores all …
Read More »Error creating AME rule R12 oracle.apps.per.ame.rules.server.RulesAM
ERROR
Read More »Undo Related Queries Part 1
To check Retention Guarantee for Undo Tablespace
Read More »ORA-04031: unable to allocate adautoconfig.sh dbTier txkcreateACL.sh exiting with status 1
ERROR Checking for existence of the ACL …. DECLARE * ERROR at line 1:
Read More »How To Add Redo Logfiles In Standby Database
How To Add Redo Logfiles In Standby Database Step 1. First, Check MEMBER present in Standby Database. SQL> select member from v$logfile; MEMBER ———————————- E:\STANDBYLOGS\REDO03.LOG E:\STANDBYLOGS\REDO02.LOG E:\STANDBYLOGS\REDO01.LOG Step 2. …
Read More »How To Drop Redo Logfiles on Physical Standby Database
How To Drop Redo Logfiles on Physical Standby Database Step 1. First, Cancel the Standby Recovery Process. SQL> alter database recover managed standby database cancel; Step 2. Check …
Read More »adgentns.pl” exitcode=”512″ while running AutoConfig
ERROR Error stack: AutoConfig completed with errors. The log file for this session is located at: /u01/apps/inst/apps/TEST_apps/admin/log/03451250/adconfig.log
Read More »AutoConfig Failing With NegativeArraySizeException After Upgrading To 11gR2 Database
ERROR Error stack while running autoconfig: Updating Context file…COMPLETED
Read More »