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 : 29-06-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-38765 : Flashed back database cannot be opened read-only.
  • ora-10630 : Illegal syntax specified with SHRINK clause
  • ora-00346 : log member marked as STALE
  • ora-31462 : internal error while accessing metadata
  • ora-01118 : cannot add any more database files: limit of string exceeded
  • ora-16234 : restarting to reset Logical Standby apply
  • ora-40289 : duplicate attributes provided for data mining function
  • ora-38467 : user cannot GRANT/REVOKE privileges to/from himself
  • ora-16767 : SQL Apply unexpectedly online
  • ora-02713 : osnprd: message receive failure
  • ora-23615 : Block number string does not exist for script string
  • ora-15197 : suppressing string additional ASM messages
  • ora-25334 : Buffered propagation must restart as the destination queue was recreated/moved
  • ora-34896 : (PPMONTHS00) At least 12 month names must be given. Only number were provided.
  • ora-36765 : (XSAGGCNTMOVE03) A string aggregation variable cannot have a string AGGCOUNT.
  • ora-27067 : size of I/O buffer is invalid
  • ora-19106 : invalid XQueryX: expected string - got string
  • ora-38420 : invalid stored attribute sub-expression: string
  • ora-02307 : cannot alter with REPLACE option a type that is not valid
  • ora-12057 : materialized view "string"."string" is INVALID and must complete refresh
  • ora-19569 : no device is allocated to this session
  • ora-16167 : LGWR network server could not switch to non-blocking mode
  • ora-37086 : %s is not a valueset
  • ora-13213 : failed to generate spatial index for window object
  • ora-30748 : column string already enabled to store objects of type string.string
  • ora-30951 : Element or attribute at Xpath string exceeds maximum length
  • ora-26699 : STREAMS message consumer string already exists
  • ora-01238 : cannot shrink datafile string
  • ora-06144 : NETTCP: SID (database) is unavailable
  • ora-15082 : ASM failed to communicate with database instance
  • 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.