-
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…
-
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…
-
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…
-
Advanced mysql replication: how to replicate only certain tables
The title is actually misleading just because I wanted to keep it short.What I wanted to achieve was to replicate 2 databases on another mysql server. Furthermore the replicated database should have different names from the sources and one of the 2 databases needed to be replicated only on a subset of tables. I couldn’t really…
-
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…