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 : 22-09-2017
ORA-24402

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

  • ora-07493 : scgrcl: lock manager error.
  • ora-29864 : analyzing domain indexes marked LOADING/FAILED not supported
  • ora-19720 : Error occurred when converting an OCI number into an SCN
  • ora-12061 : invalid ALTER MATERIALIZED VIEW option
  • ora-12924 : tablespace string is already in force logging mode
  • ora-16094 : database shutdown during archival operation
  • ora-36761 : (XSLANGDM01) Analytic workspace string already contains a dimension (%J) with the string property.
  • ora-02087 : object locked by another process in same transaction
  • ora-12716 : Cannot ALTER DATABASE CHARACTER SET when CLOB data exists
  • ora-28502 : internal communication error on heterogeneous database link
  • ora-14645 : STORE IN clause cannot be specified for Range List objects
  • ora-19708 : log destination exceeds maximum length of string characters
  • ora-02703 : osnpopipe: pipe creation failed
  • ora-19770 : invalid change tracking file name
  • ora-12075 : invalid object or field
  • ora-07268 : szguns: getpwuid error.
  • ora-10267 : Inhibit KSEDMP for testing
  • ora-14298 : LOB column block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-30177 : invalid flag used in a format specification
  • ora-29842 : option not supported with the version string of the indextype interface
  • ora-15080 : synchronous I/O operation to a disk failed
  • ora-38736 : Wrong thread number string in flashback log file header.
  • ora-25505 : the system is not in quiesced state
  • ora-28049 : the password has expired
  • ora-37032 : (XSMLTMAINT03) You cannot MAINTAIN partition template workspace object in MULTI mode.
  • ora-12319 : database (link name string) is already open
  • ora-02054 : transaction string in-doubt
  • ora-04002 : INCREMENT must be a non-zero integer
  • ora-13910 : Parameter string cannot be NULL.
  • ora-16810 : multiple errors or warnings detected for the database
  • 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.