Oracle And PHP4 Connection Problem.

Hi Experts, I had installed PHP4, Oracle 8i (8.1.5, with full installation) in my Linux Redhat 6.2. The whole installation sound like good. The problem now is I can't connect to my remote Oracle (7.3) server which is in Sun OS. But when I use tnsping it worked ! Here is my tnsping result : [oracle8i@cms03linux admin]$ tnsping iccm.mal TNS Ping Utility for Linux: Version 8.1.5.0.0 - Production on 04-JUL-00 16:42:44 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (address=(protocol=TCP)(host=10.96.24.7)(port=1575)) OK (10 msec) When I ran my php program, it prompt an error. Warning: OCISessionBegin: ORA-01034: ORACLE not available in /www/htdocs/testing/test.php on line 4 Conncetion Failed Here is my questions : 1. If tnsping successfully, it this meant my php script should able to work ? 2. How To solve this error ? Please help. Thank ! Here is my tnsnames.ora : ############ iccm.mal= (description= (failover=on) (load_balance=off) (address = (protocol = TCP) (host = 10.96.24.7) (port = 1575) ) (address = (protocol = TCP) (host = MCMS03) (port = 1526) ) (connect_data=(sid=iccm)) ########### Here is my php program : <? putenv("ORACLE_SID=iccm.mal"); putenv("ORACLE_HOME=/usr/local/oracle/8i/u01/app/oracle/product/8.1.5"); putenv("ORA_NLS=/usr/local/oracle/8i/u01/app/oracle/product/8.1.5/ocommon/nl s/admin/data"); if ($conn = ocilogon("myuser","mypass")) { printf("%s</P>", OCIServerVersion($conn)); } else { printf("Conncetion Failed"); } ?> Regards, Char begin 600 winmail.dat M>)\^(BT(0:0"$`````!$0>0!@Ke¤‰YÖ M>wD-+ëÕíŸW(```Y0``````#H$(@<` M&```$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E#$(06P.```T<'`0 M0Y`<@E0$@@,#@`-'!P$(#`L('@$!"8!"$```!$ M0S1%-S5%,#DP-3!$-#$Q.3@X,SP-CY-S-#.#9&,@#W!@$$@$)````$]R M86-L92!!;F0@4$A0-"!#;VYN96-T:6]N(%!R;V)L96TN!0,0V!"``` M@"`$#D8NH`"L``##N""&`````#```````1@``!2A0` MMPT`!X/(((8`````,``````!&```%2%`!``!``#@N,`# M#V""&````#```````1@```!A0``````L/H((8`````,` M`````!&````.%``````"P_@@@!@````P``````$8```#H4 M``````#$"""&`````#```````1@```0A0``````,08((8` M````,``````!&```!&%```````P!"@@@!@`````P``````$8 M```&(4``````>$.""&`````#```````1@```VA0`0``$ M```````'@!$@@@!@`````P``````$8```-X4`$``!``````` M!X18((8`````,``````!&```#B%`!```0```````"0D0 M0`(,%!_!0MD`$Q:1G5#H,XMP*')C<&<Q,C46,@#X"V!N#A`P M,S/]?<@J0#Y<3H,415D0(<')Q$8%C:KX'-E=#@"%4'L@*#WPY0 MU02>0=MH,S\42><T0Y7T*@C((#L);PXPYC4"@J!=6,4L##-,,S8" MT0O$($AI((A%>'$D'1S+JB2PJ$"H@'9%)(!*@9$H@"X!S9!L;F(`!0 M2%T+"!/<A,T!Z0(#@<,"@X+B@Q+C4?$"#\'1H&"!F=1Z'B9A=&E%BI M'B$@;7D=-4QY"X!U>?P"82H5-B@N,BX50&@?@'=HIP;P'X`A"B!S"&!N M'A!(;&EK'X!G;P1P+B\=-1TX(\(2,&\"8&5MN"!N;P?@!`=P6,<&8G!4`% MH&YN!9%0'3:;R(!(EP!&!T'X?-3H-RXS(<2T')V?P20'34DW@()H M02'A4XLE4!\@4R.@($)U!4!W)`)\!W!=1+0*6@'!]"X!G'BM406P);`> M$"'['3<=.$@$D"1!!"IH2XFK0EP<R#!4Z'-5C$#G'9(=DA%A(%L%L!]2 M'Z#P0&-M<P]0)9BPAX4FT+@%TD+AAC-#NGP#"5<YQX0,M-43@7PVEN M8E4A@"60="FPA#C!<BHSH@5@20)E<D?XRXP.@@+1[`V.9!JP).,E M3T+4H054PM,!,,38ZM#0R/!T'3@?P&,AP$D(4'!Y!1!G:5,9@Y.3<? M)@A0<GSH?LA@BT!02#1/:,$(#&Q*R+[)A<=DD$"0"?0!3N8BEQ5RCQ9I M02@>&0QL7,</2@G@2EP".$]5$-84"DH)!>4#T/0"[B.2-Q-"XW1%`^\42A MX#4W-2DI-FD;-#+4_$]+'\/0"($M],*R]S)&2(4=DE<MA!]`(?(G<,QH M<"=R"<!A;1\0+J&_)X%!T330Z$D-@<B8EF0KT<V(/0%`<V%-DM<,,!02 M"_T,M97"L#(\/(H@$PY$$]#209@8P00(9%"96<+@$_Q4A9!.[/0311 MT-,1?LG\4P!=@MP"VGL2'2"B"H("]W4Y`O/=!D0]"\<R\J$!Y0+F%4,RY* ML7]/LCL2-($?@%-1/&!/P%QO5<,RUA0*1!C$ND\D9_4J$>H48_%G0,`2__ M*:%Q_PI05&$"(0@,B4RU2'<"^9BX7,=U\$-!(+)Y2V-[((PTF4<5 M2H4$]7,_)!`@P!X04M,I<2[2(#]K6_LCD4@H$50I@"4P;%\K0%ZD3%-A=ATX M4!Z08?,M\2/0;'CH@!P86O1;<*]1SR,(QN2T`'D"XSH7TR%B-I:5AO,I(S M4C7F/7T=."@!`3T(9%L.3S49O52H6\K03TAH6V^"0>/Q?8@=`'!7@&\P M`2!O;/-MO4+G(#UR+ST!0Y9ST?]$(G0O1')ST43)=B]%@G=R_47B($8I<I]S MI'JO=3]V3WEW4TU#!>/4'Y/>5@RGC9Z'3;)/2I!%]D(7#F84-P`)!D/37B M1A%)K\6@6D>'-HPB4JY,AL\88A&<"U"?!V*")1U%\84TE$A,,V(B(I.P,F MF(I=2$]-13TOF2W@<B\)"B0;"\SIXO'Z".$%%@+V%P<'^.MB>!.J*/(!_R MC^*E5_X3DQ3C@^/'YNDY%H,)M!&!N+VYL5"TX[XOA#*1*!TW!I`?P"0H M\N]ST4/0;M$EX&Z*L"(0+>'X<B(LF?$*L00D2AP'E;^EQ[)W$+@`PBKE MX',\+U^FF!0!"LRWSDUF-1&$)%+[)])IAEH#\M\9L_G$173Y$BGO@_/N]( MGAKJ'.,C&<+$1RV5R$7$J%F;Q@Q*@P`L@!```'@!P$``D``` M3W)A8VQE($%N9"!02%T($-O;FYE8W1I;VX@4')O8FQE;2X@%Q$```6 M````;_EC71K4E??E5"O$=22&P"@).AQBP0Y'2;+W.-Y;\!`P#Q/PD$ M``>#%`0`"\```O3SU-24-23TXO3U4]0TU3,#,O0TX]15A#2$%.1T4@ M55-%4E,O0TX]0TA#2$%2``#!I`````!X,$!``+P``"]//4U)0U)/ M3B]/53U#35,P,R]#3CU%6$-(04Y'12!54T524R]#3CU#2$-(05(``,&4`` M````P#]/^0$`#"8``````,-@``````P"$/____\"4<0`#0 M`!C/553.V$](#MP/4UI8W)O;CML/5]#35,P,T580T@Q+3P,#<P-#`W-3<P M-UHM,C(V-S8`@'Y/P$`!+```````-RG0,C0A:M+D("LOX8(!```` M`````"]//4U)0U)/3B]/53U#35,P,R]#3CU%6$-(04Y'12!54T524R]#3CU# M2$-(05(`!X^#\!```!P`&-H8VAA<@'@X0$``O```+T\]34E# M4D].+T]5/4--4SS+T-./4580TA!3D=%(%5315)3+T-./4-(0TA!4@``@'[ M/P$``!+```````-RG0,C0A:M+D("LOX8(!`````````"]//4U)0U)/ M3B]/53U#35,P,R]#3CU%6$-(04Y'12!54T524R]#3CU#2$-(05(`!X^C\! M```!P`&-H8VAA<@'@Y0$``O``+T\]34E#4D].+T]5/4--4SS M+T-./4580TA!3D=%(%5315)3+T-./4-(0TA!4@`0',&:"]1>+Y;\!0`( M,.S&?J&/Y;\!'@]$``!```````!X'0X!```)```$]R86-L92!! M;F0@4$A0-"!#;VYN96-T:6]N(%!R;V)L96TN`L*0`````"PC```````# M`80Z";6P,!Q#I!``P0$`````#!$0````!X"!!``90``$A) M15A015)44RQ)2$%$24Y35$%,3$5$4$A0-"Q/4D%#3$4X22@X,34L5TE42$95 M3$Q)3E-404Q,051)3TXI24Y-64Q)3E584D5$2$%4-C)42$572$],14E.4U1! .3$Q!5$E/3E,`````2,$= ` end