Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
To check Retention Guarantee for Undo Tablespace
Read More »Undo Related Queries Part 1
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 »APP-FND-01542 : This Application Server is not authorized to access this system
ERROR APP-FND-01542 : This Application Server is not authorized to access this system. Please contact your system administrator.
Read More »RAC Acronyms in Used
Real Application Cluster Acronyms GCS Global Cache Services in memory database containing current locks and awaiting locks, also known as PCM GES Global Enqueue Services coordinates the requests of all …
Read More »How to compile invalid objects in an APPS Environment
Compiling Objects Manually Through SQL Commands First find the Invalid Objects in the Database by below given query. SELECT COUNT(*) FROM DBA_OBJECTS WHERE STATUS = ‘INVALID’; For a more detailed …
Read More »How to add System administrator responsibility from backend
Syntax: fnd_user_pkg.addresp(username => v_user_name ,resp_app => ‘SYSADMIN’ ,resp_key => ‘SYSTEM_ADMINISTRATOR’ ,security_group => ‘STANDARD’ ,description => ‘Auto Assignment’ ,start_date => SYSDATE – 10 ,end_date => SYSDATE + 1000); Usage: BEGIN …
Read More »