Dbd Error Ocienvinit
(DBD ERROR: OCIEnvInit) Message ID: 624c40ae-80b5-4a08-8fc3-2eacba34bbee@n19g2000prg.googlegroups.com Hello List, I have seen several such messages, and tried to gather as much wisdom as I could from those, but I still can not get it to work. Would appreciate someone helping with this. Here is the scenario: Running following perl script on Microsoft Windows XP Professional, Version 5.1.2600 Service Pack 2 Build 2600. C:\Nishi\Perl>perl tst.pl DBI connect('host=myHost;SID=sid1','myUser',...) failed: (DBD ERROR: OCIEnvInit) at tst.pl line 20 (DBD ERROR: OCIEnvInit) at tst.pl line 20. C:\Nishi\Perl>echo %PATH% C:\Nishi\instantclient_10_2;/usr/bin; C:\Nishi\Perl>echo %ORACLE_HOME% C:\Nishi\instantclient_10_2 C:\Nishi\Perl>perl -v This is perl, v5.10.0 built for MSWin32-x86-multi-thread Binary build 1003 [285500] provided by ActiveState http://www.ActiveState.com DBD-Oracle-1.21 DBI-1.604 Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production: running on a remote AIX machine (myHost) Thanks, Nishi DBI connect('host=myHost;SID=sid1','myUser',...) failed: (DBD ERROR: OCIEnvInit) by Nishi nntp.perl.org: Perl Programming lists via nntp and http. Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up DBD::Oracle fails to connect with OCIEnvInit when called when accessed through webserver only up vote 0 down vote favorite I have a simple perl http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg32978.html script that uses DBD::Oracle to run a query and print the results. It works fine from the command line, but I also have a PHP script that runs it and reads the output. When the PHP script is accessed through apache it fails to connect, with the error "OCIEnvInit". I've tried creating a shell script that re-sets all the environment variables available in the shell but that didn't help, and I also tried setting the debugging http://stackoverflow.com/questions/5760320/dbdoracle-fails-to-connect-with-ocienvinit-when-called-when-accessed-through-w output for DBI but got nothing. What could cause this error when the script does work? perl oracle dbi share|improve this question asked Apr 22 '11 at 21:37 user83358 4413815 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote accepted Are you sure that ORACLE_HOME and other relevant environment variables (e.g., LD_LIBRARY_PATH) that are set in your shell when you run the script from the command line are also set to the same values in the apache/PHP process? share|improve this answer answered Apr 27 '11 at 17:00 John Siracusa 10.7k53550 Strangely the command line doesn't have the values set but apache does. I will find out if removing them helps. –user83358 Apr 28 '11 at 16:11 It turns out that removing them from the apache environment did work. –user83358 May 21 '11 at 1:32 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged perl oracle dbi or ask your own question. asked 5 years ago viewed 379 t
problem wasthat some of our DBs are ORacle 8x and some are 9x depending on where theyare hosted. So http://grokbase.com/t/perl/dbi-users/02a12qh77j/post-regarding-error-ocienvinit after Oracle was reconfigured on the OS and the oracle envvariables were set, DBD-Oracle was reinstalled and it read the updatedvariables and things were back to normal.-----Original Message-----From: Matt SteeleSent: Tuesday, October 01, 2002 2:37 PMTo: James.Kipp@mbna.comSubject: Post regarding error OCIEnvInitHello James,You mentioned that you fixed this problem. We are getting this sameproblem. We upgraded dbd error our database and are now getting thiserror. Couldyou please let me know how you fixed it.Thanks for your help.Matt SteelePlease Disregard. I fixed the problem. thanks.-----Original Message-----From: Kipp, JamesSent: Monday, July 22, 2002 1:43 PMTo: 'dbi-users@perl.org'Subject: help with Error codeany one seen this error, and why I might be getting it?--DBI->connect(middev.fpbee01a) failed: ERROR OCIEnvInit atcreate_mcc_roll.pl dbd error ocienvinit line 15Cannot connect to Oracle ERROR OCIEnvInit--I tried googling for it, but not much luck. This is the onlydatabase that we get this error on. i have verified thatperl/DBI can "see" the database.any suggestions would be appreciated, thanks. reply Tweet Search Discussions Search All Groups Perl dbi-users Related Discussions ERROR : Could not connect: ERROR OCIEnvInit DBI->connect(AVSEDWT) failed: ERROR OCIEnvInit ERROR OCIEnvInit in Multi Ver Oracle Environment DBI connect('host=myHost;SID=sid1','myUser',...) failed: (DBD ERROR: OCIEnvInit) DBI->connect failed: ERROR OCIEnvInit Oracle-perl connection problem DBI connect('','/',...) failed: ERROR OCIEnvInit Fw: DBD-Oracle-1.14 DBD-Oracle-1.14 Perl with Oracle 9.2 Discussion Navigation viewthread | post Discussion Overview groupdbi-users @ Notice: Undefined variable: pl_domain_short in /home/whirl/sites/grokbase/root/www/public_html__www/cc/flow/tpc.main.php on line 1605 categoriesperl postedOct 1, '02 at 6:49p activeOct 1, '02 at 6:49p posts1 users1 websitedbi.perl.org Preferences responses expanded Hotkey:s font variable Hotkey:f user style avatars Hotkey:a 1 user in discussion Kipp, James (1) Content Home Groups & Organizations People Users Badges Support Welcome FAQ Contact Us Translate site design / logo © 2016 Grokbase