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 : 25-06-2017

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-12495 : cannot disable an enabled level, category, or release category
  • ora-01611 : thread number string is invalid - must be between 1 and string
  • ora-16765 : Redo Apply is unexpectedly online
  • ora-01551 : extended rollback segment, pinned blocks released
  • ora-01070 : Using an old version of Oracle for the server
  • ora-02464 : Cluster definition can not be both HASH and INDEX
  • ora-32332 : cannot refresh materialized view "string"."string" as type evolution has occured
  • ora-15097 : cannot SHUTDOWN ASM instance with connected RDBMS instance
  • ora-19655 : cannot switch to incarnation with different resetlogs data
  • ora-19008 : Invalid version of the XMLType
  • ora-34840 : (OPCREATE01) The string option must be declared with datatype string.
  • ora-16641 : failure to acquire broker configuration metadata lock
  • ora-27458 : A program of type PLSQL_BLOCK cannot have any arguments.
  • ora-12345 : user string lacks CREATE SESSION privilege in database link (linkname string)
  • ora-04066 : non-executable object, string
  • ora-24415 : Missing or null username.
  • ora-16739 : redo transport service for standby database "string" unexpectedly online
  • ora-13629 : The task or object string is being used by another operation.
  • ora-09240 : smpalo: error allocating PGA memory
  • ora-06777 : TLI Driver: error reading parms
  • ora-13383 : inconsistent network metadata: string
  • ora-40209 : setting % is invalid for % function
  • ora-12154 : TNS:could not resolve the connect identifier specified
  • ora-29701 : unable to connect to Cluster Manager
  • ora-31225 : DBMS_LDAP: invalid BER_ELEMENT
  • ora-08233 : smsdes: cannot unmap SGA
  • ora-36200 : (XSAGGR34) AGGREGATE operator string requires a WEIGHTBY clause, but ARGS variable workspace object did not specify one.
  • ora-36982 : (XSRELGID03) The grouping variable/relation workspace object must be dimensioned by all dimensions of the source relation workspace object that have more than one value in status.
  • ora-39306 : schema name mismatch expected "string" got "string"
  • ora-33213 : (CINSERT06) The target position for MAINTAIN ADD or MAINTAIN MOVE cannot fall in the range of session-only values.
  • 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.