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

Configuring RMAN Backup

Here I will explain how to configure very basic and very simple RMAN backup job to take daily backup (incremental level 0), which can be used by anyone at any OS platform and for any version of Oracle Database - difference will only be the file system paths which will be different in Windows and Unix based platforms.

ORA-03264 cannot drop offline datafile of locally managed tablespace

On one of my customer’s site, I was told that they want to drop a datafile which is offline for past one year. One year ago some novice person tried to add the datafile with a name which was not correct according to him and while trying to rename it,

Configuring Oracle Dataguard for RAC

Before we start, first you should check my article Configuring Oracle Dataguard, for a single node primary database and single node standby database; because configuring Dataguard for RAC is not much different than setting up Dataguard for single node database. During this article, I would be referring to the aforementioned document rather than

Configuring Oracle Dataguard

Following is a step by step guide to configure Oracle Dataguard using physical standby database for Oracle database. If you have RAC environment, you can follow this document to configure dataguard. OS platform for this example is Oracle Linux 6 (x86_64), but same steps can be followed to configure dataguard for other platforms. 

Database Growth History and Forecast for 10g and 11g

For 12c container/pluggable Database, you can use Database Growth History and Forecast for 12c and Above, and Tablespace Growth History and Forecast for 12c and Above scripts.

For 10g, 11g tablespace growth history and forecast, you can use Tablespace Growth History and Forecast for 10g and 11g) script. 

Performing Disaster Recovery using RMAN

Here I will be explaining how to perform disaster recovery of a database server where server has been lost because of hardware failure and needs everything to be prepared from scratch. This would require that a same type of server has been provisioned which has matching resources as we had on the actual production server. Before moving forward,

Converting a non-CDB database to a PDB

Here I would explain how do we convert a non-CDB (non-container database) to a PDB (pluggable database) in an existing CDB (container database) on the same host as well as on a different host.  For this example, I used Oracle 12.1.0.2 software version and this example assumes that there is already a container database with name “mycdb”

Upgrading Grid Infrastructure 11g to 12c

In this post I will be demonstrating the steps to upgrade Oracle Grid Infrastructure (GI) 11g (11.2.0.4) to Grid Infrastructure 12c (12.1.0.2). Since ASM runs from GI home, ASM would be upgraded automatically while the upgrade of GI. First release version of 12c was 12.1.0.1 and for this example, I would be using 12.1.0.2. As we know that

PRCA-1057 Failed to retrieve the password file location used by ASM asm

PRCA-1057 : Failed to retrieve the password file location used by ASM asm PRCR-1097 : Resource attribute not found: PWFILE

After upgrading your grid infrastructure 11g to 12c, you will notice that executing command “srvctl config asm” returns abovementioned error messages.

Upgrading Oracle 11g Database to 12c using DBUA

For manual upgrade guide from 11g to 12c or 12.1.0.1 to 12.1.0.2, click here

Here I would be discussing how to upgrade Oracle 11g (11.2.0.4) database to 12c (12.1.0.2) on the same server. This upgrade process was done on Linux 6 (x86_64). I used DBUA (Database Upgrade Assistant) to perform this upgrade. DBUA