我重动数据库时为什么会有这种错误提示

liumingdi 2003-12-22 01:56:40
SVRMGR> startup
已启动 ORACLE 实例。
系统全局区域合计有 70108428个字节
Fixed Size 70924个字节
Variable Size 36405248个字节
Database Buffers 33554432个字节
Redo Buffers 77824个字节
ORA-01991: ???????'d:\Oracle\Ora81\DATABASE\PWDgdsmart.ORA'
SVRMGR>

如何解决呀
...全文
23 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
zgh2003 2003-12-22
  • 打赏
  • 举报
回复
路径“d:\Oracle\Ora81\DATABASE\PWDgdsmart.ORA”中的密码文件“PWDgdsmart.ORA”
遭到破坏或不存在,解决办法:
先将PWDgdsmart.ORA剪切到其它地方(等数据库启动成功后再删除),
运行下面命令建立密码文件:
c:\orapwd file=d:\Oracle\Ora81\DATABASE\PWDgdsmart.ORA
password=password entries=10 /**其中参数password与entries可以修改。**/
再启动数据库。
shuangyu 2003-12-22
  • 打赏
  • 举报
回复
When trying to open (or mount) a database the following error is generated:

ORA-01991: invalid password file '...PWDOrcl.ora'

Where ‘Orcl’ is the SID of the database instance.

Cause:
Typically some corruption of the password file, or possibly the password file is for another database instance?

Possible Remedies:
If encountered when creating the database then it is because Oracle expects to create the password file but it already exists. In this instance database creation will have failed. Delete the password file and try again.

If it is suspected that the password file is corrupt then try deleting it and recreating it:

Delete the existing password file.

Create a new/replacement password file:

orapwd file=<path>\PWD<sid>.ora password=oracle

Use the same path as given in the Oracle error. The password specified will be the new internal password.


--------------------------------------------------------------------------------
shuangyu 2003-12-22
  • 打赏
  • 举报
回复
删除这个密码文件,重建一个,

17,380

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 基础和管理
社区管理员
  • 基础和管理社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧