ORA-65026 XML metadata file error : LPX-00202: could not open

In the process of converting a non-CDB database to a PDB database, once you describe a non-CDB database into and xml file and then try creating a PDB using this xml file, your CREATE PLUGGABLE DATABASE command may fail with this error message.

OEM 12c Job Failing With "ERROR: Failed to create command process"

I received OEM alert that one of my OEM 12c Cloud Control jobs is failing with message Error: Failed to create command process. Job activity page was showing details as follows

ORA-01031 insufficient privileges during switchover using DGMGRL

If you have Dataguard broker configured in your Dataguard environment and you are doing a switchover using DGMGRL, you may see ORA-013031 as you can see in the following.

[oracle@SGPvGMSIMDG01 ~]$ dgmgrl sys /

ORA-01031 While Creating or Accessing a View

ORA-01031: insufficient privileges

If your CREATE VIEW, CREATE MATERIALIZED VIEW or SELECT statement on a view is failing with this error message, it means that you are using a table in your view which is in another schema and there are some privilege issues. Reason for this error could

ORA-00942 table or view does not exist

ORA-00942:

table or view does not exist

This is one of the most common errors which end users faces, returned by the Oracle RDBMS, and the meanings of this error message is that table, view, materialized view or cluster you are trying to access (SELECT, INSERT. UPDATE or DELETE).

Error 1031 received logging on to the standby

In a Dataguard environment, if you see messages similar to the following in the alert log file of your Primary database, there could be multiple reasons for these errors.

#########################################
Error 1031 received logging on to the standby
PING[ARC1]: Heartbeat failed to connect to standby 'mydb_standby'. Error is 1031.

ASM Disks Stamping on Windows

When we start the installer for the Grid Infrastructure installation, and select either “Install and configure Oracle Grid Infrastructure for a Cluster” or “Install and configure Oracle Grid Infrastructure for a Standalone Server” option on the first screen

ORA-65139: Mismatch between XML metadata file and data file

While converting a non-CDB database to a PDB database, sometimes I was able to do this, but sometimes I was facing the following error.

################################

SQL> create  pluggable database pdb2 using '/u01/oracle/noncdb.xml';

Autostart of Pluggable Databases

In Oracle 12.1.0.1, you would need to start all pluggable database manually after the startup of the Container Database. To automate the startup of pluggable databases, you have 2 options. First option is to create a system trigger (having pluggable database “open”commands for the pluggable databases) which fires at container database  startup and opens the pluggable database(s). Trigger code would be something like this.

Creating ASM Disks using ASMLib

While installing oracle 11.2.0.4 grid infrastructure (same is true for 12c) on Oracle Linux 6 (x86_64), “Create ASM Disk Group” screen of installation wizard prompted to select the disks for the creation of a diskgroup, as you see in bellow screenshot. This installation screen would appear if you select “Install and Configure Grid Infrastructure for a Cluster