Change Oracle password after installation.

To change a password after installation:
  1. Start SQL*Plus:

    C:\> sqlplus /NOLOG
    
    
  2. Connect as SYSDBA:

    SQL> CONNECT / AS SYSDBA
     
    Action SQL Statement

    Unlock a password

    ALTER USER username ACCOUNT UNLOCK;

    Lock a password

    ALTER USER username ACCOUNT LOCK;

    Change password of an unlocked account

    ALTER USER username IDENTIFIED BY password;

    Change password of a locked account

    ALTER USER username IDENTIFIED BY password ACCOUNT UNLOCK;

     
    

Comments

Popular posts from this blog

Offers on Friday, April 24, 2020

Fatal: LoadModule: error loading module 'mod_sql_mysql.c'