Andrei DANEASA

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 »

1. 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 (11.1.0.6 now) and don’t be scared about the size
If you have a Metalink account, you can also download the last update (11.1.0.7 now, patchset 6890831) and don’t be scared about the size
Read the rest of this entry »

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

So 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 »

I 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 »

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

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:

• Oracle Database XE (small footprint, free version of Oracle DB)
• SQL Developer

Read the rest of this entry »

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 »

In order to do an automatic migration from Firebird to Oracle the only fully automatic process for Tables and Data is make a 2-step migration:
- Firebird to MySQL with MySQL Migration tool
- MySQL to Oracle with SQL Developer Migration Workbench
..but first:

Firebird connection through JDBC on Windows

Read the rest of this entry »

As I had a request and I must agree it really makes sense, I developed a console version of the DBF2Oracle tool. Functionality is the same, just that you need to give it parameters from command line.

Usage is:

Read the rest of this entry »

I expected this release for some months, but didn’t have the time to test it yet. What you can do? Here’s the official description:
“SQL Developer Data Modeling offers a full spectrum of data and database modeling tools and utilities, including Entity Relationship modeling, Relational (Database Design), Data Type and Multidimensional modeling, full forward and reverse engineering and code generation. It includes importing from and exporting to a variety of sources and targets, provides a variety of formatting options and validates the models through a predefined set of Design Rules.“.
Read the rest of this entry »