how to restore system user in oracle and lock it back

Following instructions will help you unlock the oracle db system user and lock it back when needed.
Those are the instructions:
1) login to a machine as user oracle
2) connect to sqlplus: sqlplus '/ as sysdba'
3) unlock user: alter user system account unlock;
4) change password: alter user system identified by manager;
5) verify connection: conn system/manager
6) restore password: ALTER USER system IDENTIFIED BY VALUES 'F2B917B76C7DFF0A';
7) lock user: alter user system account lock;
8) verify lock: conn system/manager
you should see the following message: ERROR: ORA-28000: the account is locked

Comments

Leigh Bolton said…
Mark Hurd, who shares the CEO position at Oracle with Safra Catz, reiterated that Oracle’s cloud business grew 82% year-over-year in its most recent quarter to roughly $800 million. 80% of corporate data centers will be gone, meaning companies are moving their IT infrastructures to data centers provided by cloud-focused companies…..

Popular posts from this blog

How to set or disable auto-logout on bash shell

How to install PGPool II on PostgreSQL Servers in master-slave architecture + PGPoolAdmin web managment

How to Install Terraform 0.12 on Ubuntu 18.04