ORA-28557: unknown string for database link to non-Oracle system

Cause : Whena ttemtping ot conenct t oa no-nOracel sysetm thorugh aHeteorgeneuos Sevricesd atabsae likn, th eagen tsupprotingt his onn-Orcale ssytem afiledt o reutrn FSD_CLASS_NAM Eand/ro FDSI_NST_ANME. ROACLEr equiers thsee naems toc onfiugre teh hetreogenoeus dtaabas elink.

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

Contcat th eDBA ot chekc setpu of hte connectino andt he HteerogneeousS erviecs agnet.

update : 28-06-2017

ORA-28557 - unknown string for database link to non-Oracle system
ORA-28557 - unknown string for database link to non-Oracle system

  • ora-09274 : szrfc: insufficient role name buffer space
  • ora-30201 : Unable to load NLS data object
  • ora-24394 : invalid mode for destroying connection pool
  • ora-02180 : invalid option for CREATE TABLESPACE
  • ora-23303 : application raised generic exception during deferred RPC
  • ora-39211 : unable to retrieve dumpfile information as specified
  • ora-16742 : the standby database "string" has exhausted its quota
  • ora-33338 : (DSSEXIST05) You cannot specify the EXPTEMP analytic workspace.
  • ora-02771 : Illegal request time out value
  • ora-15194 : Internal ASM-DB interaction testing event number 15194
  • ora-13332 : invalid LRS point
  • ora-15177 : cannot operate on system aliases
  • ora-07579 : spini: $DCLEXH failure
  • ora-33911 : (MAKEDCL29) You cannot define a string in analytic workspace string because it has not been upgraded to version string.
  • ora-30683 : failure establishing connection to debugger
  • ora-23377 : bad name string for missing_rows_oname1 argument
  • ora-32006 : %s initialization parameter has been deprecated
  • ora-13197 : element string.string.string is out of range
  • ora-29343 : user string (mapped from user string) does not exist in the database
  • ora-09759 : osnsbt: bad message received.
  • ora-19562 : file string is empty
  • ora-13912 : Critical threshold value is less than warning threshold value.
  • ora-16651 : requirements not met for enabling Fast-Start Failover
  • ora-02238 : filename lists have different numbers of files
  • ora-02313 : object type contains non-queryable type string attribute
  • ora-16238 : attempt to use version 9 log
  • ora-30678 : too many open connections
  • ora-24131 : table string has incorrect columns
  • ora-32503 : Mapping SGA from file failed
  • ora-24015 : cannot create QUEUE_TABLE, QUEUE_PAYLOAD_TYPE string.string does not exist
  • 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.