Re: Oracle-Perl Connection Problem by Mordechai_Pniel- January 4, 2005 You have to recompile the DBD::Oracle module against your current Oracle version.MordechaiThe content of this message is Applied Materials Confidential. If you are not the intended recipient and have received this message in error, any use or distribution is prohibited. Please notify me immediately by reply e-mail and delete this message from your computer system. Thank you.Sandeep Warikoo <sandeep_warikoopersistent.co.in>04012005 16:50 To: richard.foleyrfi.net cc: .http://www.nntp.perl.org/group/perl.dbi.oracle-oci/2005/01/msg159.html RE: Oracle-Perl Connection Problem by Barbara Lindsey- January 4, 2005 I have my connect set up as follows:DBI->connect("dbi:Oracle:xxx","yyy","zzz")Where "xxx" matches the name used in the tnsnames.ora file for the databaseyou are connecting to"yyy" is the user"zzz" is the passwordAnother suggestion is to use debugging as follows:!usrbinperl -dRun your script from the command line to debug. In this way you canstep into each of the modules and examine the variables to find what ismissingwrong and...http://www.nntp.perl.org/group/perl.dbi.oracle-oci/2005/01/msg158.html Re: Oracle-Perl Connection Problem by Sandeep Warikoo- January 4, 2005 Hi again,I tried NLS_LANG too. But still same result.My database settings are:NLS_LANGUAGE=AMERICANNLS_TERRITORY=AMERICANLS_CHARACTERSET=WE8ISO8859P1I tried:" export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1", but still execution of script gave me same error.I can connect to database through sqlplus and run queries.I&39;m working on HP-UX, and database is also on an HP-UX machine.LD_LIBRARY_PATH is also correct. :-(We have reinstalled DBI and other related packages. But that also...http://www.nntp.perl.org/group/perl.dbi.oracle-oci/2005/01/msg157.html Re: Oracle-Perl Connection Problem by Richard.Foley- January 4, 2005 There&39;s a few things to look at:Sometimes you need NLS_LANG (etc.) and several others set too.LD_LIBRARY_PATH may be worth checking.Have you upgraded this Oracle recentlyCan you connect using sqlplusDon&39;t give up - once it works, it&39;ll work forever ;-)On Tuesday 04 January 2005 14:04, Sandeep Warikoo wrote:> Hi Richards,>> Thanks for the help.> I have checked all the environment variables. All are correctly set> including TWO_TASK, ORACLE_SID, ORACLE_HOME. Still the...http://www.nntp.perl.org/group/perl.dbi.oracle-oci/2005/01/msg156.html Re: Oracle-Perl Connection Problem by Sandeep Warikoo- January 4, 2005 Hi Richards,Thanks for the help.I have checked all the environment variables. All are correctly set including TWO_TASK, ORACLE_SID, ORACLE_HOME. Still the problem persists.here is my modified code:------------------------------------------------------------------------!usrbinperluse DBI;$ENVTWO_TASK="d7_bilab03";$ENVORACLE_HOME="dataoracleproduct9.2.0";$ENVORACLE_SID="dmc";$dbH = DBI->connect("dbi:Oracle:","hpbi_owner","hpbi") or...http://www.nntp.perl.org/group/perl.dbi.oracle-oci/2005/01/msg155.html Re: Oracle-Perl Connection Problem by Scott T. Hildreth- January 4, 2005 Also, this should be on the dbi-users list. Join that list forDBIDBD Questions.On Tue, 2005-01-04 at 12:09 +0100, Richard Foley wrote:> You usually need to have quite a few environment variables set before you can > access Oracle, as the error message (OCIEnvInit) roughly indicates. Try > reading the docs that came with the DBI (and DBD::Oracle particularly), I > believe there are many examples in there.> > You are at least short of > > ORACLE_SID or TWO_TASK> >.http://www.nntp.perl.org/group/perl.dbi.oracle-oci/2005/01/msg154.html Re: Oracle-Perl Connection Problem by Richard.Foley- January 4, 2005 You usually need to have quite a few environment variables set before you can access Oracle, as the error message (OCIEnvInit) roughly indicates. Try reading the docs that came with the DBI (and DBD::Oracle particularly), I believe there are many examples in there.You are at least short of ORACLE_SID or TWO_TASKCiaoRichard Foley---Ciao - Shorter than Aufwiedersehenhttp:www.oreilly.comcatalogperldebugprindex.htmlOn Tuesday 04 January 2005 09:47, Sandeep Warikoo wrote:> Hi,>> I&39;m...http://www.nntp.perl.org/group/perl.dbi.oracle-oci/2005/01/msg153.html Oracle-Perl Connection Problem by Sandeep Warikoo- January 4, 2005 Hi,I&39;m trying the access oracle through perl, but am getting the error "ERROR OCIEnvInit".My perl script is:-------------------------------------------------------------------------use DBI;$ENVORACLE_HOME=&39;dataoracleproduct9.2.0&39;;my $dbh = DBI->connect("dbi:Oracle:d7_bilab03","hpbi_owner","hpbi") or die "couldn&39;t connect to database: $DBI::errstrn";--------------------------------------------------------------------------Does...http://www.nntp.perl.org/group/perl.dbi.oracle-oci/2005/01/msg152.html |