Category Archives: Oracle in general

Persistent device naming (or binding) for running RAC on Linux (10g R2 clusterware and above)

Installing oracle clusterware has been made easier and easier from release to release. When installing 10g R1 you struggled with ssh equivalence, wrong directory permissions and script bugs was a pain. 10g R2 was better but still quite painful (especially … Continue reading

Posted in Oracle in general | 5 Comments

Oracle databases with ASM in normal redundancy mode

It´s been a while since my last post because i was busy doing some projects. One of these projects involved installing a rac cluster with ASM in normal redundancy mode. My experiences installing this configuration is covered in this article. … Continue reading

Posted in Oracle in general | 2 Comments

can we change kernel parameter in linux when oracle is running

I found the following question in my blog statistics: “can we change kernel parameter in linux when oracle is running” The answer is: Yes, of course! You can alter any kernel parameter as long as it don’t require a reboot. … Continue reading

Posted in Oracle in general | Leave a comment

Authentificate Oracle user passwords against Active Directory using Radius

I developed this topic last year while taking the OCP course. The instructor told us about oracle authentication and because i was a little bit bored i played around with it. My goal was to use oracle external authentication to … Continue reading

Posted in Oracle in general | 1 Comment

Metalink HTML (aka. “non-flash”) Interface

Classic Metalink retired the last weekend. New flash-bashed Metalink currently faces a lot of problems (to be honest: it is at the moment [12th November 2009] completely unusable). Beside this major errors there are other problems: such as incredible high … Continue reading

Posted in Oracle in general | Leave a comment

I am now an OCE (Managing Oracle on Linux Certified Expert)

As of today i successfully passed the exam to become an OCE. Next certifiecation i am working on is “Oracle Database 10g: Real Application Clusters Administrator Certified Expert”.

Posted in Oracle in general | 3 Comments

Logging syslog and database audit messages to an oracle database with rsyslog

A few months ago i tested yet another syslog implementation: rsyslog. Among all other available syslog implementation such as syslog or syslog-ng rsyslog offers some nice features such as: database support MySQL Postgres Oracle Failover log destinations syslog over tcp … Continue reading

Posted in Oracle in general | 16 Comments

Oracle 11g 2 Release for Solaris SPARC available

As of today (09th November 2009) Oracle 11g Release 2 is available for Solaris SPARC. You can download it from OTN. The release includes database, client and grid infrastructure (aka “clusterware” as well). According to the release schedule Oracle 11g … Continue reading

Posted in Oracle in general | Leave a comment

Which file system to choose for running Oracle on Linux

Beneath the battle of the operating systems (Windows vs.UNIX) there one argumentation after deciding for running oracle on Linux: The choice of the file system and the “correct” partition layout. This article will sum up what file system are certified … Continue reading

Posted in Oracle in general | 3 Comments

Oracle 11g Release 2 – RMAN compression comparison

Starting with Oracle 11g Oracle added several compression algorithms to compress data. They can be used for compressing tables, LOBs , compressed data pump exports or even RMAN backups. Unfortunately for some compression algorithms you need to purchase the “Advanced … Continue reading

Posted in Oracle 11g Release 2, Oracle in general | 15 Comments