oracle/php error

Anon

Hi. When I go into the program that I have built, I am getting this error. Not everytime, sometimes I can go for hours and not get it. All of the database connections have disconnect statements after them and before them (just to make sure).

Warning: OCISessionBegin: ORA-24327: need explicit attach before authenticating a user

The password to the database is correct and the connections work most of the time.

Please Help!!!
Thanks in advance.
-maddora

Anon

I get that error too.

However, I have moved to a situation now where either the connection works or it times out.

Try using OCIPlogon

And place the "DESCRIPTION=" as the third parameter to OCIPlogon.

ex : $cnct = OCIPLogon("user","pass","DESCRIPTION=(ADDRESS=(PROTOCOL...)))");

Or you can try to put the service name in the third parameter, in that case you would have to put the DESCRIPTION= string in the tnsnames.ora. However, I have yet to get that to work at all.

I am not sure if this will make you better off, but at least you might start getting connections. Sorry I couldn't help more but I am still haveing problems myself with OCI.

Regards,
Shep

Anon

I had this problem too. Yesterday. Not today though =)..
I noticed that the databaseserver i connect to was not in my /etc/hosts file but had to be looked up for the IP since i use a domainname in tnsnames.. this fixed my problems, strangely enough. Try it.