EBS11i 安装完成，无Orapwd文件之解决方法

以Oracle用户登陆系统，打开终端

[oracle@rh~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.3.0 - Production on Thu Apr 15 09:58:45 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.3.0 - Production

SQL> alter user sys identified by oracle;

User altered.

SQL> show parameter pass

NAME                       TYPE    VALUE

remote_login_passwordfile string NONE(检查当前口令文件是否启用）NONE为未启用，

启用口令文件：remote_login_passwordfile = exclusive

SQL> alter system set remote_login_passwordfile=exclusive scope=spfile;

System altered.

SQL>shutdown immediate(重启数据库设置生效）

SQL> startup force;

ORACLE instance started.

Total System Global Area 131142648 bytes

Fixed Size 451576 bytes

Variable Size 104857600 bytes

Database Buffers 25165824 bytes

Redo Buffers 667648 bytes

ORA-01990: error opening password file ''/opt/oracle/product/9.2.0/dbs/orapw''

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3(当前口令文件不存在）

SQL> show parameter pass

NAME TYPE VALUE

remote_login_passwordfile string EXCLUSIVE

创建spfile文件

create spfile from pfile

打开新的终端，执行[oracle@rh~]$ source /home/oracl/.ora

[oracle@rh~]$ cd $ORACLE_HOME/bin

[oracle@bin]$ orapwd

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.

[oracle@rh dbs]$ orapwd file=$ORACLE_HOME/dbs/orapw password=password entries=2

[oracle@rh dbs]$

重启数据库OK！

(参考：http://hi.baidu.com/zhougw03/blog/item/0113dbfc71db94fefc037f7e.html，其中Orapwd命令执行不同，即file=----orapw 其文中文件命名为orapw.ora,导致ora-01990错误仍然存在。将其后缀去掉执行Orapwd命令，问题解决）