ORA-1031 Error With 'alter User Sys' Command Executed By SYSTEM User
(Doc ID 2347509.1)
Last updated on OCTOBER 10, 2022
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Nov 22 10:29:51 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> ALTER USER "SYS" IDENTIFIED BY ******;
User altered.
But SYSTEM user can't change the SYS user password.
sqlplus system/****
SQL*Plus: Release 12.2.0.1.0 Production on Nov 22 10:30:14 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> ALTER USER "SYS" IDENTIFIED BY VALUES **************;
*
ERROR at line 1:
ORA-01031: insufficient privileges
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 |
| Cause |
| Solution |