Fintan wrote:
> Then the Client should be complete. Then why am I getting sqlplus/php
> errors. Just out of curiousity what is the minimun needed to get php
> working. I know you need the Oracle Call Interface. Do you need the
> rest? I've tried different things like
>
> putenv("ORACLE_HOME=/opt/oracle/product/9.2.0");
> putenv("ORACLE_SID=DATABASE");
> putenv("LD_LIBRARY_PATH=/opt/oracle/product/9.2.0/lib");
If you are using mod_php, you can't do that with putenv or Apache's
SetEnv. Set (and export) these variables in the shell before you start
Apache (e.g. in /etc/init.d/rcapache).
> $ora = "DATABASE.OPW.IE = (DESCRIPTION =(ADDRESS_LIST = (ADDRESS =
> (PROTOCOL = TCP)(HOST = server.opw.ie)(PORT = 1521)))(CONNECT_DATA =
> (SERVICE_NAME = DATABASE)))";
You can either use the database name "DATABASE.OPW.IE" or the connection
string:
"(DESCRIPTION =(ADDRESS_LIST = (ADDRESS =
(PROTOCOL = TCP)(HOST = server.opw.ie)(PORT = 1521)))(CONNECT_DATA =
(SERVICE_NAME = DATABASE)))"
If you set NAMES.DEFAULT_DOMAIN = opw.ie, you should also be able to use
"DATABASE" without the ".OPW.IE".
Regards...
Michael
