ORA-24392: no connection pool to associate server handle

Cause : OCIServerAttach called in OCI_POOL mode but no connection pool found to associate the server handle.

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

1) Verify that OCIConnectionPoolCreate is called before calling OCIServerAttach. 2) Verify that the database link specified in OCIServerAttach matches with that of the connection pool database link.

update : 26-04-2017

ORA-24392 - no connection pool to associate server handle
ORA-24392 - no connection pool to associate server handle

  • ora-12612 : TNS:connection is busy
  • ora-25116 : invalid block number specified in the DUMP DATAFILE/TEMPFILE command
  • ora-22308 : operation not allowed on evolved type
  • ora-12054 : cannot set the ON COMMIT refresh attribute for the materialized view
  • ora-07281 : slsget: times error, unable to get cpu time.
  • ora-10586 : Test recovery had to corrupt 1 data block in order to proceed
  • ora-39203 : Partition selection is not supported over a network link.
  • ora-12527 : TNS:listener: all instances are in restricted mode or blocking new connections
  • ora-30030 : suppress resumable related error message
  • ora-01541 : system tablespace cannot be brought offline; shut down if necessary
  • ora-02216 : tablespace name expected
  • ora-00476 : RECO process terminated with error
  • ora-07494 : scgcm: unexpected error.
  • ora-19609 : %s is from different backup set: stamp string count string
  • ora-00288 : to continue recovery type ALTER DATABASE RECOVER CONTINUE
  • ora-02038 : define is not allowed for array type
  • ora-01030 : SELECT ... INTO variable does not exist
  • ora-02344 : cannot revoke execute on a type with table dependents
  • ora-12542 : TNS:address already in use
  • ora-07425 : sdpri: error string in translating dump file location.
  • ora-29399 : user string does not have privilege to switch to consumer group string
  • ora-23332 : group string is in use; cannot drop
  • ora-09369 : Windows 3.1 Two-Task driver bad instance handle
  • ora-23472 : materialized view "string"."string" must be atomically refreshed
  • ora-02403 : plan table does not have correct format
  • ora-08308 : sllfop: Cannot open file
  • ora-14151 : invalid table partitioning method
  • ora-31199 : Warning in processing file string
  • ora-10659 : Segment being shrunk is not a lob
  • ora-32811 : subscriber string already exists
  • 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.