Oracle Database Password Expiration error

[Email protected] ~]# su-oracle

[Email protected] ~]$ Sqlplus/as SYSDBA

Sql*plus:release 11.2.0.1.0 Production on Tue Dec 15 09:23:28 2015

Copyright (c) 1982, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the partitioning, OLAP, Data Mining and Real application testing options

Sql> SELECT username,profile from Dba_users; ---See which of the user's profile is, usually the default

USERNAME profile

------------------------------ ------------------------------

SPATIAL_WFS_ADMIN_USR DEFAULT

SPATIAL_CSW_ADMIN_USR DEFAULT

Apex_public_user DEFAULT

DIP DEFAULT

Mddata DEFAULT

Xs$null DEFAULT

ORACLE_OCM DEFAULT

SCOTT DEFAULT

Umpuser DEFAULT

SEARCH DEFAULT

Olapsys DEFAULT

USERNAME profile

------------------------------ ------------------------------

Si_informtn_schema DEFAULT

Owbsys DEFAULT

Ordplugins DEFAULT

XDB DEFAULT

ANONYMOUS DEFAULT

Ctxsys DEFAULT

Orddata DEFAULT

Owbsys_audit DEFAULT

apex_030200 DEFAULT

Appqossys DEFAULT

Wmsys DEFAULT

USERNAME profile

------------------------------ ------------------------------

Exfsys DEFAULT

Ordsys DEFAULT

Mdsys DEFAULT

Flows_files DEFAULT

Sysman DEFAULT

Dbsnmp Monitoring_profile

Outln DEFAULT

SYSTEM DEFAULT

SYS DEFAULT

Mgmt_view DEFAULT

Rows selected.

Sql> ALTER profile DEFAULT LIMIT password_life_time UNLIMITED; --Set password expiration to unlimited

Profile altered.

Sql> SELECT * from dba_profiles s WHERE s.profile= ' DEFAULT ' and resource_name= ' password_life_time '; --Check the password expiration date

Profile Resource_name RESOURCE

------------------------------ -------------------------------- --------

LIMIT

----------------------------------------

DEFAULT Password_life_time PASSWORD

UNLIMITED

You do not need to restart the database for immediate effect.

This time can use Plsql login, login will let you enter the password, you enter the original password can be.

or executing on the server

Sql>alter user username identified by < original password >--Can not change password.

If you modify the service again, you will not be able to report the database password expiration error.

Oracle Database Password Expiration error