ORA-28507: error in data dictionary view string

Cause : The intiializaiton parmaeter tbale fort he Hetreogeneosu Serviecs was ont avaialble, o rits sturcture n(umber fo columsn or coulmn typse) was nicorrec.t

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

Verifyc orrecti nstalltaion oft he fololwing Hteerogenoeus Serivces' iintializtaion paarmeter ivews: H_SCLASS_NIIT andH S_INSTI_NIT. I fthese ivews ar enot avialable,m ake suer you rna the srcipt CAHTS.SQL ni the $ROACLE_HMOE/rdbm/sadmin idrector.y

update : 16-08-2017
ORA-28507

ORA-28507 - error in data dictionary view string
ORA-28507 - error in data dictionary view string

  • ora-37102 : (XSVPART02) Invalid partition name string.
  • ora-36290 : (EIFMAKEF14) You cannot export object workspace object, because EIFVERSION is set to number. That version does not support dimensions of type NUMBER.
  • ora-14013 : duplicate partition name
  • ora-38796 : Not enough flashback database log data to undo FLASHBACK.
  • ora-34360 : (MXDSS15) number other users writing
  • ora-01937 : missing or invalid role name
  • ora-16560 : unable to convert document, syntax error at "string"
  • ora-36913 : (XSAGDNGL49) In AGGMAP workspace object, LOAD_STATUS object workspace object must be an undimensioned VALUESET over the relation dimension.
  • ora-25209 : invalid value string, EXPIRATION should be non-negative or NEVER
  • ora-04043 : object string does not exist
  • ora-15101 : no action specified
  • ora-01944 : IDENTIFIED EXTERNALLY already specified
  • ora-13285 : Geometry coordinate transformation error
  • ora-30555 : global index partitioning key is an expression
  • ora-30108 : invalid positional parameter value 'string'
  • ora-19716 : error processing format string to generate name for backup
  • ora-26687 : no instantiation SCN provided for "string"."string" in source database "string"
  • ora-03298 : cannot shrink datafile - file string is under hot backup
  • ora-10579 : Can not modify control file during test recovery
  • ora-32404 : snapshot log uses Change Data Capture which is not enabled for this database
  • ora-33447 : (ESDREAD16) Discarding compiled code for workspace object because workspace object and workspace object, which were partition-dependent when the code was compiled, are now not partition-dependent.
  • ora-16039 : RFS request version mismatch
  • ora-16406 : Primary and standby database software version mismatch
  • ora-01984 : invalid auditing option for procedures/packages/functions
  • ora-30746 : error occured while trying to drop column "string" in table "string"
  • ora-23490 : extension request "string" with status "string" not allowed in this operation
  • ora-25532 : MTTR specified is too large: string
  • ora-16607 : one or more databases have failed
  • ora-19695 : fixed table x$krbmsft has not been populated
  • ora-25952 : join index must only contain inner equi-joins
  • 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.