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 : 26-04-2017

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

  • ora-16795 : database resource guard detects that database re-creation is required
  • ora-09266 : spawn: error starting an Oracle process
  • ora-07222 : slspool: line printer spooler command exited with an error.
  • ora-01696 : control file is not a clone control file
  • ora-01543 : tablespace 'string' already exists
  • ora-23341 : user function required
  • ora-31058 : cannot modify read-only XOBs
  • ora-12457 : security label exceeded maximum allowable length
  • ora-31073 : Resource not retrieved using path name
  • ora-31510 : name uses reserved prefix CDC$
  • ora-24170 : %s.string is created by AQ, cannot be dropped directly
  • ora-01554 : out of transaction slots in transaction tables
  • ora-29262 : bad URL
  • ora-37060 : (XSMCSESS08) number is not a valid custom member in dimension workspace object.
  • ora-28119 : policy group does not exist
  • ora-24043 : destination string uses a reserved name, names with AQ$_ prefix are not valid
  • ora-13217 : invalid parameters supplied in ALTER INDEX statement
  • ora-28669 : bitmap index can not be created on an IOT with no mapping table
  • ora-22864 : cannot ALTER or DROP LOB indexes
  • ora-01025 : UPI parameter out of range
  • ora-16804 : one or more configuration properties in metadata have invalid values
  • ora-30081 : invalid data type for datetime/interval arithmetic
  • ora-06579 : Bind variable not big enough to hold the output value
  • ora-37176 : argument string is not valid for the sparsity advisor
  • ora-12556 : TNS:no caller
  • ora-36643 : (XSDUNION21) Concat dimension workspace object cannot be changed to NOT UNIQUE because it contains custom member values.
  • ora-30567 : name already used by an existing log group
  • ora-30645 : reject limit out of range
  • ora-17624 : Failed to delete directory string
  • ora-13443 : GeoRaster metadata SRS error
  • 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.