问:当忘记了oracle口令时应该怎么办？

txkss

现在数据库已经进不去了
请问有什么办法可以解决啊

谢谢大家

jeffreyli

(如果oracle没有口令)以root用户进去,su到oracle用户下,用sqlplus "/as sysdba"
进去后就可以修改.

bitao

orapwd重新生成密码文件

imtj

同一楼上的！

chris0820

是，改口令文件

gscyjh

修改用户密码

sqlplus "/@服务名 as sysdba"
然后在sqlplus中
alter user sys identified by 新密码;
alter user system identified by 新密码;

redhawk

同意6楼的

txkss

@服务名 请问这个服务名是什么意思？    我去什么地方可以看出来啊？


另外

sqlplus "/@服务名 as sysdba"
  上面这句话我直接在cmd 下输入就可以了是不是啊？

谢谢

gongzidong

支持 6楼的

beautiful

TO txkss:

You must come into the system as oracle user.

Next.

Enter the following command:

sqlplus /nolog

connect / as sysdba

alter user sys identified by 'your password'

alter user system identified by 'your password'

Below is an example:

[oracle@localhost oracle]$ sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Tuesday Auguest 1 17:15:31 2006

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

SQL> connect / as sysdba
Connected.
SQL> alter user sys identified by txkss123456;

User altered.
SQL> alter user system identified by txkss123456;

User altered.
SQL>quit

Now your password for the user sys and system is txkss123456.

Thanks.

[ 本帖最后由 beautiful 于 2006-8-1 17:34 编辑 ]