Database Blog

VSS Integration: Strengthening OCI (Oracle Cloud Infrastructure) Security with VSS (Vulnerability Scanning Service.

VSS Integration: Strengthening OCI (Oracle Cloud Infrastructure) Security with VSS (Vulnerability Scanning Service.  Introduction  In today’s digital world, security is a top concern due to the increasing risk of cyber-attacks…

Read More

ADOP Cutover Phase Fails When Starting Application Tier Services

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 More

Identify versions of components in EBS

Useful 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 More

Smart Flash in Oracle Exadata

Smart 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 More

Smart Scans in Oracle Exadata

Smart 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 More

STEPS TO INSTALL SQLSERVER IN WINDOWS 10

STEP – 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 More

METABASE INSTALLING IN ORACLE DATABASE

METABASE 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 More

Feature Oracle Database 12c, 19c, 21c

Feature 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 More

Query to get inactive count as per machine name and sql id

Please 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 More

ORA-07445: exception encountered: core dump [kggchk()+52] [SIGSEGV] [ADDR:0x444C5E6E0] [PC:0x117171614] [Application data integrity precise] [3]

Please 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 More