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
This is a Forthscale blog aimed to share the knowledge we had gained in our projects.
1 comment:
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…..
Post a Comment