Oracle更改system和sys用户名和密码[回钦波解析]

原先安装oracle时就没设置和管理默认oracle的 dba和 scott 等用户,昨天怎么好进不去,后来慢慢摸索着修改用用户密码果然成功了!!期望新手们和钦波一起加油..

 

D:\oracle\ora92\bin>sqlplus /nolog 这句话是说不登陆数据库，只启动sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on 星期四 8月 16 11:32:22 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn /as sysdba
已连接。
SQL> alter user system identified by password;

用户已更改。

SQL> alter user sys identified by password;

用户已更改。

SQL> alter user system identified by manger;

用户已更改。

SQL> exit

<!---------------------------------------------------------------------

      钦波友情提示:

      如果你想修改用户的话请用下面的语句:

      conn   /   as   sysdba

     alter   user   sys   identified   by   sys;

     alter   user   system   identified   by   system;

      ...

------------------------------------------------------------->

<!---------------------------------------------------------------------

      钦波友情提示:

      如果你想修改scott用户的话请先解锁(因为默认scott用户是被锁住的)用下面的语句:

      conn   /   as   sysdba

     

     alter   user scott account unlock;

     alter   user   scott   identified   by   password;

     alter   user   system   identified   by   tiger;

      ...

------------------------------------------------------------->

从Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production中断开

D:\oracle\ora92\bin>sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on 星期四 8月 16 11:40:37 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

请输入用户名:  system
请输入口令:

连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
orcl