[ 执行数据库启动命令报错 ]
SQL> startup
ORACLE instance started.
Total System Global Area 655854448 bytes
Fixed Size 732016 bytes
Variable Size 419430400 bytes
Database Buffers 234881024 bytes
Redo Buffers 811008 bytes
ORA-01990: error opening password file '/oracle/app/product/920/dbs/orapw'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
[ 处理方法 ]
问题是因为密码文件丢失或被破坏等原因造成文件不能访问。
查看命令orapwd语法:
$ orapwd
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.
查看密码文件所在位置:
$ pwd
/oracle/app/product/920/dbs
在指定位置重建密码文件:
$ orapwd file=/oracle/app/product/920/dbs/orapw password=sys123 entries=10
使用sqlplus重新启动oracle数据库:
$ sqlplus /nolog
sql>conn / as sysdba
sql>startup