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 : 22-09-2017

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

  • ora-31105 : User does not own lock "string"
  • ora-25505 : the system is not in quiesced state
  • ora-00021 : session attached to some other process; cannot switch session
  • ora-24013 : invalid value string, RETRY_DELAY should be non-negative
  • ora-30038 : Cannot perform parallel insert on non-partitioned object
  • ora-06305 : IPA: Illegal message type
  • ora-06317 : IPA: Local maximum number of users exceeded
  • ora-22298 : length of directory alias name or file name too long
  • ora-10936 : trace name context forever
  • ora-07586 : spdcr: $SEARCH failure
  • ora-27365 : job has been notified to stop, but failed to do so immediately
  • ora-31216 : DBMS_LDAP: PL/SQL - Invalid LDAP rdn.
  • ora-07656 : slsprom:$GETDVI failure
  • ora-06960 : Failed to access log file
  • ora-37178 : column string has no values
  • ora-30190 : reserved for future use
  • ora-06575 : Package or function string is in an invalid state
  • ora-24154 : rule string.string already in rule set string.string
  • ora-31115 : XDB configuration error: string
  • ora-16140 : standby online logs have not been recovered
  • ora-32320 : REFRESH FAST of "string"."string" unsupported after container table PMOPs
  • ora-12153 : TNS:not connected
  • ora-36778 : (XSPGTRLOW) The amount of available temporary storage is still low. Free some temporary storage immediately. You can do so, for example, by UPDATING or DETACHING an analytic workspace.
  • ora-31651 : communication error with master process - detaching job
  • ora-24061 : cannot specify non-zero SECONDARY_INSTANCE if PRIMARY_INSTANCE was zero
  • ora-12912 : Dictionary managed tablespace specified as temporary tablespace
  • ora-08192 : Flashback Table operation is not allowed on fixed tables
  • ora-15040 : diskgroup is incomplete
  • ora-32843 : value for string is outside the valid range of string to string
  • ora-22917 : use VARRAY to define the storage clause for this column or attribute
  • 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.