CA Service Management

When User are lock under Oracle

  • 1.  When User are lock under Oracle

    Broadcom Employee
    Posted 10-03-2013 12:16 PM
    When you find that the user is lock under Oracle, here is a way to unlock it and find out what other oblicore users are block:


    ->sqlplus /nolog
    -> conn sys@oblicore as sysdba

    -> Look at all the users and if they are locked:

    select username,account_status,expiry_date from dba_users;

    SERNAME ACCOUNT_STATUS EXPIRY_DA
    ----------------------------------------------- ----------------------------------- --------------------
    OBLIDBADMIN OPEN 24-SEP-13
    USRINSIGHT OPEN 24-SEP-13
    USRACE OPEN 24-SEP-13
    OBLICORE EXPIRED & LOCKED 24-SEP-13
    USRCSL OPEN 24-SEP-13
    USRDASH OPEN 24-SEP-13
    USRRPT OPEN 24-SEP-13
    USRPSL OPEN 24-SEP-13
    USRSLA OPEN 24-SEP-13
    USREDR OPEN 24-SEP-13
    USRMTN OPEN 24-SEP-13

    USERNAME ACCOUNT_STATUS EXPIRY_DA
    ------------------------------------------------ ----------------------------------- ------------------
    DBSNMP EXPIRED & LOCKED 24-SEP-13
    WMSYS EXPIRED & LOCKED 24-SEP-13
    SYS OPEN 24-SEP-13
    SYSTEM OPEN 24-SEP-13
    OUTLN EXPIRED & LOCKED 24-SEP-13
    DIP EXPIRED & LOCKED 24-SEP-13
    ORACLE_OCM EXPIRED & LOCKED 24-SEP-13
    TSMSYS EXPIRED & LOCKED 24-SEP-13


    -> Unlock a user under Oracle:

    alter user oblicore account unlock;