Posts Tagged ‘11gR2’
Poll on Sql Plan Management
Dominic is conducting poll on SPM and Sql Profiles usage on his website. Link can be found here I have been using SPM and SQL Profiles (using coe_xfr_profile.sql) to fix plans for queries and believe me its very easy and quick way of fixing problems in production [Read More]
ORA-7445 core dump [kokscold()+849] from EM 12c
The first problem reported by my EM 12c is an ORA-7445 error. After checking the alert log following is the exact message: Sun Feb 19 12:09:41 2012 Errors in file /u01/app/oracle/diag/rdbms/pkldb/pkldb/trace/pkldb_j035_14712.trc (incident=52961): ORA-07445: exception [Read More]
11gR2:Listener Startup Issues
In this blog post I will be discussing listener startup issues faced in 11gR2 RAC. I will be constantly updating this post based on my experiences or any comments on this blog post. Let’s get started.You will experience following errors while starting listener using [Read More]
Changing CRS/Database timezone in 11.2.0.2 post install
I had installed a 11.2.0.2 RAC setup few days back with incorrect timezone. It had to be PDT but I installed with UTC. Starting/stopping clusteware with correct timezone didn’t solve the issue. In 11.2.0.2 Oracle stores timezone information in file [Read More]
Oracle Database Appliance Introduced
Oracle has introduced it new product: ODA (Oracle Database Appliance) I was not able to join Oracle President Mark Hurd’s webcast where he supposed to announce a new Oracle product, now viewing this webcast HERE Kerry Osborne has shared information about this product, [Read More]
CRS-4640 Error on Starting 11gR2 clusterware
I was working on a issue where in Clusterware was not coming up as private interface was down. Following errors were recorded in ocssd.log which informed that issue was with private interface 2011-08-31 15:03:38.051: clssnmvDHBValidateNCopy: node 2, testrac2, has a disk HB, [Read More]
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]
In-Place Upgrade 11gR2 RAC : 11.2.0.1 To 11.2.0.2
Sharing a post from my friend “Carthik” on 11gR2 RAC in-place upgrade. Overview ======== Starting oracle 11gR2 the Oracle database and Clusterware upgrades are done via the “Out of place upgrade”. And is the easier way to perform your upgrade. [Read More]
BUG:10082277: Database Connections failing with ORA-4031
A short write-up on a problem faced in few newly upgraded databases to 11.2.0.1 : I faced this issue in couple of databases which were recently upgraded to 11gR2, the problem is so severe that even connecting using “/ as sysdba” is not working and erroring out [Read More]
BUG: Creating 11gR2 RAC Using VMware On Toshiba Laptop
I was setting up 11gR2 RAC grid infra on my new Toshiba L745 series laptop on OEL5.4, the installation was going very smoothly but suddenly the VMWare machines crashed while performing remote operations on second node with following message: <span [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]
Adding a reinstalled/reimaged node back to 11gR2 Cluster
There could be a scenario of node crash due to OS/hardware issues and a reinstall/reimage of the same. In such cases, just a normal node addition would not help since the OCR still contain the references of original node. We need to remove them first and then perform a [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]
