Database Blog

Step by Step Oracle Audit Vault Installation on VMware

Introduction: This post is a guide to install Oracle Audit Vault 12.2.0.8 on VMware. High Level steps 1. Media Download 2. Prerequisites 3. Installation of Audit Vault 12.2.0.8 4. Post…

Read More

PDB is in restricted mode, datapatch puts pdb$seed to restricted mode

Container and Pluggable database  SYMPTOMS The PDB$SEED is in restricted mode. CON_ID CON_NAME OPEN MODE RESTRICTED 2 PDB$SEED READ ONLY YES When we try to open the PDB$SEED it shows…

Read More

BI Publisher program failed due to opp

Error: “Post-processing of request 4667897 failed at 30-Apr-2021 15:54:50 with the error message: One or more post-processing actions failed. Consult the OPP service log for details.” … oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.XDOException”…

Read More

NID UTILITY IN ORACLE12C

NID UTILITY IN ORACLE 12C DATABASE We can change both DBID and DB NAME using NID utility, the following will show how to change the DB NAME using NID utility.…

Read More

Step by step Creating a Custom Application top for EBS 12.2 Using AD Splice

Introduction: This post is to guide to Create a Custom Application top for EBS 12.2 Using AD Splice. Steps to create a Custom Application top for EBS 12.2 Using AD…

Read More

ORA-01012: not logged on error

ORA-01012: not logged on error while trying to start the oracle database. Solution: To resolve this error  remove the orphaned shared memory segment using sysresv utility. sysresv command will list…

Read More

SQLTXTRACT and SQLTEXECUTE -Revealing Confusion

SQLT XTRACT is the easiest report to create because it does not require the execution of the SQL at the time of the report generation. The report can be collected…

Read More

Query to find the dbms_jobs running

To find the job details set pages 1000 lines 1000 col schema_user for a20 col this_date for a20 col next_date for a20 col what for a80 col instance for 999999999…

Read More

Query to generate AWR report

set lines 500; set pages 500; set long 1000000; SELECT X.SQL_ID, X.CPU_TIME, X.EXECUTIONS, T.SQL_TEXT FROM DBA_HIST_SQLTEXT T, ( SELECT S.SQL_ID SQL_ID, SUM(S.CPU_TIME_DELTA/1000000) CPU_TIME, SUM(S.EXECUTIONS_DELTA) EXECUTIONS FROM DBA_HIST_SQLSTAT S, DBA_HIST_SNAPSHOT P…

Read More

Script to generate statspack report

set lines 300; set pages 500; set long 1000000; select A.hash_value, A.text_subset, A.module, trunc((B.cpu_time-A.cpu_time)/1000) “CPU_TIME(ms)”, B.executions-A.executions executions, trunc(decode(B.executions-A.executions, 0, 0, (B.cpu_time-A.cpu_time)/(B.executions-A.executions))/1000) “CPU_TIME_PER_EXEC(ms)” from STATS$SQL_SUMMARY  A, STATS$SQL_SUMMARY  B where A.hash_value =…

Read More