12.13.2013

Upgrade to Oracle 12c [1Z0-060 ] exam is available now

A very quick note about the announcement of Upgrade to Oracle 12c - 1Z0-060 exam availability, it is no longer beta now. The exam has two sections, with 51 and 34 question respectively in each section with 64% and 65% passing margin. You must succeed in both sections in order to certify Oracle 12c upgrade exam.
However, I felt the exam fee is little higher, 245$, isn't expensive?

What you guys waiting for, go ahead, and upgrade your certification to the latest Oracle release. Its a good chance to upgrade to the latest release with a single upgrade exam, even if you are certified earlier with Oracle 7.3.

Here is the link for more information about the exam:

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-060

https://blogs.oracle.com/certification/entry/0856_18


Good luck with your exam!

10.28.2013

Exadata - a new learning cuvrve

Perhaps I might be touch late on adopting/exploring/reacting/coping up with the exadata, but, it was always my dream and passion to work with the technologies since the announcement. As we knew Exadata is not something we can download and configure that easily on PC like those of traditional database or RAC software. Luckily and with the immense help from one of my friends, I managed to simulate Exadata setup (faked) on my new Macpro Book, 2 cell servers and 2 Oracle 12c RAC db nodes. Believe me, they are running incredibly fast and I am already on my way to explore/test the capabilities of Exadata.

I have also set some goals so that I will not become lazy or go slow on what I am doing. Planning to appear Exadata Admin and Implementation Specialist certification this December and January. If you are one of me and on the same boat as I am, feel free to contact me to discuss about Exadata stuff.

Have a good day

10.23.2013

I am speaking @AIOUG - SANGAM13 conference

This post is specifically aimed to the folks back in India, mostly in Hyderabad or surrounding places.

Perhaps most of you probably knew that the All India Oracle Users Group (AIOUG) annual conference SANGAM13 will be taking place in Hyderabad this year. I have been trying my luck over the past couple of years to attend and present at least a session at the conference without a success. However, this time I determined not to miss the conference, and successfully proposed two sessions.

I am glad to inform you guys that I an able to make it to the conference this year and also delivering the following two technical sessions:

  • Oracle RAC 12c upgrade - best practices (9/11/2013)
  • Troubleshooting & Managing Clusterware - 360 degrees (9/11/2013)
Having said that, I am indeed super excited to visit Hyderabad after a very long time, as this will be my first visit to the city after almost a decade, yes, you read it correctly!. Though I belong to the same state, I couldn't get a chance to visit Hyderabad over the past 10 years or so. You guys can guess all my excitement. 

I strongly recommend and encourage all of you who live in India or Hyderabad not to miss the opportunity to attend the conference and meet with many world known Oracle Gurus, like, Arup Nanda, Gaja Krishna Vidyanatha, Murali Vallath, also many other local big shots.

For enrollment and more information about the conference, do visit the one of the following websites:


Look forward to seeing you folks at the conference.

Have a good time.

9.12.2013

Oracle Open World 2013 - attending & presenting

Most of us knew Oracle Open World 2013 event is fast approaching and the event will kick start in a few days time. I haven't talked much about the OOW13 event of late, therefore, I am sharing my plans over here.

  • attending Oracle ACE Directors briefing scheduled on 19-20 Sept 2013 at Oracle HQ
  • participating and speaking in the following two Expert panel sessions 
      • Session ID: UGF9774
        Session Title: Oracle RAC SIG Meeting: Expert Panel
        Venue / Room: Moscone West - 3004
        Date and Time: 9/22/13, 15:30 - 16:30
If you are coming to OOW13, you are most welcome and I will be glad to see you in my sessions.

I can't guarantee though I will try to bring all authors of 'Expert Oracle RAC 12c'  book together for an unofficial book singing event at the book shop.

Stay tuned for more updates!!

Good luck and look forward seeing you at OOW13.



Jaffar

8.17.2013

Deprecated database init. parameters in 12c

Here is a very short blog about all the deprecated database initialization parameters in 12c.  It is sometime becomes essential to be familiar with those database features and init. parameters that are either de-supported or deprecated in a new release of Oracle database before proceeding with the upgrade. This is because, some of the legacy applications upgrade decision either directly or in-directly depends on those changes.
To obtain a list of deprecated database parameter in 12c, use the following SQL statement:

SQL> SELECT name from v$parameter WHERE isdeprecated = 'TRUE' ORDER BY name;
 
Here is the list:
 
active_instance_count
background_dump_dest
buffer_pool_keep
buffer_pool_recycle
commit_write
cursor_space_for_time
fast_start_io_target
global_context_pool_size
instance_groups
lock_name_space
log_archive_local_first
log_archive_start
max_enabled_roles
parallel_automatic_tuning
parallel_io_cap_enabled
parallel_server
parallel_server_instances
plsql_v2_compatibility
remote_os_authent
resource_manager_cpu_allocation
sec_case_sensitive_logon
serial_reuse
sql_trace
standby_archive_dest
user_dump_dest
 
I am little bit surprised to see the sec_case_sensitive_logon parameter in the list.

6.28.2013

Useful MOS notes on 12c

Here is the list of useful MOS notes on 12c:


  1. Oracle Database 12c Release 1 (12.1) Upgrade New Features [ID 1515747.1]
  2. NOTE:1520299.1 - Master Note For Oracle Database 12c Release 1 (12.1) Database/Client Installation/Upgrade/Migration Standalone Environment (Non-RAC)
  3. NOTE:1493645.1 - Oracle Database 12c Release 1 (12.1) DBUA : Understanding New Changes With All New 12.1 DBUA 
  4. NOTE:1503653.1 - Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1)
  5. Oracle Database 12c Release 1 (12.1) Upgrade New Features [ID 1515747.1]
  6. RMAN RECOVER TABLE Feature New to Oracle Database 12c [ID 1521524.1]
  7. How to Merge Multiple Partitions in Oracle 12C [ID 1482263.1]
  8. How to Drop/Truncate Multiple Partitions in Oracle 12C [ID 1482264.1]
  9. How to Create Interval-Reference Partitioned Tables in Oracle 12c [ID 1519042.1]


Oracle Database 12c Technology Day worldwide

Oracle quotes that 12c comes with more than 500 new features. Join the Oracle technology day event to learn firsthand how the new multitenant architecture make it easy to deploy and manage database clouds.

You will learn the following:


    • Simplify database consolidation
    • Automatically compress and tier data
    • Improve application continuity
    • Redact sensitive data
Why waiting, select your city and enroll for the event now on http://www.oracle.com/us/corporate/events/database-12c-technology-day/index.html




6.26.2013

Upgrade, Migrate and Consolidate to Oracle Database 12c slide deck by Mike Dietrich

Mike and his team did it once again. This time its 12c Upgrade/Migrate.

Here is the excerpt from his blog:

with (sorry, we've did it again!) over 500 slides covering:
  • The brand new Parallel Upgrade including new Pre/Post-Upgrade-Fix-Ups
  • The new Full Transportable Export/Import Feature
  • Obviously Oracle Multitenant, which got talked about a lot as Pluggable Databases or Container Databases before
  • Plenty of new parameters, cool and very helpful features and much more ...
  • Download the slides Upgrade, Migrate and Consolidate to Oracle Database 12c
And of course, the slide deck will see some updates in the near future :-)
-Mike

You can download the slide deck on:

https://blogs.oracle.com/UPGRADE/entry/finally_oracle_database_12c_is

6.25.2013

Oracle Database 12c - download on https://edelivery.oracle.com/

Although Oracle yet to announce the release of Oracle Database 12c publicly, if you have got MOS login credentials, download Oracle Database 12c for Linux on E-Delivery site.

https://edelivery.oracle.com

However, the documentation is not open yet.

Enjoy and good luck with all your testing!!!!!!!!!


Update:

After few hours, Oracle now made the software/documentation available on OTN too for Linux/Solaris.

Software : http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
Documentation : http://www.oracle.com/pls/db121/homepage

Anticipating tons of blogs, posts, papers about 12c from you people.


6.16.2013

ORA-01115: IO error reading block from file (block # ) - a list of common causes

There are situations when a single issue could arise for different reasons. Will list out some of the common causes of an 'ORA-01115: IO error reading block from file  (block # )' error over here.

Typically, when Oracle failed to read a data block from an open data file, it throws an ORA-01115 error.  Before you suspect any database issue, it is advised to have a close look at the error message stack presented before and after the ORA-01115 error in the database alert.log file. As there could be a different reason for this error when comparing the same error over the net or previous occurrence, it is pretty important that you isolate the issue looking at the other error messages represented along with this error.

One of the following would be the most common reasons for the error:
  • the datafile in the context is OFFLINE
  • database might have lost communication with the underlying ASM instance
  • caused by any hardware problems
  • physical data block corruption at the storage level
  • a Oracle BUG
We have encountered similar issue in one of our RAC databases due to communication loss with the underlying ASM instance. Here is the alert.log entries:

WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
ERROR: paging ASM fault extent map failed gn=28 fn=256 extet=715
Errors in file /u00/app/oracle/diag/rdbms/xxxDB/xxxDB2/trace/xxxDB2D2_ora_21886.trc:
ORA-00704: bootstrap process failure
ORA-01115: IO error reading block from file  (block # )
ORA-01110: data file 1: '+DG_DATA/xxxdb/datafile/system.256.680619545'
ORA-15055: unable to connect to ASM instance
ORA-15055: unable to connect to ASM instance
ORA-00020: maximum number of processes (100) exceeded
ORA-00704: bootstrap process failure
ORA-01115: IO error reading block from file  (block # )
ORA-15055: unable to connect to ASM instance
ORA-15055: unable to connect to ASM instance
ORA-00020: maximum number of processes (100) exceeded
Error 704 happened during db open, shutting down database
USER (ospid: 21886): terminating the instance due to error 704
Instance terminated by USER, pid = 21886



In a nutshell, you must examine the error stack message when you encounter similar issue to diagnose the real cause of the problem.

NOTE: I welcome your inputs, additions and you want to share your experience on this issue.

6.13.2013

Rejoining a node to a 2 node cluster on Windows Platform - Yet another learning experience

There was a situation encountered a couple of days ago where a node (second node) had to rejoin to a 2 node cluster environment on Windows 2008 platform. The Windows OS admin team rebuilt the 2 node after OS crash without DBAs being informed and requested the DBA team to rejoin the node to the existing cluster. Although the second node was clean, after the rebuilt, it wasn't properly removed from the cluster.

When addNode.bat procedure was initiated on the node 1, it failed with the following errors:

Error ocurred while retrieving node numbers of the existing nodes. Please check if clusterware home is properly configured.
SEVERE:Error ocurred while retrieving node numbers of the existing nodes. Please check if clusterware home is properly configured.


The error string doesn't yield any obvious reason of failure. And the following has been reported in the addnode_action*.logs:

Node is okay
--------------------------------------------------------------------------
INFO: Setting variable 'REMOTE_CLEAN_MACHINES' to 'xxxxxdb2'. Received the value from a code block.
INFO:  cannot initialize cluster interface skgxn error number 1311719766   operation skgxncin   location forced vacuo Could not initialize cluster
INFO: Vendor clusterware is not detected.
INFO: Error ocurred while retrieving node numbers of the existing nodes. Please check if clusterware home is properly configured.
SEVERE: Error ocurred while retrieving node numbers of the existing nodes. Please check if clusterware home is properly configured.
INFO: User Selected: Yes/OK

Both the reasons misleading in my cause though. I have verified and ensured that the cluster home is properly set before executing the addNode.bat procedure. However, the other error  'INFO:  cannot initialize cluster interface skgxn error number 1311719766   operation skgxncin   location forced vacuo Could not initialize cluster' caught my attention. Upon a little research over the net and My Oracle Support (MOS), it takes and guides me to another direction. One of the metalink  notes mentioned that this issue causes while adding the RDBMS (RAC) home not the GI home. This is due to missing olsnodes execute. If you find lsnodes, you must replace it with olsnodes and re-try the addNode.sh procedure. Fortunately, in our case, the olsnodes executable exists in GI and RAC homes.


Since the node wasn't removed properly, I wanted to have a look at the inventory to verify about the current nodes list. I found that the inventory still has the entry about two nodes. What all I have do was update the inventory (which is usually a post delete note step) and ensure only one node is listed. I did update the inventory with one node for GI and RDBMS homes. After updating the inventory, the addNode.bat procedure went smoothly and managed to add (rejoin) the node succesfully.


The bottom line is, in most circumstances, the errors reported doesn't give the right direction. Hence, it is pretty important that you review different logs, understand the history and sometimes need to think out-of-the box.



5.31.2013

Introducing Java EE 7 - Live Webcast


Wednesday, June 12, 2013 / Thursday, June 13, 2013 

Two opportunities to come together with the Java community, chat with experts, and explore Java EE 7: 
9 a.m. PT / 12 p.m. ET / 5 p.m. London or 
9 p.m. PT / 12 a.m. ET (Thursday) / 2 p.m. Sydney (Thursday) 

The introduction of Java EE 7 is a free online event where you can connect with Java users from all over the world as you learn about the power and capabilities of Java EE 7. Join us for presentations from Oracle technical leaders and Java users from both large and small enterprises, deep dives into the new JSRs, and scheduled chats with Java experts.

Register for the event here.

Jave EE 7 updates (session recording and PDF)
https://java.net/projects/jugs/downloads/download/JavaEE_Update_ArunGupta_May30.mp3



5.28.2013

Expert Oralce RAC 12c - upcoming book

Here is the TOC for upcoming Expert Oracle RAC 12c book, which is slated to release sometime in August 2013 (of course subject to Oracle 12c announcement), published by Apress.


Table of contents

  1. Overview of Oracle RAC
  2. Clusterware Management and Troubleshooting
  3. RAC Operational Practices
  4. RAC New Features
  5. Storage and ASM Practices
  6. Application Design Issues
  7. Managing and Optimizing a Complex RAC Environment
  8. Backup and Recovery in RAC
  9. Network Practices in RAC
  10. RAC Database Optimization
  11. Locks and Deadlocks
  12. Parallel Query in RAC
  13. Clusterware and Database Upgrades
  14. Oracle RAC One Node
  15. Virtualized RAC - Setup DB Clouds - Part 1
  16. Virtualized RAC - Setup DB Clouds - Part 2
You might get about 29% off on pre-order copy at Amazon.

5.18.2013

A tricky standby database situation

A very tricky and interesting situation came-up this morning while configuring one of the standby databases of over 1.5TB sized . Whilst the database is being cloned to the DR site as part of the DUPLICATE..ACTIVE DATABASE command, which actually took more than 1.5 day, a couple of new datafiles were added to the primary database.  After cloning process was over, the newly build DR database was almost 2 days behind withe the primary database. I knew I can make it in SYNC the PRIMARY and STANDBY applying the standby roll-froward method, but, I already have a daily cumulative incremental backups on TAPE.  If I perform incremental backup to do the roll-forward upgrade, it gonna take much time. Hence, I determined to make use of the existing backups. When the the roll-forward method was followed, the following confronted:

RMAN> SWITCH DATABASE TO COPY;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch to copy command at 05/18/2013 10:25:29
RMAN-06571: datafile 58 does not have recoverable copy


Obviously, it was expected, because the datafile in the question was added after standby database creation initiations.

Workaround:
Had to try out-of-the-box solution (roll-forward method).
  1. Re-create and restore the standby controlfile
  2. Restore missing datafiles on the standby
  3. Catalog standby database datafiles (diskgroup was different from primary)
  4. Recover the database
  5. Complete the rest of the standby configure to make it in sync 
Will be writing a detailed article on this. Stay tuned for more.

Happy reading

Jaffar


5.14.2013

New Page - Data Guard

A quick update about the new page.

I have created a new page (tab) 'Data Guard' on my blog to share/discuss all data guard related issues that we confronted during our extensive DR setup and testing. The objective is to record all the errors/issues of data guard setup and how we resolve them. Also, I will be sharing the DR configuration procedure and the best practices that we used in our environment.

Appreciate your inputs, and if you are interested to share/write something on the subject matter, do write to me, I will put it on the page under your name.

Have a nice day,

Jaffar


5.11.2013

Its data guard time for the team yet again

Just a very quick update about my upcoming tasks and what I will be doing for the next 3 weeks time.

It is indeed going to be a super busy rest of the month for the entire team as over 41 RAC databases data guard configuration need to be done.  We will be pretty engaged and occupied for the next 3 weeks creating standby databases and configuring DG setup in the context to have a fully functional DR environment.

We have done similar practice in the past (a few months ago) to test the DR capabilities for database and application, and now its time to have a permanent DR configuration. Therefore, anticipate a lot of blogging about DR stuff in the coming days at my blog.

Wish me luck people.


Jaffar


5.03.2013

Things to be considerd before/after the OS patch deployment

The objective of this write-up is to emphasize the importance of considering things like verifying the patch compatibility and  relinking the Oracle home after patching the underlying Operating System (OS)  in any Oracle environment. I would like to share an incident (a little story) that we encountered a few days ago in one of our non-production RAC environments where the Clusterware stack didn't start after the OS patch deployment.

As part of the patching policy set in the organization, our HPUX admin scheduled the latest quarterly HPUX v11.3x OS patch deployment activity on all servers, and a non-RAC and Oracle RAC environments have patched in the context. Though the patching activity went smoothly on both the environments,  we faced issues starting the Cluster stack in the Cluster environment. When the cluster stack status was verified, we have noticed that the Cluster Synchronization Daemon process (cssd) was in 'STARTING' state, as shown below:


$ ./crsctl stat res -init -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
      1        ONLINE  OFFLINE      rac1                     
ora.cluster_interconnect.haip
      1        ONLINE  OFFLINE      rac1                     
ora.crsd
      1        ONLINE  OFFLINE      rac1                     
ora.cssd
      1        ONLINE  OFFLINE      rac1                     STARTING                
ora.cssdmonitor
      1        ONLINE  ONLINE       rac1                      


Oracle High Availability Daemon process (ohsd) started without any issues, however, the crsd couldn't be started on any of the nodes after the patch deployment . Upon examining the ocssd.log, it was found that some how the voting disks were not able to discover by the process, hence, the crsd process couldn't start and the following messages appeared in the ocssd.log:

CRS-1714:Unable to discover any voting files
2013-04-23 18:47:16.553: [ SKGFD][6]Discovery with str:/dev/rdsk/c0t5d5,/dev/rdsk/c0t5d4:

2013-04-23 18:47:16.553: [ SKGFD][6]UFS discovery with :/dev/rdsk/c0t5d5:
2013-04-23 18:47:16.559: [ SKGFD][6]Fetching UFS disk :/dev/rdsk/c0t5d5:
2013-04-23 18:47:16.559: [ SKGFD][6]OSS discovery with :/dev/rdsk/c0t5d5:
2013-04-23 18:47:16.559: [ SKGFD][6]Discovery advancing to nxt string :/dev/rdsk/c0t5d4:
2013-04-23 18:47:16.559: [ SKGFD][6]UFS discovery with :/dev/rdsk/c0t5d4:
2013-04-23 18:47:16.564: [ SKGFD][6]Fetching UFS disk :/dev/rdsk/c0t5d4:
2013-04-23 18:47:16.564: [ SKGFD][6]OSS discovery with :/dev/rdsk/c0t5d4:
2013-04-23 18:47:16.564: [ CSSD][6]clssnmvDiskVerify: Successful discovery of 0 disks
2013-04-23 18:47:16.564: [ CSSD][6]clssnmCompleteInitVFDiscovery: Completing initial voting file discovery
2013-04-23 18:47:16.564: [ CSSD][6]clssnmvFindInitialConfigs: No voting files found

From the messages it was pretty clear that for some reasons the voting disks (placed on the shared storage) are inaccessible to the node/s. When searched over the internet and in the My Oracle Support (MOS) with the combination of error codes, all the links were pointing to verify the ownership and permission on the voting disks. We found there were no issues with regards to the ownership and permissions on the voting disks, we even dumped the the disks with the DD command found no corruption and no ownership/permission issues.  After 1 hour of hard struggles, there was a little hope about the issue when we come across of a MOS note (id 1508899.1) that explained an incident close to ours.
According the note, this issue was due to a bug : 14810756 and the workaround is to apply patch: 14810756 or rollback the OS patch PHCO_43004. There was no chance of applying the patch for us as we were not able to start-up the cluster, hence, we verified with the OS admin whether PHCO_43004 is part of the bundle patch that deployed a while ago on HPUX 11.3x plat form. The OS admin then confirmed us that the particular patch is indeed part of the patch bundle deployed a while ago. We then requested the OS admin to roll-back the patch in the context to try our luck. After rolling back the patch from a node, Clusterstack successfully started on the node. We did the same on the rest of the nodes and everything came back successfully.
The MOS note states that the issue likely to happen during the execution of the rootupgrade.sh script as part of the the cluster upgrade from 11.2.0.2 to 11.2.0.3 on the HPUX 11.3x platform, and when the voting disks is placed on disk/raw devices.
We fail to understand why the HP didn't mentioned about this behavior despite there were similar issues recorded and addressed on the HP forums.

Conclusion:
The motive of his blog entry is emphasize the importance of verifying the compatibility of the PATCH before deploying in any environment.
Also, it is highly advised to relink the binaries manually right after the OS patch deployment. The following demonstrates how to relink the binaries in 11gR2 GI RAC env.:

as the root user:
Unlock the CRS (ensure cluster stack is not running on the server)
$GRID_HOME/crs/install/rootcrs.pl -unlock

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk rac_on ioracle


References:
  • How to Check Whether Oracle Binary/Instance is RAC Enabled and Relink Oracle Binary in RAC [ID 284785.1]
  • hp-ux: 11gR2 GI Fails to Start or rootupgrade.sh Fails with "clsfmt: Received unexpected error 4 from skgfifi for file" if PHCO_43004 is Applied [ID 1508899.1]



4.05.2013

Managing & Troubleshooting Cluster - 360 degrees -- upcoming webinar

My upcoming webinar 'Managing & Troubleshooting Cluster - 360 degrees' sponsored/arranged by RedGate is scheduled on 25th April 2013. The following topic will be covered during the course of the presentation:


  • What's new in 11gR2 Clusterware – Key new features at a glance
  • Oracle 11gR2 Clusterware software stack
  • Clusterware start up sequence
  • CRS logs & directory tree structure
  • Analyzing CRS logs
  • CRS logs rotation/retention policy
  • Troubleshooting Cluster start up issues
  • Debugging/Tracing CRS components
  • Tools & Utilities – how to pick the right one
  •   Q&A
If you haven't enrolled yet, enroll now. Registration is limited!.

See you at the webinar (of course virtually).

Jaffar  

3.13.2013

Possible data corruption,ORA-600 on RAC instance shutdown

I am afraid, it is not a so good news for those who manage 11.2.0.1|2 RAC databases. On a very unfortunate day, an RAC database db | instance shutdown normal|transactional|immediate mode could result in an ORA-600 errors or may cause logical corruption to the redo stream .

According to the MOS ID [1318986.1] , when a RAC instance(s) (11.2.0.1|2) shutdown either in normal|transactional|immediate mode, there could be possibilities, under certain circumstances, of hitting the bug.1020523 which could produce either pool of ORA-600 errors or might also corrupt the data.  The following workaround is suggested in the note:

For complete RAC database shutdown:

    SQL> alter system checkpoint;
    srvctl stop database -d <db_uniqueue_name> -o abort -f

For one or more RAC instances, run the below for each instance:

    SQL> alter system checkpoint local;
    SQL> shutdown abort; or
    
    # srvctl stop instance -d <db_unique_name> -i <instance_name> -o abort -f

-- as the shutdown abort -f option complete by-pass the vulnerable code path of the bug:

The known downstream effect includes the following:

* Data corruption occurs around shutdown one or more of the RAC instances

* One of the following ORA-600 asserts:
- ORA-600 [kclchkblk_3]
- ORA-600 [kclwcrs_6]
- ORA-600 [ktubko_1]
- ORA-600 [kcratr_scan_lostwrt]
- ORA-600[3020] on the standby database

You may also refer to my earlier post discussion about choosing a quick database shutdown mode.


Reference:


2.27.2013

Database downgrade - MOS useful notes

Are you planning a database upgrade keeping a back-out (downgrade) plan in mid? Here are a few very important MOS docs explains all about:
  • How To Downgrade From Database 11.2 To Previous Release (includes 11.2.0.3-11.2.0.1) [ID 883335.1]
  • Database Server Upgrade/Downgrade Compatibility Matrix [ID 551141.1]
  • Master Note For Oracle Database Downgrade [ID 1151427.1]
  • Downgrading Database Without Executing catdwgrd.sql (11.1.0.x to 10.2.0.x/10.2.0.x to 10.2.0.x) [ID 783643.1]
  • Complete Checklist For Downgrading The Database From 11.1 To Lower Releases [ID 443890.1]

Welcome to the IOUG Cloud Computing Special Interest Group (SIG)

The IOUG Cloud Computing Special Interest Group (SIG) is dedicated to communication and information interchange around the subject matter of Cloud Computing centric to Oracle.
 The main purpose of the SIG is to discuss and share independent thought, challenges, options, and best practices on key areas of Cloud Computing from the perspective of Oracle. Topics will be discussed freely in this open forum and touch on prevalent Cloud Computing Paradigms/Technologies. 
The IOUG Cloud Computing SIG is led by the following thought leaders in the Oracle Community:
  • · President - Tariq Farooq, BrainSurface - Oracle ACE Director
  • · Vice President - George Trujillo, HortonWorks - Oracle ACE
  • · Vendor Liaison Chair - Michael Corey, Ntirety - Oracle ACE / VMware vExpert
  • · Vendor Liaison Co-Chair - Charles Kim, Viscosity NA - Oracle ACE Director
  • · Content and Resource Chair - Dr. Bert Scalzo, Dell - Texas Publishing / Oracle ACE
  • · Web Events Chair - Kai Yu, Dell - Oracle ACE Director
  • · Website Chair - Ron Batra, Oracle ACE Director
  • · Member at Large - Michael Ault, Oracle ACE - Texas Memory Systems
  • · Member at Large - Syed Jaffar Hussain, Al Inma Bank - Oracle ACE Director
  • · Board Liaison - Alex Gorbachev, Pythian - Oracle ACE Director"
 For more details and signing, visit here

1.22.2013

OTNYathra 2013 - scheduled between 15 & 27 Feb 2013

Just a very quick update about the upcoming event in your city (India).

If you are around in India, don't miss the OTNYathra event scheduled between 15 & 27 February 2013.  Many world known Oracle ACE Directors, Java champions and other experts are presenting. For more details and registration, visit the following links:

www.otnyathra.com or otnyathra.info 


Good luck to all the presenters and hope you people will enjoy the event.