本文介绍了有关Oracle中忘记System和Sys密码后的处理方法,一种是OS验证,另一种密码文件验证方式。
Oracle提供两种验证方式,一种是OS验证,另一种密码文件验证方式
如果是第一种方式用以下方法修改密码:
sqlplus /nolog; connect / as sysdba alter user sys identified by ; alter user system identified by ; |
如果是第二种方法用以下方法修改密码:
orapwd file=pwdxxx.ora password=你设定的新密码 entries=10 |
设定完后,重新启动服务,再次登陆就可以了。
Oracle 10g忘记system,sys,sysman密码解决方案
C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 10.1.0.2.0 - Production on 星期六 12月 26 11:08:34 2010
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> alter user system identified by “123456”;
User altered.
SQL> alter user sys identified by “123456”;
User altered.
SQL> alter user system identified by “123456”;
User altered.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options
C:\Documents and Settings\Administrator>sqlplus
SQL*Plus: Release 10.1.0.2.0 - Production on 星期六 6月 26 11:11:34 2010
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Enter user-name: system
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select instance_name from v$instance;
INSTANCE_NAME
--------------------------------
orcl