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

Suntec’s Data Mining Services Help You Get Efficient Data

It is a well- established fact that the availability of accurate and updated data is the base of undertaking successful business operations. Data is required at all point of business operations ranging from buying of goods and services from suppliers to marketing your final product. Often, business organizations fail to utilize their data to its full potential.

At SunTec, our…


Posted by Alvaro Dee on May 26, 2017 at 3:46am

Convert Prospects into Repeat Customers with Amazon Data Entry Services

eCommerce store owners get a better exposure for their products by selling on a platform like Amazon. If you are thinking about selling on Amazon or you are already a seller who needs help in managing product listings on this popular online marketplace, stop worrying. Professionals with sound technical knowledge of Amazon product listings, categorization, content, etc. are there to make things easier for you.

You can outsource …


Posted by Alvaro Dee on April 12, 2017 at 10:05pm

Increase Sales with Unique and Compelling Product Descriptions

Are you thinking about opening an online store? Or, do you already have one? Whether you have a small online business or a big store, the manner in which you list your products leads to a dramatic impact on your sales.

Don’t just sell a product, you need to sell an experience.
You yourself get excited about the features and specifications of your products. But the problem is that your…


Posted by Alvaro Dee on April 10, 2017 at 11:18pm

Business Research Helps You Understand Critical Traits of Your Business

Business organization needs strong customer and actionable industry insights to develop better understanding of its market and other important aspects. It can meet business objectives and make tactical, strategic and operational decisions with the help of business research services. The growth of a company largely depends on effective business research. You can conduct a successful market research with…


Posted by Alvaro Dee on April 3, 2017 at 3:23am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service