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 : 27-04-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-31225 : DBMS_LDAP: invalid BER_ELEMENT
  • ora-26692 : invalid value string, string should be in string format
  • ora-02774 : Invalid request list latch time out value
  • ora-19212 : no key columns specified before call to DBMS_XMLSTORE.updateXML()
  • ora-28362 : master key not found
  • ora-14326 : Primary index on an IOT, DOMAIN and LOB indexes may not be specified in the UPDATE INDEXES clause
  • ora-22894 : cannot add constraint on existing unscoped REF columns of non-empty tables
  • ora-29389 : too many errors during validation
  • ora-06118 : NETTCP: unable to complete handshake with ORASRV
  • ora-25333 : Buffered Queue to Queue propagation did not connect to the correct instance
  • ora-12436 : no policy options specified
  • ora-01026 : multiple buffers of size > 4000 in the bind list
  • ora-16033 : parameter string destination cannot be the same as parameter string destination
  • ora-14165 : MODIFY DEFAULT ATTRIBUTES FOR PARTITION may not be combined with other operations
  • ora-29368 : consumer group string does not exist
  • ora-31628 : error getting worker process exception
  • ora-13852 : Tracing for service(module/action) string is not enabled
  • ora-26679 : operation not allowed on LOB or LONG columns in LCR
  • ora-01638 : parameter string does not allow ORACLE version string to mount cluster database
  • ora-22982 : cannot create sub-view under this view
  • ora-02050 : transaction string rolled back, some remote DBs may be in-doubt
  • ora-36815 : (XSTBLFUNC08) The OLAP_TABLE has attempted to use an AW single row function with the aw_attach parameter set to DURATION QUERY.
  • ora-10634 : Segment is already being shrunk
  • ora-14611 : Duplicate subpartition name string in template
  • ora-09950 : Unable to get server operating system privileges
  • ora-00288 : to continue recovery type ALTER DATABASE RECOVER CONTINUE
  • ora-36978 : (XSRELGID01) workspace object must be a self-relation.
  • ora-22874 : attribute "string" is not part of the type "string"
  • ora-28049 : the password has expired
  • ora-01501 : CREATE DATABASE failed
  • 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.