ora9i 忘了密码,怎么办

deepperblue

装的ora9i for solaris,装完2个星期没动,忘了系统密码,有没有什么解决办法,我是菜鸟,虚心请教大家,谢谢

george.ma

看来你真的是一个非常非常新的新手，忘记sys密码，非常简单，登录到oracle所有机器，设置正确的ORACLE_SID，用sqlplus "/as sysdba"就可以直接登录，然后再改密码。

deepperblue

用root帐户运行/ora/bin/orapwd file=/ora/dbs/orapworcl password=test123 entires=30 提示
Unable to find error file
在sun主机运行sqlplus "/as sysdba"
然后sql>show user;  显示是SYS
然后sql>alter user sys identified by test123;
显示missing or invaild operation
实在是菜鸟,希望高手搭救

numenhuang

su - oracle
$orapwd file=/ora/dbs/orapworcl password=test123 entires=30

deepperblue

$ orapwd file=/ora/dbs/orapworcl password=test123 entires=30
Usage: orapwd file=<fname> password=<password> entries=<users>

  where
    file - name of password file (mand),
    password - password for SYS (mand),
    entries - maximum number of distinct DBA and OPERs (opt),
  There are no spaces around the equal-to (=) character.

这是命令输入后的执行结果拷屏,密码还是没有修改成功,偶滴神啊
是su - oracle 后的执行

numenhuang

原帖由 deepperblue 于 2007-9-11 13:46 发表
$ orapwd file=/ora/dbs/orapworcl password=test123 entires=30
Usage: orapwd file= password= entries=

  where
    file - name of password file (mand),
    password - password for SYS (mand), ...

entries=30

deepperblue

终于搞定,偶滴神,我是大头虾,修改后重启数据库,一切正常.谢谢楼上的大侠

[ 本帖最后由 deepperblue 于 2007-9-11 14:28 编辑 ]

deepperblue

同时另外一个疑问
在sun主机运行sqlplus "/as sysdba"
然后sql>show user;  显示是SYS
然后sql>alter user sys identified by test123;
显示missing or invaild operation
为什么这种方法不对呢?