Retour
-
Titre
How to manage password for SYS account on Oracle 12c R2 or 19 -
Description
Unable to manage SYS account password after Oracle DB upgrade to 12c R2 or 19. All other accounts on the Oracle system can still be managed by TPAM after the upgrade.
-
Cause
Behavior change in Oracle 12.2 DB. -
Résolution
1. To manage the SYS account, the TPAM functional account for the Oracle 12c R2 or 19 system needs to be SYS, per the Oracle KB below:
https://support.oracle.com/knowledge/Oracle%20Database%20Products/2347509_1.html
2. In TPAM under the System's "Details | Information" tab; Set the "Extra DB Connection String:" value on the Oracle 12C R2 or 19 system to be:
dba privilege=SYSDBA
Once both of these settings have been made, all accounts on the Oracle system including the SYS account can be managed.