标签：sysdba
Oracle lost sysdba password

Oracle忘记管理员密码处理
[oracle@flyinweb ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 25 22:53:26 2011
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
SQL> connect / as sysdba 
Connected to an idle instance.
SQL> alter user sys identified by password@oracle;
alter user sys identified by password@oracle;
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

SQL> startup
ORACLE instance started.
Total System Global Area 1272213504 bytes
Fixed Size                  1336260 bytes
Variable Size             771755068 bytes
Database Buffers          486539264 bytes
Redo Buffers               12582912 bytes
Database mounted.
Database opened.

SQL> alter user sys identified by password;
User altered.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

以上在Cent OS 5.6 Oracle Database 11g上测试通过

本日志由 flyinweb 于 2011-07-25 23:08:18 发表到 数据库技术 中，目前已经被浏览 905 次，评论 0 次；

作者添加了以下标签： sysdba；

首页只显示了部分日志内容，要查看日志的全部内容请阅读全文；