Database Administration (MOSC)

MOSC Banner

External Oracle job fails from PDB

Hi. We are running Oracle 19.11 on RHEL multi-tenant. An external DBMS_SCHEDULER job from a specific pbd where a credential for the OS Oracle user was created, fails with:

ORA-27465: invalid attribute for password

ORA-06512: at "SYS.DBMS_ISCHED", line 242

ORA-06512: at "SYS.DBMS_SCHEDULER', line 566

ORA-06512: at line 2

We have reset the Oracle OS password, dropped and re-created the credential, set the PDB PDB_OS_CREDENTIAL - all correct.

Before we set the PDB_OS_CREDENTIAL in the specific PDB to 'KEN_CRED', running the job had no output other than 'PLSQL procedure successfully completed'. When running the job after the PDB_OS_CREDENTIAL change, the error message above is displayed.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center