Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
Fixing a “Failed” worker Whenever a job fails for the 1st time, the job is deferred at the end of the phase and another job is assigned to that worker. …
Read More »RapidWiz log files for Oracle Applications Release 12
RapidWiz log files for Oracle Applications Release 12 During installation of Release 12 using RapidWiz, the following log files are created. In case of any errors during the installation, …
Read More »Oracle AD Controller
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 »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 »