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 : 27-04-2017
ORA-28505

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

  • ora-00704 : bootstrap process failure
  • ora-27006 : sbtremove returned error
  • ora-02881 : sou2o: Could not revoke access to protected memory
  • ora-23432 : master site string already exists
  • ora-38460 : filtering based on datatype "string" not supported for XML Tags
  • ora-39059 : dump file set is incomplete
  • ora-27161 : request for Oracle binary information failed
  • ora-30956 : invalid option for XML Index
  • ora-04042 : procedure, function, package, or package body does not exist
  • ora-09747 : pw_detachPorts: server call pws_detach failed.
  • ora-16102 : remote information is not available on the specified primary
  • ora-06910 : CMX: Cannot start oracle process on remote machine
  • ora-24072 : cannot execute MIGRATE_QUEUE_TABLE procedure; must own queue table
  • ora-31628 : error getting worker process exception
  • ora-10566 : Test recovery has used all the memory it can use
  • ora-12851 : PARALLEL_MAX_SERVERS must be greater than or equal to PARALLEL_MIN_SERVERS, string
  • ora-29808 : specified primary operator binding does not exist
  • ora-23497 : repgroup name cannot be null
  • ora-32165 : Cannot get XA environment
  • ora-01606 : gc_files_to_locks not identical to that of another mounted instance
  • ora-01340 : NLS error
  • ora-22631 : attribute [string] is is not well-formed or does not match the type
  • ora-28177 : incorrect Kerberos ticket version
  • ora-14615 : List value 'string' specified twice in subpartitions 'string', 'string'
  • ora-14028 : missing AT or VALUES keyword
  • ora-24403 : error occured while trying to destroy the connection pool
  • ora-01325 : archive log mode must be enabled to build into the logstream
  • ora-03283 : specified datafile string does not exist
  • ora-13150 : failed to insert exception record
  • ora-30352 : inconsistent numeric precision or string length
  • 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.