ORA-24084: DBLINK name in address field of agent string is not unique within the first 24 bytes

Cause : Adavncde Qeuuign rqeuiers htatt hea getn'sd blnik anmes holud eb uinqu ewihtint hef irts 2 4byets f(or8 .0c omaptilbe uqeuteabels)

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

Spceif ya bdlikn nmae htati s nuiqeu wtihi nth efisrt 42 btyeso r imgrtae ot 81. cmopaitbl equueetbale swhree htisr esrticitoni s ont hter.e

update : 28-06-2017
ORA-24084

ORA-24084 - DBLINK name in address field of agent string is not unique within the first 24 bytes
ORA-24084 - DBLINK name in address field of agent string is not unique within the first 24 bytes

  • ora-30504 : system triggers cannot have a FOR EACH ROW clause
  • ora-26529 : local store callback term phase failed for 'string.string'
  • ora-23452 : flavor string of object group "string"."string" is already published
  • ora-26671 : maximum number of STREAMS processes exceeded
  • ora-06901 : CMX: no local name assigned to local application
  • ora-14284 : one or more of table's subpartitions reside in a read-only tablespace
  • ora-19586 : %s k-byte limit is too small to hold piece directory
  • ora-32026 : %s.string has fewer columns compared to string table.
  • ora-14315 : cannot merge a partition with itself
  • ora-07274 : spdcr: access error, access to oracle denied.
  • ora-25353 : branch marked for deletion
  • ora-04086 : trigger description too long, move comments into triggering code
  • ora-28584 : heterogeneous apply internal error
  • ora-01230 : cannot make read only - file string is offline
  • ora-06801 : TLI Driver: listen for SPX server reconnect failed
  • ora-30045 : No undo tablespace name specified
  • ora-23408 : this replication operation is not supported in a mixed configuration
  • ora-07587 : spdcr: $CREPRC failure
  • ora-00330 : archived log ends at change string, need change string
  • ora-02214 : duplicate BACKUP option specification
  • ora-40219 : apply result table string is incompatible with current operation
  • ora-01138 : database must either be open in this instance or not at all
  • ora-26036 : subpartition load specified but table string is not subpartitioned
  • ora-33918 : (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string.
  • ora-16577 : corruption detected in Data Guard configuration file
  • ora-12070 : cannot offline instantiate materialized view "string"."string"
  • ora-38782 : cannot flashback database to non-guaranteed restore point 'string'
  • ora-28546 : connection initialization failed, probable Net8 admin error
  • ora-22165 : given index [string] must be in the range of [string] to [string]
  • ora-02277 : invalid sequence name
  • 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.