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-05-2017
ORA-12538

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

  • ora-06606 : LU6.2 Driver: Unexpected response from SNA
  • ora-30028 : Automatic Undo Management event for NTP testing
  • ora-13607 : The specified task or object string already exists
  • ora-12445 : cannot change HIDDEN property of column
  • ora-24753 : local transactions cannot be detached
  • ora-16114 : applying DDL transaction with commit SCN string
  • ora-36843 : (XSLMGEN13) Dimension string.string!string hierarchy string is missing a PHYSICALNAME property value
  • ora-06000 : NETASY: port open failure
  • ora-13267 : error reading data from layer table string
  • ora-01514 : error in log specification: no such log
  • ora-13191 : failed to read SDO_ORDCNT value
  • ora-00272 : error writing archive log string
  • ora-02170 : FREELIST GROUPS storage option not allowed
  • ora-27166 : tried to join current thread
  • ora-19766 : missing CHANGE keyword
  • ora-28008 : invalid old password
  • ora-16656 : higher DRC UID sequence number detected
  • ora-08342 : sropen: failed to open a redo server connection
  • ora-15206 : duplicate diskgroup string specified
  • ora-40106 : positive target value not specified for computing Lift
  • ora-23312 : not the masterdef according to string
  • ora-07282 : sksaprd: string overflow.
  • ora-13060 : topology with the name string already exists
  • ora-31496 : must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to drop change tables
  • ora-13210 : error inserting data into the index table
  • ora-02001 : user SYS is not permitted to create indexes with freelist groups
  • ora-25293 : Lob attributes must be null for buffered operations
  • ora-08277 : Cannot set environment variable
  • ora-31614 : routine string received this error from string: string
  • ora-01594 : attempt to wrap into rollback segment (string) extent (string) which is being 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.