[PHP-DB] Re: ORA-12541: TNS:no listener error
Thanks, We've also discovered something else interesting. Even though the Oracle server and the web server are both running Solaris 2.8, the web server is an older version and does not have the same libraries as the newer version. We'll correct that and see how your suggestion works. Tom Tsongas wrote: > Joe, > > I built PHP with oracle and oci8 extensions. I built it as a static module for > Apache 1.3.20. > If you are getting errors from running 'configure' (something like it can't > locate the Oracle libraries) its because the Oracle 8 library searched for is > hard coded as libclntsh.so.8.0 corresponding to the older oracle library. > If you create a symbolic link to the oracle 9 library as follows: > > ln libclntsh.so.9.0 libclntsh.so.8.0 > > it will compile and build. > > Tom > > Joe Casey wrote: > > > What module did you build PHP with? We tried rebuilding PHP 4.06 with oci8 > > after upgrading to 9i and apparently the client libraries were missing. Am I > > missing something? > > > > Tom Tsongas wrote: > > > > > Hi folks. > > > > > > My group recently switched from an 8i to a 9i database. I recompiled > > > PHP4.0.6 against Oracle 9i and everything went smoothly. However, when I > > > attempt to execute my PHP code, I get the following error: > > > > > > ORA-12541: TNS:no listener > > > > > > My database admin says that the connection information is accurate. Is > > > there something new I have to do with 9i? > > > > > > Tom > > > > -- > > Joe -- Joe Casey PC/LAN Support Specialist Technical Web Master Clinical Trials Group NCIC (613) 533-6000 Ext. 74934 email: [EMAIL PROTECTED] http://www.ctg.queensu.ca -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: ORA-12541: TNS:no listener error
Joe, I built PHP with oracle and oci8 extensions. I built it as a static module for Apache 1.3.20. If you are getting errors from running 'configure' (something like it can't locate the Oracle libraries) its because the Oracle 8 library searched for is hard coded as libclntsh.so.8.0 corresponding to the older oracle library. If you create a symbolic link to the oracle 9 library as follows: ln libclntsh.so.9.0 libclntsh.so.8.0 it will compile and build. Tom Joe Casey wrote: > What module did you build PHP with? We tried rebuilding PHP 4.06 with oci8 > after upgrading to 9i and apparently the client libraries were missing. Am I > missing something? > > Tom Tsongas wrote: > > > Hi folks. > > > > My group recently switched from an 8i to a 9i database. I recompiled > > PHP4.0.6 against Oracle 9i and everything went smoothly. However, when I > > attempt to execute my PHP code, I get the following error: > > > > ORA-12541: TNS:no listener > > > > My database admin says that the connection information is accurate. Is > > there something new I have to do with 9i? > > > > Tom > > -- > Joe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: ORA-12541: TNS:no listener error
What module did you build PHP with? We tried rebuilding PHP 4.06 with oci8 after upgrading to 9i and apparently the client libraries were missing. Am I missing something? Tom Tsongas wrote: > Hi folks. > > My group recently switched from an 8i to a 9i database. I recompiled > PHP4.0.6 against Oracle 9i and everything went smoothly. However, when I > attempt to execute my PHP code, I get the following error: > > ORA-12541: TNS:no listener > > My database admin says that the connection information is accurate. Is > there something new I have to do with 9i? > > Tom -- Joe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
