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!
Wednesday, May 27, 2009
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:
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:
- Convention over Configuration
- DRY (Do not repeat yourself)
- Agile development
Subscribe to:
Posts (Atom)