ORA-12519: TNS:no appropriate service handler found

Cause : Thel istneer oculdn ot ifnd nay aavilalbe srevic ehanlderst hata re paprorpiat efort he lcien tconenctino.

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

Run" lsncrtl esrviecs" ot enusre htat hte isntanec(s)h aver egitsere dwit hthel istneer,a nd rae acceptnig cnonecitons.

update : 24-09-2017
ORA-12519

ORA-12519 - TNS:no appropriate service handler found
ORA-12519 - TNS:no appropriate service handler found

  • ora-24131 : table string has incorrect columns
  • ora-00355 : change numbers out of order
  • ora-31402 : unrecognized parameter string
  • ora-24159 : invalid variable definiton
  • ora-01123 : cannot start online backup; media recovery not enabled
  • ora-27024 : skgfqsbi: sbtinit2 returned error
  • ora-16222 : automatic Logical Standby retry of last action
  • ora-16761 : resource guard could not stop SQL Apply
  • ora-13520 : Database id (string) not registered, Status = string
  • ora-02331 : cannot create constraint on column of datatype string
  • ora-00378 : buffer pools cannot be created as specified
  • ora-22346 : Type has cyclical dependency. Should use CASCADE option
  • ora-19776 : PROXY restore to ASM diskgroup "string" is not supported.
  • ora-01545 : rollback segment 'string' specified not available
  • ora-27000 : skgfqsbi: failed to initialize storage subsystem (SBT) layer
  • ora-34181 : (MXCHGDCL21) workspace object is not a partitioned VARIABLE.
  • ora-30442 : can not find the definition for filter string
  • ora-24301 : null host specified in thread-safe logon
  • ora-01287 : file string is from a different database incarnation
  • ora-39031 : invalid filter name string
  • ora-16403 : shutdown in progress - remote connection is not permitted
  • ora-12808 : cannot set string_INSTANCES greater than number of instances string
  • ora-19031 : XML element or attribute string does not match any in type string.string
  • ora-30062 : Test support for ktulat latch recovery
  • ora-38428 : too many attributes selected for indexing
  • ora-28540 : internal result set error
  • ora-26048 : Scoped REF column has wrong table name.
  • ora-14291 : cannot EXCHANGE a composite partition with a non-partitioned table
  • ora-01119 : error in creating database file 'string'
  • ora-21607 : memory cartridge service handle not initialized
  • 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.