Category: linux

  • Application Server 10.1.3 on SUSE LINUX Enterprise Server 9

    This document is based on a previous one on how to install as10gR2 on SLES9. You should start from that document since the pre-installation process is identical. The differences are few and involves only the installation GUI so the only purpose of this document is to show the snapshots of the installation process. Note: The…

  • 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…

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

    The installation of Oracle 10g on SLES9 x86 is a lot easier than the one on AMD64 so this document is going to be a sort of cut and paste of the x86-64 version without the parts not needed due to the native 32 bit architecture.As always any feedback (even negative) is welcome. Usual notes…

  • Clustering third party application with Oracle 10g Clusterware

    With oracle 10gR2 oracle decided to open and publish the API of it’s clusterware. This permits to third parti application to be registered in the oracle cluster layer or to develop your own high-availability (HA) solution.For the howto install step of the oracle cluster you can refer to this document (place here the link). The 10gR2…

  • Authentication with Certificates

    Recently I had to implement some more advanced security in my shop and I got very frustrated trying to collect information from internet.Googling around didn’t help me too much and the official oracle documentation was sometimes vague. So I decided to write down what I have down and why. This document is intended to help…

  • X.509 certificates with Oracle Application Server

    Starting from the first and second document I’m going to test the connection via certificates from an oracle application server to an oracle database. The steps will be: – application server security configuration (certificate generation),– connection pool and data-source definition.– test. My architecture: client: SLES9 with Oracle Application Server 10.1.3client name: breoraasls02 server: SLES 9…

  • Oracle, firewall and port redirection

    Port Redirection This paper collects some discussions I had on newsgroup and mailing list on oracle and the so called “port redirection”.It is intended to help ending the oracle myth regarding the use of oracle (on unix) and firewalls. The tests have been performed on Linux, AIX, Solaris.At the moment I haven’t got any other…

  • Oracle and linux I/O schedulers (part 2)

    This paper start from what were left behind in the previous one.It’s purpose is to further tests the capabilities and performance of oracle against different linux I/O scheduler.The workload of choice is transactional. Horahammer is going to simulate a TPC-C workload while the scheduler will be switched dynamically. The main difference compared to the first…

  • Oracle and linux I/O schedulers (part 1)

    Oracle and linux I/O SchedulerPart 1 Following the paper on the block size I decided to write something more on the Linux I/O schedulers and their interaction with oracle. This paper involves a series of tests stressing oracle with a TPC-C workload while the oracle DB rely on different linux schedulers. The purpose of the…

  • Asynch I/O on SLES

    Asynch I/O on Oracle Asynch I/O for 10gR1 Even on some documentation it is stated that async I/O is enable by default: you should need only to relink the binaries with the command: linux: # su – oracleoracle@linux > cd $ORACLE_HOME/rdbms/liboracle@linux > make PL_ORALIBS=-laio -f ins_rdbms.mk async_onoracle@linux > make PL_ORALIBS=-laio -f ins_rdbms.mk ioracle and set…