/ as sysdba stopped working post oracle patching

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

$tdb = DBI->connect("dbi:Oracle:","/",undef, { ora_session_mode => ORA
+_SYSDBA }) or &errHand("5","Database is unavailable.");
[download]

Comment on / as sysdba stopped working post oracle patching Download Code

Replies are listed 'Best First'.
Re: / as sysdba stopped working post oracle patching by cavac (Prior) on Dec 05, 2024 at 10:13 UTC
You didn't provide any details for us to really understand your problem. Please provide a Short, Self-Contained, Correct Example. It certainly would also help to know more about this "Oracle patching". From what version to what version did you upgrade? What are the relevant changes/releasenotes? Any documented incompatibilities with older clients? Changes to security settings? Deprecated features? On first glance, this sounds more like a database problem than a Perl problem. Just in case, try to reinstall the Oracle client libraries and DBD::Oracle. There might be an API/ABI mismatch that prevents a proper connection. Does your command line client (running under the same OS user) work with the same login information? PerlMonks XP is useless? Not anymore: XPD - Do more with your PerlMonks XP Also check out my sisters artwork and my weekly webcomics	[reply]

Replies are listed 'Best First'.

Re: / as sysdba stopped working post oracle patching
by cavac (Prior) on Dec 05, 2024 at 10:13 UTC

You didn't provide any details for us to really understand your problem. Please provide a Short, Self-Contained, Correct Example. It certainly would also help to know more about this "Oracle patching". From what version to what version did you upgrade? What are the relevant changes/releasenotes? Any documented incompatibilities with older clients? Changes to security settings? Deprecated features?

On first glance, this sounds more like a database problem than a Perl problem.

Just in case, try to reinstall the Oracle client libraries and DBD::Oracle. There might be an API/ABI mismatch that prevents a proper connection. Does your command line client (running under the same OS user) work with the same login information?

PerlMonks XP is useless? Not anymore: XPD - Do more with your PerlMonks XP
Also check out my sisters artwork and my weekly webcomics

[reply]