Archive for May, 2007

I’ve just had a situation: I’ve defined a new Linux virtual machine with 512MB swap space and Oracle requirement was 1GB.

What do you need to do in order to increase the swap:
– shut down the virtual machine
– Add a new hard disk (either IDE or SCSI)
– start the virtual machine and wait to that hard disk to be discovered
– run:

#fdisk /dev/sdX
#fdisk /dev/hdX

where X is a-z, ussualy b. You will use hdX if your drive is IDE and sdX if your drive is SCSI
– click p to see the existing partitions
– if this is your new virtual hard drive, click n to create a new patition
– click t to change the partition type to “Linux Swap” (it is 82)
– click w to write changes
– run:

#mkswap /dev/sdX1
#mkswap /dev/hdX1

– change the swap location with the following command:

swapon /dev/sdX1
swapon /dev/hdX1

good luck

Comments 1 Comment »

Lots of people think that Oracle is very complex, is suited just for large enterprises and is very expensive.
It is not true at all.
Since 10g, Oracle offers lots of absolutely free software:

Regarding the books, lots of resources are available here:

For new users, the recommandations are:

  • 2 Day DBA
  • 2 Day Developer Guide
  • SQL Reference
  • PL/SQL User’s Guide and Reference

For any question regarding the above technologies feel free to contact me.


Comments No Comments »

If you install VS2005 and then ODP.Net you will probably get a strange error when you will try to use Oracle Explorer for the first time:

Package ‘Oracle Developer Tools for Visual Studio .NET’ has failed
to load properly ( GUID = {D601BB95-E404-4A8E-9F24-5C1A462426CE} ).
Please contact package vendor for assistance. Application restart is
recommended, due to possible environment corruption. Would you like to
disable loading this package in the future? You may use
‘devenv /resetskippkgs’ to re-enable package loading.

The problem is an assembly mismatch. As Christian Shay (principal product manager for at Oracle) said in an announcement, there are 2 options to solve this issue:

1. My recommended solution:

Execute the following command from a command prompt:

gacutil /i <Oracle Home>\\bin\2.x\Oracle.DataAccess.dll

where is the Oracle Home directory where you installed ODT 2005. For example, on my machine is c:\oracle\product\10.2.0\client_1.

2. Reinstall:

Deinstall ODP.NET 1.x from your machine (if you’re not using it) and install ODP.NET 2.0 in the same Oracle Home.


Comments 1 Comment »

Long time no blogging… I changed my employer and starting January the 1st I am Consultant at Oracle Corp.
My main role is to deliver workshops & presentations to Oracle partners based in EMEA, helping them to take all the benefits from Oracle products.

Places where I’ve been with this new role? London, Prague, Athens, Bratislava, Zurich, Warsaw, Krakow, Moscow…..
All the pictures are here


Comments No Comments »