Thursday, May 1, 2014

Queryable Patch Inventory or DBMS_QOPATCH

New in Oracle 12c is queryable Opatch. Oracle offers a set of tables and a PL/SQL packages to query the Oracle Inventory.Prior to Oracle 12c, it was not easy to List Oracle patches. Now from Oracle 12c and beyond, you can use the DBMS_QOPATCH package to list all patches.

Using DBMS_QOPATCH; Oracle Database 12c has a PL/SQL - SQL interface for viewing patch information using a select statement instead a OS ORACLE opach command. This new interface view all the patch information available as part of the ,OPatch lsinventory -xml command conform the the OS Oracle opatch command. The package DBMS_QOPATCH accesses the Oracle Universal Installer (OUI) patch inventory in real time to provide patch and patch meta information.

Friday, March 7, 2014

EM database Control Using EMCA fails when Service Name contains Hyphen.

When using "emca -config dbcontrol db -repos create -cluster" on a RAC Database the installation of EM database Control fails. Investigation of the logs will see an error in the emca_repos_config_.log


Thursday, December 12, 2013

Oracle 12c - Oracle-Supplied - CATCON.pl

The installation of an Oracle database is done by executing serveral scripts. Those scripts perform operations such as creating data dictionary views and installing options. Oracle has now introduced multiple database [PDB's] inside one database [CDB]. For maintenacne and a new strategy Oracle's best way is to run SQL scripts and SQL statements is done by using catcon.pl. It can run them in the root and in specified PDBs in the correct order, and it generates log files that you can view to confirm that the SQL script or SQL statement did not generate unexpected errors.
It also starts multiple processes and assigns new scripts to them as they finish running scripts previously assigned to them.

Example of the Statement
perl /u02/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -n 1 -l /u02/app/oracle/admin/CDB1/scripts -b catalog /u02/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catalog.sql

CatCon.pl = Perl Module for creating - upgrading CATalogs for CONtainer databases

Tuesday, December 10, 2013

Creating pluggable databases with and without OMF structure; [CDB=OMF storage structure]

For creating a pluggable database you have to consider how to create the pluggable database, and what are you current CDB settings. In this post i have played with and without OMF and difference file structures inside ONE CDB database. Mostly pluggable database will be created from the seed database. What is needed when you want the oracle files of the pluggable database on an other file structure storage. What will you use, and when should you use what. After the createing of a pluggable database, you need possible extra steps inside the pluggable database to keep your optimalisize storage environment. Think about the steps that are needed with a single none CDB, those steps would also be needed on a pluggable database by or after the creating steps. When you don't think about this, the change is that you get a spaghetti mixture of files inside your environment.

Lets play;

Wednesday, November 27, 2013

Oracle Database 12c (Multitentant) Archiecture Overview - Oracle by Example (OBE)

Oracle Learning Library : Oracle Database 12c Architecture Overview

This video explains some of the Oracle Database 12c architecture changes. This is an introductory video for the Oracle Database 12c Posters. Oracle by Example (OBE)

Oracle Learning Library : Oracle Database 12c Multitentent Architecture Overview

This video shows you the main components of the Oracle Database 12c new multitenant architecture. Oracle by Example (OBE)

Tuesday, November 26, 2013

Using Oracle multithreaded Oracle model (Threaded execution)

In previous releases, Oracle processes did not run as threads on UNIX and Linux systems. Starting in Oracle Database 12c, the multithreaded Oracle Database model enables Oracle processes to execute as operating system threads in separate address spaces.

THREADED_EXECUTION specifies whether to enable the multithreaded Oracle model. Starting in Oracle Database 12c, the multithreaded Oracle model enables Oracle processes on UNIX and Linux to run as operating system threads in separate address spaces.

The choice of threading model is dictated by the THREADED_EXECUTION initialization parameter.
THREADED_EXECUTION=NO  : The default value causes Oracle to run using the multiprocess model.
THREADED_EXECUTION=YES : Oracle runs with the multithreaded model.

Friday, October 11, 2013

DRCP - Database Resident Connection Pooling

Database Resident Connection Pool (DRCP) is a connection pool in the server that is shared across many clients. Best practice is to use DRCP in connection pools where the number of active connections is fairly less than the number of open connections. DRCP increases Database server scalability and resolves the resource wastage issue that is associated with middle-tier connection pooling. The Database Resident Connection Pool implementation creates a pool on the server side, which is shared across multiple client pools. This significantly lowers memory consumption on the server because of reduced number of server processes on the server and increases the scalability of the Database server.