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 : 24-07-2017
ORA-12538

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

  • ora-06030 : NETDNT: connect failed, unrecognized node name
  • ora-30514 : system trigger cannot modify tablespace being made read only
  • ora-01492 : LIST option not valid
  • ora-10583 : Can not recovery file string renamed as missing during test recovery
  • ora-29856 : error occurred in the execution of ODCIINDEXDROP routine
  • ora-01874 : time zone hour must be between -12 and 14
  • ora-34357 : (MXDSS10) string is not an alias of analytic workspace string.
  • ora-22952 : Nested Table equality requires a map method on the element ADT
  • ora-30968 : invalid XPATH or NAMESPACE option for XML Index
  • ora-27008 : function called with invalid file structure
  • ora-19563 : %s header validation failed for file string
  • ora-06516 : PL/SQL: the Probe packages do not exist or are invalid
  • ora-28346 : an encrypted column cannot serve as a partitioning column
  • ora-07758 : slemcw: invalid handle
  • ora-30551 : The index depends on a package/type body which does not exist
  • ora-13115 : [string]_EDGE$ table does not exist
  • ora-06744 : TLI Driver: listener cannot bind
  • ora-30688 : maximum program calling depth exceeded
  • ora-15095 : reached maximum ASM file size (string GB)
  • ora-10927 : trace name context forever
  • ora-19634 : filename required for this function
  • ora-09260 : sigpidu: error obtaining process id
  • ora-07274 : spdcr: access error, access to oracle denied.
  • ora-00117 : PROTOCOL, ADDRESS or DESCRIPTION must be specified
  • ora-16038 : log string sequence# string cannot be archived
  • ora-12047 : PCT FAST REFRESH cannot be used for materialized view "string"."string"
  • ora-01120 : cannot remove online database file string
  • ora-24199 : message store is overflow
  • ora-28545 : error diagnosed by Net8 when connecting to an agent
  • ora-31462 : internal error while accessing metadata
  • 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.