Image copy Of Database using RMAN
Introduction: By default RMAN takes the backup as BACKUPSETS i.e. it combines of multiple datafiles into one or more backupsets.If you want to take the backup of datafiles as it…
Read MoreSilent 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 MoreMigrating 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 MoreStep 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 MorePDB 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 MoreBI 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 MoreNID 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 MoreStep 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 MoreORA-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 MoreSQLTXTRACT 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