This content has been marked as final. Show 11 replies
Looking down the 8.0.6 column of the support interoperability matrix,
the rows for Oracle clients 10.1 and higher are red "Not supported"
status. They reference note #3 "An ORA-3134 error is correctly
reported when attempting to connect to this version." This is what
you are seeing.
The Oracle 9.2 client row has purple "was supported" status meaning
that it should technically work, but calling Oracle Support for help
The PHP Windows team releases php_oci8.dll built with Oracle 10.2
client libraries. You need to build PHP so it compiles and links with
an Oracle 9.2 client, similar to this:
./configure --with-oci8=$ORACLE_HOME ...
Windows instructions are at: https://wiki.php.net/internals/windows/stepbystepbuild
I've never tested this combination.
Overall, I'd step back and see if you have other options, such as
upgrading the Database.
Edited by: cj on Mar 26, 2012 11:17 AM
Thanks for your time spent helping me. I'll check that you said and I'll back to tell you how's it going. I didn't know nothing about Windows SDK but I'll read so much about it. Also I'll install the Client Version 8.x.x maybe this could help me. By the way I can't upgrade the Data base, because it isn't mine and it works with other application called LG. Do I need to check something in the Server? maybe for enable or disable the oci library or something like that, I haven't done nothing in it.
PHP OCI8 will only compile with Oracle 9.2 client or later. To connect to your Oracle 8.0.6 DB you will need to use only this Oracle 9.2 client.
There is no setting in the DB or in PHP that will prevent the ORA-03134. You must use a compatible Oracle client and Oracle DB version.
It is always easier to build and use PHP on Linux. You could install VirtualBox and try building PHP on any Linux.
Answering the questions:
1.- It’s hard because I have a Windows Server 2003 as Webserver, and I can’t use other PC to configure another Webserver (He doesn’t want, I mean my boss), just for an app that use a connection to Oracle.
2. - First I want to connect to oracle 8i, after that, the app is going to make reports. I’m just want to use "SELECTS" and that’s’ it.
3. – It’s not too much.
How often does it run? When my boss wants to check them (the reports).
Can you use an intermediate 9.2 DB that has DB links to the 8.0.6 database?
Is it possible? Can I have an intermediate DB? How can I do it?
My job starts to depends on it.
2. - First I want to connect to oracle 8iI assume you still meant 8.0 not 8i (which is 8.1). If it was 8.1.7
then you could use Instant Client 10.2 to connect to it.
Maybe you can sacrifice system efficiency and reliability by using
SQL*Plus to query the data on the DB machine? Use PHP to fetch the
results via remote file access.
Questions about DB links and DB architecture should be asked in other
Yes you're right, I meant Oracle server 22.214.171.124.0, I'll open other thread about DB links, but I was thinking if is it possible to create a trigger (to copy in real time) or task to copy or export data from oracle Server 126.96.36.199.0 to Oracle server 10.x.x ?
If is it possible, I could connect any php app to Oracle 10.x.x, cause this one is still supported.
What do you think? Could it be a good way to try? Or are you still thinking about DB links? Which option is better?
Thanks for your time.
Hi all, the answer to my problem was a DBLink.
I installed Oracle 10g server in a different server than Oracle 8, then I made a Data base Link in Oracle 10g and I got it!... I connected PHP with Oracle 10g and then this one with oracle 8 server using DBlink.
It was like this:
Oracle 10g Server:
CREATE DATABASE LINK nombre_del_dblink
CONNECT TO usuario
IDENTIFIED BY password
USING '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST =
hostname)(PORT = 1521)) (CONNECT_DATA = (SID = SIDname)))'
Thanks for your help... I hope to help to someone else.