Tag: Oracle

Oracle Database Consolidation – What’s Your Story?

I’m working on a small story about database consolidation and interested to learn what are success and failures that others are going through. While we have our own experience at Pythian, I find it interesting to learn about what others are going through. If you have enough details, it would be nice to see your feedback along these lines…

Read More >

Seems Oracle is Giving us some Extra Time

I just read on Metalink (1130327.1) that we Commodore 64 users who have to patch our 10.2.0.4. will get extened support untill April 30, 2011

Read More >

ORA-00214 and Control File Mismatch

The scenario goes like this: The instance was in nomount stage and was unable to mount the database. Checked the uptime, and found that the server was rebooted some 5 minutes ago, and the instance tried to come up automatically but failed to mount the database. Checked the alert log and found the following error: ORA-214 signaled during: ALTER DATABASE MOUNT…Made a quick searched about ORA-00214 and it was about mismatched control files. It was probably due to the fact that control files got out of sync as the not-so-graceful reboot of the server was done without first cleanly shutting down the database. This is what doc says:

Read More >

Choosing the Appropriate Driver

For this blog I have compiled the main information regarding JDBC drivers specifically considering the 11gR2 platform, but the concepts and idea also apply for older platforms as well.

Read More >

Installing 11gR2 Grid Infrastructure in 5 Easy Lessons

It started out innocently enough: Two node RAC cluster on two Linux RHEL5 with Netapp NFS used as shared filesystem for all shared files. My favorite OS and storage, so I felt confident that clusterware installation will be as smooth as it usually is. I told the customer that this can be done in 3 hours. What I didn’t take into account is that this was my first 11gR2 installation, and that much have changed since 11gR1. As things turned out, it took over 20 hours of my time and a lot of help from colleagues and even former colleagues before we had a successful installation. The time it takes you to read this blog post (and any other on this subject) is likely to be time well spent.

Read More >

Oracle DBA & DEV: MERRY CHRISTMAS!

Just to make you smile and let you remember all those sweet holidays I would like to congratulate you and wish you MERRY CHRISTMAS! in Oracle style:

Read More >

Just Learned I have Passed 2 Oracle Certification Exams …

Hey ALL! I just got a very good present from Santa :) I Passed 1Z1-536 Oracle Exadata 11g Essentials and 1Z1-515 Data Warehousing 11g Essentials certification exams. How cool it is if small things like these can make you rejoice like a child :) I am still smiling ….

Read More >

11G R2 Cluster: AVOID using sqlplus & lsnrctl for Oracle

For last few months I was part of the Pythian’s team helping implement Oracle 11gR2 Clusters for different Oracle customers. All the implementations had different requirements and configurations, however, in all cases, the client’s DBAs made the same mistake over and over again. They used sqlplus and lsnrctl utilities to manage (start/stop) databases and listeners. This is totally wrong in the 11gR2 Cluster world. The following commands are just few examples on how you should start/stop Oracle processes

Read More >

DBD::Oracle and Oracle 11gR2 – Battle of Bits

11gR2, lib32 directory no longer exists and 32 bit libraries are no longer provided. Which means that there is no way to use 32 bit Perl to connect to Oracle. BTW. This applies to other 32 bit clients as well. I’ve heard that SAP can’t support 11gR2 for a similar reason. What do we do? Here are the options.

Read More >

DBD Release 1.27 Release Candidate 1

Sorry, no funny nick name for version 1.27 but here is the scoop on it anyway. This version removes ‘PERL_POLLUTE’ and adds in PL_ so it will be fully compatible with Perl 5.13. So in a nutshell 1.27 is a single issue maintenance release.

Read More >
Page 58 of 141« First Page...10...5657585960...70...Last Page »