ORA-28002: the password will expire | Make Oracle password never expire | Oracle Database



ORA-28002: the password will expire | Make Oracle password never expire | Oracle Database

ORA-28002: the password will expire | Make Oracle password never expire |  Oracle Database

ORA-28002: the password will expire | Make Oracle password never expire | Oracle Database | How to set Oracle Database 18c, sql plus username and password for unlimited
Make Oracle password never expire
commands:~
connect sys/secret_password as sysdba;
alter user SYSTEM identified by password;
alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;
alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited;

select username, account_status, EXPIRY_DATE from dba_users where username=’SYSTEM’;
#softtechhelp
#oracle
#cmd