-
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…
-
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…
-
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 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.
-
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…
-
Oracle Advance security
This section started by chance but it is becoming a series in fast speed.I hope to add in a day or two a couple of papers on how to extend the authentication with certificates to Oracle Application Server, websphere and in general any application using jdbc. I really wish to thank Maxim Demenko for helping…
-
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…