Category: database

  • Heretical: Oracle Blocksize on Linux

    In particolar it is common practice to choose a DB block size identical to the filesystem block size when not using direct i/o. I’m going to discuss the use of I/O on linux system but I won’t extend my arguments to other unix flavours since I don’t know their i/o subsystems well enough. Steve Adams…

  • Oracle and linux I/O Scheduler

    Starting from the previous two papers and thanks to Jens Axboe advices I decided to start several test trying to tune the cfq scheduler. The database has been recreated as well as the TPCC schema. For this reason I performed a couple of benchmarch with the deadline scheduler as a baseline for the tests on…

  • Oracle RAC 10g x86 on SUSE LINUX Enterprise Server 9 x86

    Oracle has recently released a new 10g RDBMS version with the first service pack integrated: 10.1.0.3. It gives better support for SuSE and solves some installation issues.In addition, SuSE has released a new orarun version which makes the installation process a little bit easier.The plain RDBMS installation is the smoothest I have performed so far.…

  • 10gR2 CRS on SLES9 x86

    CRS is the clusterware software of oracle and it is the base for the RAC installation.I’m covering this in a separate document since the functionality of CRS 10gR2 are improved from 10gR1 and the API has been opened for third party and home made applications.In this way you can clusterize your own application on the…

  • Oracle 9.2.0.4 x86-64 on SUSE LINUX Enterprise Server 9 AMD64

    This mini-HOWTO will cover the installation of oracle on SLES9 (SUSE LINUX Enterprise Server 9) for x86 and AMD64 architectures.If you find any error imprecision or simply you have suggestions (or you need help) feel free to contact me. Some notes before starting:  As always I’d like to thank the people in the suse-oracle mailing…

  • Oracle 10gR2 client on SUSE 10 x86

    This installation has been done smoothly on SUSE 10 beta 2 (SUSE 10 is not out yet).I don’t know if I’m going to upgrade this document when other beta version will be out since everything works pretty well almost out of the box with one of the first betas. This installation has been quite simple…

  • Oracle 10g x86 on SUSE LINUX Enterprise Server 9 AMD64

    This mini-HOWTO will cover the installation of oracle on SLES9 (SUSE LINUX Enterprise Server 9) for x86 and AMD64 architectures. If you find any error imprecision or simply you have suggestions (or you need help) feel free to contact me. Some notes before starting:   10g for linux is only available (at this moment) as…

  • Oracle 10.1.0.3 x86-86 on SUSE LINUX Enterprise Server 9 x86-64

    Since my last document lot of things changed: a new release of oracle was released, a new SuSE service pack for SLES9 and a new orarun.For this reason I decided to write a new documentation which is going to explain how much easier is to install 10g on the SLES9 (and, of course, on SuSE…

  • Oracle 10.1.0.3 x86 on SUSE LINUX Enterprise Server 9 x86

    Since my last document lot of things changed: a new release of oracle was released, a new SuSE service pack for SLES9 and a new orarun.For this reason I decided to write a new documentation which is going to explain how much easier is to install 10g on the SLES9 (and, of course, on SuSE…

  • Oracle 10gR2 client on SUSE

    This document cover the installation on a general SUSE. It has been verified on SLES9 and SUSE 10 (beta 2). This installation has been quite simple and since it is client only I didn’t use orarun as for the server installation. Make sure you have the needed packages:  If you are on SLES9 then install…