note 10535 added to Oracle functions
| From: | Kanyin_Cai at hp dot com | Date: | Tue, 09 Jan 2001 18:04:50 +0000 |
| Subject: | note 10535 added to Oracle functions | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-9519@lists.php.net to get a copy of this message | ||
Hi,
I have oracle 8 server in a hp-ux machine.
Now I want to access this oracle server from my NT workstation, where I have installed Oracle 8
client and a web server.
I have tried to set the environment varable in NT like the notes above describes. But it just
doesn't work.
here is my Tnsnames.ora under orant\Net80\Admin:
================================================
OV_NET.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = my.unix_host_name.com)(PORT = 1521))
(CONNECT_DATA = (SID = openview))
)
==============================================
and here is the sqlnet log file:
================================================
Fatal NI connect error 12203, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ov_net)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ov_net)(CID=(PROGRAM=C:\php\php.exe)(HOST=MY.NT_PC_NAME.com)(USER=my_name))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.0.5.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - Production
Time: 09-JAN-01 18:50:04
Tracing not turned on.
Tns error struct:
nr err code: 12203
TNS-12203: TNS:unable to connect to destination
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 0
nt OS err code: 0
===============================================
As you can see the host name in sqlnet.log is wrong. How can I tell php to use the correct service.
Everything works just fine in unix. But how can I set the variable correct in NT?
Any help or suggestion will be welcome.
Best wishes!
http://www.php.net/manual/ref.oracle.php