ORA-24398: connection pool already exists

Cause : Aocnnceitnop oo lah slaerda yebnec ertadef rot ehs epicifdep oo lahdnel.

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

)1S epicyfa d fiefertnp oo lahdnelt orcaeeta n wec noentcoi noplo .)2I foy uiwhst oomidyft ehp oo laparemetsr ,acllO ICoCnnceitnooPlorCaeeti nCO_IPCOO_LERNITIAIILEZm do.e

update : 22-07-2017

ORA-24398 - connection pool already exists
ORA-24398 - connection pool already exists

  • ora-22130 : buffer size [string] is less than the required size [string]
  • ora-31501 : change source string is not an AutoLog change source
  • ora-16727 : resource guard cannot close database
  • ora-16633 : the only instance of the database cannot be removed
  • ora-02242 : no options specified for ALTER INDEX
  • ora-15060 : template "string" does not exist
  • ora-37070 : You may not execute OLAP DML programs in a parallel query session.
  • ora-19300 : Error occurred in uri processingstring
  • ora-07700 : sksarch: interrupt received
  • ora-27156 : request for process information failed
  • ora-15082 : ASM failed to communicate with database instance
  • ora-30378 : MV_CAPABILITIES_TABLE is not compatible with Oracle version
  • ora-16132 : An error occurred during activation of the standby.
  • ora-12007 : materialized view reuse parameters are inconsistent
  • ora-02226 : invalid MAXEXTENTS value (max allowed: string)
  • ora-36278 : (XSCGMDLAGG07) workspace object does not exist or is not valueset.
  • ora-23318 : a ddl failure has occurred
  • ora-00263 : there are no logs that need archiving for thread string
  • ora-00290 : operating system archival error occurred. See error below
  • ora-14253 : table is not partitioned by Composite Range method
  • ora-12443 : policy not applied to some tables in schema
  • ora-24335 : cannot support more than 1000 columns
  • ora-30071 : conversion between datetime/interval and string fail
  • ora-13455 : GeoRaster metadata TRS error
  • ora-31068 : updateXML expected data format [string] instead of [string]
  • ora-29536 : badly formed source: string
  • ora-09929 : GLB of two labels is invalid
  • ora-22337 : the type of accessed object has been evolved
  • ora-29839 : failed to validate implementation type
  • ora-09744 : smsget: mmap returned an error.
  • 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.