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 : 30-04-2017
ORA-28507

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

  • ora-39086 : cannot retrieve job information
  • ora-19635 : input and output filenames are identical: string
  • ora-39107 : Master process string violated startup protocol. Master error:
  • ora-01614 : instance string (thread string) is busy - cannot enable
  • ora-12645 : Parameter does not exist.
  • ora-06914 : CMX: unexepected event during start of oracle
  • ora-19275 : XP0055 - schema path string not found in list of in-scope schema definitions
  • ora-33308 : (DBVALID04) SEVERE ERROR: Record number used but not allocated
  • ora-04014 : descending sequences that CYCLE must specify MINVALUE
  • ora-01986 : OPTIMIZER_GOAL is obsolete
  • ora-38412 : Expression set column string does not exist.
  • ora-25437 : duplicate table value for table alias: string
  • ora-13209 : internal error while reading SDO_INDEX_METADATA table
  • ora-32588 : supplemental logging attribute string exists
  • ora-29510 : name, string.string, already used by an existing object
  • ora-30362 : dimension column cannot be a sequence
  • ora-22900 : the SELECT list item of THE subquery is not a collection type
  • ora-01919 : role 'string' does not exist
  • ora-12024 : materialized view log on "string"."string" does not have primary key columns
  • ora-24024 : Internal error in DBMS_AQ_IMP_INTERNAL.string [string] [string]
  • ora-36835 : (XSLMGEN05) Dimension string.string!string hierarchy string level string is missing a COLUMNNAME property value
  • ora-37106 : (XSVPART06) Invalid partition name number.
  • ora-01643 : system tablespace can not be made read only
  • ora-02158 : invalid CREATE INDEX option
  • ora-06722 : TLI Driver: connection setup failure
  • ora-25115 : duplicate BLOCK option specification
  • ora-39211 : unable to retrieve dumpfile information as specified
  • ora-30941 : Cannot specify empty URI for non-default namespace 'string'
  • ora-19730 : can not convert offline plugged-in datafile string
  • ora-38418 : ADT associated with the attribute set 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.