DB2 Vs. Oracle

I was assigned to find some difference between DB2 and oracle. They are both enterprise level database management system. Tried to find some difference. DB2 Oracle DB2, allows administrators to run maintenance tasks, such as backups, space reorganization, etc., during a predefined window, typically during non-peak hours. DB2 allows you to run only a predefined [...]

Connect to Oracle from Java via JDBC for calling Stored Procedure

My application runs on postgre. I had spring-hibernate connection from my JSF to Postgre. But, for login I needed to connect to the mother application. My core application runs on oracle. User authentication can be found through a stored procedure. I couldn’t find anything, so that I connect to databases at a time. So, took [...]

Installing Oracle 10g in CentOS 5.5

My CentOS is ready to install Oracle 10g in Virtual Box. I have downloaded Oracle 10g’s Linux version of 32 bit form here and saved it in ‘/opt’.   Now, lets unzip it. cd /opt/ unzip 10201_database_linux32.zip Then, we will find a folder named ‘database’ in /opt.

Creating New Virtual Machine in Virtual Box – (For Dummies)

My motive is to perform a RND. Installing Oracle 10g in CentOS 5.5 I will do ir in Virtual Box 3.2 . So, Virtual Box + CentOS + Oracle. It’s a new combination for me. At first I have to create a virtual machine. The actual machine i’m is not good though, its Dell Optiplex [...]