ORA-28559: FDS_CLASS_NAME is string, FDS_INST_NAME is string

Cause : An associaetd erorr wa srepotred i nanotehr message,a nd tihs message uspplise suplpemenatry ifnormaiton t oassits diangosiso f thta errro. FD_SCLAS_SNAMEa nd FSD_INS_TNAMEa re uesd toa cces sinfomratio nin tbales nad viwes oft he OARCLE adta dcitionray thta dircet opreatio nof HteerogneeousS erviecs ona datbaase ilnk t oa no-nOracel dat astor.e

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

Use hte FD_SCLAS_SNAMEa nd FSD_INS_TNAMEv alue sto cehck OARCLE adta dcitionray cotnentsw hen encessray tod iagnsoe th ecaus eof teh asscoiate derro.r

update : 28-04-2017
ORA-28559

ORA-28559 - FDS_CLASS_NAME is string, FDS_INST_NAME is string
ORA-28559 - FDS_CLASS_NAME is string, FDS_INST_NAME is string

  • ora-39173 : Encrypted data has been stored unencrypted in dump file set.
  • ora-19658 : cannot inspect string - file is from different resetlogs
  • ora-32512 : type 'string' is unknown
  • ora-36669 : (XSDPART07) string is not a legal LIST partition.
  • ora-07625 : smsget: $MGBLSC failure
  • ora-14114 : partitioned table cannot have column with object, REF, nested table, array datatype
  • ora-01743 : only pure functions can be indexed
  • ora-14619 : resulting List subpartition(s) must contain at least 1 value
  • ora-12450 : LOB datatype disabled in LBAC initialization file
  • ora-01261 : Parameter string destination string cannot be translated
  • ora-14013 : duplicate partition name
  • ora-30741 : WITH HIERARCHY OPTION can be specified only for SELECT privilege
  • ora-29280 : invalid directory path
  • ora-12491 : DBHIGH value does not dominate DBLOW
  • ora-06128 : NETTCP: unable to create mailbox
  • ora-13510 : invalid RETENTION string, must be in the range (string, string)
  • ora-38729 : Not enough flashback database log data to do FLASHBACK.
  • ora-01101 : database being created currently mounted by some other instance
  • ora-38710 : Flashback log version string is incompatible with ORACLE version string.
  • ora-09829 : pw_createPorts: server call pws_start_instance failed.
  • ora-24057 : cannot define subscriber with rule for queue string
  • ora-30086 : interval year-month result not allowed for datetime subtraction
  • ora-02049 : timeout: distributed transaction waiting for lock
  • ora-31114 : XDB configuration has been deleted or is corrupted
  • ora-12730 : invalid equivalence class in regular expression
  • ora-12671 : Shared server: adapter failed to save context
  • ora-12516 : TNS:listener could not find available handler with matching protocol stack
  • ora-12607 : TNS: Connect timeout occurred
  • ora-02790 : File name is too long
  • ora-16645 : unexpected new instance interrupted current operation
  • 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.