mylearning4oracle

 While I was working with oracle 11G cluster ware I used to come across a term called cluster health check monitor which actually helps us to analyze the cluster ware statistics. However this feature is optional as it used to consume more CPU and it is integral part of oracle database 11g where the data is maintained in Berkeley database. From Oracle 12.1.0.2, MGMTDB is a mandatory database installed by Oracle itself. The MGMTDB is a built-in database to store Grid Infrastructure Management Repository (GIMR). This repository enables such features as Cluster Health Monitor(aka CHM/OS, ora.crf), Oracle Database QoS Management, and Rapid Home Provisioning, and provides a historical metric repository that helps in  viewing of past performance and diagnosis of issues. Management Repository is a single instance database that's managed by Oracle Clusterware in 12c. The database will be automatically failed over to other node in case of node evictions. In 12.2, MGMTLSNR also listens o...

 This blogs explains a simple process to migrate your non cdb database to pdb database after 12 upgrade  We have different methods to perform the migration Export/import  DBMS_PDB GG replication  shutdown the database  start the database in read only mode  Now we need to create a metadata xml file using DBMS_PDB package BEGIN   DBMS_PDB.DESCRIBE(pdb_descr_file =>'/u01/app/oracle/backup/ora12c.xml'); END; /       4. shutdown the non-cdb database  and login to CDB database as sys user       5. Let us assume we don't have CDB database , if so we need to create CDB database       6. use DBCA -silent installation to create the CDB database        export ORACLE_SID=CDB sqlplus / as sysdba CREATE PLUGGABLE DATABASE PDBORCL USING '/u01/app/oracle/backup/ora12c.xml'   COPY   FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/orcl/', '/u01/app/oracle/oradata/cdb/pdborcl/...

 This blog explains the basic steps which we need to follow to upgrade 11g database to 12c database  and preferably moving to PDB databases I have tried to read oracle MOS standard document ( How to Download and Run Oracle's Database Pre-Upgrade Utility (Doc ID 884522.1) )   which actually directs to different links explaining upgrade steps. But my intention is just to keep it simple to everyone when they were about to jumpstart the upgrade activity. We can follow couple of methods to perform the upgrade activity  Manual Method DBUA tool I prefer to go with manual method because automated method will always makes our life difficult when we struck during the upgrade process. But this have been fixed with 18c and 19c upgrades. Supported Upgrade Paths: =================  Destination                Source ===========                ====== 12c Release 1 (12.1.0.2)   10.2.0....