oracle中system用户能lock吗？

从mos上的文档中显示，oracle中system用户是可以lock的

Can the SYS and SYSTEM users be locked? (文档 ID 2132859.1)

需要注意的是：1.system用户下面没有自动化作业。2、在升级或者打补丁的时候，需要将system用户解锁，不然会报错

 

In this Document

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

GOAL

Can the SYS and SYSTEM users be locked?  If so, what is the impact of this?


 

SOLUTION

SYS cannot truly be "locked", as it is the SYS account that connects / AS SYSDBA:

SQL> alter user sys account lock;
User altered.
SQL> connect / as sysdba
Connected.
SQL>

SYSTEM can be locked if it is not being used by DBAs or automated jobs.

However, locking SYSTEM will cause errors during patches/upgrades, so ensure it is unlocked prior to such activities.

If you get an 'ORA-28000: the account is locked' error when connecting to SYS as SYSDBA remotely and the SYS account is locked, you may be experiencing bug 17732353, Refer to Note 1601360.1

REFERENCES

NOTE:1601360.1 - ORA-28000: The Account Is Locked When Log In As SYS User Remotely While SYS User Was Locked