Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
Updating OS in Oracle RAC running on Azure using Flashgrid Software In this blog post we will talk about on how to update the OS for nodes running Oracle RAC …
Read More »Updating OS in Oracle RAC
April CPU JDK Upgrade on DB
April CPU JDK Upgrade on DB and Grid Homes in Oracle 19c Real Application Cluster Setup Current Version:- GRID HOME:- grid> cd $GRID_HOME/jdk/bin grid> ./java -version java version “1.8.0_311” …
Read More »Materialized View refresh error
Materialized View refresh error generating huge Archive Logs after Database Upgrade to 19c. Issue:- A huge amount of archive log generation when materialized view refreshing after database upgrade from 11g …
Read More »How to clean FND_NODES table in Oracle Applications
How to clean FND_NODES table in Oracle Applications Note: Remember That All the Latest Cloning Patches Should Be Applied to avoid Any Ambiguity. Step 1: Login to Database with Apps …
Read More »ORA-04063: package body “APPS.AP_ACCTG_DATA_FIX_PKG” has errors
ERROR ORA-04063: package body “APPS.AP_ACCTG_DATA_FIX_PKG” has errors ORA-06508: PL/SQL: could not find program unit being called: “APPS.AP_ACCTG_DATA_FIX_PKG” ORA-06512: at line 38
Read More »How to Get Apps Password From Backend
How to Get Apps Password From Backend STEP 1. First login to Database through Command Prompt sqlplus / as sysdba STEP 2 : Create Function From Below Script …
Read More »JSP error Request URI:/OA_HTML/RF.jsp java.lang.NoClassDefFoundError
ERROR JSP Error: Request URI:/OA_HTML/RF.jsp Exception: java.lang.NoClassDefFoundError JSP Error: Request URI:/OA_HTML/AppsLocalLogin.jsp Exception: java.lang.NoClassDefFoundError
Read More »A Brief Introduction to ADPatch
A Brief Introduction to ADPatch AutoPatch (adpatch) “AutoPatch (adpatch) is the utility you use to apply patches to the Oracle E-Business Suite file system or database.” Modes Of adpatch There …
Read More »How to Check Version of Apache in Oracle Apps?
How to Check Version of Apache in Oracle Apps? Step 1. Goto Oracle Application Home $ cd $IAS_ORACLE_HOME/Apache/Apache/bin/ $ pwd /apps/ebs/apps/tech_st/10.1.3/Apache/Apache/bin Step 2. Write httpd -v to fetch the Version …
Read More »How to rename a Datafile with Extension .dbf?
How to rename a Datafile with Extension .dbf? For example we have added a datafile but we forgot to give the extension .dbf Step 1. Shut down the Database SQL> …
Read More »