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
Which DB my mview resides???
Today one of my friend called me and asked - Can we determine the database and the mview, from the database where mview log resides? The mview log was occupying lot of space which he wanted to drop and recreate, which was followed by complete refresh of mview (which used that mview log).He had no … Continue reading Which DB my mview resides???
Learn. Share. Repeat. 