January 2011 Blog Posts (16)

11gR2 Physical Data Guard Setup project, with Active Data Guard option (English and French)

The purpose of this document is to create a step by step guideline for using the Oracle Data Guard a High available mechanism.

The Oracle version is 11gR2.

We will first introduce to you the Oracle Data Guard. We will define the requirements for this demonstration.

We will create 2 windows virtual machines using Oracle virtual Box. Then, We will set up the Primary database.

After that, we will use Recovery Manager RMAN to create the Standby database, and, we will check the…


Added by Wissem EL KHLIFI on January 31, 2011 at 10:35am — No Comments

How to fix ORA-979: not a GROUP BY expression in version

1- Introduction:
After migration my Oracle version 10gR2 to 11gR2 (, Some of the queries did not run successfully.
Some of the queries gave me an ORA-979 error.
In this article, I am going to explain how to fix the error. Oracle says ORA-979 in 11gR2 is a bug.
The bug number is 9411496.


Read more here: http://www.oracle-class.com/?p=1337

Added by Wissem EL KHLIFI on January 28, 2011 at 12:30pm — No Comments

processing – code: -14551 msg: ORA-14551: cannot perform a DML operation inside a query in version

From 10g of Oracle, the “dbms_space.object_growth_trend” is a new useful pipelined function that displays the segment growth at a specific point in time. The statistics are collected from the Automatic Workload Repository Facilities (AWRF) every day.

The column QUALITY has 3 different values: “GOOD”, “INTERPOLATED”, “PROJECTION”.


Read more here:  http://www.oracle-class.com/?p=1347

Added by Wissem EL KHLIFI on January 28, 2011 at 12:28pm — No Comments

Online RAC DBA training - Instructor lead

Hi All,

Greetings from TutorsOnInternet.
Why you need to attend this training:-Any one , who wants to  start   their career as  RAC DBA, need to know the basic concept as well as hand-on experience.Otherwise its difficult to get entry and survival in DBA filed.Working…

Added by Nisha on January 22, 2011 at 12:31pm — No Comments


http://rafioracledba.blogspot.com/ Continue

Added by Rafiuddin Alvi on January 18, 2011 at 11:11pm — No Comments Grid Infrastructure Install or Upgrade may fail due to Multicasting Requirement

This is a bug to aware, If someone install Oracle Grid Infrastructure for Cluster, and run "root.sh" command on node02 (and multicasting is not enabled on private network).

Oracle Grid Infrastructure introduces new feature called Redundant Interconnect allowing for Oracle Supplied redundancy for the cluster interconnect. With this new feature, multicast network communication on the private interconnect network is utilized on bootstrap to…

Added by Surachart Opun on January 17, 2011 at 6:26pm — No Comments

Somasoft Solutions.


SOMASOFT is a high value full service…


Added by Krissy Sutton on January 12, 2011 at 8:26pm — No Comments

How to upgrade ASM after Install Grid Infrastructure Software Only?

Posted "struggle to Upgrade Oracle Database to" topic, and someone comment me "Upgrade Grid Infrastructure to ASM after Installed Grid Infrastructure Software Only"

So, just tested to upgrade ASM after installed Grid Infrastructure Software Only…


Added by Surachart Opun on January 11, 2011 at 4:19am — No Comments

Flashback Database puts Physical Standby into MOUNT from READ-ONLY OPEN

Another bit of discovery from my present Data Guard course in Munich: If you have a Physical Standby opened READ-ONLY, you can do Flashback Database in that state without first shutting down and going to status MOUNT:


Added by Uwe Hesse on January 5, 2011 at 1:00am — No Comments

Clone Database from Snapshot Standby Database

In 11g, we introduced the new feature Snapshot Standby Database for Data Guard.In my current Data Guard course, one of the attendees asked, whether itis possible to create a Database Clone out of such a Snapshot StandbyDatabase. Maybe you want to preserve the changes that have been doneduring the time, your Physical Standby Database was turned into aREAD-WRITE opened (Test-)Database. I…


Added by Uwe Hesse on January 5, 2011 at 1:00am — No Comments

Database Migration to ASM with short downtime

We start this scenario with a small Database running in aconventional filesystem, setup ASM instance and two ASM diskgroups,then migrate to ASM with the downtime it takes only to shutdown andrestart the instance – in other words, the downtime will be in therange of only minutes on a productive system. The example is done on asmall Linux server using Oracle Database Enterprise Edition,but should work very similar on other platforms and with the 10gversion as well:…


Added by Uwe Hesse on January 5, 2011 at 12:58am — No Comments

Real-Time Query and Automatic Block Media Recovery in 11gR2

Yesterday, I posted about dealing with Block Corruption in general. Special case is Block Corruption in a Data Guard Environment, where we introduced the New Feature Automatic Block Media Recovery (ABMR). Yes, another cool abbrevation from the  the Oracle Realm:…


Added by Uwe Hesse on January 5, 2011 at 12:57am — No Comments

Dealing with Oracle Database Block Corruption in 11g

When we look at physical damage of datafiles, the effects are notalways so drastic that the file is completely destroyed. Sometimes,only small parts of the file are damaged resp. corrupted. It may very well not even noticed for a while. This posting is designed to show how to a) detect block corruption and b) recover from it:…


Added by Uwe Hesse on January 5, 2011 at 12:56am — No Comments

Real-Time Query for Read-Mostly Applications

Here is one nice little demonstration from my last 11gR2 Data Guardclass that I’d like to share with the Oracle Community. It is aboutenabling Read-Mostly Applications to run on a Physical Standbydatabase, leveraging the 11g New Feature Real-Time Query (part of theActive Data Guard Option):


Added by Uwe Hesse on January 5, 2011 at 12:55am — No Comments

Brief introduction into External Tables

As an Oracle DBA, you will sooner or later encounter the task to dealwith interface files (Flat Files) from some other application that youneed to process in your Oracle Database. External Tables, introduced in9i already, are usually the tool of choice for that and can beconsidered as the successor of the ancient SQL*Loader for that purpose:…


Added by Uwe Hesse on January 5, 2011 at 12:54am — No Comments

Recover Dropped tablespace using RMAN tablespace point in time recovery

This is new feature for Oracle 11g R2.Here I'm go to demonstrate How to recover dropped Tablespace using RMAN Tablespace point in time recovery.

Download PDF Document from here

Recover Dropped tablespace using RMAN TSPITR pdfRight Click on this URL, Save Target as  & then Download it.
Step 1: Create Tablespace


Added by Mohamed Azar on January 2, 2011 at 6:00am — 3 Comments

Monthly Archives











Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins



Blog Posts

Streamline Your Business Process with Real Estate Data Entry Services

People in the real estate business have to deal with huge volumes of data on a regular basis. It includes the data that is generated from legal documents, property valuation statements, latest commercial and non-commercial property information, etc. This database should be regularly updated and processed properly to help you in your business procedures. With access to relevant real-time data, your business organization can thrive in the commercial real estate market. In…


Posted by Alvaro Dee on March 27, 2017 at 2:48am

Augment the Speed and Efficiency of Website Development with Joomla

Over the past few years, Joomla has emerged out as one of the greatest platforms for designing, developing, and deploying websites and web applications worldwide. Joomla scales up extremely well, uses less memory and gives a brilliant performance. Hire skilled and experienced Joomla developers to use Joomla CMS for developing simple and complex corporate websites. You can even enhance the functioning of your existing website by using this open source platform.

By outsourcing Joomla…


Posted by Alvaro Dee on March 20, 2017 at 4:00am

Top 10 Interview Questions & Answers for Java Developers

An organization hiring a Java developer is looking for someone who can code the applications flawlessly. For the period after Java training, the following is a very important list of ten Java interview questions. Make sure you tap the benefits of this comprehensive list of questions shared by our Java counterparts to crack your next interview.

1. What is immutable…


Posted by Michael Warne on March 17, 2017 at 3:00am

Get the Best Website for Your Business in a Set Time Frame

If you sell products online, you must be knowing how time-consuming and mundane it is to upload products. There are chances of you looking for someone to handle your product data entry tasks. A company that has a wealth of experience and is known for providing its customers with data entry services for a variety of eCommerce solutions can deal efficiently with high volumes of work without any hassle.…


Posted by Alvaro Dee on March 17, 2017 at 2:47am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service