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

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

  • ora-30055 : NULL snapshot expression not allowed here
  • ora-02242 : no options specified for ALTER INDEX
  • ora-06565 : cannot execute string from within stored procedure
  • ora-01901 : ROLLBACK keyword expected
  • ora-12484 : invalid OS label
  • ora-25335 : AQ array operations not allowed for buffered messages
  • ora-38786 : Flash recovery area is not enabled.
  • ora-02251 : subquery not allowed here
  • ora-25210 : invalid value for RELATIVE_MSGID, no message in queue with that msgid
  • ora-10636 : ROW MOVEMENT is not enabled
  • ora-00063 : maximum number of log files exceeded string
  • ora-16067 : activation identifier mismatch in archive log string
  • ora-08118 : Deferred FK constraints cannot be enforced, index too big (string)
  • ora-22929 : invalid or missing directory name
  • ora-08462 : raw buffer contains invalid decimal data
  • ora-12642 : No session key
  • ora-33292 : (DBERR18) insufficient permissions to access analytic workspace string using the specified access mode.
  • ora-38497 : Expression Filter index does not exist
  • ora-00473 : ARCH process terminated with error
  • ora-16025 : parameter string contains repeated or conflicting attributes
  • ora-22931 : MOVE of nested table to a different tablespace not supported
  • ora-24793 : Test DTP service start and stop
  • ora-19688 : control file autobackup format(string) for string does not have %F
  • ora-31442 : operation timed out while acquiring lock on string
  • ora-10930 : trace name context forever
  • ora-28117 : integrity constraint violated - parent record not found
  • ora-19230 : XP0010 - unsupported axis string
  • ora-23443 : missing template parameter
  • ora-16047 : DGID mismatch between destination setting and standby
  • ora-22826 : cannot construct an instance of a non instantiable type
  • 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.