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 : 26-05-2017
ORA-12557

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

  • ora-19115 : too many context items specified
  • ora-16001 : database already open for read-only access by another instance
  • ora-24901 : handles belonging to different environments passed into an OCI call
  • ora-01181 : file string created before last known RESETLOGS, cannot recreate
  • ora-14042 : partition bound may not be specified for a partition being moved, modified or rebuilt
  • ora-26666 : cannot alter STREAMS process string
  • ora-00319 : log string of thread string has incorrect log reset status
  • ora-22874 : attribute "string" is not part of the type "string"
  • ora-14037 : partition bound of partition "string" is too high
  • ora-06933 : CMX: error during attach
  • ora-16594 : %s process discovered that DMON process does not exist
  • ora-23380 : propagation mode "string" is not valid
  • ora-39025 : jobs of type string are not restartable
  • ora-26053 : Row was not loaded due to conversion error.
  • ora-28029 : could not authorize remote server for user string
  • ora-06923 : CMX: illegal break condition
  • ora-15150 : instance lock mode 'string' conflicts with other ASM instance(s)
  • ora-01539 : tablespace 'string' is not online
  • ora-07750 : slemcr: fopen failure
  • ora-01776 : cannot modify more than one base table through a join view
  • ora-27545 : Fail to prepare buffer for remote update
  • ora-29290 : invalid offset specified for seek
  • ora-32576 : missing TYPE keyword
  • ora-22064 : invalid NLS parameter string [string]
  • ora-00161 : transaction branch length string is illegal (maximum allowed string)
  • ora-32593 : database supplemental logging attributes in flux
  • ora-32518 : cannot wait for ORADEBUG command completion (waited number ms for process string); total wait time exceeds number ms
  • ora-13013 : the specified topology was not INTERIOR or BOUNDARY
  • ora-09875 : TASDEF_WRITE: write error when writing ?/dbs/tasdef@.dbf file.
  • ora-12728 : invalid range in regular expression
  • 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.