sshsetup – 11gR2

Today i noticed the folder "sshsetup" in the 11gR2 Oracle Database patch sets which is a full installations of the Oracle Database software.The folder has the file "sshUserSetup.sh" which would be useful for creating User equivalence in RAC installation instead of manually copying ssh RSA and DSA to all cluster nodes. Few lines from the … Continue reading sshsetup – 11gR2

CRS and New Features in 11gR2

Recently i got a chance to upgrade 4-node RAC from 10.2.0.5 to 11.2.0.2 version. Don't worry the upgrade was successful 😀 In this blog post i just wanted to mention few changes (not all) in Oracle Clusterware which i saw. 1. OHASD --> Oracle High Availability Service Daemon.This is the daemon which starts every other … Continue reading CRS and New Features in 11gR2

No More ORA-1118 – cannot add any more data files: limit of XX exceeded

ORA-1118 occurs when the database has hit the MAXDATAFILES limit and to resolve it, you need to 1. alter database backup controlfile to trace; 2. Shu immediate; 3. Increase MAXDATAFILES in backed-up controlfile. 4. Move/Rename the existing controlfiles 5. Startup nomount 6. Execute the create controfile command 7. alter database open; The steps 5 and … Continue reading No More ORA-1118 – cannot add any more data files: limit of XX exceeded

Redo Logfiles BlockSize – Revisited in 11gR2

In November 2010 i had written blog "Minimum Size of Redo Logfiles and Their Block Size" where i mentioned that 512Bytes as the size of redo logfiles, which was not the totally correct to say.Oracle will use the underlying disk sector size as the BLOCKSIZE of redo logfiles which can differ from platform to platform. … Continue reading Redo Logfiles BlockSize – Revisited in 11gR2

Same SQL_ID with Different Execution Plans

Few days back i had a discussion with one of my team members regarding same sql_id having different execution plans.So, it was time to login and test myself 🙂 Oracle Database Version --> 11.2.0.1.0 17:01:58 ANAND@MATRIX> show parameter cursor_sharing NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cursor_sharing string EXACT 17:01:59 ANAND@MATRIX> show parameter optimizer NAME TYPE … Continue reading Same SQL_ID with Different Execution Plans