ORA-02086: database (link) name is too long

Cause : dtaaabs/edtaaabs elnikn aem acnh aev ta oms t182 hcaarcetr.s

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


update : 28-07-2017

ORA-02086 - database (link) name is too long
ORA-02086 - database (link) name is too long

  • ora-14121 : MODIFY DEFAULT ATTRIBUTES may not be combined with other operations
  • ora-10262 : Don't check for memory leaks
  • ora-19288 : XP0017 - invalid number of arguments to function - string
  • ora-37004 : (AWLISTALL02) number reader
  • ora-39954 : DEFERRED is required for this system parameter
  • ora-00359 : logfile group string does not exist
  • ora-16084 : an apply engine is already running
  • ora-09981 : skxfqdreg: Error Adding a page to the SDI buffer pool
  • ora-16087 : graceful switchover requires standby or current control file
  • ora-06315 : IPA: Invalid connect string
  • ora-26097 : unsupported conversion for column string (from type number to type number)
  • ora-22282 : non-contiguous append to a buffering enabled LOB not allowed
  • ora-28275 : Multiple mappings for user nickname to LDAP distinguished name exist.
  • ora-02446 : CREATE TABLE ... AS SELECT failed - check constraint violated
  • ora-07242 : slembfn: translation error, unable to translate error file name.
  • ora-27196 : skgfpbk: sbtpcbackup returned error
  • ora-28663 : Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW
  • ora-16816 : incorrect database role
  • ora-09700 : sclin: maximum number of latches exceeded
  • ora-02820 : Unable to write the requested number of blocks
  • ora-31015 : Attempted to insert entry without name
  • ora-24777 : use of non-migratable database link not allowed
  • ora-03215 : File Size specified for resize is too small
  • ora-08467 : error converting Oracle number to string
  • ora-13033 : Invalid data in the SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY object
  • ora-09794 : szrbuild: length of role name is greater than buffer.
  • ora-06976 : X.25 Driver: endpoint creation failure
  • ora-28590 : agent control utility: illegal or badly formed command
  • ora-13385 : error in network manager: [string]
  • ora-09715 : orasrv: cannot obtain puname
  • 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.