Re: Linux, Oracle, Apache with PHP oci8 module TNS resolve problem

indrek siitan wrote: > > Hi, > > > I had a every thing running but then someone decided that I had to use > > the new oci8 support with php instead of the normal ora_ with that > > result: > > Warning: _oci_open_server: ORA-12154: TNS:could not resolve service > > name They can mix fine, but you tend to get ORA-3115 errors when you use ora_ functions against an oracle 8.x db under load (it has do to runtime protocol translation). > > first - the "normal" ora_ functions are for accessing oracle 7.x > servers whereas oci8 is for accessing oracle 8. as far as i know, > you can't mix these two. > > but the problems is probably caused by missing ORACLE_HOME environment > variable, which tells the oci8 libraries where to look for the > configuration files. you can doublecheck that by generating a > simple phpinfo() page and checking the HTTP_ENV_VARS from there. > > Rgds, > Tfr > > --==< tfr@cafe.ee >==< http://tfr.cafe.ee/ > >==< +372-50-17621 >==-- > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- $_ = 'George Schlossnagle'; s#.#(ord$')-(ord$&)+((index($_,$')-$&)?1002:0)#ego;s#-#((substr($],4,1)-6)?67:$-[0])#eog;$:=$_;print join('',(map chr$_,reverse map{substr($:,(3*$_),3)+(11,-109,-14,94,-894,-28,-61,-202,-417,83,-20,-678,53,96,4,-494,82,-869,-826,24,16,-684,-450,-27)[$_]}(0...length($_)/3)),chr(length($_)/2+ord$/),$/);