THE WORLD DISCUSSES #PYTHIAN ON TWITTER. HAVE A QUESTION? USE OUR HASHTAG AND ASK AWAY.

Upgrade Exadata to 11.2.0.3

During last couple of month I was seeing some discussion and question in different online conferences and user groups about upgrade RAC and exadata to 11.2.0.3. The questions were mostly about upgrade procedure, timing, what can happen during the upgrade and how a system behaves after upgrade.

I’ve recently upgrade couple of exadata to 11.2.0.3 and want to share the experience. I hope this short note will help someone to make the decision, calculate estimation and prepare for maintenance. I am going to talk about upgrade from the version 11.2.0.2 BP10 to 11.2.0.3 BP2.

I. Preparation:
First, you need to read thoroughly oracle support note [ID 1373255.1] (strongly recommended as a primary guidance for the upgrade), make a general plan and calculate estimation time for every upgrade step. Most of the steps can be done in rolling mode and don’t require full downtime for the environment.

The second step is about gathering information about your current system and checking if your firmware and exadata software versions fulfill the requirements for 11.2.0.3.

Read the rest of this entry . . .

Updating ASMLIB driver using “update-driver”

It is a controversial question whether use or not ASMLIB for manage disks for a ASM instance but I don’t want to start a new discussion about it in this post. I want to talk about updating ASMLIB after or before updating kernel version.
We know that the ASMLIB driver is kernel dependent and has to be updated to match the kernel version. We have to go to the Oracle site, find the proper version for ASMLIB driver, download it and install. But beginning oracleasm-support version 2.1.0 and higher we can use the embedded function “update-driver” which can help us to save time and simplify the process of updating ASMLIB driver.
Read the rest of this entry . . .

Oracle GoldenGate Installation, Part 1

I want to introduce several post about Oracle GoldenGate (GG), a relatively new replication software from Oracle.

We all know replication using Oracle Streams technology. Streams are improving from version to version of the RDBMS, and now it is a very well managed and reliable technology with a large set of options and capabilities. But, in the document Oracle – GoldenGate Statement of Direction (PDF), GoldenGate software was announced as the strategic replication solution for Oracle Database, and Oracle plans to direct all efforts to improve it.Therefore, I think it is time to make the acquaintance of GoldenGate.

This first post is about installating GG software and creating the simplest replication using only the “extract” and “replicat” processes.

Lets start the installation. Read the rest of this entry . . .

Start NowWith Pythian - database design, management and emergency handling capabilities...

Live Updates

pythian: RT @FN_Press2: Schooner Information Technology Teams with Pythian to Deliver Advanced Support and High... http://finanznachrichten.de/20
more



Testimonials

  • Serge Racine

    DBA, Brookfield Energy

    We are very satisfied by the service given to us by Andre and Shakir in support of our recent data quality and reorganization initiative.... more



Social links powered by Ecreative Internet Marketing