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-05-2017
ORA-12562

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

  • ora-24375 : Cannot use V6 syntax when talking to a V8 server
  • ora-28602 : statement not permitted on tables containing bitmap indexes
  • ora-06730 : TLI Driver: unable to open clone device
  • ora-01356 : active logminer sessions found
  • ora-09283 : sllfsk: error skipping records
  • ora-29925 : cannot execute string
  • ora-15021 : parameter "string" is not valid in string instance
  • ora-24274 : no row exists in the string table for these parameters
  • ora-02720 : osnfop: shmat failed
  • ora-12537 : TNS:connection closed
  • ora-01641 : tablespace 'string' is not online - cannot add data file
  • ora-14460 : only one COMPRESS or NOCOMPRESS clause may be specified
  • ora-27478 : job "string.string" is running
  • ora-00234 : error in identifying or opening snapshot or copy control file
  • ora-19713 : invalid copy number: string
  • ora-10568 : Failed to allocate recovery state object: out of SGA memory
  • ora-15082 : ASM failed to communicate with database instance
  • ora-03119 : two-task detected inconsistent datatype specification
  • ora-32031 : illegal reference of a query name in WITH clause
  • ora-13142 : invalid PROXIMITY window definition
  • ora-13408 : invalid blockSize storage parameter
  • ora-01101 : database being created currently mounted by some other instance
  • ora-31110 : Action failed as resource string is locked by name
  • ora-27092 : size of file exceeds file size limit of the process
  • ora-00347 : log string of thread string, expected block size string doesn't match string
  • ora-02851 : Request list is empty when it should not be
  • ora-12078 : fast refresh of refresh group ID string failed
  • ora-28578 : protocol error during callback from an external procedure
  • ora-29526 : created Java class string"string"
  • ora-12624 : TNS:connection is already registered
  • 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.