ORA-12228: TNS:protocol adapter not loadable

Cause : On smoe pltaform s(suc has Wnidows )protcool spuporti s lodaed a trun-itme. fI thes hare dlibrray (o rDLL)f or teh prootcol daapte ris msisingo r on eof ist supoprtin glibrraies si misisng tehn thsi errro is erturnde.

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

For ufrthe rdetalis, trun ont racign andr eexeucte teh opeartion .The rtace ifle wlil inlcude hte naem of hte shraed lbirary( or DLL) thta coudl notb e lodaed.

update : 24-04-2017
ORA-12228

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

  • ora-02437 : cannot validate (string.string) - primary key violated
  • ora-13348 : polygon boundary is not closed
  • ora-26510 : materialized view name: 'string' is greater than max. allowed length of string bytes
  • ora-24191 : the property name string has existed
  • ora-31004 : Length string of the BLOB in XDB$H_INDEX is below the minimum string
  • ora-27202 : skgfpen: sbtpcend returned error
  • ora-34363 : (MXDSS13) number other user writing
  • ora-29540 : class string does not exist
  • ora-12574 : TNS:redirection denied
  • ora-15057 : specified size of string MB is larger than actual size of string MB
  • ora-35276 : (SNSYN163) The format of the ALLOCATE command is: ALLOCATE varname [SOURCE svarname] [BASIS bvarname [ACROSS dimname]] [TARGET tvarname [TARGETLOG logvarname]] [ USING aggmap ]
  • ora-22809 : nonexistent attribute
  • ora-06747 : TLI Driver: error in listen
  • ora-21522 : attempted to use an invalid connection in OCI (object mode only)
  • ora-28367 : wallet does not exist
  • ora-39128 : unexpected DbmsJava error number from statement string
  • ora-07612 : $GETUAI failed in retrieving the user's clearance level
  • ora-30396 : rewrite equivalence procedures require the COMPATIBLE parameter to be string or greater
  • ora-07576 : sspexst: $GETJPIW failure on process ID string
  • ora-25236 : buffer too small for user data
  • ora-26503 : internal RepAPI operation failure on object string.string
  • ora-38498 : invalid stored attribute for the index object : string
  • ora-14063 : Unusable index exists on unique/primary constraint key
  • ora-19112 : error raised during evaluation: string
  • ora-01218 : logfile member is not from the same point-in-time
  • ora-06134 : NETTCP: file access privilege violation
  • ora-02253 : constraint specification not allowed here
  • ora-30566 : Index maintainence clause not allowed for this command
  • ora-39166 : Object string was not found.
  • ora-13158 : Oracle object string does not exist
  • 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.