During Cutover phase while Patching , ADOP failed with below error stating unable to start the application. Please find the root cause and its related solution below Error : …
Read MoreUseful commands to find the versions of various components used in Oracle E-Business Suite Find Apache Version or Oracle Application server version in R12 Log in to the Application server…
Read MoreSmart Flash in Oracle Exadata In the realm of data management and high-performance computing, Oracle Exadata has established itself as a powerhouse, delivering exceptional capabilities for both online transaction processing…
Read MoreSmart Scans in Oracle Exadata In the ever-evolving landscape of data management and analytics, businesses are continually searching for ways to extract more value from their data while optimizing performance…
Read MoreSTEP – 1 1 First download .netframework 3.5 Completed. Now the .net framework 3.5 has been installed in the windows system STEP-2 -Download software for the sqlserver -User the…
Read MoreMETABASE INSTALLING IN ORACLE DATABASE Requirements – Metabase requires a Java Runtime Environment (JRE), with a Java version of 11 or higher. – Check you have a java version…
Read MoreFeature Oracle Database 12c, 19c, 21c Introduction: Oracle is by far the leader in all key leading research reports for On-prem and Cloud Database Management Systems. Oracle is…
Read MorePlease use the below query. SELECT count(prev_sql_id),prev_sql_id,sql_text FROM v$session LEFT OUTER JOIN v$sql ON v$session.prev_sql_id = v$sql.sql_id WHERE status=’INACTIVE’ and machine like ‘%servername%’ HAVING COUNT(prev_sql_id)>5 GROUP BY prev_sql_id,sql_text…
Read MorePlease find the below steps to resolve the same. ADI [Application Data Integrity] memory feature is enabled by default in Solaris SPARC Download and apply Patch 35464935. OR Set the…
Read Morewhat is psudocolumn, Rowdepandancy and Norowdepandency in oracle A pseudocolumn behaves like a table column, but is not actually stored in the table. You can select from pseudocolumns, but you…
Read More