Oracle 11g Dos下 找回用户名和修改密码方法

Oracle 11g  Dos下 找回用户名和修改密码方法：

 

Microsoft Windows [版本 6.1.7600]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。

C:\Users\Administrator>set oracle_sid=orcl  //数据库启动

C:\Users\Administrator>sqlplus / as sysdba   //以系统管理员登陆

SQL*Plus: Release 11.2.0.1.0 Production on 星期二 3月 26 14:46:37 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user   //显示用户名
USER 为 "SYS"
SQL> alter user sys identified by 123456;//修改密码

用户已更改。

SQL> connect sys/123456  //用户名和密码登陆数据库
ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

警告: 您不再连接到 ORACLE。
SQL> connect sys/123456 as sysdba  //用户名和密码登陆数据库
已连接。
SQL> alter system identified by 123456;
alter system identified by 123456
             *
第 1 行出现错误:
ORA-02065: 非法的 ALTER SYSTEM 选项

SQL> alter user system identified by 123456;//修改密码

用户已更改。

SQL> desc dba_users
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ----------------------------

 USERNAME                                  NOT NULL VARCHAR2(30)
 USER_ID                                   NOT NULL NUMBER
 PASSWORD                                           VARCHAR2(30)
 ACCOUNT_STATUS                            NOT NULL VARCHAR2(32)
 LOCK_DATE                                          DATE
 EXPIRY_DATE                                        DATE
 DEFAULT_TABLESPACE                        NOT NULL VARCHAR2(30)
 TEMPORARY_TABLESPACE                      NOT NULL VARCHAR2(30)
 CREATED                                   NOT NULL DATE
 PROFILE                                   NOT NULL VARCHAR2(30)
 INITIAL_RSRC_CONSUMER_GROUP                        VARCHAR2(30)
 EXTERNAL_NAME                                      VARCHAR2(4000)
 PASSWORD_VERSIONS                                  VARCHAR2(8)
 EDITIONS_ENABLED                                   VARCHAR2(1)
 AUTHENTICATION_TYPE                                VARCHAR2(8)

SQL> select username from dba_users;

USERNAME
------------------------------
MGMT_VIEW
SYS
SYSTEM
DBSNMP
SYSMAN
CQTIMAS
OUTLN
FLOWS_FILES
MDSYS
ORDSYS
EXFSYS

USERNAME
------------------------------
WMSYS
APPQOSSYS
APEX_030200
OWBSYS_AUDIT
ORDDATA
CTXSYS
ANONYMOUS
XDB
ORDPLUGINS
OWBSYS
SI_INFORMTN_SCHEMA

USERNAME
------------------------------
OLAPSYS
SCOTT
ORACLE_OCM
XS$NULL
BI
PM
MDDATA
IX
SH
DIP
OE

USERNAME
------------------------------
APEX_PUBLIC_USER
HR
SPATIAL_CSW_ADMIN_USR
SPATIAL_WFS_ADMIN_USR

已选择37行。

SQL>

转载于:https://www.cnblogs.com/xygzs/archive/2013/03/26/2982553.html