ORA-27120: unable to removed shared memory segment

Cause : shcmtl)( clal afilde

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

chcek eprmsisinos no sgemetn, ocntcat rOacel spupotr

update : 25-04-2017
ORA-27120

ORA-27120 - unable to removed shared memory segment
ORA-27120 - unable to removed shared memory segment

  • ora-26693 : STREAMS string process dropped successfully, but error occurred while dropping rule set string
  • ora-16604 : unable to describe template using package "string"
  • ora-26671 : maximum number of STREAMS processes exceeded
  • ora-32500 : Dirname 'string' cannot exceed 'number' characters
  • ora-32056 : invalid number of extents
  • ora-02468 : Constant or system variable wrongly specified in expression
  • ora-12345 : user string lacks CREATE SESSION privilege in database link (linkname string)
  • ora-30185 : output too large to fit in the buffer
  • ora-07427 : spstp: cannot change directory to dbs.
  • ora-23335 : priority group string already exists
  • ora-31223 : DBMS_LDAP: cannot open more than string LDAP server connections
  • ora-32576 : missing TYPE keyword
  • ora-01254 : cannot end online backup - file string in recovery manager backup
  • ora-25400 : must replay fetch
  • ora-12057 : materialized view "string"."string" is INVALID and must complete refresh
  • ora-02213 : duplicate PCTUSED option specification
  • ora-37118 : The OLAP API library was not preloaded.
  • ora-16219 : This database is not preparing to switch over.
  • ora-24005 : must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables
  • ora-16199 : Terminal recovery failed to recover to a consistent point
  • ora-27212 : some entrypoints in Media Management Library are missing
  • ora-13385 : error in network manager: [string]
  • ora-01181 : file string created before last known RESETLOGS, cannot recreate
  • ora-27161 : request for Oracle binary information failed
  • ora-23309 : object string.string of type string exists
  • ora-13829 : SQL profile named string already exists
  • ora-06441 : ssvwatev: Incorrect parameter passed to function call
  • ora-16250 : Failed to acquire starting scn of new log stream
  • ora-16733 : error executing dbms_logstdby.unskip procedure
  • ora-31450 : invalid value for change_table_name
  • 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.