Problem with perl 5.8.8 with Oracle 9.0

------_=_NextPart_001_01C64F26.3D17743E
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi Tim,
I have a problem with perl operating with DBD-Oracle. The error i get is
as follows -=20
=20
DBI connect('edwtest','i2_read',...) failed: ERROR
OCINlsEnvironmentVariableGet(
OCI_NLS_CHARSET_ID) Check ORACLE_HOME and NLS settings etc. at
f:\tkprod\bkscrip
t\perlscript\i2lutils.pl line 2372
Database connection not made: ERROR
OCINlsEnvironmentVariableGet(OCI_NLS_CHARSET
_ID) Check ORACLE_HOME and NLS settings etc. at
f:\tkprod\bkscript\perlscript\i2
lutils.pl line 2372.
[i2csync.bat] Csync failed, check i2csync.out
=20
Please help. I feel this might be a problem with Oracle installation. So
first question is which version of Perl is compatible with Oracle 9.0?
With Best Regards
=20
Kedar Joshi
i2 Demand Planner Upgrade
CISCO ODC, 1st Floor, Building 2, Infosys Technologies Limited,
Bangalore.
Phone No - 08051167206
Mobile - +91 9980453162=20
=20

------_=_NextPart_001_01C64F26.3D17743E--

Re: Problem with perl 5.8.8 with Oracle 9.0

This is can be a number of things but it is definitely a configuration
problem of some sort as Oracle has some environment variables that are
critical,

so check your LD_LIBRARY_PATH, ORACLE_HOME, and NLS_LANG paths

These values may not be set for the user attempting to run the app.

Check with your Oracle DBA if you're not familiar with these.


""Kedar Joshi -X (kedajosh - Infosys at Cisco)"" wrote
in message
news:C9C0B81EBB644244BF7524D71D92F2FE01175788@xmb-blr-412.ap ac.cisco.com...
Hi Tim,
I have a problem with perl operating with DBD-Oracle. The error i get is
as follows -

DBI connect('edwtest','i2_read',...) failed: ERROR
OCINlsEnvironmentVariableGet(
OCI_NLS_CHARSET_ID) Check ORACLE_HOME and NLS settings etc. at
f:\tkprod\bkscrip
t\perlscript\i2lutils.pl line 2372
Database connection not made: ERROR
OCINlsEnvironmentVariableGet(OCI_NLS_CHARSET
_ID) Check ORACLE_HOME and NLS settings etc. at
f:\tkprod\bkscript\perlscript\i2
lutils.pl line 2372.
[i2csync.bat] Csync failed, check i2csync.out

Please help. I feel this might be a problem with Oracle installation. So
first question is which version of Perl is compatible with Oracle 9.0?
With Best Regards

Kedar Joshi
i2 Demand Planner Upgrade
CISCO ODC, 1st Floor, Building 2, Infosys Technologies Limited,
Bangalore.
Phone No - 08051167206
Mobile - +91 9980453162

RE: Problem with perl 5.8.8 with Oracle 9.0

Google is my friend. I can be your friend also:
http://codecomments.com/PERL_DBI/message824574.html

Read the comment from Andy Hassal.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: Kedar Joshi -X (kedajosh - Infosys at Cisco)
[mailto:kedajosh@cisco.com]=20
Sent: Friday, March 24, 2006 2:35 AM
To: dbi-users@perl.org
Subject: Problem with perl 5.8.8 with Oracle 9.0


Hi Tim,
I have a problem with perl operating with DBD-Oracle. The error i get is
as follows -=20
=20
DBI connect('edwtest','i2_read',...) failed: ERROR
OCINlsEnvironmentVariableGet(
OCI_NLS_CHARSET_ID) Check ORACLE_HOME and NLS settings etc. at
f:\tkprod\bkscrip t\perlscript\i2lutils.pl line 2372 Database connection
not made: ERROR OCINlsEnvironmentVariableGet(OCI_NLS_CHARSET
_ID) Check ORACLE_HOME and NLS settings etc. at
f:\tkprod\bkscript\perlscript\i2 lutils.pl line 2372. [i2csync.bat]
Csync failed, check i2csync.out
=20
Please help. I feel this might be a problem with Oracle installation. So
first question is which version of Perl is compatible with Oracle 9.0?
With Best Regards
=20
Kedar Joshi
i2 Demand Planner Upgrade
CISCO ODC, 1st Floor, Building 2, Infosys Technologies Limited,
Bangalore. Phone No - 08051167206 Mobile - +91 9980453162=20
=20

This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Problem with perl 5.8.8 with Oracle 9.0

On Fri, 24 Mar 2006 08:37:37 -0700, Reidy, Ron wrote:

Hi Ron

> Google is my friend. I can be your friend also:
> http://codecomments.com/PERL_DBI/message824574.html

http://codecomments.com/ is unreachable. Any other source?

--
Cheers
Ron Savage, ron@savage.net.au on 25/03/2006
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company

Re: Problem with perl 5.8.8 with Oracle 9.0

------=_Part_7538_11014554.1143288738500
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On 3/24/06, Ron Savage wrote:
>
> On Fri, 24 Mar 2006 08:37:37 -0700, Reidy, Ron wrote:
> > Google is my friend. I can be your friend also:
> > http://codecomments.com/PERL_DBI/message824574.html
>
> http://codecomments.com/ is unreachable. Any other source?
>


Works for me...now...

--
Jonathan Leffler #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."

------=_Part_7538_11014554.1143288738500--

Re: Problem with perl 5.8.8 with Oracle 9.0

On Sat, 25 Mar 2006 04:12:18 -0800, Jonathan Leffler wrote:

Hi Jonathan

>> http://codecomments.com/ is unreachable. Any other source?
> Works for me...now...

And me, now.

--
Cheers
Ron Savage, ron@savage.net.au on 26/03/2006
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company