Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
While performing a database tier clone in Oracle E-Business Suite 12.2 on Linux 8.10, you may encounter a failure during the execution of: perl adcfgclone.pl dbTechStack The error that i …
Read More »How to fix Unable to locate ‘g++’ in Linux 8.10
Yearly Archives: 2026
Error : 400 Bad Request, Request Header Or Cookie Too Large while downloading EBS 12.2 Forms 10.1.2 Patch on the frustrating and irritating newer Oracle MOS Support Interface.
Issue: I had to recently download a patch as part of the migration of Oracle EBS 12.2.10 Application from Oracle Linux 7 to 8 and I faced the Error : …
Read More »How to resolve piled-up Pending Concurrent Requests in Output Post Processor (OPP) and Standard Manager in Oracle EBS 12.2
In Oracle E-Business Suite, one of the issues faced by EBS administrators is pending concurrent requests stuck in the Output Post Processor (OPP) or Standard Manager. Recently, I encountered a …
Read More »Dataguard Switchover And Failover Using DGMGRL
Oracle Data Guard Broker Drill (19c): Switchover + Failover Using DGMGRL (End-to-End Runbook) This week I ran a Data Guard Broker DR drill for a client on Oracle 19c, covering …
Read More »Configuring Oracle Data Guard Broker
Configuring Oracle Data Guard Broker for High Availability How I recently standardized an existing Primary/Standby setup using Broker (DGMGRL) for simpler HA operations. In one of my recent HA/DR …
Read More »Datapump
Check Directories ================== SQL> desc DBA_DIRECTORIES; SQL> select * from dba_directories where directory_name=’DATA_PUMP_DIR’; =================================================================== Change datapump directory =================================================================== SQL> CREATE OR REPLACE DIRECTORY “DATA_PUMP_DIR” as ‘/app/oracle/product/11.2.0/dbhome_1/rdbms/log/’; …
Read More »Copy Password File From Primary to Standby ASM
Copy Password File From Primary to Standby ASM If you’ve worked with Oracle Real Application Clusters (RAC) or Data Guard, you know that because the password file …
Read More »A Deep Dive into Huge Pages
A Deep Dive into Huge Pages Recently, was working on optimising an Oracle database server that was struggling with memory management overhead. The server was beefy, sporting …
Read More »How to fix REP-0004 Error: Unable to Open User Preference File
Issue faced:REP-0004: Warning: Unable to open user preference file SYMPSTOMS:Concurrent request logfiles have the below error:REP-0004: Warning: Unable to open user preference file Cause:The prefs.ora is either missing or non-accessible. …
Read More »Fixing ORA-12514: Listener Does Not Know of Service (Oracle EBS CDB/PDB)
The application was down, and a quick SQL*Plus connection was supposed to confirm the database status. Instead of a clean sqlplus login prompt, the screen flashed an error:ORA-12514: TNS: Listener …
Read More »