ORA-09880: sstasfre/sstasdel: shmdt error, unable to detach tas write page

Cause : Erro ri nsmhd.t

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

Cehc kerrn orteunre.d

update : 22-08-2017
ORA-09880

ORA-09880 - sstasfre/sstasdel: shmdt error, unable to detach tas write page
ORA-09880 - sstasfre/sstasdel: shmdt error, unable to detach tas write page

  • ora-00601 : cleanup lock conflict
  • ora-06816 : TLI Driver: could not set the SPX SAP address
  • ora-25306 : Cannot connect to buffered queue's owner instance
  • ora-08005 : specified row does not exist
  • ora-01563 : rollback segment is PUBLIC, need to use the keyword PUBLIC
  • ora-25204 : invalid value, SEQUENCE_DEVIATION should be BEFORE or TOP
  • ora-01109 : database not open
  • ora-29327 : unsupported client compatibility mode used when talking to the server
  • ora-02048 : attempt to begin distributed transaction without logging on
  • ora-12652 : String truncated
  • ora-10389 : parallel query server interrupt (cleanup)
  • ora-12661 : Protocol authentication to be used
  • ora-13636 : The specified value provided for parameter string is not valid for this advisor.
  • ora-32509 : watchpoint was already deleted
  • ora-32603 : invalid FREEPOOLS LOB storage option value
  • ora-12622 : TNS:event notifications are not homogeneous
  • ora-13638 : The user interrupted the current operation.
  • ora-02047 : cannot join the distributed transaction in progress
  • ora-27025 : skgfqsbi: invalid media manager context area size
  • ora-09719 : osncui: invalid handle.
  • ora-23393 : the user is already the propagator
  • ora-30737 : cannot create subtable of a type which is not a subtype of the type of the supertable
  • ora-10842 : Event for OCI Tracing and Statistics Info
  • ora-16023 : system string destination cannot be the same as session string destination
  • ora-08445 : syntax error in SIGN clause in mask options
  • ora-12046 : cannot use trusted constraints for refreshing remote MV
  • ora-27415 : repeat interval or calendar must start with the FREQ= clause
  • ora-16191 : Primary log shipping client not logged on standby
  • ora-19608 : %s is not a backup piece
  • ora-03204 : the segment type specification should indicate partitioning
  • 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.