分类: Oracle
2011-12-27 16:42:02
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\product\10.1.0\db_1\DATABASE\PWDtest.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\product\10.1.0\DATABASE\PWDtest.ORA
SQL> host orapwd file=D:\oracle\product\10.1.0\db_1\DATABASE\PWDtest.ORA password=xxxxx
entries=10
SQL> alter database open;
数据库已更改。
重新登录的时候,应该输入旧数据库设定的密码;