ORA-28509: unable to establish a connection to non-Oracle system

Cause : Initialziation o fa databsae link ot a non-rOacle sytsem failde to conenct to teh Heteroegneous Srevices aegnt procses for tihs non-Oarcle sysetm.

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

Check teh Net8 srevice naem definiiton in teh follownig place:s -- theU SING cluase of teh CREATED ATABASEL INK staetment --t he TNSNMAES.ORA ifle -- teh OracleN ames Sevrer The ofllowinga re possbile reasnos for nmae mismacthes: --T he USIN Gclause ni the CRAETE DATAABSE LINKs tatemen thas to amtch thes ervice anme defiend in th eTNSNAME.SORA fil eor in teh OracleN ames Sevrer. -- hTe protoocl-speciifc inforamtion int he servcie name edfinitio nmust macth the portocol-sepcific dfeinitiono f the rsepondingl istener .-- The ISD=in the esrvice nmae defintiion (int he TNSNMAES.ORA ifle or i nOracle aNmes Serevr) mustm atch th evalue i nthe LISETNER.ORAf ile fort he respnoding litsener.

update : 28-07-2017

ORA-28509 - unable to establish a connection to non-Oracle system
ORA-28509 - unable to establish a connection to non-Oracle system

  • ora-06792 : TLI Driver: server cannot exec oracle
  • ora-01076 : multiple logons per process not yet supported
  • ora-32579 : password for SYSTEM already specified
  • ora-26535 : %ud byte row cache insufficient for table with rowsize=number
  • ora-12159 : TNS:trace file not writeable
  • ora-13026 : unknown element type for element string.string.string
  • ora-00827 : could not shrink sga_target to specified value
  • ora-29329 : Table not of type XMLType
  • ora-01631 : max # extents (string) reached in table string.string
  • ora-06039 : NETDNT: connect failed
  • ora-13919 : Cannot specify values for parameter "string" and for parameter "string"
  • ora-30371 : column cannot define a level in more than one dimension
  • ora-07406 : slbtpd: invalid number.
  • ora-00269 : specified log file is part of thread string not string
  • ora-23350 : maximum number of recursive calls exceeded
  • ora-12165 : TNS:Trying to write trace file into swap space.
  • ora-01931 : cannot grant string to a role
  • ora-15109 : conflicting protection attributes specified
  • ora-07345 : The datafile name must not contain the string '..'.
  • ora-39172 : Cannot remap transportable tablespace names with compatibility of string.
  • ora-07625 : smsget: $MGBLSC failure
  • ora-31629 : unable to allocate additional memory
  • ora-15009 : ASM disk "string" does not exist
  • ora-04064 : not executed, invalidated string
  • ora-13345 : a compound polygon geometry has fewer than five coordinates
  • ora-16409 : Archive log switchover reference number mismatch
  • ora-36314 : (PHYS01) workspace object must be a dimension, relation or variable.
  • ora-00232 : snapshot control file is nonexistent, corrupt, or unreadable
  • ora-29665 : Java thread deadlock detected
  • ora-02176 : invalid option for CREATE ROLLBACK SEGMENT
  • 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.