原先安装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