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 : 24-09-2017
ORA-12557

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

  • ora-06118 : NETTCP: unable to complete handshake with ORASRV
  • ora-01229 : data file string is inconsistent with logs
  • ora-37073 : (XSMCSESS01) Applied relation workspace object must be dimensioned by dimension workspace object.
  • ora-13233 : failed to create sequence number [string] for R-tree
  • ora-38491 : could not evaluate subexpression for rowid "string"
  • ora-30369 : maximum number of columns is 32
  • ora-01484 : arrays can only be bound to PL/SQL statements
  • ora-16519 : the resource handle is invalid
  • ora-26011 : Cannot load type string into column string in table string
  • ora-32333 : disable table scn update for Materialized view
  • ora-13380 : network not found
  • ora-13381 : table:string not found in network:string
  • ora-31226 : DBMS_LDAP: MOD_ARRAY size limit exceeded
  • ora-02828 : Segment free list is empty
  • ora-13379 : invalid index for sub-element to be extracted
  • ora-02239 : there are objects which reference this sequence
  • ora-04000 : the sum of PCTUSED and PCTFREE cannot exceed 100
  • ora-09846 : soacon: ARCH unable to open named pipe.
  • ora-25014 : cannot change the value of a PARENT reference variable
  • ora-12808 : cannot set string_INSTANCES greater than number of instances string
  • ora-19806 : cannot make duplex backups in recovery area
  • ora-24306 : bad buffer for piece
  • ora-08462 : raw buffer contains invalid decimal data
  • ora-02220 : invalid MINEXTENTS storage option value
  • ora-13382 : geometry metadata (table:string column:string) not found in spatial network:string
  • ora-01937 : missing or invalid role name
  • ora-29308 : view TS_PITR_CHECK failure
  • ora-30508 : client logon triggers cannot have BEFORE type
  • ora-16154 : suspect attribute: string
  • ora-01769 : duplicate CLUSTER option specifications
  • 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.