ORA-24402: error occured while creating connections in the pool

Cause : The username and password specified in OCIConnectionPoolCreate might be invalid.

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

Specify a valid username and password.

update : 28-07-2017
ORA-24402

ORA-24402 - error occured while creating connections in the pool
ORA-24402 - error occured while creating connections in the pool

  • ora-15091 : operation incompatible with open handle in this session
  • ora-22888 : duplicate SCOPE clauses for a REF column
  • ora-12922 : concurrent ALTER DATABASE [NO] FORCE LOGGING command is running
  • ora-06525 : Length Mismatch for CHAR or RAW data
  • ora-22313 : cannot use two versions of the same type "string"
  • ora-00308 : cannot open archived log 'string'
  • ora-12924 : tablespace string is already in force logging mode
  • ora-00231 : snapshot control file has not been named
  • ora-06435 : ssaio: write error, unable to write requested block to database file.
  • ora-30567 : name already used by an existing log group
  • ora-12687 : Credentials expired.
  • ora-12703 : this character set conversion is not supported
  • ora-30066 : test support - drop rollback segment wait
  • ora-02296 : cannot enable (string.string) - null values found
  • ora-22958 : This operation is not allowed in check constraints or triggers
  • ora-02043 : must end current transaction before executing string
  • ora-23416 : table "string"."string" does not contain a primary key constraint
  • ora-12409 : policy startup failure for string policy
  • ora-16403 : shutdown in progress - remote connection is not permitted
  • ora-09719 : osncui: invalid handle.
  • ora-01091 : failure during startup force
  • ora-00057 : maximum number of temporary table locks exceeded
  • ora-01286 : start interval required
  • ora-12230 : TNS:Severe Network error occurred in making this connection
  • ora-23371 : column string unknown in table string
  • ora-22819 : scope of input value does not correspond to the scope of the target
  • ora-15178 : directory 'string' is not empty; cannot drop this directory
  • ora-02264 : name already used by an existing constraint
  • ora-16705 : internal error in resource guard
  • ora-01208 : data file is an old version - not accessing current version
  • 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.