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 : 24-05-2017

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

  • ora-26532 : replication parallel push simulated site failure
  • ora-19226 : XP0006 - XQuery dynamic type mismatch: expected string got string
  • ora-02876 : smpini: Unable to attach to shared memory for PGA
  • ora-09209 : sftget: error reading from file
  • ora-30395 : dimension options require the COMPATIBLE parameter to be string or greater
  • ora-27465 : invalid value string for attribute string
  • ora-15072 : command requires at least string failure groups, discovered only string
  • ora-13003 : the specified range for a dimension is invalid
  • ora-22344 : can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change
  • ora-33308 : (DBVALID04) SEVERE ERROR: Record number used but not allocated
  • ora-16177 : media recovery is not required
  • ora-16544 : modifying DG_BROKER_START requires SID='*' qualifier
  • ora-01970 : You must specify a database name for CREATE CONTROLFILE
  • ora-06018 : NETASY: message send failure
  • ora-30071 : conversion between datetime/interval and string fail
  • ora-36672 : (XSDPART10) A RANGE or LIST PARTITION TEMPLATE can only have a single partition dimension.
  • ora-28045 : SSL authentication between database and OID failed
  • ora-24001 : cannot create QUEUE_TABLE, string already exists
  • ora-13206 : internal error [string] while creating the spatial index
  • ora-30364 : this level has the same set of columns as another
  • ora-22889 : REF value does not point to scoped table
  • ora-29274 : fixed-width multibyte character set not allowed for a URL
  • ora-19011 : Character string buffer too small
  • ora-01243 : system tablespace file suffered media failure
  • ora-07228 : rtecho: unable to restore terminal to echo mode.
  • ora-39048 : Unable to start all workers; only string worker(s) available.
  • ora-32322 : PCT refresh of "string"."string" not allowed the sequence of DMLs/PMOPs
  • ora-30006 : resource busy; acquire with WAIT timeout expired
  • ora-09208 : sftcls: error closing file
  • ora-00380 : cannot specify db_stringk_cache_size since stringK is the standard block size
  • 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.