Oracle 10g client not working with Perl 5.5

chora_sid has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Oracle 10g client not working with Perl 5.5 by marto (Cardinal) on May 09, 2018 at 17:54 UTC
What version of Solaris are you running that is preventing you from installing the 12c client? What is the value of the NLS_LANG environment variable? Sunfreeware is some sort of subscription service now IIRC, https://www.opencsw.org is an alternative. As someone who spends most of their day job on Solaris, with Oracle 12c, make life easy on yourself. Perl 5.5 is old and not maintained/supported. Build your own perl, install it to something like `/app/applicationNameHere`. Install DBI and DBD::Oracle the way you would any other perl module.	[reply] [d/l]
Re^2: Oracle 10g client not working with Perl 5.5 by karlgoethebier (Abbot) on May 10, 2018 at 11:22 UTC
"...Build your own perl..." As i vaguely remember 10g as well as 11g come with their own Perl. If so the OP will have to maintain/take care of some versions of Perl: the one that comes with Oracle, the one that will surely be on his box and the one he compiles for his own purposes, right? I wish him well. Best regards and have a nice Father's Day, Karl ŤThe Crux of the Biscuit is the Apostropheť `perl -MCrypt::CBC -E 'say Crypt::CBC->new(-key=>'kgb',-cipher=>"Blowfish")->decrypt_hex($ENV{KARL});'`Help	[reply] [d/l]
Re^3: Oracle 10g client not working with Perl 5.5 by marto (Cardinal) on May 10, 2018 at 11:39 UTC
Oracle has shipped with some version of perl for a long time, it's used for their tools and some scripts which get shipped as part of/updates to the product. For reference Oracle 12C ships with perl 5.14.1 (from 2011). This is maintained by Oracle under the release of the database product. I don't even bother using it.	[reply]
Re^4: Oracle 10g client not working with Perl 5.5 by karlgoethebier (Abbot) on May 10, 2018 at 17:52 UTC
Re: Oracle 10g client not working with Perl 5.5 by chora_sid (Novice) on May 16, 2018 at 11:48 UTC
Hi All, Thanks for your responses so far. Server OS is Solaris 5.8. I have downloaded Perl 5.22 from ActivePerl site and have updated my Perl code(Shebang line) to point to it. However, I am getting below error while hitting the URL which calls a CGI file: HTTP4068: cannot execute CGI script indexaf.cgi (exec() failure Invalid argument) Can anyone please help on this.	[reply]
Re^2: Oracle 10g client not working with Perl 5.5 by marto (Cardinal) on May 16, 2018 at 12:14 UTC
You should probably start a new thread if the Oracle issue is resolved. You should show the code for a basic CGI page which reproduces the error, as well as the surrounding configuration. How do I post a question effectively?	[reply]
Re^3: Oracle 10g client not working with Perl 5.5 by chora_sid (Novice) on May 16, 2018 at 12:33 UTC
Oracle client issue is due to Perl 5.5 not compatible with Oracle 10g client. Will start a new thread for errors I am getting while upgrading Perl.	[reply]


go ahead... be a heretic
	PerlMonks