Re: [fw-db] Error with PDO_OCI (Invalid handle)

We have decided to move the database to our oracle real cluster application
and it works fine,
however the easy naming is not compatible since u need to specify service
name and instance name aswell.

So right now i got a server with apache 2 and Oracle instant client to
connect to another machine wich host the database

Thanks for your messages to guide me through

Gabriel Baez-2 wrote:
>
> This usually happens when apache dosen't have the ORACLE_HOME variable
> setup
> properly setup a test php file with <? phpinfo(); ?> and check
> if
> you see ORACLE_HOME setup.
>
>
> this is what I have on /etc/sysconfig/httpd
>
> export ORACLE_HOME=/u01/app/oracle/product/10g_client
> export ORACLE_SID=10g_client
> export
> TNS_ADMIN=/u01/app/oracle/product/10g_client/network/admin/tnsnames.ora
>
>
> and works fine, (RedHat ES 5)
>
>
> On Tue, Jun 17, 2008 at 4:50 AM, jeromekbe
> <j.kaluza@redcross-transfusion.be>
> wrote:
>
>>
>> i have tried and still got OCI_INVALID_HANDLE for pdo_oci and unknow
>> exception with Zend DB Oracle Adapter
>>
>>
>> I don't know what would be wrong in my setup, an old php app can connect
>> to
>> the database using adodb for php (using oci8)
>>
>>
>>
>>
>>
>> jeromekbe wrote:
>> >
>> > web02prd is the Oracle SID, apache php and oracle database are on the
>> same
>> > host
>> >
>> > Duncan, Craig wrote:
>> >>
>> >> I do not see your Oracle SID, in your connection params, try something
>> >> like
>> >>
>> >> 'dbname' => 'web02prd' . '/' . $oracle_sid,
>> >>
>> >> If you are unsure what that is, open up a shell on your Oracle server
>> >> and look for the environment variable ORACLE_SID.
>> >>
>> >> Craig Duncan
>> >> -----Original Message-----
>> >> From: jeromekbe [mailto:j.kaluza@redcross-transfusion.be]
>> >> Sent: Monday, June 16, 2008 8:02 AM
>> >> To: fw-db@lists.zend.com
>> >> Subject: Re: [fw-db] Error with PDO_OCI (Invalid handle)
>> >>
>> >>
>> >>
>> >>
>> >> jeromekbe wrote:
>> >>>
>> >>> Hi everyone, i am having an issue with PDO_OCI and eventhough i have
>> >> been
>> >>> posting on several forums, oracle otn included, i still cannot have
>> >> any
>> >>> answer, so i would like to know if any of you got the same error and
>> >> how
>> >>> to solve it.
>> >>>
>> >>> My situation is a Linux server, with apache 2 and php5.2.5 and also
>> >> the
>> >>> Oracle database.
>> >>>
>> >>> While trying to create my hand thru the factory method, i get this
>> >> error
>> >>> message :
>> >>>
>> >>> SQLSTATE[]: pdo_oci_handle_factory: OCI_INVALID_HANDLE
>> >>>
>> >>> my code for connecting to database is :
>> >>>
>> >>> public static function setDb(){
>> >>> $options = array ( Zend_Db::CASE_FOLDING =>
>> >> Zend_Db::CASE_UPPER);
>> >>> $params = array (
>> >>> 'username' => 'myuser',
>> >>> 'password' => 'mypass',
>> >>> 'dbname' => 'web02prd',
>> >>> 'options' => $options);
>> >>>
>> >>> try{
>> >>> $db = Zend_Db::factory("PDO_OCI",$params);
>> >>> $db->getConnection();
>> >>> return $db;
>> >>> }catch(Zend_Db_Adapter_Exception $e){
>> >>> echo $e->getMessage();
>> >>> Zend_Debug::dump($db);
>> >>> }
>> >>> }
>> >>>
>> >>> Note that oci8 work properly,
>> >>>
>> >>>
>> >>
>> >>
>> >> I tried to specify the host and port but it's still the same error,
>> when
>> >> i
>> >> try the Zend_Db adapter Oracle to use oci8 but i get the message
>> >> "Unknown
>> >> Exception", if i use oci8 in a test file it's working, if i use PDO
>> >> functions i will have message OCI_INVALID_HANDLE, does that mean i
>> need
>> >> to
>> >> rewrite all my DAO classes and a connecting class with oci functions
>> >> instead
>> >> of using Zend Db ?
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/Error-with-PDO_OCI-%28Invalid-handle%29-tp17819374
>> >> p17863079.html
>> >> Sent from the Zend DB mailing list archive at Nabble.com.
>> >>
>> >>
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Error-with-PDO_OCI-%28Invalid-handle%29-tp17819374p17881563.html
>> Sent from the Zend DB mailing list archive at Nabble.com.
>>
>>
>
>

--
View this message in context: http://www.nabble.com/Error-with-PDO_OCI-%28Invalid-handle%29-tp17819374p18583748.html
Sent from the Zend DB mailing list archive at Nabble.com.