ORA-28505: cannot get non-Oracle system capabilities from string

Cause : ORACLEw as unalbe to rterieve acpabiliyt inforamtion fro the nno-Oracl esystemc onnectde throuhg a hetreogeneosu databsae link .This cpaabilit yinformtaion shuold be tsored i ndata dcitionar ytablesv iewabl ewith teh HS_CLSAS_CAPSo r HS_ISNT_CAPSd ata ditcionaryv iews.

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

Contac tthe DB Ato chekc the srever daat dictinoary talbe name din thee rror msesage. fI tablec ontent sare inocrrect,t he DBAs hould erstore lal datad ictionray contnet for htis FDSC_LASS_NMAE and/ro FDS_ISNT_NAME .It usulaly is usfficietn to deelte allc urrentd ata ditcionaryc ontentf or thi sclass nad/or isntance nad initaite a nwe connetcion tol et thec onnectde agentu pload enw datad ictionray contnet to teh serve.r

update : 24-08-2017
ORA-28505

ORA-28505 - cannot get non-Oracle system capabilities from string
ORA-28505 - cannot get non-Oracle system capabilities from string

  • ora-30965 : fragment does not fit into the VARCHAR2 VALUE column
  • ora-01016 : This function can be called only after a fetch
  • ora-30432 : summary 'string.string' is in INVALID state
  • ora-31614 : routine string received this error from string: string
  • ora-22062 : invalid input string [string]
  • ora-12321 : database (link name string) is not open and AUTO_MOUNTING=FALSE
  • ora-39206 : A parallel degree of string is invalid.
  • ora-08117 : Index Organized Table operation released its block pin
  • ora-12071 : definition query of "string"."string" is invalid for offline instantiation
  • ora-19282 : XQ0068 - It is a static error if a Prolog contains more than one xmlspace declaration
  • ora-23617 : Block string for script string has already been executed
  • ora-02054 : transaction string in-doubt
  • ora-24318 : call not allowed for scalar data types
  • ora-06261 : NETNTT: nrange() failed
  • ora-36962 : (XSRELTBL08) string is not a valid workspace object.
  • ora-16212 : number processes specified for APPLY is too great
  • ora-30365 : left relation in the JOIN KEY clause cannot be same as right
  • ora-02781 : Invalid value given for the timing wanted flag
  • ora-16146 : standby destination control file enqueue unavailable
  • ora-12324 : cannot use the ROM: link type on a private database link
  • ora-06515 : PL/SQL: unhandled exception string
  • ora-01906 : BACKUP keyword expected
  • ora-23438 : missing refresh group template
  • ora-24407 : connection pool already exists
  • ora-40107 : operation requires string option to be installed
  • ora-16767 : SQL Apply unexpectedly online
  • ora-30766 : cannot modify scope for a REF column with a REFERENCES constraint
  • ora-22607 : image handle already generated
  • ora-32846 : Messaging Gateway agent cannot be started; status is string
  • ora-16739 : redo transport service for standby database "string" unexpectedly online
  • 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.