오라클 시스템 계정 암호를 잃었을 때
OS prompt> orapwd file="C:\oracle\db11gR2\database\PWD[SID].ora" password=[password] entries=5 force=y
SQL> alter user [user] identified by [password];
SQL> alter user [user] account unlock;
SQL> select name from v$database;
OS prompt> sqlplus user/pass@ip:port/SID
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED
댓글 없음:
댓글 쓰기