PDB In RESTRICTED MODE Due To Sync Failure "Sync PDB failed with ORA-65177 during 'ALTER PROFILE PROFILE_NAME LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED' in pdb_plug_in_violations"
(Doc ID 3053331.1)
Last updated on OCTOBER 23, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.0.0.0 and laterGen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
PDB in restricted mode ,getting following error while trying to connect :
An user profile change which has not SYNCED properly prevents the PDB-s from opening in READ WRITE mode.
Changes
Either a manual profile change or an automatic one possibly triggered by a patch being applied. In the case of this customer we could not identify where the change came from, the customer applied GRID and DB RU patches and the issue started immediately after. In the alert logs we could not find any DDL related to this profile.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |