ORA-24202: publisher does not exist for the queue

Cause : tAetpmet dota tlreo rrdpoa n noe ixtsne tuplbsieh rrfmoa q eueu.

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

pScefi ynatoeh ruplbsieh.r

update : 27-04-2017

ORA-24202 - publisher does not exist for the queue
ORA-24202 - publisher does not exist for the queue

  • ora-01956 : invalid command when OS_ROLES are being used
  • ora-30681 : improper value for argument EXTENSIONS_CMD_SET
  • ora-19239 : XP0019 - step expression must return sequence of nodes
  • ora-36178 : (XSAGGR01) To be used with AGGREGATE, AGGMAP workspace object must be declared with the AGGMAP command.
  • ora-24306 : bad buffer for piece
  • ora-16578 : failed to read Data Guard configuration file
  • ora-01179 : file string does not exist
  • ora-24002 : QUEUE_TABLE string does not exist
  • ora-02877 : smpini: Unable to initialize memory protection
  • ora-29960 : line string, string
  • ora-00261 : log string of thread string is being archived or modified
  • ora-28595 : Extproc agent : Invalid DLL Path
  • ora-23339 : duplicate conflict resolution information
  • ora-39125 : Worker unexpected fatal error in string while calling string [string]
  • ora-34342 : (MXDSS01) IMPORTANT: Analytic workspace string is read-only. Therefore, you will not be able to use the UPDATE command to save changes to it.
  • ora-39956 : duplicate setting for PL/SQL compiler parameter string
  • ora-06033 : NETDNT: connect failed, partner rejected connection
  • ora-15014 : location 'string' is not in the discovery set
  • ora-00473 : ARCH process terminated with error
  • ora-12609 : TNS: Receive timeout occurred
  • ora-12923 : tablespace string is in force logging mode
  • ora-23470 : invalid status
  • ora-29522 : authorization error for referenced name string.string
  • ora-01881 : timezone region id number is invalid
  • ora-00721 : changes by release string cannot be used by release string
  • ora-01312 : Specified table/column does not exist
  • ora-02265 : cannot derive the datatype of the referencing column
  • ora-31069 : Cannot apply typed changes to non-schema-based XMLType nodes
  • ora-26745 : cursors (string) are not sufficient
  • ora-32828 : Messaging Gateway agent must be running
  • 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.