Re: [PHP4BETA] OCI8 Problems

On Wed, 18 Aug 1999, Ashish Bhutiani wrote: > Warning: oci8_open_server: Error while trying to retrieve text for error > ORA-12154 in /usr/local/apache/htdocs/oratest2.php3 on line 4 > OCIDebug: oci8_open_server: FAILURE -> CLEANUP called > OCIDebug: _oci8_close_server: detaching conn=0 dbname=devdb > OCIDebug: _oci8_close_server: closind DEAD server > OCIDebug: oci8_do_connect: FAILURE -> CLEANUP called > OCIDebug: _oci8_close_conn: id=0 oerr ORA 12154 12154, 00000, "TNS:could not resolve service name" // *Cause: The service name specified is not defined correctly in the // TNSNAMES.ORA file. // *Action: Make the following checks and correct the error: // - Verify that a TNSNAMES.ORA file exists and is in the proper // place and accessible. See the operating system specific manual // for details on the required name and location. // - Check to see that the service name exists in one of the // TNSNAMES.ORA files and add it if necessary. // - Make sure there are no syntax errors anywhere in the file. // Particularly look for unmatched parentheses or stray characters. // Any error in a TNSNAMES.ORA file makes it unusable. See // Chapter 4 in the SQL*Net V2 Administrator's Guide. If // possible, regenerate the configuration files using the Oracle // Network Manager. hi, please make sure that you ORACLE_HOME and ORACLE_SID are set in your environment *before* you start apache! and, if you can say: > sqlplus user/passwd your php shoule read: $conn = ocilogon("user","passwd"); if you have to say > sqlplus user/passwd@service you php should be like: $conn = ocilogon("user","passwd","service"); regards, tc PS: we'll soone have a litte debugging FAQ in the oci8 docs (i hope - mark?) > > > ----- Original Message ----- > From: Thies C. Arntzen <thies@digicol.de> > To: Ashish Bhutiani <ashish@customerinsites.com> > Cc: php <php4beta@lists.php.net> > Sent: Wednesday, August 18, 1999 4:51 PM > Subject: Re: [PHP4BETA] OCI8 Problems > > > > sorry, what does ocilogon tell you? > > > > > > tc > > > > PS: i'm going to sleep now (11PM local time) > > > > > > > > On Wed, 18 Aug 1999, Ashish Bhutiani wrote: > > > > > We have another problem we were hoping you would be able to help us > with. We > > > can get the OCI functions to be recognized, but they cant connect with > the > > > oracle database. And in a page that shows the php info, the fields are > all > > > blank, we dont know if that is related or not. Any help from anyone > would be > > > apprecited > > > > > > > > > output from php_info: > > > > > > oci8 > > > Oracle version: > > > Compile-time ORACLE_HOME: > > > Libraries used: > > > > > > > > > thanks, > > > ashish > > > > > > > > > > > > > > > -- > > > PHP 4 Beta > > > > > > > > > > > > Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" > > Digital Collections Phone +49 40 235350 Fax +49 40 23535180 > > Hammerbrookstr. 93 20097 Hamburg / Germany > > > > > > -- > > PHP 4 Beta > > > -- > PHP 4 Beta > > Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany