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 : 19-08-2017

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

  • ora-26506 : null global context
  • ora-02342 : replacement type has compilation errors
  • ora-32317 : cannot run a job from a job
  • ora-24041 : propagation schedule exists for QUEUE string and DESTINATION string
  • ora-02147 : conflicting SHARED/EXCLUSIVE options
  • ora-16213 : ddl encountered, stopping apply engine
  • ora-12712 : new character set must be a superset of old character set
  • ora-36841 : (XSLMGEN11) Dimension string.string!string was not found
  • ora-09858 : sfngat: the input file name is not in the OMF format
  • ora-06550 : line string, column string: string
  • ora-39126 : Worker unexpected fatal error in string [string] string
  • ora-02274 : duplicate referential constraint specifications
  • ora-02144 : no option specified for ALTER CLUSTER
  • ora-01052 : required destination LOG_ARCHIVE_DUPLEX_DEST is not specified
  • ora-30514 : system trigger cannot modify tablespace being made read only
  • ora-26662 : unable to process STREAMS Data Dictonary information for object
  • ora-15127 : ASM file name 'string' cannot use templates
  • ora-19235 : XQ0015 - unsupported must-understand extension
  • ora-16166 : LGWR network server failed to send remote message
  • ora-27057 : cannot perform async I/O to file
  • ora-12667 : Shared server: outbound transport protocol different from inbound
  • ora-07480 : snchmod: cannot change permissions on ?/dbs/sgalm.dbf.
  • ora-13294 : cannot transform geometry containing circular arcs
  • ora-19770 : invalid change tracking file name
  • ora-16720 : no LOG_ARCHIVE_DEST_n initialization parameters available
  • ora-25014 : cannot change the value of a PARENT reference variable
  • ora-01674 : data file string is an old incarnation rather than current file
  • ora-31425 : subscription does not exist
  • ora-03200 : the segment type specification is invalid
  • ora-14068 : TABLESPACE and TABLESPACE_NUMBER may not be both specified
  • 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.