윌리/DB
[Oracle] 오라클 sys 암호 변경
Jehna
2018. 3. 19. 14:49
"오라클 sys 암호 변경"
<환경>
- CentOS7
- Oracle 10g
1. oracle sys 로 접속
[oracle@orcl root]$ su - oracle Password: [oracle@orcl ~]$ sqlplus "/as sysdba" // sys로 접속하는 명령어 SQL*Plus: Release 10.2.0.5.0 - Production on Mon Mar 19 07:54:53 2018 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Data Mining and Real Application Testing options SQL> show user; USER is "SYS" |
2. sys 암호 변경
alter user [사용자이름] identified by [변경 할 비밀번호];
SQL> alter user sys identified by oracle; User altered. |