Archive for the “Database” Category

SQL Server, Oracle, Mysql

xe_logoBest way to have a easy to access XE database and APEX on top of it is to put them on a Ubuntu Server virtual machine that I start just when I need.

Installation of 10g Express Edition should not take more than 10 minutes and the steps are below:

1. Prepare the swap space
If you have less than 1GB memory run the following commands to create swap space:

$ sudo dd if=/dev/zero of=/swpfs1 bs=1M count=1000
$ sudo mkswap /swpfs1
$ sudo swapon /swpfs1

Read the rest of this entry »

Tags: , , , , ,

Comments 20 Comments »

Trying to connect to SQL Server 2000 or 2005 from Oracle SQL Developer having Windows Authentication enabled on SQL Server will fail with:
“I/O Error: SSO Failed: Native SSPI Library not loaded. Check the java.library.path system property.”

The solution is simple: place a dll called NTLMAUTH.DLL (NT authentication) in your system path and restart SQL Developer. Windows/System32 is always a wise choice.

Where to get this DLL? It is shipped with JTDS here.

Is there another option? Yes, enable SQL Server authentication.

Related posts:

Tags: , , ,

Comments 2 Comments »

I’ve been told that there is no way to connect to a SQL Server 2005 named instance from SQL Developer. That’s not necessary true, but it’s strange.

A bit of background information: SQL Developer is connecting to SQL Server through JTDS opensource driver. The driver said that it cannot support named instances. On the other hand, in the connection string, there is a syntax for named instance, like “instance=your_instance“.
Read the rest of this entry »

Tags: , , , , ,

Comments 3 Comments »

Note! this is applicable at least for OEL, RedHat, Fedora, but probably to all recent linux flavors.

oel5I had a strange error today when trying to install an Oracle Enterprise Linux 5 on a brand new VM made with VMware server 1.0.5:
When I tried to create linux partitions inside the VM, I’ve got: “no valid devices were found on which to create new filesystems“… like the kernel didn’t see the VM disks.

After less than a minute of google-ing this, I found that the “Typical” configuration inside the VMware Server is creating a SCSI disk with BusLogic controller which is not supported anymore by the Linux kernel.

To overcome this, you must create either a IDE disk either a SCSI disk with a LsiLogic controller.

Good luck!

Related posts:

Tags: , , ,

Comments 5 Comments »

oracle_11g_database1. Introduction
First, you need to make sure that you have enough space. As space was never a big concern for Oracle (but performance yes), make sure that you have at least 10 GB free disk space.
Second, make sure that you have the latest Windows SP and loopback adapter installed and configured if you are using DHCP. How? See this.

Download the latest 11g release ( now) and don’t be scared about the size 🙂
If you have a Metalink account, you can also download the last update ( now, patchset 6890831) and don’t be scared about the size 🙂
Read the rest of this entry »

Tags: , , , , , , ,

Comments 2 Comments »

Lots of people landed on my blog by searching for “10g XE disadvantages”, but unfortunately I don’t have such an article. I mean until now 🙂

xe_logoSo what are the disadvantages of using 10g XE database? :

  • it’s not supported by Oracle support
  • it is working on just one processor core, no matter how many you have
  • it will not use more than 1 GB of RAM, no matter how much RAM you have
  • you cannot store more than 4 GB of user data, hard-coded limitation
  • you’ll not find patches for it
  • not yet a 11g version

Of course there are lots of advantages:
Read the rest of this entry »

Tags: , , ,

Comments 6 Comments »

oracle_10g-databaseoracle_11g_databasewindows-2008-logoI ran a migration workshop last week and had a partner who tried to install Oracle on a Windows 2008 Server.
Here are the today’s certification status:
– Oracle DB 10gR2 is certified
– Oracle DB 11gR1 is NOT certified yet, but projected
– Hyper-V and Server Core in Windows 2008 are not supported by Oracle

According to the last statement of direction, the timeframe for certification/support of 11g on Windows Server 2008 is 1st quarter 2009. Read the rest of this entry »

Tags: , , , , ,

Comments 9 Comments »

I never considered myself a good DBA and it’s not necessary my plan to become one. But in order to be convincing to the partners I had to take this certification.
After few months of study and exercises I took 1z0-043 (Administration II) exam on 18th of December. I passed it with 96,9% and this made me very proud.

Of course I will need to take the upgrade exam to 11g and I am pretty sure I will forget some of the things if I am not facing them on a daily basis but it was a very good lecture.
What will be the benefits? Don’t know… a diploma and a certification card for sure, 40% discount on some Oracle press books and maybe knowledge and confidence…

I’m open to share my experience with anybody interested in taking this certification

Tags: , , , , , ,

Comments 1 Comment »

After we tested our JDBC connection to Firebird and then migrated from Firebird to MySQL we have just one more step to do:

Migration from MySQL to Oracle using SQL Developer Migration Workbench

For migrating MySQL to Oracle we need to have:

Read the rest of this entry »

Tags: , , , , , ,

Comments 1 Comment »

Now that we connected successfully to Firebird through JDBC, let’s see if MySQL Migration Tool can connect and migrate the data to MySQL, our intermediary stage for migrating to Oracle.

Migration from Firebird to MySQL

In addition to what we installed during Part 1, we need to install MySQL 5.0 Community Server, the free version, which comes by default (not the Essential Edition) with MySQL Migration Toolkit.
Read the rest of this entry »

Tags: , , , , , ,

Comments 4 Comments »