On 12c, Oracle XML DB is now a mandatory component of Oracle Database. You cannot uninstall it, and if Oracle XML DB is not already installed in your database prior to an upgrade to Oracle Database 12c or later, then it is automatically installed in tablespace SYSAUX during the upgrade. If Oracle XML DB has … Read more
On : 19.18.0.0.0 version, Patching After applying a RU Patch , CATALOG / CATPROC Component goes Invalid with lot of invalid objects Running datapatch also fails because invalid objects : There are a lot of invalid objects which will not validate by running catalog.sql or catproc.sql or utlrp.sql Compiling individual objects will fail with: Issue … Read more
ORACLE_HOME disk (filesystem) became full and caused an ASM error… Got the following errors in the alert log file: ORACLE_HOME disk (filesystem) became full leaving no space for writing audit records to $ORACLE_HOME/rdbms/audit. 10g and higher in particular generate a lot of informational trace files for various internal operations, and if these can not be … Read more
SAR is used to collect, report or save system activity. SAR stands for System Activity Report. SAR is used to check Memory, CPU, system load, network, swap space utilization, etc. It uses a proc file system to collect the information. The sar command writes to standard output the contents of selected cumulative activity counters in … Read more
The top utility is a commonly used tool for displaying system-performance information. It dynamically shows administrators which processes are consuming processor and memory resources. Top is incredibly handy. The top (table of processes) command shows a real-time view of running processes in Linux and displays kernel-managed tasks. The command also provides a system information summary that shows … Read more
Traditional startup/shutdown command prior to 12c. Shutdown Command SHUTDOWN NORMAL SHUTDOWN IMMEDIATE SHUTDOWN ABORT Startup Command STARTUP STARTUP NOMOUNT STARTUP MOUNT What happen when we execute shutdown immediate at CDB? If we use one of these traditional shutdown methods at the container database (CDB) layer, we will bring down the CDB and the associated PDBs … Read more
After performing database upgrade from 12.1.0.2.171017 to 12.2.0.1.171017, PDB is shown in RESTRICTED mode. PDB_PLUG_IN_VIOLATIONS returns the following error: However, there was no datapatch related error shown in DBUA trace.log. Upgrading PDB seems successfully completed. Run datapatch by the following steps will resolve the issue: 1. $ sqlplus / as sysdba 2. SQL> alter pluggable … Read more
Archivelog gap Log Gap Check Restore Archivelog from Backup Stop and Start MRP Services
Private SQL area holds information about a parsed SQL statement and other session specific information for processing. When a server process executes SQL or PL/SQL code, the process uses the private SQL area to store bind variable values, query execution state information, and query execution work areas. The private SQL areas for each execution of … Read more