Yeah, on the server you should be able to type tnsping and your tnsname to make sure it is configured correctly. <>< Ryan -----Original Message----- From: Andrey Hristov [mailto:andrey@webgate.bg] Sent: Wednesday, December 18, 2002 10:05 AM To: NIPP, SCOTT V (SBCSI); php-db@lists.php.net Subject: Re: FW: Oracle connectivity question... Hey, A friend of mine told me that : kalo 19:02: trjanbva ti tnsping vdb.masq kalo 19:02: uf.. ne znam kak ce nastrojva tnslistaner-a..;( kalo 19:03: ima si programa s kojato se pipat nastraojkite na TNSListener-a kalo 19:03: ina4e ne mozesh ada se zaka4ish.. Translared to english : 19:02 You need tnsping the_machine 19:03 : uff, I don't know how to setup the tnslistener 19:03 : there is a program to change the setting of TNSListener 19:03 : otherwise you can't connect If this helps you :)) Andrey ----- Original Mesage ----- From: "NIPP, SCOTT V (SBCSI)" <sn4265@sbc.com> To: <php-db@lists.php.net> Sent: Wednesday, December 18, 2002 6:51 PM Subject: FW: Oracle connectivity question... > More information on the problem... I tried including the SID in the > OCILogon function and think that I may have gotten a bit further, but still > not a successful logon. Here is the error I am now receiving with the SID: > > Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name in > /www/DW/oratest.php on line 11 > Unable to logon to database. > Thanks agian. > > > -----Original Message----- > > From: NIPP, SCOTT V (SBCSI) > > Sent: Wednesday, December 18, 2002 10:30 AM > > To: 'php-db@lists.php.net' > > Subject: Oracle connectivity question... > > > > OK. I think I now have Oracle support built into PHP/Apache. The > > biggest hiccup for HP-UX seems to be that once you add Oracle support to > > PHP, you CANNOT built PHP as a DSO, PHP MUST be compiled into Apache. > > Once again, I think this is the case, I am still not completely sure at > > this point. > > > > I am now receiving an error on trying to connect to the Oracle > > database that I do not understand, but leads me to believe that the PHP > > Oracle support is functioning. Here is the code I am attempting: > > > > <?php > > $connection = OCILogon("userid", "password") or die ("Unable to logon to > > database."); > > # phpinfo(); > > ?> > > > > Here is the error I am receiving: > > > > Warning: OCISessionBegin: ORA-01034: ORACLE not available in > > /www/DW/oratest.php on line 10 > > Unable to logon to database. > > The code I am attempting is simply to verify successful connectivity > > to the database. I know that this doesn't really do anything, but I am > > trying this simply to test for a successful connection. Please let me > > know if you have any ideas or suggestions. Thanks again. > > > > Scott Nipp > > Phone: (214) 858-1289 > > E-mail: sn4265@sbc.com > > Web: http:\\ldsa.sbcld.sbc.com > > > > > > -- > 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
