Re: Core dump (Oracle DB)

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.

Comment on Re: Core dump (Oracle DB)

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.	[reply]
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»	[reply]
Re^3: Core dump by LanX (Saint) on Jun 24, 2021 at 21:06 UTC
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}	[reply]
Re^4: Core dump by karlgoethebier (Abbot) on Jun 25, 2021 at 07:03 UTC
«…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»	[reply] [d/l] [select]

In Section Seekers of Perl Wisdom