Author Archive
11gR2:Enable and Disable Oracle Feature with Chopt
Oracle has introduced a utility called Chopt in 11gR2 to enable/disable few database features after database installation. To perform this, you need to shut down database and run the utilty present under $ORACLE_HOME/bin. Find below list of options allowed Value Description [Read More]
10gR2 Silent Install with 11gr2 CRS fails
I was trying to perform a 10.2 silent install with 11gR2 CRS. While doing pre-checks installer failed with following error Check complete: Failed <<<< Problem: The 'active' version of Oracle Clusterware is not 10g Release 2 (10.2). Recommendation: You [Read More]
10.2 CRS startup issue
Today I faced a strange issue with CRS post host reboot. CRS was not coming up and we could see following message in $ORA_CRS_HOME/log/<hostname>/client/clsc*.log cat clsc26.log Oracle Database 10g CRS Release 10.2.0.4.0 Production Copyright 1996, 2008 Oracle. All [Read More]
ORA-00132 while starting 11gR2 database
Short post on a error which can take lot of time to debug. You have upgraded a database and after restoring all files (init,tnsnames) try to startup 11g database and it fails with following error SQL> startup nomount ORA-00119: invalid specification for system parameter [Read More]
Retrieving Database SID,Port information from Grid Control repository
This is short posting on sql which can be used to get Hotsname,SID,Port information for databases registered in Grid Control repository. This information can be used to create a tns entries and we can further use it to run a sql on all these databases. set pages 999 lines [Read More]
October 2010 Blogroll Report
It’s been time since we saw log-buffer edition with last being published on 1st October 2010 and Coskan’s weekly blogroll report I found them really useful to read top blog articles for week. So I decided to tag few articles posted in October 2010 which I [Read More]
Steps to Upgrade 11.2.0.1 RAC to 11.2.0.2
This post is in continuation to Grid Infrastructure upgrade post written earlier. Ensure that you have downloaded the software and have upgraded the infrastructure database. Following files contain database software for 11.2.0.2. p10098816_112020_Linux-x86-64_1of7.zip [Read More]
Upgrading Grid Infrastructure 11.2.0.1 to 11.2.0.2 on RHEL4
11.2.0.2 Patchset was released few days back. I decided to upgrade a test RAC database to 11.2.0.2 yesterday and was able to do it successfully. I will be documenting the steps here for easy reference Environment Details 2 node RAC on Red Hat Enterprise Linux AS release 4 [Read More]
11.2.0.2 Patchset available.Download directly to server
11.2.0.2 Software is now available for download. It contains 4G+ binaries as you now perform out of place upgrade i.e software is installed in separate home from current home. You can also use it to install 11.2.0.2 directly instead of upgrading from 11.2.0.1. Use wget to [Read More]
Renaming Diskgroup containing Voting Disk and OCR
Recently encountered a issue where we had to rename a diskgroup for 11.2 RAC containing OCR and Voting Disk.At this moment we had not created database . I had done similar activity on 11.2 Single instance having database files (see this post) using renamedg. Therefore we [Read More]
Finding blogging tough? Just copy and do find and replace
Well this is motto followed by Guenadi Jilevski for his blog http://gjilevski.wordpress.com and he seems to get result too (14k+ hits) Timur Akhmadeev highlighted this content plagiarism by posting links of various articles copied by Guenadi along with original link. You [Read More]
Physical Corruption: ORA-1578 part 3
Recently we encountered a block corruption issue in 10g database on Linux x86 64 bit and using ASM for storing database files. Saurabh had earlier written articles on ora-1578. http://askdba.org/weblog/2008/04/physical-corruption-ora-1578-part-1/ [Read More]
Cloning RAC Database with RMAN fails with error
Steps for cloning a RAC database with RMAN is similar to cloning a single instance database. But while using rman duplicate in 10g, you will get following errors RMAN-00571: =========================================================== RMAN-00569: =============== ERROR [Read More]
DBMS_SCHEDULER jobs not running?
I came across this posting on OTN which lists down things to check in case your scheduler job is not . This is quite old and many of you would have already seen it. But for others and also for my future reference I am mentioning it here [Read More]
‘Metric execution timed out’ error reported by Grid
We use 10.2 Enterprise Manager Grid control to monitor our oracle database environments . Apart from the normal metrics provided by oracle we also use host based and sql user defined metrics which allows you to monitor almost anything . Coming back to the main issue, [Read More]
