note 50278 modified in ref.oci8 by sixd
| From: | sixd@php.net | Date: | Thu, 10 Apr 2008 22:14:05 +0000 |
| Subject: | note 50278 modified in ref.oci8 by sixd | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-138146@lists.php.net to get a copy of this message | ||
Great Solaris patch! Finally built. Here's some tips on connecting:
Just made this on solaris8 32bit, actually works.
1) put everything in one directory
2) unsetenv ORACLE_HOME
3) set the env vars LD_LIBRARY_PATH and SQLPATH and TNS_ADMIN(if you have it) to that directory.
4) use one of the other easy connection notations here
http://www.oracle.com/technology/
docs/tech/sql_plus/10102/readme_ic.htm
These env vars worked when put at the top of apachectl script as well.
To build you may have to fake it out with an ORACLE_HOME var, but unset it later. You may also
have to fake out the build by putting header files where it is looking for them, e.g. in the
rdbms/demo directory or some such other place.
When running though, make sure you have only the files required in only one directory.
Oracle has not put up a link to the 32bit solaris sqlplus--you have to guess it--it's there
though:
http://download.oracle.com/otn/solaris/instantclient/
instantclient-sqlplus-solaris32-10.1.0.3.zip
...and don't forget to add ".world" on to the end of your SID. It's very common
to have to specify DBNAME.WORLD to connect.
--was--
Great Solaris patch! Finally built. Here's some tips on connecting:
Just made this on solaris8 32bit, actually works.
1) put everything in one directory
2) unsetenv ORACLE_HOME
3) set the env vars LD_LIBRARY_PATH and SQLPATH and TNS_ADMIN(if you have it) to that directory.
4) use one of the other easy connection notations here
http://www.oracle.com/technology/
docs/tech/sql_plus/10102/readme_ic.htm
These env vars worked when put at the top of apachectl script as well.
To build you may have to fake it out with an ORACLE_HOME var, but unset it later. You may also
have to fake out the build by putting header files where it is looking for them, e.g. in the
rdbms/demo directory or some such other place.
When running though, make sure you have only the files required in only one directory.
Oracle has not put up a link to the 32bit solaris sqlplus--you have to guess it--it's there
though:
http://download.oracle.com/otn/solaris/instantclient/
instantclient-sqlplus-solaris32-10.1.0.3.zip
...and don't forget to add ".world" on to the end of your SID. It's very common
to have to specify DBNAME.WORLD to connect.
http://php.net/manual/en/ref.oci8.php