Apps DBA Workshop

In this article I am going to test new options introduced in Oracle Database 12cR1. Oracle introduced 2 new  type of databases  in this release "Container Database" and "Pluggable Database" . This is one of the major new change introduced from this release. I believe for this feature only Oracle has changed the naming convention of its release from letter "g" to "c" as this feature is completely compatible with the concept what we call as a "CLOUD". Here I am going to demonstrate the following points:  Container Database & pluggable Database  Using DBCA to create container database  Using DBCA to create pluggable database  Managing pluggable database Container Database & Plug gable Database:  - Container database is the root database to which all pluggable database belongs. Here Oracle used same concept as of Solaris Zones. There will be two types of zones in solaris Global zone and non-global zone. Global zon...

Rename/Move data file online - This is the first new feature I am demonstration on Oracle database 12c new features. This is really a wonderful feature. You cannot only move datafiles  form one location to another on normal file system, you can even move your datafiles  from NON-ASM to ASM Diskgrups: In this article I will demonstrate rename/move : 1) Normal rename of datafille 2) Rename from normal location to ASM 3) Move from one ASM location to another 4) Move from ASM to Non-ASM 1) Normal rename of datafille SQL> SQL> select name, STATUS  from v$datafile; NAME                                                         STATUS -------------------------------------------------...

This  article demonstrates how to Install and configure newly released Oracle 12c Grid Infrastructure software on Linux-64 bit  on standalone system. I have configured this on OEL 5.7 64bit virtual machine with 4GB RAM and single core processor. There no much difference in Installation procedure though there some new screens Introduced in this release. New Options: 1) screen for root/sudo password for running root.sh scripts 2) Edit configuration at "summary of Installation" screen 3) Performing Linux operations This is my second post on Oracle Database 12c. If you're following the steps for configuring GI 12c then please perform all OS per-requisites listed in post of oracle 12 database Installation: 12c Database Installation   Steps for configuring standalone Oracle 12c Grid Infrastructure Software: 1) Install addition OS packages (oracleasm - rpms) 2) Configure oracleasm and create asmdisks 3) Configure directory privileges for GI sw 4) Instal...

This is my first article  on Oracle database 12c. I have installed oracle database 12cR1 on Oracle Enterprise Linux 5.7 - 64 bit virtual mahcine with 4GB RAM, 6GB SWAP and 15 GB of HDD space. I do not find much difference in Installation steps in oracle 12c when compare it with 11g. There are indeed certain new options and some more per-requisite OS packages. You can download the software from OTN or EDELIVERY  website. http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Hardware Requirements: > Single Core CPU > 3 GB RAM > 8 GB of Disk Space (SW + database) OS per-requisites: > Create OS group and users > Create required directories with appropriate privileges > Configure Kernel parameters > Install required OS packages > Configure proper Display [root@linux1 ~]#groupadd dba [root@linux1 ~]#useradd -g ora12c [root@linux1 ~]# passwd ora12c Changing password for user ora12c. New UNIX passwor...