Andrei DANEASA

Approx. 4 months after the Linux release, the Windows version of 11gR2 arrived on OTN silently.

Just 64bit version for the moment, but I’m sure the 32bit version will follow soon. Considering the fact there is nothing on corporate blogs or on eDelivery, I’m sure they will make it public after both version will be available, most probably after Easter.

Regarding the version itself, I used the beta versions and will definitely recommend it.

LATER UPDATE (6th of April): 32bit version has just arrived on OTN here.

Enjoy!

I recently read SQL Developer 2.1 book by Sue Harper, published by Packt Publishing (thanks Veena).

In a few words: I’m impressed. It’s a must read for everybody who’s working with Oracle.

For those of you who never used SQL Developer, Read the rest of this entry »

I’m a constant user of Google Analytics. It’s a great piece of software with lots of useful reports, easy to read and to understand. However, I was never curious how far I can go with it.

Last week I had a discussion with someone in Oracle about Real-Time Decision (RTD) Server and Real User Experience Insight (RUEI), so I decided to find out first all the capabilities of Google Analytics.
After half of day of reading the course materials on Google Conversion University, I decided that a challenge might worth 50$, so I took the exam.

More than an hour later I passed the 70 questions exam, much difficult than I expected, with a score of 87%:

Now having the proof I understood correctly what’s happening with Google Analytics, I can jump into conclusions: Read the rest of this entry »

well… my colleagues from SQL Dev team will probably take out from the marketplace our competition. Having so many features for free is something that me and all the users are highly appreciating.

SQL Developer 2.1 EA1

Some facts of SQL Developer 2.1 Early Adopter 1: Read the rest of this entry »

Yes, it finally arrived! Check this out!

Related posts:

On SQL Server 2005 Express Edition (I don’t know how’s on full version, never had a license for it) the default connection model is through named pipes and TCP/IP is disabled.

If you want to connect to it from Oracle SQL Developer using jTDS driver it will throw a generic connection failure, as he is trying just TCP/IP. The error looks like this:

In ordrer to enable TCP/IP you have to do a few steps:
Read the rest of this entry »

Best 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:

Read the rest of this entry »

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:

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 »

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

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