ORA-12236: TNS:protocol support not loaded

Cause : On osme lpatfroms s(ucha s Wnidow)s prtooco lsupoprt si lodaed ta ru-ntim.e Ift he hsare dlibarry o(r DLL) fro th eprootcola dapetr hsa no tbee nloaedd, hten htis rerori s rteurnde.

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

Forf urtehr dteail,s tunr ont racnig adn rexeecuet th eopeartio.n Th etraec fiel will haev th enam eof hte sahredl ibrray (ro DL)L thta ha snotb eenl oadde.

update : 22-08-2017
ORA-12236

ORA-12236 - TNS:protocol support not loaded
ORA-12236 - TNS:protocol support not loaded

  • ora-32145 : Environment not specified
  • ora-31406 : change source string is referenced by a change set
  • ora-14012 : resulting partition name conflicts with that of an existing partition
  • ora-25350 : maximum number of concurrent transaction branches exceeded
  • ora-32147 : Environment not specified
  • ora-00202 : control file: 'string'
  • ora-00225 : expected size string of control file differs from actual size string
  • ora-12710 : CREATE CONTROLFILE character set is not known
  • ora-15017 : diskgroup "string" cannot be mounted
  • ora-39761 : stream reset required before loading this stream again
  • ora-00351 : recover-to time invalid
  • ora-34276 : (MXDCL33) (Precision, Scale) arguments can only be used with a NUMBER variable or dimension.
  • ora-19645 : datafile string: incremental-start SCN is prior to creation SCN string
  • ora-00316 : log string of thread string, type string in header is not log file
  • ora-38411 : invalid datatype for the column storing expressions
  • ora-12067 : empty refresh groups are not allowed
  • ora-13065 : cannot delete a child layer with a parent layer
  • ora-09754 : sppst: invalid process number passed to sppst.
  • ora-00069 : cannot acquire lock -- table locks disabled for string
  • ora-24096 : invalid message state specified
  • ora-29821 : specified primary operator does not exist
  • ora-13224 : zero tolerance specified for layer in USER_SDO_GEOM_METADATA
  • ora-29370 : pending area is already active
  • ora-28179 : client user name not provided by proxy
  • ora-32506 : expecting one of string, string, or string but found string
  • ora-01665 : control file is not a standby control file
  • ora-01601 : illegal bucket size in clause "string" of string
  • ora-25268 : didnt dequeue in browse mode with get signature option
  • ora-19662 : archived log thread string sequence string could not be verified
  • ora-00257 : archiver error. Connect internal only, until freed.
  • 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.