Avatar of joyacv2
joyacv2
Flag for Puerto Rico asked on

oci_connect and oracle 9i

Hi,

I am using oci_connect to connect to an oracle 11 without problems, but oci_connect don't work with 9i, what i can do and how i can solve this problem?
Oracle DatabasePHP

Avatar of undefined
Last Comment
joyacv2

8/22/2022 - Mon
slightwv (䄆 Netminder)

I don't think it is oci_connect.  Likely the version of the client you have installed.

To connect to a 9i database, you'll need a pretty old Oracle client version.  Sorry but I don't know the exact version.
joyacv2

ASKER
The oci_connect in php docs indicates that requires 10 and over
slightwv (䄆 Netminder)

Version 10g should connect to a 9i database.  I would expect 11g and higher to have problems.

What version do you have installed?

Finding a 10g client version is going to be problematic if you don't have it in-house somewhere.  Oracle has removed the 10g software from their site.
Your help has saved me hundreds of hours of internet surfing.
fblack61
joyacv2

ASKER
i have the oracle 11 client on an ubuntu server and use php to connect to databases, so what i can do?
slightwv (䄆 Netminder)

I'm trying to find information on if the 11g client will connect to a 9i database.

While I look, what error message are you getting?
slightwv (䄆 Netminder)

Check out this document on Oracle Support:
Client / Server Interoperability Support Matrix for Different Oracle Versions (Doc ID 207303.1)

I cannot post any of the information if you don't have access to Oracle Support.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
joyacv2

ASKER
couldn't found driver
slightwv (䄆 Netminder)

Now that I've re-read the question, I might have misunderstood the problem.

Just to make sure I understand the problem:
You have an 11g client installed and are trying to talk to a 9i database using oci connect?
or
You have a 9i client installed trying to connect to a 9i database?
joyacv2

ASKER
the first one, 11 client trying to talk to 9i database using oci_connect
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
slightwv (䄆 Netminder)

Since it states it cannot find the driver, I wonder if there is an issue with the install.

Was this a new install or the same machine doing connections to both an 11g and 9i database and the 11g works?
joyacv2

ASKER
the connection always is to an 11 oracle database, this is the first time that I try to 9i, but which alternative i have if oci_connect cannot be used?
slightwv (䄆 Netminder)

I'm not a PHP person.

If the same app on the same server can connect to an 11g database and all you change is the database you are connecting to, I would not expect a "couldn't found driver" type error.

I would expect a version incompatibility type error.

I see some posts stating that you need 10g or above for EZConnect.  I see other posts stating oci_connect will work against 9i.

Are you using EZConnect?  If so, try the old tnsnames.ora method.

If it still doesn't work, please provide the exact error.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
joyacv2

ASKER
yes, I already try that, but don't found any tsnames explanation for ubuntu server 12.04 lts, do you know how to do that?
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
joyacv2

ASKER
i have an ubuntu server 12.04 lts, with php, 11 oracle client, pci8 that connects to another server that have 11 oracle database, and i am trying to connect to another server that have a 9i oracle database
slightwv (䄆 Netminder)

OK, then the same server that works connecting to 1g database is failing when trying to connect to a 9i database.

That tells me that the client is installed correctly.

Still waiting for your connect string.
Still waiting for the exact error message.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
joyacv2

ASKER
i am out of office right now, i will give you the info as soon as i can, thank you very much!