Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Oracle 10g client not working with Perl 5.5

by chora_sid (Novice)
on May 09, 2018 at 17:25 UTC ( #1214291=perlquestion: print w/replies, xml ) Need Help??
chora_sid has asked for the wisdom of the Perl Monks concerning the following question:

Our application works on Perl 5.5 and connects to Oracle 9i Database using Oracle 8i client.

Database is getting migrated to Oracle 12c. Due to OS constraint, we cannot install 12c client and have to do with Oracle 10g client.

We are able to connect from command line but not through Perl code. It throws NLS Lang error ORA-12705.

Can somebody please help on this. Also, where can I find Perl package for Solaris. The one in ActivePerl site is common for all Unix based OS.

  • Comment on Oracle 10g client not working with Perl 5.5

Replies are listed 'Best First'.
Re: Oracle 10g client not working with Perl 5.5
by marto (Archbishop) 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.

      "...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

        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.

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.

      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?

        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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1214291]
Approved by marto
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (5)
As of 2018-11-13 02:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My code is most likely broken because:
















    Results (149 votes). Check out past polls.

    Notices?