ORA-09914: Unable to open the ORACLE password file.

Cause : ORACLE could not open the password file for reading.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Check the UNIX error number. If the error number indicates that the file does not exist, have the database administrator create the file by running orapasswd. If the error number indicates insufficient permissions, ask the database administrator to change the permissions. Otherwise, contact ORACLE customer support.

update : 29-06-2017

ORA-09914 - Unable to open the ORACLE password file.
ORA-09914 - Unable to open the ORACLE password file.

  • ora-01867 : the interval is invalid
  • ora-14119 : specified partition bound is too long
  • ora-13421 : null or invalid cell value
  • ora-14059 : partition "string": INITRANS value must be less than MAXTRANS value
  • ora-02402 : PLAN_TABLE not found
  • ora-12688 : Login failed: the SecurID server rejected the new pincode
  • ora-07646 : sszfck: $CREATE failure
  • ora-32407 : cannot exclude new values when materialized view log includes new values
  • ora-29546 : badly formed resource: string
  • ora-00345 : redo log write error block string count string
  • ora-06906 : CMX: cannot get maximum packet size from CMX
  • ora-32742 : Hang analysis initialize failed
  • ora-00252 : log string of thread string is empty, cannot archive
  • ora-00053 : maximum number of enqueues exceeded
  • ora-26572 : %s.string.string: argument string does not match replication catalog
  • ora-22903 : MULTISET expression not allowed
  • ora-24440 : OCI Easy Install mode cannot be initialized
  • ora-31693 : Table data object string failed to load/unload and is being skipped due to error: string
  • ora-06958 : Failed to access configuration file
  • ora-25185 : index column other than last can not be specified for INCLUDE clause
  • ora-16768 : SQL Apply unexpectedly offline
  • ora-26000 : partition load specified but table string is not partitioned
  • ora-38306 : this object is not recoverable standalone
  • ora-19162 : XP0004 - XQuery type mismatch: invalid argument types 'string', 'string' for function 'string'
  • ora-07709 : sksaprs: archiving to a remote host is not allowed
  • ora-29329 : Table not of type XMLType
  • ora-19603 : cannot backup or copy active file with KEEP .. UNRECOVERABLE option
  • ora-32017 : failure in updating SPFILE
  • ora-26528 : local store callback proc phase failed for 'string.string'
  • ora-09205 : sfqio: error reading or writing to disk
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.