DBAToolZ

Lightweight Oracle DBA Tools

 

Archive for RAC

11gR2 clients connect to the database using SCANs

If you’ve extended your RAC cluster on a set of new nodes you already know how painful it can be to have to go through the list of your clients and make sure their SQL*Net configuration is up to date. 11gR2 solves this problem using Single Client Access Name (SCAN).
The single client access name [...]

11gR2 – raw and block devices – no longer supported

I was just reading up on the 11gR2 documentation for Grid Infrastructure Installation and finally we have a closure on the topic of RAW and BLOCK devices for OCR and VOTING disks:
With this release, OUI no longer supports installation of Oracle Clusterware files on block or raw devices. Install Oracle Clusterware files either on Automatic [...]

Using Flashback Database to strengthen Data Guard Setup

MAA recommends to enable Flashback Database on the primary prior to FailOver:
Enable Flashback Database to reinstate failed production databases after a
failover operation has completed. Flashback Database provides a second
very significant function, enabling fast point in time recovery if needed.
See: MAA_WP_10gR2_SwitchoverFailoverBestPractices.pdf
Enabling Flashback Database involves setting up flash recovery area and setting a flashback retention target which [...]

Oracle RAC’s share everything vs share nothing …

Google’s share nothing approach to application development has lead to the #1 search engine solution both in performance and functionality. Notice that I said “application development” because for the share nothing approach to work it needs to be built into the application from day one not as an afterthought.
On the other end of the [...]


My name is Vitaliy Mogilevskiy -- I started working with ORACLE Products in 1996 (Oracle v7, 7.3.4 was pretty good).

What you will find here is what works for me day in day out - 24x7x365 - simple ORACLE DBA Tools written using components that are available on every Unix platform with an ORACLE database -- sqlplus and KSH.

Do you have DBA questions? Head over to Ask DBA.

RSS DBA Forums


Recent Comments

  • Hans Forbrich: Douglas – your comment about ASM after Clusterware was true for 11gR1 and older. With 11g...
  • gurpreet: thanks…..
  • MVE: According to the 11gR2 documentation — “OCR and voting disk files can be placed either on ASM, or on...
  • Douglas: Dude, You can’t put the OCR and vote/quorum devices in ASM… Clusterware must be up before ASM,...
  • Craig: Easy to understand -as an Oracle newbie it was very usefull.Thx I followed your tutorial and I’m...

Categories

Blogroll


Archives