Posts

"Oracle Data Guard 11gR2 Administration Beginner’s Guide" - Book Review

Image
I am very much thankful to Pack publishers and specially kyathi shah from packt for providing an opportunity to review book "Oracle Data Guard 11gR2 Administration Beginner’s Guide" . The most demanding technology for Disaster Recovery in database world - Oracle Dataguard. This book is co-authored by my friends Nassyam basha and Emre baransel . This book covers each and every possible configuration that could be deployed within oracle data guard according to business requirements. I am very thankful to both of them for their efforts and providing  such a wonderful book to the oracle community. This book also illustrate all generic errors DBA's come across while working on Data Guard. I  will highly recommend this book to every DBA who have enthusiasm for learning this robust technology. Chapter1:Getting Started It contains full explanation about data guard architecture, different types of data guard configuration, evolution of data guard and its fun...

Oracle 12c Grid Infrastructure Installation on Solaris 11 standalone

Image
In this article i will demonstrate Installation of  Oracle 12c grid Infrastructure software on  oracle Solaris 11 - X86 (64-bit) and creation of 12c Database on ASM Disk group. Step-By-Step actions: 1) Download software for Solaris X86-64 Bit architecture. 2) Configure OS perquisites. 3) Install Oracle 12c Grid Infrastructure software. 4) Install 12c RDBMS software and create database on ASM Storage. Configuration of OS Pre-requistes: create OS user and group create directories for software and change permissions accordingly configure kernel parameters set proper display variable start Installation - create OS user ad group -  root@solaris11:~#groupadd dba root@solaris11:~#useradd -g dba -d /export/home/ora12c -m ora12c   - create directory structure root@solaris11:~#mkdir -p /ora1/grid [GI Home] root@solaris11:~#mkdir -p /ora1/ora12c [RDBMS Home] root@solaris11:~#chmod -R 775 /ora1/grid root@solaris11:~#chown -R ...

powermt display dev all Device(s) not found - solaris 11

Image
If you're trying to configure EMC clariion/vnx with solaris 11 and you encountered an Error "powermt display dev=all Device(s) not found." then this post if for you. Though LUN is connected, zoning is perfect,  Physical drive for LUN is visible and still you're not able to list the devices with powerpath. This is because your storage array in solaris 11 is listed as unmanaged. Just we need to change it from unmanaged to managed and save the configuration. - Here its listing the physical drive (LUN). - No devices are listed - Here its  listing "Clariion" as unmanaged  - change the status of clariion from unmnaged to manage - Now LUN is visible in powerpath management. Happy trouble shooting and thanks for reading :) regards, X A H E E R

Create Oracle 12c Database using DBCA - 12c Container Database & pluggable Database

Image
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...