ORA-27406
Cause
An attempt is being made to set the EMAIL_SERVER_WALLET_DIRECTORY or EMAIL_SERVER_WALLET_CREDENTIAL global attributes from within a pluggable database (PDB) that is not created as a private endpoint (PE) enabled database. It can also happen if an invalid value is specified for the attribute or the user lacks necessary privileges to perform the operation. A valid attribute value must satisfy the following criteria and meet following privilege requirements:
- For EMAIL_SERVER_WALLET_DIRECTORY attribute, it must exist as a valid directory object. Also, the database user invoking DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE API call must be granted READ privilege on the directory object or be granted CREATE ANY DIRECTORY system privilege.
- For EMAIL_SERVER_WALLET_CREDENTIAL attribute, it must exist as a valid credential object and be in ENABLED state. Also, both the username and password associated with the credential object must be less than or equal to 128 bytes long. Further, the database user invoking DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE API call must be granted EXECUTE privilege on the credential object.
Action
If you are attempting to set the EMAIL_SERVER_WALLET_DIRECTORY or EMAIL_SERVER_WALLET_CREDENTIAL global attributes, ensure that the PDB is private endpoint (PE) enabled and retry the operation. If the error is due to missing or invalid attribute values, take appropriate action to ensure that a valid value is passed to DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE API call. If the error is due to missing privileges, then contact your database administrator and retry the operation after obtaining the required privileges.