Re: [PHP-GTK] [PHP-GTK-ORACLE] - Erreur TNS

TNS resolution fails (if it's going to) across networks & (most viciously) when there are 2 versions of Oracle doing battle, as both need their own 'orahome' filepath. .  

Isn't there the equivalent of a TNS hosts file?

- & ps Markus is right, you're on the wrong list!

----- Original Message ----- 
From: "Christophe Chassagneux" <[email protected]>
To: "php-gtk" <[email protected]>
Sent: Tuesday, July 31, 2001 4:45 PM
Subject: Re: [PHP-GTK] [PHP-GTK-ORACLE] - Erreur TNS


But i'm on NT...... and Oracle7
----- Original Message ----- 
From: "Markus Fischer" <[email protected]>
To: "Christophe Chassagneux" <[email protected]>
Cc: "php-gtk" <[email protected]>; <[email protected]>
Sent: Tuesday, July 31, 2001 3:27 PM
Subject: Re: [PHP-GTK] [PHP-GTK-ORACLE] - Erreur TNS


Such questions are best asked at [email protected] .

I've defined them in the envoironent throgh a shell script
looking like this

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/8.1.7
export ORACLE_SID=home
export PATH=/u01/app/oracle/product/8.1.7/bin:$PATH
export CLASSPATH=.:/u01/app/oracle/product/8.1.7/jdbc/lib/classes111.zip
export LD_LIBRARY_PATH=/u01/app/oracle/product/8.1.7/lib
export ORA_NLS33=/u01/app/oracle/product/8.1.7/ocommon/nls/admin/data
export NLS_LANG=german

and I had no problems whatsoever to access oracle database
within my php-gtk application.

- Markus

On Tue, Jul 31, 2001 at 04:06:16PM +0100, Christophe Chassagneux wrote : 
> I have a simple script in php :
> 
> putenv("ORACLE_HOME=D:\\ORANT");
> putenv("TNS_ADMIN=D:\\ORANT\\NETWORK\\ADMIN");
> putenv("ORACLE_SID=xxxxxxxxx");
> 
> echo "Oracle : ". getenv("ORACLE_HOME")." \n";
> echo "TNS_ADMIN : ". getenv("TNS_ADMIN")." \n";
> echo "ORACLE_SID  : ". getenv("ORACLE_SID")." \n";
> 
> $connect_oracle = ora_logon("xxxxx@xxxxxxx"   ,
>                             "SERETI"        );
> 
> But then i do :
>     e:\> php testoracle.php
> the prog reply : ORA-12154 : TNS name not resolved
> 
> with apache server, I don't have this problem.
> Can u help me ?
> 
> 
> 
> 

-- 
Markus Fischer,  http://guru.josefine.at/~mfischer/
EMail:         [email protected]
PGP Public  Key: http://guru.josefine.at/~mfischer/C2272BD0.asc
PGP Fingerprint: D3B0 DD4F E12B F911 3CE1  C2B5 D674 B445 C227 2BD0

-- 
PHP GTK 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 GTK 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]