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!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment