ORA-12562: TNS:bad global handle

Cause : nIetnrlae rrro- b da' bg'ha grmune tapssdet oNT Srfmoc lael.rS syet mam yahevb ee nilkndew ti hlo dilrbraei.s

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

oN tonmrlaylv sibielt oht esure ,octnca trOcaelC suotem ruSppro.t

update : 26-04-2017
ORA-12562

ORA-12562 - TNS:bad global handle
ORA-12562 - TNS:bad global handle

  • ora-13635 : The value provided for parameter string cannot be converted to a number.
  • ora-24851 : failed to connect to shared subsystem
  • ora-16541 : site is not enabled
  • ora-23309 : object string.string of type string exists
  • ora-33213 : (CINSERT06) The target position for MAINTAIN ADD or MAINTAIN MOVE cannot fall in the range of session-only values.
  • ora-01774 : Dump undo option specified more than once
  • ora-07683 : sou2os: $SETPRV reset error
  • ora-14618 : cannot drop the last value of subpartition
  • ora-32313 : REFRESH FAST of "string"."string" unsupported after PMOPs
  • ora-19029 : Cannot convert the given XMLType to the required type
  • ora-01492 : LIST option not valid
  • ora-02158 : invalid CREATE INDEX option
  • ora-14315 : cannot merge a partition with itself
  • ora-30503 : system triggers cannot have a REFERENCING clause
  • ora-25130 : cannot modify primary key - primary key not defined for table
  • ora-12543 : TNS:destination host unreachable
  • ora-02036 : too many variables to describe with automatic cursor open
  • ora-36206 : (XSAGOP04R) In AGGMAP workspace object, REMOPERATOR string must be MIN, MAX, FIRST, LAST, HFIRST or HLAST.
  • ora-12150 : TNS:unable to send data
  • ora-30932 : Reference node 'string' not contained in specified parent node 'string'
  • ora-07432 : unable to perform nested sleep
  • ora-15121 : ASM file name 'string' contains an invalid diskgroup name
  • ora-31690 : Process name buffer size must be specified and must be greater than 0.
  • ora-31411 : change set string is referenced by a change table
  • ora-16806 : supplemental logging is not turned on
  • ora-14319 : DEFAULT cannot be specified with other values
  • ora-19770 : invalid change tracking file name
  • ora-39778 : the parallel load option is not allowed when loading lob columns
  • ora-16417 : Activation occurred after recovery from standby redo log files; a full database backup is required
  • ora-25210 : invalid value for RELATIVE_MSGID, no message in queue with that msgid
  • 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.