Exadata MAA Presentation – Oracle Day 2013 Istanbul

Exadata Maximum Availability Architecture from Yunus Emre Baransel

Packt Publishing e-book Promotion

I would like to inform you that, to mark Columbus Day, Packt is offering its entire catalog of eBooks and videos at 50% off. This is te last day of the promotion. If you plan to buy some e-books don't miss this. http://bit.ly/1bqvB29 Discount code: COL50 

The Book is Out!

After one year of hard work, it's very nice to introduce the Oracle Data Guard 11gR2 Administration book written by me and Nassyam Basha. As for me, i can honestly say that it has been a really good book and will help its reader a lot to learn and implement (more...)

Data Guard Queries

After all those years, my 5 years old post “How To Query Dataguard Status” still has the top visitors of this blog, so I wanted to write a fresh one including newer queries, commands. Here it is: Standby database process status: You can run following query on standby database to (more...)

TROUG – Oracle EBS Day 2013

About "Expert Oracle Database Architecture" Book

I'm reading the "Expert Oracle Database Architecture" book of Thomas Kyte, which is a must read for everyone who is serious on being an Oracle DBA. Jonathan Lewis already said: "Frankly, if every DBA and developer in the world were made to work carefully through Tom Kyte’s book, I’d probably (more...)

Delete Force Noprompt Backuppiece

In some cases you may not be able to delete the obsolete RMAN backup pieces that are visible with “report obsolete” command. In my case, after a switchover, i was getting the following error when my daily backup scripts tries to delete obsolete backups after the crosscheck: RMAN-06216: WARNING: db_unique_name mismatch - 334 objects could not be updated RMAN-06218: List of objects requiring

Moving OCR & Voting Files In 11gR1 (Using Raw Devices)

-- Query current status of OCR and Voting Files: oracle@server1:/> cat /etc/oracle/ocr.loc  ocrconfig_loc=/dev/ocr1_test11g ocrmirrorconfig_loc=/dev/ocr2_test11g local_only=FALSE oracle@server1:/> crsctl query css votedisk  0.     0    /dev/voting1_test11g  1.     0    /dev/voting2_test11g  2.     0    /dev/voting3_test11g Located 3 voting disk(s). -- Check OCR integrity

Basic Oracle LogMiner Steps

This is a quick note about using LogMiner for mining archived redo logs on the database itself. (Source and mining databases are same) - Specify a dictionary file with the following procedure: EXECUTE DBMS_LOGMNR_D.BUILD('dictionary.ora','/oracle/acs/logmnr', OPTIONS => DBMS_LOGMNR_D.STORE_IN_FLAT_FILE); - Determine the minimum and maximum archived log sequences that is in the mining scope. -

My Presentations at DOAG and UKOUG 2012 Conferences

At the end of this year, i'll speak at the two biggest Oracle events in Europe, DOAG 2012 and UKOUG 2012 conferences. I'm very excited to attend and experience these organizations, also listen to and meet with many Oracle fellows. I'll speak about advanced Data Guard topics on my both presentations. Here are the highlights of my presentation: Configuration Considerations Redo Apply and Redo

TROUG Day 2012

Türk Oracle Kullanıcı Grubu TROUG yılın en büyük etkinliğini 11 Ekim'de Bahçeşehir Üniversitesi'nde düzenliyor. Etkinlikte DBA ve Developer odaklı sunumlar farklı salonlarda gerçekleştirilecek. Açılış sunumunda  ACE Director, OCM ve DBA of the Year 2011 ödülünün sahibi Syed JaffarHussain "Oracle High Availability 11g New Features" üzerine konuşacak. Sonrasında birçok değerli Oracle

TROUG Exadata SIG Meeting 2012

TROUG Özel İlgi Grubu (SIG) etkinliklerine hız kesmeden devam ediyor. Nisan ayında gerçekleşen "TROUG Exadata SIG Meeting 2012" de Türkiye'deki Exadata kullanıcıları bir araya geldi ve birbirinden faydalı sunumlar yapıldı. Etkinliğin sonunda ise "DWH Global Leaders" program yöneticisi Reiner Zimmermann'ın katıldığı bir sohbet toplantısı gerçekleştirildi.  Siz de TROUG Exadata SIG

Book Review: Oracle Database 11gR2 Performance Tuning Cookbook

I started reading this book last week, and I'm half way through right now. But i wanted to write this review because what i found in the book is fairly enough for this. As the book's tittle expresses it involves examples, recipes, different test cases for almost all topics in the chapters. This is great, because just definitions and descriptions are not enough to fully understand the concept (

My Presentation at OUG Ireland Conference 2012

I'll present at OUG Ireland Conference, Wednesday 21st March in Dublin. My presentation will be on Oracle Data Guard as in the Open World last year. I'm looking forward to present, listen to and meet with new people. There are a wide range of topics from Oracle professionals in the agenda. There will be 6 streams and 35 sessions in total. Well known Oracle ACEs/ACE Directors and Oracle

Automatic Block Media Recovery on Maximum Performance Mode

Automatic Block Media Recovery is a cool 11gR2 feature. If the database on which a corruption occurs is associated with a real-time query physical standby database, then the database automatically attempts to perform block media recovery. The primary database searches for good copies of blocks on the standby database and, if found, repairs the blocks with no impact to the query that

A Grid Infrastructure Installation Adventure

I was very used to create ASM instance manually before 11gR2. With 11gR2 we must to install Grid Infrastructure even on sigle instance databases if we’re going to use ASM. In my last installation i had strange errors that i’ll share below. First error was complaining about the password and the log file is: INFO: Executing ASMCA INFO: Command /u01/app/oracle/product/11.2.0/grid/bin/asmca -

[INS-20802] Oracle Net Configuration Assistant failed

I had the following error on 11gR2 Grid Infrastructure installation: [INS-20802] Oracle Net Configuration Assistant failed.  The plug-in failed in its perform method tail -50 /u01/app/oraInventory/logs/installActions2012-01-06_09-45-58AM.log INFO: Oracle Net Listener Startup: INFO: The information provided for this listener is currently in use by other software on this computer.

Book Review: Oracle WebCenter 11g PS3 Administration Cookbook

I knew a little about Webcenter and Packt's Oracle Webcenter 11g book was very helpful for me to learn about the new version and developing the administration skills. Yannick Ongena did a greate job on this book with a uniqe style of teaching. In this book topics are covered with 4 dimensions. "Getting ready" "How to do it..." "How it works..." and  "There's more..." With this way of

Book Review: Oracle Enterprise Manager Grid Control 11gR1: Business Service Management

Here is another greate book i read and recommend, published by Packt and written by  Ashwin Kumar Karkala and Govinda Raj Sambamurthy. This is about Oracle Enterprise Grid Control. Book is named with "Business Service Management" to impress the capabilities of Grid Control. Grid Control is not just for your Database Monitoring needs, but also for a complete service management which includes

RMAN Channels, Parallelism, Multisection Backups & Multiplexing

I wanted to summirize some complicated RMAN concepts, using the "11gR2 Backup and Recovery User's Guide" definitions. Channel & ParallelismThe number of channels available for use with a device when you run a command determines whether RMAN reads from or write to this device in parallel while performing the command. When the work is done in parallel, the backup of the files is done by more than