Wednesday, May 27, 2009

Oracle XE + Ubuntu 9.04

The installation of Oracle XE on Ubuntu 9.04 was very easy. There is also very well done web based administration.
After installation I tried to connect with PHP to the server. And here is the first problem. There is no OCI8 or PDO_OCI extensions in the Ubuntu's repository.
I tried to compile both of this, but I was able to do this with OCI8 extension and not with PDO extension.
There is a problem with PDO dev files, for some reason configuration always ends with this error: "configure: error: Cannot find php_pdo_driver.h", searched google but with no success ... the file is there but configure is able to locate it.

After OCI8 extension I tried to to connect by sqlplus program: /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/scripts/sqlplus.sh
First try ended with this error: "TNS:net service name is incorrectly specified" the solution I found was to add two rows to /etc/profile:
export ORACLE_SID=PROD1
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

Now everything works!

Saturday, May 2, 2009

Me on Rails

Hello again :)
I've started with Ruby on Rails ... And ... started to like it from the first two chapters of the book. It looks that my philosophy of developing is very similar to the one Rails uses:
  1. Convention over Configuration
  2. DRY (Do not repeat yourself)
  3. Agile development
This are the main principles of Rails framework. This are my principles too. So ... I'm starting to like it very much.