OCI and ORA-24315

717861

Hi all,

I have a problem connecting to an oracle database using oci, I'm all out of options, so I hope you can help me..

I installed a WAMPserver on a Windows Server machine.
I've also downloaded instantclient_11_1, and made a PATH entry to this locatiion.
I also set the following in php.ini:
+;extension=php_oci8.dll ; Use with Oracle 10gR2 Instant Client+
extension=php_oci8_11g.dll ; Use with Oracle 11g Instant Client
if I run phpinfo() I see an OCI8 section.

This machine has OracleXE installed and is also in a network where an oracle11g db is installed.

I have the following code in index.php:

*<?php*
echo "Hello world!";
*$conn = oci_connect('hr', 'welcome', 'localhost/XE');*

*if (!$conn) {*
*$e = oci_error();*
trigger_error(htmlentities($e['message']), E_USER_ERROR);
*}*
*?>*

This results in:

Hello world!
*Warning: oci_connect() [function.oci-connect]: ORA-24315: illegal attribute type in C:\wamp\www\index.php on line 3*

Fatal error: ORA-24315: illegal attribute type in C:\wamp\www\index.php on line 7


I am pretty sure that my code is correct, It seems to me that oci functions per definition generate an ORA-24315 error.
Any help is welcome

Grtz Sake

756650

<?php
echo "Hello world!";
$conn = oci_connect('hr', 'welcome', 'xe');

if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message']), E_USER_ERROR);
}
?>

Edited by: user6724455 on Feb 26, 2010 10:14 AM

Christopher Jones-Oracle

It sounds like a library mismatch issue. Having both a 10.2 (the XE
install) and the 11.1 libraries might be causing a clash. The error
seems rare. There was one old report of the problem in
http://bugs.php.net/bug.php?id=25123

I'd step back and make a decision about which client libraries you
want to use.

I expect the WAMP install uses a version of the OCI8 DLL that was
compiled with 10gR2 libraries. So it should run with the XE or the
11g instant client, because there is backward compatibility.

If PHP runs with the libraries in the XE install you can still connect
to your XE DB or your remote 11g DB.

Let us know what you find.

809339

Is there anyone to help on this?I having the similar warning and errors too. keep trying it for few days edi....

Christopher Jones-Oracle

If you use a dependency checker, what libraries are being accessed?

1028086

I'm having similar issues.

If I install the a wamp on a separate machine with instant client, it seems to work, but not when the database and php script is on the same machine...

Christopher Jones-Oracle

If you want help, you'll need to give a lot more detail about the environment, what you installed, and how you installed it.