Monday 31 March 2014

Configure SSH equivalence For Oracle RAC

SSH password less Equivalence  in RAC nodes are the most important things that count as pre reqs for installing Oracle RAC for more than one node for all RAC related users like oracle who is owner of database and grid who is owner of grid infrastructure. Oracle 11g includes automatic password less equivalence but as you guys know if it returns an error it is one of the most hillarious thing you can ever face before Installing Oracle RAC (click the link for step by step guide of installing Oracle RAC) and at that time you always go for manual way which was very very difficult for new comers so here the easy way to configure password less equivalence for users in Solaris and Linux based operating systems.

Saturday 29 March 2014

How to Configure and Access CIFS Server on NETAPP Filler



NetApp Support File and Block at the same time dislike EMC which depends upon the hardware and have to buy block and file separately or you can go for unified in EMC Storage. well in this writeup I am going to share Cifs setup configuration via CLI. you will be required to have a user which have administrative access in you Active Directory, Active directory's primary and secondary Ip addresses and Time Server Ip Addresses for Time Sync. and yeah you must have CIFS license, NetApps allow you to create CIFS and share them once the CIFS license is purchased. Nothing is free, except maybe samba :D

Friday 28 March 2014

How To Update NetApp Filler DOT Version from 8.0 to 8.1

Storage upgrade is always a big and tricky task for storage engineers. So in this writeup I am going to share the procedure to succesfull upgrade of DOT version from 8.0 to 8.1 and I believe this procedure will help you to upgrade any DOT version of Any netapp storage product for fas32xx and fas62xx.In my scenario the storage is fas6240 and has been provisioned to other unix based servers. you can follow the same step if you going to upgrade your brand new storage you will be needed below mention softwares:

Monday 17 March 2014

How to Update File OE of VNX 5700 - VNX Series Operating Environment

The system comes pre-installed with the latest version of VNX OE software available at the
time of shipment.
In addition to upgrading the VNX OE software, the USM wizards can be used for installing
other software, such as language packs, software enablers, and disk firmware. For these
tasks, EMC provides the ability to create instructions tailored to your environment. Go to
the Update VNX software link on https://mydocs.emc.com/VNX to create these customized
procedures.


Sunday 9 March 2014

Oracle Optimizer Modes (All_Rows, First_Rows, Choose & Rule RBO)


The optimizer_mode is the most powerful of these silver bullet parameters and a change can radically alter the characteristics of your SQL execution workload. 

To see how important the optimizer_mode is to SQL execution, consider the following three-way table join which returns 100,000 rows:

Let’s run this SQL query with several different optimizer_mode values and observe the changes to the execution plans and SQL response times: