Oracle System/system 초기화

# 비밀번호 초기화하기

SQL> conn /as sysdba
SQL> alter user system identified by 1234;
SQL> alter user sys identified by 1234;
SQL> conn system/1234

# LOCK 해제하기

SQL> conn sys/1234 as sysdba
SQL> ALTER USER SYSTEM ACCOUNT UNLOCK;
SQL> ALTER USER SYSTEM IDENTIFIED BY 1234;

#접속 확인하기

sqlplus /nolog
SQL> conn system/1234
SQL> show user;
USER은 "SYSTEM"입니다.

#sys, system 계정의 FAILED_LOGIN_ATTEMPTS LIMIT를 확인하기

SQL> select du.username, dp.profile, dp.resource_name, dp.limit
SQL> from dba_users du, dba_profiles dp
SQL> where dp.profile = du.profile
SQL> and du.username in ('SYS','SYSTEM')
SQL> and dp.resource_name = 'FAILED_LOGIN_ATTEMPTS'
SQL> ;