Database Blog

Silent mode Installation of Grid and database in oracle cloud (19C)

Description: The Oracle Grid Infrastructure for a standalone server is the Oracle software that provides system support for an Oracle database including volume management, file system, and automatic restart capabilities.Oracle…

Read More

Migrating a Normal disk group to flex disk group in ASM oracle cloud (19C)

Description: Flex Diskgroups are the new features in oracle 12c R2 for quotas, cloning and filegroups. Oracle ASM provides two-way mirroring by default for newly-created flex disk groups. We can…

Read More

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