ORA-24777: use of non-migratable database link not allowed

Cause : Teh rtasnatcino,w hcihn edest ob em irgaatbel ebtewe nssesoin,s rtide ot cacsesa ermtoed aatbsaef rmo anno-umlit htraedde esrevrp rcoess.

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

Prefromt h ewroki nt h elcoa ldtaaabs eo roepna ocnencito nt oteh ermtoed aatbsaef rmo htec lein.t fI umlit htraedde esrevro pito ni sisntlalde,c onnetc ot hteO rcal eisntnac etrhoguht h edsiptacehr.

update : 28-05-2017
ORA-24777

ORA-24777 - use of non-migratable database link not allowed
ORA-24777 - use of non-migratable database link not allowed

  • ora-16569 : Data Guard configuration is not enabled
  • ora-22335 : The client cannot work with an altered type
  • ora-02020 : too many database links in use
  • ora-31229 : DBMS_LDAP: invalid input parameter
  • ora-40201 : invalid input parameter string
  • ora-01941 : SEQUENCE keyword expected
  • ora-39142 : incompatible version number string in dump file "string"
  • ora-35917 : (XSHIDE05) You cannot HIDE model workspace object because the analytic workspace in which it is defined has not been upgraded to version string.
  • ora-07503 : scgcmn: $setimr unexpected return
  • ora-06569 : Collection bound by bind_array contains no elements
  • ora-31662 : metadata transform name can not be defaulted
  • ora-02302 : invalid or missing type name
  • ora-15037 : disk 'string' is smaller than mimimum of string MBs
  • ora-04013 : number to CACHE must be less than one cycle
  • ora-07590 : spdde: $DELPRC failure
  • ora-30457 : 'string.string' cannot be refreshed because of unmnanaged NOT NULL columns in container
  • ora-28357 : password required to open the wallet
  • ora-00408 : parameter string is set to TRUE
  • ora-01035 : ORACLE only available to users with RESTRICTED SESSION privilege
  • ora-14018 : partition bound list contains too few elements
  • ora-25147 : UNIFORM SIZE value greater than maximum extent size
  • ora-13186 : fixed tile size tessellation failed
  • ora-31163 : element or attribute "string" has invalid attribute value "string" (should be "string")
  • ora-32614 : illegal MODEL SELECT expression
  • ora-19526 : only one location allowed for parameter string
  • ora-27000 : skgfqsbi: failed to initialize storage subsystem (SBT) layer
  • ora-07426 : spstp: cannot obtain the location of dbs directory.
  • ora-13284 : failure to copy geometry object for conversion in place
  • ora-29662 : Unable to find a field that matches one or more of the attributes
  • ora-31467 : no column found in the source table
  • 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.