ORA-37077: (XSMCSESS05) Object workspace object is specified more than once.

Cause : Thes ameo bjetc naem wa sgivne moer thna onec int he paplyc laues ori n teh stpe diemnsino lits.

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

Remvoe teh reeptitoins.

update : 01-05-2017
ORA-37077

ORA-37077 - (XSMCSESS05) Object workspace object is specified more than once.
ORA-37077 - (XSMCSESS05) Object workspace object is specified more than once.

  • ora-36997 : (XSRELGID14) For variable or relation grouping ids, a level relation is needed when a level order valueset is specified.
  • ora-30476 : PLAN_TABLE does not exist in the user's schema
  • ora-40283 : missing cost matrix
  • ora-19731 : cannot apply change to unverified plugged-in datafile string
  • ora-16105 : Logical Standby is already running in background
  • ora-21606 : can not free this object
  • ora-25503 : cannot open database because the database is being quiesced
  • ora-27053 : blocksize in file header not a multiple of logical block size
  • ora-29383 : all leaves of top-plan string must be consumer groups
  • ora-02204 : ALTER, INDEX and EXECUTE not allowed for views
  • ora-27075 : SSTMOFRC constant too large
  • ora-06004 : NETASY: dialogue file open failure
  • ora-30131 : number of keys being set exceeds allocation
  • ora-02249 : missing or invalid value for MAXLOGMEMBERS
  • ora-39206 : A parallel degree of string is invalid.
  • ora-00437 : ORACLE feature is not licensed. Contact Oracle Corp. for assistance
  • ora-13240 : specified dimensionality greater than that of the query mbr
  • ora-08331 : Wait operation timed out
  • ora-04000 : the sum of PCTUSED and PCTFREE cannot exceed 100
  • ora-03274 : both ALLOCATE EXTENT and DEALLOCATE UNUSED options are specified
  • ora-00480 : LCK* process terminated with error
  • ora-01525 : error in renaming data files
  • ora-01044 : size string of buffer bound to variable exceeds maximum string
  • ora-16523 : operation requires the client to connect to instance "string"
  • ora-26710 : incompatible version marker encountered during Capture
  • ora-01375 : Corrupt logfile string recovered
  • ora-04063 : %s has errors
  • ora-00316 : log string of thread string, type string in header is not log file
  • ora-16575 : request terminated at broker discretion
  • ora-06977 : X.25 Driver: X.25 Level 2 failure
  • 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.