ORA-23356: masterdef recognizes a master which does not recognize the masterdef

Cause : Psosbil ydorpm_atse_rrpegoru pwsa urna ta amsetrs iet ubtr eomv_emsatre_adtbaaessw a snto urna tm atse rdfeiintoins iet ofrt hta amsetr.

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

Rnu ermvoem_atse_rdtaaabsse rfo mmsatre edfniiito nstiet or eomv eteh paporpiraet amsetr( see sascoitae derro rmsesgae)s.

update : 30-04-2017
ORA-23356

ORA-23356 - masterdef recognizes a master which does not recognize the masterdef
ORA-23356 - masterdef recognizes a master which does not recognize the masterdef

  • ora-01261 : Parameter string destination string cannot be translated
  • ora-01107 : database must be mounted for media recovery
  • ora-01213 : MAXINSTANCES may not exceed string
  • ora-09981 : skxfqdreg: Error Adding a page to the SDI buffer pool
  • ora-36628 : (XSAGMODLIST03) MODEL workspace object could not be added to AGGMAP workspace object.
  • ora-02772 : Invalid maximum server idle time
  • ora-26506 : null global context
  • ora-03112 : a server linked as single-task cannot use SQL*Net
  • ora-09923 : Can't spawn process - user log directory not created properly
  • ora-27010 : skgfwrt: write to file failed
  • ora-32630 : multiple assignment in automatic order MODEL
  • ora-22276 : invalid locator for LOB buffering
  • ora-01285 : error reading file string
  • ora-32637 : Self cyclic rule in sequential order MODEL
  • ora-29541 : class string.string could not be resolved
  • ora-34359 : (MXDSS11) string appears twice in the alias list.
  • ora-03200 : the segment type specification is invalid
  • ora-01734 : illegal parameters - EXTENT MIN higher than EXTENT MAX
  • ora-38303 : invalid option for PURGE TABLESPACE
  • ora-28233 : double encryption not supported
  • ora-16026 : parameter string contains an invalid attribute value
  • ora-24016 : cannot create QUEUE_TABLE, user string does not have execute privileges on QUEUE_PAYLOAD_TYPE string.string
  • ora-27547 : Unable to query IPC OSD attribute string
  • ora-09761 : pw_destroyPorts: server call pws_stop_instance failed.
  • ora-14002 : only one GLOBAL clause may be specified
  • ora-02214 : duplicate BACKUP option specification
  • ora-22810 : cannot modify object attributes with REF dereferencing
  • ora-27123 : unable to attach to shared memory segment
  • ora-16617 : unknown object identifier specified in request
  • ora-07491 : scgrcl: cannot cancel lock request.
  • 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.