Category: linux

  • Using HUGETABLE in oracle and “ORA-27125: unable to create shared memory segment”

    Using HUGETABLE in oracle and “ORA-27125: unable to create shared memory segment” On SLES9 hugetlb is enable by default and it could cause you problems.A good resource to resolve this kind of issue can be found here:http://linux.inet.hr/oracle10g_on_debian.html However on oracle9i if you wish to use this feature (without the DISABLE_HUGETLBFS=1 trick) you will need patch…

  • Connecting Oracle to sql server

    Connect Oracle to another DB This document will cover the use of Generic Connectivity which permits to connect oracle to a generic DB.The main requirement is the availability of an odbc driver. It is quite easy to find an ODBC on a windows system, not so much on a unix. Connecting to a sqlserver 2000…

  • Connecting Oracle to DB2

    Connect Oracle to another DB This document describe one of the most troublesome configuration I have ever set up.It took me almost two days to figure out how to properly set everything to make it works so I’m writing this documentation to spare a headache to other sysadmins/DBA who wish to achieve the same. I…

  • Connect Oracle to another DB

    Generic Connectivity permits oracle to communicate and exchange data with other vendor databases such as DB2, Sql Server, MySQL, ecc.

  • Oracle Myths for Unix Sysadmins

    Just a couple of myths (or discussions) that needs to be checked

  • Authenticate yourself with certificates

    Authentication via X.509 certificates Starting from the previous document  I’m going to describe a more complex configuration.Basically I’m adding a certification authority (faked by a third oracle wallet) to sign the client and server X509 certificates. I’m even introducing more complex DNs. Still the configuration is textual only (I’m still stuck to command line and…

  • Getting rid of the ASMlib without reinstalling your cluster

    Scope of the document Personally I’m not fond of the ASMlib. In the past I was always able to perform my RAC installation without using them. However, recently, I installed an oracle clusterware on Redhat. With very few time at my disposal I wasn’t able to find a good solution on how not to use…

  • Oracle on Suse

    The title  “Oracle on Suse” can be misleading. This section is a collection of the documents I wrote on the topic: Oracle. My testing operating system was Suse at that time. Probably, in the next future, you are going to see some new document based on Ubuntu (which is not oracle supported) or RedHat. I…

  • How to open a network document using KDE (and libreoffice)

    Recently I’ve switched from Windows 8 to KDE and I’m still trying to get used to the new environment. I’m missing some useful software (a good mysql client like Toad… likewise for Oracle and VMware client *sigh*). Recently I hit a new problem. With KDE I was unable to open libreoffice file on a network…

  • Toad for Mysql 7.0 on Linux

    Recently I switched from Windows 7 to Linux (Kubuntu) since I can’t put up with Windows 8 passing constantly from desktop to Apps. I’ve found KDE surprisingly customizable. The main problem was that I wasn’t able to find a good GUI for Mysql administration. I tested several programs (workbench, Valentina, etc) but I couldn’t find…