Re: Problem about OCI functions

Thx Mike, I have settled the problem after set the evironment var in apache. ----- Original Message ----- From: "Mike Berry-Porter" <Berry-PorterM@newcrest.com.au> To: "'Axl'" <axl@classover.com>; "php developers" <php-dev@lists.php.net> Sent: Thursday, October 19, 2000 3:08 PM Subject: RE: [PHP-DEV] Problem about OCI functions > Hi Axl, > > I use the OCI functions all the time so firstly it's unlikely to be a PHP > issue as such. I guess the first quest is do you still have a user called > scott and a password of tiger? The fact it's intermittent doesn't help. It > sounds like the PHP server is having a problem with the tnsnames.ora entry. > If you use the command oerr (Find Oracle Error) to see what your error is > you get the following: > > > [bash]# oerr ora 24327 > > 24327, 00000, "need explicit attach before authenticating a user" > // *Cause: A server context must be initialised before creating a session. > // *Action: Create and initialize a server handle. > > This would suggest your SID (usually defined by ORACLE_SID environment > variable, or the third parameter of the OCILogon function) is not correct. > However, it could be a million other things such as the OS your using, what > "user" is running the PHP service or daemon, etc.) > > First place I would check is your tnsnames.ora and your SID settings. > Second, what version of the client are you using? I would download 8.1.6 > from Oracle? > > MBP > > > -----Original Message----- > From: Axl [mailto:axl@classover.com] > Sent: Thursday, 19 October 2000 12:26 PM > To: php developers > Subject: [PHP-DEV] Problem about OCI functions > > > Dear All, > > I have a little problem when I using OCI functions. > I have copy a sample code from the PHP manual using OCI and create the > tables in my Oracle8i which are needed when running the program. > The program can run properly sometimes, and I also get the error ORA-24327 > sometimes. > I hope someone can help me the settle it down. Following is the code: > > <?php > 3 /* > > > -- > PHP Development Mailing List <http://www.php.net/> > To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net > For additional commands, e-mail: php-dev-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >