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 : 24-05-2017

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

  • ora-19032 : Expected XML tag string got string
  • ora-04028 : cannot generate diana for object stringstringstringstringstring
  • ora-15018 : diskgroup cannot be created
  • ora-09844 : soacon: Archmon unable to open named pipe.
  • ora-00032 : invalid session migration password
  • ora-22343 : Compilation error for type invalidated by ALTER TYPE
  • ora-01720 : grant option does not exist for 'string.string'
  • ora-23440 : incorrect public template value
  • ora-01451 : column to be modified to NULL cannot be modified to NULL
  • ora-00166 : remote/local nesting level is too deep
  • ora-14178 : STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes
  • ora-01351 : tablespace given for Logminer dictionary does not exist
  • ora-16005 : database requires recovery
  • ora-28652 : overflow segment attributes cannot be specified
  • ora-30068 : Internal Event to turn on nested
  • ora-16567 : Data Guard broker internal parser error at "string"
  • ora-19300 : Error occurred in uri processingstring
  • ora-39175 : Encryption password is not needed.
  • ora-09750 : pw_attachPorts: port_rename failed.
  • ora-01019 : unable to allocate memory in the user side
  • ora-31193 : This versioning feature isn't supported for resource string
  • ora-26516 : no push transaction acknowledgement
  • ora-25105 : RECOVERABLE option can only be used with ALTER INDEX REBUILD
  • ora-07592 : sspgprv: Error obtaining required privileges
  • ora-13757 : "SQL Tuning Set" "string" owned by user "string" is active.
  • ora-25442 : too many column values for table alias: string
  • ora-21608 : duration is invalid for this function
  • ora-29372 : identifier string is too long; it must be less than string characters
  • ora-26505 : unexpected internal null
  • ora-08465 : input mask contains more than 32 characters
  • 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.