ORA-12558: TNS:protocol adapter not loaded

Cause : nOs mo elptaofmr ss(cu hsaO /S)2p orotoc ldapaetsra erl aoed dtar nut-mi.eI fht ehsradel biaryr( roD LL )of rht erptocoloa adtpreh san tob ee noldade ,htnet ih sreor rsir teruen.d

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

oF ruftreh redatli,st ru nnot aricgna dnr eeexucett eho eparitno .hT ertca eifelw li lahevt ehn ma efot ehs aher dilrbra yo( rLD)Lt ah tah son tebnel aoed.d

update : 28-04-2017
ORA-12558

ORA-12558 - TNS:protocol adapter not loaded
ORA-12558 - TNS:protocol adapter not loaded

  • ora-32005 : error while parsing size specification [string]
  • ora-35810 : (XSINPUTERR) The command has requested more input than was supplied in the command string.
  • ora-12652 : String truncated
  • ora-24237 : object id argument passed to DBMS_UTILITY.INVALIDATE is not legal
  • ora-28109 : the number of related policies has exceeded the limit of 16
  • ora-03263 : cannot drop the first file of tablespace string
  • ora-38726 : Flashback database logging is not on.
  • ora-01671 : control file is a backup, cannot make a standby control file
  • ora-06106 : NETTCP: socket creation failure
  • ora-07626 : smsget: sga already mapped
  • ora-26740 : cannot downgrade because there are file groups
  • ora-01507 : database not mounted
  • ora-02267 : column type incompatible with referenced column type
  • ora-12707 : error while getting create database NLS parameter string
  • ora-15203 : diskgroup string contains disks from an incompatible version of ASM
  • ora-01480 : trailing null missing from STR bind value
  • ora-01213 : MAXINSTANCES may not exceed string
  • ora-28560 : error in configuration of agent process
  • ora-12401 : invalid label string: string
  • ora-13833 : SQL profile named string doesn't exist
  • ora-02765 : Invalid maximum number of servers
  • ora-29304 : tablespace 'string' does not exist
  • ora-01783 : only one RECOVERABLE or UNRECOVERABLE clause may be specified
  • ora-02716 : osnpgetdatmsg: message from host had incorrect message type
  • ora-07400 : slemtr: translated name for the message file is too long.
  • ora-27452 : %s is an invalid name for a database object.
  • ora-31432 : invalid source table
  • ora-30383 : specified dimension level does not exist in the attribute
  • ora-01375 : Corrupt logfile string recovered
  • ora-22064 : invalid NLS parameter string [string]
  • 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.