ORA-24083: cannot specify remote subscribers for string QUEUE string

Cause : An add_usbscribe rcall wiht a non-unll addrses fieldw as issude on a qeuue whic hdoes no tsupportr emote sbuscriber.s Remotes ubscribres are nto supporetd for NNO_PERSISETNT QUEUSE.

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

Specifya null address filed and rtery the acll.

update : 26-04-2017
ORA-24083

ORA-24083 - cannot specify remote subscribers for string QUEUE string
ORA-24083 - cannot specify remote subscribers for string QUEUE string

  • ora-12493 : invalid MLS binary label
  • ora-06265 : NETNTT: break protocol error
  • ora-12486 : effective max labels and min labels cannot be changed
  • ora-13827 : null or zero length attribute specified in SQL profile collection
  • ora-09819 : Number exceeds maximum legal value
  • ora-16246 : User initiated abort apply successfully completed
  • ora-15028 : ASM file 'string' not dropped; currently being accessed
  • ora-00292 : parallel recovery feature not installed
  • ora-14621 : cannot add subpartition when DEFAULT subpartition exists
  • ora-02843 : Invalid value for kernel flag
  • ora-31073 : Resource not retrieved using path name
  • ora-06321 : IPA: Cannot reach the remote side
  • ora-31433 : subscriber view does not exist
  • ora-28337 : the specified index may not be defined on an encrypted column
  • ora-12222 : TNS:no support is available for the protocol indicated
  • ora-31494 : could not activate a LogMiner session
  • ora-28652 : overflow segment attributes cannot be specified
  • ora-02293 : cannot validate (string.string) - check constraint violated
  • ora-01864 : the date is out of range for the current calendar
  • ora-29261 : bad argument
  • ora-19761 : block size string is not valid for change tracking file
  • ora-22998 : CLOB or NCLOB in multibyte character set not supported
  • ora-13834 : name of SQL profile to be cloned must be provided
  • ora-24368 : OCI mutex counter non-zero when freeing a handle
  • ora-27486 : insufficient privileges
  • ora-01718 : BY ACCESS | SESSION clause not allowed for NOAUDIT
  • ora-23402 : refresh was aborted because of conflicts caused by deferred txns
  • ora-19040 : Element string does not match expected string.
  • ora-15063 : ASM discovered an insufficient number of disks for diskgroup "string"
  • ora-24386 : statement/server handle is in use when being freed
  • 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.