没人回答我自己来吧 为了省事,直接冷备份Oracle的数据文件,安装好oracle后,直接恢复到原来对应的目录。启动,出现: SQL> startup ORACLE 例程已经启动。 Total System Global Area 135338868 bytes Fixed Size 453492 bytes Variable Size 109051904 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes ORA-01991: ???????'D:\oracle\ora92\DATABASE\PWDora9.ORA' 解决方法,由于未运行在归档模式下,使用orapwd重建oracle的密码文件: C:\>orapwd /help Usage: orapwd file= passWord=entries= 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. SQL> host del D:\oracle\ora92\DATABASE\PWDora9.ORA SQL> host orapwd file=D:\oracle\ora92\DATABASE\PWDora9.ORA password=oraclepass e ntries=10 SQL> alter database open; 数据库已更改。重新登录的时候,应该输入旧数据库设定的密码
日志:
Thu Apr 03 09:47:01 2008
ORA-01109: 数据库未打开
为了省事,直接冷备份Oracle的数据文件,安装好oracle后,直接恢复到原来对应的目录。启动,出现: SQL> startup
ORACLE 例程已经启动。 Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
ORA-01991: ???????'D:\oracle\ora92\DATABASE\PWDora9.ORA' 解决方法,由于未运行在归档模式下,使用orapwd重建oracle的密码文件: C:\>orapwd /help
Usage: orapwd file= passWord=entries= 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.
SQL> host del D:\oracle\ora92\DATABASE\PWDora9.ORA SQL> host orapwd file=D:\oracle\ora92\DATABASE\PWDora9.ORA password=oraclepass e
ntries=10 SQL> alter database open; 数据库已更改。重新登录的时候,应该输入旧数据库设定的密码