July 2011 Blog Posts (19)

11gR2 ASM – Inside story – Part 6 (Recreate High available Service and rename Disk group)

 

I have written this post in 3 different languages; English, French and Spanish...

 

Extract in English:



In the previous ASM inside story article, which refers to the part 5 of the story. We have seen how to read an ASM file from OS.

In this article, we will see how to recreate the high available service, register the resources and at the end of this article we will rename a diskgroup.

The following procedures have been tested in an 11gR2…

Continue

Added by Wissem EL KHLIFI on July 30, 2011 at 7:57am — No Comments

Oracle e-Business Suite Blog Opened - http://oracleebsapps.blogspot.com

Hi,

 

I opened my blog especially handling the Oracle e-Business Suite. As an Oracle Functional and Technical eBS consultant I'll post articles with my experiences in implementing eBS. For example handy SQL statements for issue solving and going behind the standard functionality with writing new concurrent programs will be posted. Currently I'm working with eBS 11.5.10.2 and 12.1.3 for several clients.

 

Visit the blog at…

Continue

Added by Cyriel van Schaik on July 29, 2011 at 2:27pm — No Comments

please help me doing this

I am a freshers and i know oracle and c,c++ but i unable to do this,if any one can give me some idea please send it to me
Write a C/C++ program to add a user to MySQL. The user should be permitted to only "INSERT" into the given database.

Added by RAJESH KUMAR MOHINI on July 29, 2011 at 12:35pm — No Comments

11.2 RAC’s New Goodies, Node UnPinning….

From the past few months, I have been delivering a lots of sessions on 11.2 RAC and I must say, there are many new things which are being added to it. There are some more highlighted pieces  about the changes and some are not so much. So I have thought that I shall share those new goodies which didn’t qualify to be come in the limelight here  . Please note that that all what I shall mention is not an earth shattering news and/or internals. These are just notes or pointers about stuff that I… Continue

Added by Aman Sharma on July 28, 2011 at 9:49pm — No Comments

Interview with Hans Forbrich – Oracle ACE Director and Oracle Expert

In 1969 I had the opportunity trough the University of Calgary (UofC) to use their computers and write my first program. Not long thereafter, in the 1970s I worked as a contractor writing Fortran programs to pay for my university education. Perhaps the most interesting thing in my history is that I attended UofC Electrical Engineering at the same time that James Gosling attended the same school in Computer Science.

 

 1- Why did you choose to specialize in Oracle…

Continue

Added by Wissem EL KHLIFI on July 28, 2011 at 4:28am — No Comments

RAC Database tape Restore to a new server



Introduction:

The goal of this article is to build a step by step document which helps you to restore your RAC database from tape to a new host. The destination host may have a database running or not.

It is always possible to have your test environment to setup the tape MML and the servers. In my case, this is an exercise to know better how RMAN restore works.

In this document, I am using RMAN to backup the RAC database. The RAC database is 11g…

Continue

Added by Wissem EL KHLIFI on July 27, 2011 at 12:53pm — No Comments

Oracle Database Firewall

Most of have heard about Oracle Database Firewall that was released recently.. it adds to a host of other database security products that Oracle has such as Audit Vault, VPD, Secure Backup etc. Read more about it on my post

I will be glad to hear your thoughts and feedback. Share and rate it if you like it.

Added by Siba Prasad on July 22, 2011 at 3:00am — No Comments

Replacing a damaged Hard Disk on Exadata Cells

A task that you will most likely encounter during the administration of Exadata is the replacement of a damaged Hard Disk on the storage servers:

http://uhesse.wordpress.com/2011/07/19/replacing-a-damaged-hard-disk-on-exadata-cells/

Added by Uwe Hesse on July 20, 2011 at 8:38am — No Comments

11gR2; Sqlnet.ora and Oracle Restart

What’s the effect of adding this entry SQLNET.AUTHENTICATION_SERVICES = (NONE) to the SQLNET.ORA file?

To enable password authentication for sys user, I used to add the SQLNET.AUTHENTICATION_SERVICES = (NONE) to the SQLNET.ORA.

But, this is making serious problem in RAC and grid infrastructure installations. Remember that Oracle Restart which was introducted with Oracle 11gR2 is the framework responsible of the availability of the Oracle database components. Oracle Restart uses…

Continue

Added by Wissem EL KHLIFI on July 18, 2011 at 2:27am — No Comments

Patch 12311357 – 11.2.0.2.2 Patch Set Update Standalone grid infrastructure

 

This is my experience with the Patch 12311357 – 11.2.0.2.2 Patch Set Update Standalone grid infrastructure.

In my precedent post, article I have shown how to apply the Patch 12311357 in RAC environment.

1- Backup the database:

First of all, it-s recommended to backup your database with RMAN.

2- Update the Opatch version;

Make sure you have updated the Opatch with the latest…

Continue

Added by Wissem EL KHLIFI on July 17, 2011 at 12:34pm — No Comments

Trace Materialized views;

One of my colleagues raised the issue that she ‘s not able to see the truncate or delete statements when she tries to trace 5 materialized views in only one refresh shot.

This behaviour does not occur in the case of 1 materialized view refresh.
I came across the issue after an investigation and I found the solution, so I wanted to share it.

 

Read more here: http://wp.me/p1hlba-xA

 

Wissem

Added by Wissem EL KHLIFI on July 17, 2011 at 12:32pm — No Comments

RAC 11.2.0.2 Patch 12311357 – 11.2.0.2.2 GI Patch Set Update and mutex patch – 4 Nodes on Redhat Linux

 

Follow the Readme.html or .txt for each Patch:

* Update Opatch

* Patch 12311357 – 11.2.0.2.2 GI Patch Set Update (Includes Database PSU 11.2.0.2.2)

* Patch for Bug# 12431716 for Linux x86-64 Platforms; mutex patch

You can find below the steps we followed to patch both grid infrastructure and database homes for RAC 4 nodes on Redhat Linux:

 

FOR EACH NODE DO THE FOLLOWING: The cluster should be up and running to apply…

Continue

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

LGWR redo write times (log file parallel write)

General ***rule of thumb*** I’ve heard and buy into is that decent log file syncs times should be 3ms or under. Well “log file sync” depends on “log file parallel write” times, and “log file parallel write” times depend on the size of the write, thus I looked at some different log write sizes on a Solaris system with redo files on a SAN with plenty of write back cache and 4Gb FC and there are the distributions I saw on this single system

In the following charts

  • X axis is…
Continue

Added by Kyle Hailey on July 15, 2011 at 1:22pm — No Comments

About Oracle DBA career

Dear All,

 

I am working from last 4 years as an Oracle DBA on 9i and 10g but in my organization i don't have lots of work on oracle.

So i have to work many other things with oracle.

 

Now, I am really confused about my career. Should i work as an oracle dba or should i change my career.

 

Todays world every organization wants RAC but i have knowledge of Basic Oracle Administration and RMAN.

Pleaes let me know what should i…

Continue

Added by Anil Kumar Verma on July 14, 2011 at 11:47pm — 4 Comments

Oracle VM Images for Developer community

So, Oracle has pre-installed development stacks in Oracle VM which can be used to quickly setup your development environments. Here you go - blog post

Added by Siba Prasad on July 14, 2011 at 4:11am — No Comments

Important Statistics & Wait Events on Exadata

With this posting, I’d like to highlight the most important Statistics & Wait Events on Exadata that a DBA needs to be familiar with in my view:

http://uhesse.wordpress.com/2011/07/06/important-statistics-wait-events-on-exadata/

Added by Uwe Hesse on July 13, 2011 at 1:24am — No Comments

SQL*Plus output in nice HTML format

Every DBA knows that: SQL*Plus is a powerful tool, but its output is often almost unreadable. Do we have to format everything carefully with col commands or change to a more comfortable GUI instead? No!

http://uhesse.wordpress.com/2011/06/30/sqlplus-output-in-nice-html-format/

Added by Uwe Hesse on July 13, 2011 at 1:23am — No Comments

Database upgrade guide

Came across a very useful database upgrade guide on Metalink - Read on my blog

Added by Siba Prasad on July 5, 2011 at 9:06pm — 1 Comment

Monthly Archives

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

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

Oracle Blogosphere

Loading… Loading feed

Badge

Loading…

Blog Posts

Do What You Do Best and Outsource the Rest

One of the most valuable assets of an organization, data lies at the heart of business. It impacts everything from customer service to email deliverability and ultimately revenue generation. If the data that you have is not accurate, it will have a direct impact on your company’s ability to meet…

Continue

Posted by Alvaro Dee on February 7, 2017 at 2:07am

Draw Actionable Insights and Make Better Decisions with Data Mining Services

Data Mining is the process of analyzing and extracting crucial information from a database and presenting the same in an appropriate way to help business cut cost and boost revenue. In simple words it is the process of drawing crucial and actionable insights, which is imperative for better decision making.

Data mining is crucial for effective management of your business. It is also used for verifying whether or not the strategies are going as planned so as to provide desired results.…

Continue

Posted by Alvaro Dee on February 1, 2017 at 4:02am

Attain Data Accuracy, Competitive Pricing, and Quick Turnaround Time by Outsourcing Data Entry Services

In order to focus on crucial business activities, organizations worldwide prefer outsourcing data entry services to reliable service providers. Though redundant but highly crucial, data entry still remains an important component of document management and requires vigorous quality checks. Outsourcing data entry tasks to experts ensures affordable and quality output while saving time and resources that can be…

Continue

Posted by Alvaro Dee on January 31, 2017 at 4:49am

Present and Exchange Documents Reliably With Portable Document Format

Are you having data in large volumes that needs to be converted from hard copy to PDF format? Can you imagine how much time it would take you to manually convert this data? Well, if you know, then what’s the point of putting in lot of efforts and time?

With the help of PDF data entry services, this task can be made a lot easier. Data entry experts can help you save time and efforts…

Continue

Posted by Alvaro Dee on January 25, 2017 at 3:38am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service