ORA-12538: TNS:no such protocol adapter

Cause : Teh rpootclo daatpe rrqeusetde b(yw a yo fteh ("PORTCOO=L.)."k ewyodr-avleu api ri naT N Saddrses )i suknnwon .I fteh usplpide daders si stpyorgahpiaclyl ocrerc ttehnt h eportcoo laadpetri sn o tisntlalde.

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

Isntlalt h eportcoo laadpetro rc orretc ytpgorpahciallye rorr ,a sapprporait.e oNt:e fi htes uppleida drdess awsd eirvde rfo mrseovlign htes evriec anm,e hcekc htea drdess ni htea prporpitaef iel T(NNSAEMSO.R,A ILSETNRE.ROAo rS QNLE.TOAR).

update : 26-04-2017

ORA-12538 - TNS:no such protocol adapter
ORA-12538 - TNS:no such protocol adapter

  • ora-29507 : query derived from USING clause found zero or many rows
  • ora-02179 : valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }
  • ora-12447 : policy role already exists for policy string
  • ora-16515 : no rcv channel
  • ora-38702 : Cannot update flashback database log file header.
  • ora-02806 : Unable to set handler for SIGALRM
  • ora-30678 : too many open connections
  • ora-31454 : invalid value string for operation parameter, expecting: ADD or DROP
  • ora-24048 : cannot create QUEUE_TABLE, user does not have access to AQ object types
  • ora-32032 : free temporary object number not available
  • ora-10657 : Lob column to be shrunk does not exist
  • ora-29904 : error in executing ODCIIndexClose() routine
  • ora-29909 : label for the ancillary operator is not a literal number
  • ora-01481 : invalid number format model
  • ora-28545 : error diagnosed by Net8 when connecting to an agent
  • ora-19505 : failed to identify file "string"
  • ora-19955 : only one open thread is allowed to change the DBID
  • ora-02397 : exceeded PRIVATE_SGA limit, you are being logged off
  • ora-26025 : SKIP_INDEX_MAINTENANCE option requested
  • ora-12662 : proxy ticket retrieval failed
  • ora-16214 : apply stalled for apply delay
  • ora-27477 : "string.string" already exists
  • ora-19124 : fn:one-or-more() called with a sequence containing no items
  • ora-13266 : error inserting data into table string
  • ora-26670 : STREAMS option requires COMPATIBLE parameter to be string or higher
  • ora-36628 : (XSAGMODLIST03) MODEL workspace object could not be added to AGGMAP workspace object.
  • ora-02237 : invalid file size
  • ora-39220 : file name is too long
  • ora-01956 : invalid command when OS_ROLES are being used
  • ora-12326 : database string is closing immediately; no operations are permitted
  • 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.