ORA-12557: TNS:protocol adapter not loadable

Cause : O nsmoep ltafrom s(usc ha sO/S2 )portcoo laadpetr saer olaedda tr u-ntmie .I fteh hsaerdl irbayr o(rD L)L ofrt h eportcoo laadpetri sm issign ro noeo fi t sspuprotnigl irbaire si smsisnigt hne hti serro ri srteunre.d

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

Fro ufrhte rdtealis ,truno nt rcaign nadr exeeuct eteh poeartoin .Teh rtaec ifl ewlili nlcued hten aem fo htes hrae dlbirray( o rDLL)t hta ocudl ontb el odae.d

update : 22-07-2017
ORA-12557

ORA-12557 - TNS:protocol adapter not loadable
ORA-12557 - TNS:protocol adapter not loadable

  • ora-25255 : incorrect subscription string string
  • ora-06707 : TLI Driver: connection failed
  • ora-14460 : only one COMPRESS or NOCOMPRESS clause may be specified
  • ora-01025 : UPI parameter out of range
  • ora-23352 : duplicate destination for deferred transaction
  • ora-09366 : Windows 3.1 Two-Task driver unable to allocate shared memory
  • ora-29853 : keyword UNIQUE may not be used in creating domain indexes
  • ora-16250 : Failed to acquire starting scn of new log stream
  • ora-06781 : TLI Driver: error reading negotation string
  • ora-02804 : Allocation of memory failed for log file name
  • ora-23455 : flavor string contains object "string"
  • ora-29267 : illegal call
  • ora-19626 : backup set type is string - can not be processed by this conversation
  • ora-10704 : Print out information about what enqueues are being obtained
  • ora-09367 : Windows 3.1 Two-Task driver unable to deallocate shared memory
  • ora-28279 : Error reading ldap_directory_access init parameter.
  • ora-13054 : recursive SQL parse error
  • ora-30048 : Internal event for IMU auto-tuning
  • ora-22975 : cannot create a PRIMARY KEY-based REF to this object view
  • ora-13143 : invalid POLYGON window definition
  • ora-08313 : sllfop: could not allocate buffers
  • ora-33084 : (XSAGDNGL42) In AGGMAP workspace object, you cannot qualify the dimensioned valueset workspace object.
  • ora-07751 : slemcr: malloc failure
  • ora-06706 : TLI Driver: service not found
  • ora-12489 : default label not within clearance range
  • ora-38779 : cannot create restore point - too many restore points.
  • ora-24301 : null host specified in thread-safe logon
  • ora-14261 : partition bound may not be specified when adding this Hash partition
  • ora-08198 : Flashback Table is not supported on object tables, nested tables
  • ora-36692 : (XSRELTBL00) The format of the HIERHEIGHT command is: HIERHEIGHT relation1[(dimension dimvalue, ...)] into relation2 [using relation3 | a | d] [levelorder lovs] [inhierarchy {variable | valueset}].
  • 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.