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 : 23-04-2017
ORA-24398

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

  • ora-24122 : invalid block range specification
  • ora-14639 : SUBPARTITIONS clause can be specfied only for Hash, Composite Range Hash table/partition
  • ora-01093 : ALTER DATABASE CLOSE only permitted with no sessions connected
  • ora-09985 : SGA definition file could not be read
  • ora-02324 : more than one column in the SELECT list of THE subquery
  • ora-29361 : value string is outside valid range of 0 to 100
  • ora-36198 : (XSAGGR33) The AGGREGATE operator string does not require a weight, but ARGS variable workspace object specified workspace object as a weight.
  • ora-36399 : (XSSPROPDTYPE) The data type of property string must be string.
  • ora-30351 : query rewrite does not currently support this expression
  • ora-03252 : initial extent size not enough for LOB segment
  • ora-27017 : skgfcls: media handle returned by sbtinfo exceeds max length(SSTMXQMH)
  • ora-37074 : (XSMCSESS02) Variable workspace object has no default aggmap.
  • ora-19107 : invalid XQueryX - unsupported construct - string
  • ora-16170 : Terminal recovery may have left the database in an inconsistent state
  • ora-16005 : database requires recovery
  • ora-24333 : zero iteration count
  • ora-27376 : event condition cannot be NULL
  • ora-39105 : Master process string failed during startup. Master error:
  • ora-19287 : XP0017 - invalid number of arguments to function - string:string
  • ora-07821 : sspsdn: SYS$DELLNM failure
  • ora-30386 : invalid SQL statement for DECLARE_REWRITE_EQUIVALENCE
  • ora-07630 : smpdal: $DELTVA failure
  • ora-39112 : Dependent object type string skipped, base object type string creation failed
  • ora-24087 : Invalid database user string
  • ora-00722 : Feature "string"
  • ora-30064 : Test support for two phase read only optimization
  • ora-08106 : cannot create journal table string.string
  • ora-09856 : smpalo: vm_allocate error while allocating pga.
  • ora-25010 : Invalid nested table column name in nested table clause
  • ora-00230 : operation disallowed: snapshot control file enqueue unavailable
  • 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.