RE: Re: Oracle/PHP Issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Nope, that was not it? Still giving me the *** ORA-12545: Connect failed
because target host or object does not exist *** error.

Hmmmmm....

- Paul

-----Original Message-----
From: Justin Patrin [mailto:papercrane@xxxxxxxxxxxxxxx]
Sent: Thursday, December 04, 2003 4:23 PM
To: php-db@xxxxxxxxxxxxx
Subject:  Re: Oracle/PHP Issue


I'm using the descriptor type of connection and it looks a bit different
than yours. Try changing your CONNECT_DATA setion to:

(CONNECT_DATA = (SID = BDB1) (GLOBAL_NAME = BDB1.world))

Paul Miller wrote:

> Hello,
>
> I am having a strange issue with Oracle and PHP.  I am running PHP Version
> 4.3.4 on Red Hat AS 2.3 and trying to connect to Oracle 9i also on Red Hat
> AS 2.3.
>
> I compiled PHP successfully with OCI and oracle.  My script uses the
> ocilogon($user, $password, $db); or ora_logon($user.'@'.$db, $password);
> depending on what interface I want to use in my abstraction layer.
>
> Note: All oracle failures (*** some error ***) are when I use the
ora_logon,
> ocilogon, or the ocinlogon.
>
> Info about what works:
>
>  - PHP can at lease partially talk to the remote Oracle DB.
>
>  - If I give a bad username or password, PHP returns *** Oracle:
Connection
> Failed: ORA-01017: invalid username/password; logon denied.***  So I know
> PHP is able to validate the username against the remote Oracle database.
>
>  - If I give an unspecified TNS name, "BDB1_broken", instead of "BDB1"
which
> is in the tnsnames.ora file, I get the following Oracle message though
PHP:
> *** Oracle: Connection Failed: ORA-12154: TNS:could not resolve service
name
> ***.  So I know that the TNS name is being verified against the remote
> database.
>
> - When I try to logon to the remote DB with SQLPlus using the same
> tnsnames.ora file used by PHP, I can logon just fine.  Also, a plsql
stored
> procedure running off a DAD on the server works.
>
> THE PROBLEM:
> When I use the correct username, password and ORACLE_SID, I get the
> following error:
>
> *** Oracle: Connection Failed: ORA-12545: Connect failed because target
host
> or object does not exist ***
>
> I have:
>  - Tried specifying the DB connection in the PHP code
>     $DATABASE = "(DESCRIPTION =
>         (ADDRESS_LIST =
>           (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.2)(PORT = 1521))
>             )
>         (CONNECT_DATA =
>           (SERVICE_NAME = BDB1.world)
>             )
>          )";
>  - Tried using the IP address "192.168.2.2" and the host name both in the
> PHP and the tnsnames file.
>  - Added apache and nobody to the oracle and the dbs groups.
>  - Setting different environment vars in the PHP code
>     putenv("ORACLE_HOME=/opt/ora9/product/9201");
>     putenv("ORACLE_SID=BDB1")
>  - Recompiling PHP
>  - Using "BDB1" and "BDB1.PROD_DATABASE.MY_DOMAIN.COM" in the putenv and
the
> database name in the connection function.
>  - Checked the Apache config
>         ##ORACLE ENVIRONMENT
>         ORACLE_HOME=/opt/ora9/product/9201
>         ORACLE_BASE=/opt/ora9/
>         export ORACLE_HOME ORACLE_BASE
>         ORACLE_TERM=vt100
>         LD_LIBRARY_PATH=$ORACLE_HOME/lib
>         PATH=$ORACLE_HOME/bin:$PATH
>         export PATH LD_LIBRARY_PATH
>         ORACLE_DOC=$ORACLE_BASE/doc
>         ORACLE_SID=BDB1
>         TNS_ADMIN=/opt/ora9/product/9201/network/admin
>         export ORACLE_DOC ORACLE_SID TNS_ADMIN
>
>
> Does anyone have any thoughts????
>
> Thanks for any help,
>
> Paul
>
> ___________________________
> Paul Miller
> System-Wise
> pmillerATsystemDASHwiseDOTcom
> AT = @
> DASH = -
> DOT = .
>
>
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux