ORA blog: August 2013

Friday, 16 August 2013

alt.oracle: RMAN 12c – More SQL without ‘sql’: Up until version 12c, the RMAN command line parser was capable of parsing certain DML and DDL statements. To do this, we use the “sql” com...

alt.oracle: Oracle 12c - Out With the Grid, In With the Cloud: So Oracle database 12c is out now. The cloud (and hence the “c”) is hanging over us. At least we don’t have to hear about “the grid” anymo...

Oracle Database 12c: Consolidating to Oracle 12c Multitenant Architectu...: Now that Oracle 12c has been released we want to consolidate our databases to a Multitenant Architecture. Note: This blog post will be...

Oracle Database 12c: ASM 12c External Redundancy Diskgroup Handles Corr...: I had the pleasure of working for a company where I came across an ASM corruption where to this day no vendor was able to find the root caus...

Oracle Database 12c: ASM 12c New Feature Replace Command: We are going to test the new replace command for a simulated disk failure. In the test we will simulate that disk DG_DISK1A is bad after a b...

Oracle Database 12c: Oracle Database 12c New AWR Report Sections: Below are a few new sections I found in the Oracle Database 12c AWR Report This sections contains info on GoldenGate component...

Oracle Database 12c: ASM 12101 Normal Redundancy Testing: We will be testing normal ASM redundancy using ASM 12c. The test will simulate a device failure for one of the devices used by ASM disk. I...

Oracle Database 12c: Upgrade Grid Infrastructure Cluster 11203 to 12101...: This is an out-of-place upgrade, which will create a new GI home and leave old home untouched for us to rollback/downgrade easily. My Set...

Oracle Database 12c: Create Oracle Database 12c Container Database (CDB...: In this demo I show how to create a CDB using DBCA If you have not read or heard about CDB or PDB I recommend a few references below. C...

Oracle Database 12c: Install Oracle Database 12c Single Instance Softwa...: Install Oracle Database 12c Single Instance Software Only Installing Oracle Database 12c Software Only 1. ./runInstaller 2. N...

Oracle Database 12c: Oracle Database 12c Multitenant Architecture Part ...: Now that Oracle Database 12c has been release everyone wants to know about the new multitenant architecture. In part 1 of the multitenant A...

Oracle Database 12c: Provision Cross Platform non-CDB 11gr2 to Pluggabl...: In this demo I will show how to provision PDB on RedHat Linux from a non-CDB 11gr2 on Solaris. You maybe ask what the reason is for mov...

Oracle Database 12c: Use Database 12c Net Manager to Configure TNS for ...: In this demo I will show how to use the well known Net Manager utility to configure the local TNS file on the Multitenant environment. The N...

Oracle Database 12c: RMAN Backup for Multitenant Architecture: In this demo I will show how to handle different types of RMAN backups in a Multitenant environment. In a Multitenant environment for c...

Oracle Database 12c: Startup and Shutdown of a Container Database: In this demo I show how to shutdown and start the container database. I also show what you need to do with your pluggable databases after a ...