Naveed, The short - there is not a DBD:Oracle client that currently works with the 9i Oracle drivers, however you the current DBD:Oracle still works with the Oracle 8i client drivers with are fully compatible with talking with a 9i server.
Long explanation is below: I recently upgraded to Oracle9i and have had no problems with DBD/DBI (version should not matter). The key here is what version of the Oracle client drivers you are using to access the Oracle9i server. Oracle9i is fully backwards compatible with previous versions of the Oracle client drivers software (at least to back to version 7). The error you are getting below "OCIEnvInit" is pointing to an initialization problem with the Oracle client software. My guess is, you are running your perl script on the same computer/user you installed the Oracle 9i Server. If you check the environment variable $ORACLE_HOME, this will tell you where any Oracle DB client software is going to look for the Oracle client drivers. If $ORACLE_HOME is pointing to your installation of 9i (be careful, $ORACLE_HOME needs to point to the 9i install for the server software to work correctly), then Mac is correct, you'll need to rebuild DBD:Oracle to talk with the new 9i Oracle client drivers. However, if you still have the oracle 8i client software installed (or can install it), then make sure your $ORACLE_HOME points to where the 8i client is installed (you should use a different user than the one used to startup the 9i server so they can have different $ORACLE_HOME environment variables) and DBD should work just fine. Now, if you cannot use the older Oracle client drivers and must use the 9i client, then you will have to recompile DBD:Oracle. This may be a problem since 9i is now 64-bit only. You'll have to make sure you can get DBD:Oracle to compile 64-bit. For myself, I'm using the older Oracle 8i client until I have time to get things working with the 9i client. Hope this helps. -----Original Message----- From: Naveed Anwer [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2003 4:09 AM To: 'Michael A Chase'; [EMAIL PROTECTED] Subject: RE: Connection Problem Hi Mac, Thanks for your reply. But we've re-installed DBD::Oracle 1.14 and still getting the same error. Could you tell me which version of DBD will work with Oracle9i Thanks and Regards Naveed -----Original Message----- From: Michael A Chase [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2003 2:47 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Connection Problem On Mon, 2 Jun 2003 12:35:48 +0500 Naveed Anwer <[EMAIL PROTECTED]> wrote: > Recently we shifted to Oracle9i from Oracle8.1.7 on Solaris platform. > We > have some perl scripts which connects with the database using DBI. After > migration to Oracle9i perl scripts fail to connect using DBI and give > following error "DBI->connect() failed: ERROR OCIEnvInit". I've checked > all > the environment variables and settings and they seem to be fine. Perl > version being used is 5.6.1 and DBD/DBI version are 1.12/1.18. We > re-installed DBD1.14 but no use. > Anyone on this list who have faced same kind of problem, kindly help. Rebuilding DBI is nice though you should have upgraded at the same time. The critical thing is rebuilding DBD::Oracle. The OCI and other libraries provided with Oracle 9i are not the same as those provided with Oracle 8i. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
