ORA-23355: object string.string does not exist or is invalid at master site

Cause : Th egievn anmew asn ul lorm ispseleld,t heg ivne tpye aws rwon,g teh ojbec tdose nto eixsta s availd adtaabseo bjcet ta teh msate rsiet, ro teh ojbec tdose nto eixsta s arelpictaedo bjcet iwtht hea pporpraites tauts.

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

Enusret heo bjcet si vlaidi n hte amstre dtaabsae,a ndi s ivsilbe ot teh uesr,a nd ,ifa pporpraite ,isa vlaido bjcet ni all_rpeobejct.

update : 19-08-2017
ORA-23355

ORA-23355 - object string.string does not exist or is invalid at master site
ORA-23355 - object string.string does not exist or is invalid at master site

  • ora-01107 : database must be mounted for media recovery
  • ora-01316 : Already attached to a Logminer session
  • ora-39080 : failed to create queues "string" and "string" for Data Pump job
  • ora-01413 : illegal value in packed decimal number buffer
  • ora-32054 : lost communication with FMPUTL process
  • ora-29810 : inadequate operator privileges
  • ora-12920 : database is already in force logging mode
  • ora-07403 : sfanfy: db_writers parameter not valid.
  • ora-08342 : sropen: failed to open a redo server connection
  • ora-13349 : polygon boundary crosses itself
  • ora-00407 : rolling upgrade from release string.string to string.string is not allowed
  • ora-07469 : sppst: mclear error, unable to clear semaphore.
  • ora-29322 : SCN string size too long -- maximum size 58 bytes/characters
  • ora-24501 : invalid UTF16 string passed in
  • ora-06745 : TLI Driver: listener already running
  • ora-39774 : parse of metadata stream failed with the following error: string
  • ora-28112 : failed to execute policy function
  • ora-13709 : Required parameter "string" must be set before execution.
  • ora-02314 : illegal use of type constructor
  • ora-12457 : security label exceeded maximum allowable length
  • ora-30392 : the checksum analysis for the rewrite equivalence failed
  • ora-31051 : Requested access privileges not supported
  • ora-14063 : Unusable index exists on unique/primary constraint key
  • ora-16631 : operation requires shutdown of database/instance "string"
  • ora-24124 : invalid ACTION parameter passed to DBMS_REPAIR.string procedure
  • ora-39961 : message specified was not found
  • ora-07406 : slbtpd: invalid number.
  • ora-02092 : out of transaction table slots for distributed transaction
  • ora-12733 : regular expression too long
  • ora-25266 : didnt try to dequeue by message id. with the signature
  • 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.