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 : 18-08-2017

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

  • ora-01234 : cannot end backup of file string - file is in use or recovery
  • ora-22895 : referenced table "string" in schema "string" is not an object table
  • ora-01576 : The instance string is not enabled
  • ora-29390 : some resource plans are not part of any top-plan
  • ora-37016 : (XSACQUIRE01) You must specify objects to acquire for the ACQUIRE command.
  • ora-01511 : error in renaming log/data files
  • ora-27479 : Cannot string "string.string" because other objects depend on it
  • ora-15171 : invalid syntax in the alias path after 'string'
  • ora-02784 : Invalid shared memory ID specified
  • ora-01107 : database must be mounted for media recovery
  • ora-00322 : log string of thread string is not current copy
  • ora-16078 : media recovery disabled
  • ora-08102 : index key not found, obj# string, file string, block string (string)
  • ora-02797 : No requests available
  • ora-24147 : rule string.string does not exist
  • ora-12720 : operation requires database is in EXCLUSIVE mode
  • ora-25175 : no PRIMARY KEY constraint found
  • ora-16811 : apply instance not recorded by the Data Guard broker
  • ora-02345 : cannot create a view with column based on CURSOR operator
  • ora-01686 : max # files (string) reached for the tablespace string
  • ora-12026 : invalid filter column detected
  • ora-06767 : TLI Driver: alloc failed during release
  • ora-30434 : refresh method must be one of FC?AN, not 'string'
  • ora-02461 : Inappropriate use of the INDEX option
  • ora-16601 : site contains required resources that are disabled
  • ora-30066 : test support - drop rollback segment wait
  • ora-24009 : invalid value string, QUEUE_TYPE should be NORMAL_QUEUE or EXCEPTION_QUEUE
  • ora-29884 : domain index is defined on the column to be dropped
  • ora-19023 : The first argument to UPDATEXML operator has to be an XMLTYPE
  • ora-16191 : Primary log shipping client not logged on standby
  • 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.