Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Core dump (Oracle DB)

by LanX (Sage)
on Jun 24, 2021 at 16:30 UTC ( #11134260=note: print w/replies, xml ) Need Help??


in reply to Core dump

> We're migrating our servers from RHEL6(Oracle 12.2.0.1) and using the Perl that comes with Oracle (/12.2.0.1/perl/bin/perl) to RHEL7(Oracle 19.3.0.0 with Oracle Client 19.8.0.0.0) and using Perl 5.32

I didn't know that Oracle comes with a bundled Perl and I'm not sure why...

But if you are migrating to another version you should keep using° that bundled Perl.

My guess is that Oracle requires included XS modules, they are compiled for a particular version and might break otherwise.

There must be a reason why it's bundled.

Cheers Rolf
(addicted to the Perl Programming Language :)
Wikisyntax for the Monastery

°) What kind of "using"? What for?

update

I was assuming you are using the bundled Perl for some kind of maintenance of the DB. Anything else would be unfortunate at least.

Replies are listed 'Best First'.
Re^2: Core dump
by marto (Cardinal) on Jun 24, 2021 at 20:04 UTC

    "I didn't know that Oracle comes with a bundled Perl and I'm not sure why..."

    Oracle is one of those apps that ships with it's own version of perl, they use it for database maintenance etc. The perl shipped with Oracle should be left well alone. Installing your own perl elsewhere on the system, and building your own DBD::Oracle ensures plain sailing, well, as far as you can get with anything Oracle related.

Re^2: Core dump
by karlgoethebier (Abbot) on Jun 24, 2021 at 20:21 UTC
    «I didn't know that Oracle comes with a bundled Perl and I'm not sure why...»

    Probably because this crap is a Perl app. Once upon a time I opened a ticket at Oracle Support because this beast forked itself to death and killed the machine where it was running. After 1/2 year or so I gave it up because they couldn’t solve the issue and turned EM off for ever. The other ugly details/reasons I suppressed.

    «The Crux of the Biscuit is the Apostrophe»

      But is there any reason for a DBA to use the bundled Perl directly?

      The longer I think about the OPs question, the more bizarre it becomes...

      Cheers Rolf
      (addicted to the Perl Programming Language :)
      Wikisyntax for the Monastery

        «…any reason…»

        No. But as always it’s more difficult. Oracle comes with it’s own environment. Everything runs under the UID oracle E.g. if you install DBI it only works if you do it as user oracle. If you are lucky. It might be interesting to see what which perl would tell if called as user oracle.

        «The Crux of the Biscuit is the Apostrophe»

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11134260]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (2)
As of 2022-08-19 05:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?