ORA-27125: unable to create shared memory segment

Cause : shmget() call failed

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

contact Oracle support

update : 29-04-2017

ORA-27125 - unable to create shared memory segment
ORA-27125 - unable to create shared memory segment

  • ora-32018 : parameter cannot be modified in memory on another instance
  • ora-13337 : failure in concatenating LRS polygons
  • ora-28340 : a different encryption algorithm has been chosen for the table
  • ora-15163 : cluster not in rolling downgrade
  • ora-07271 : spwat: invalid oracle process number.
  • ora-14062 : one or more of table's partitions reside in a read-only tablespace
  • ora-16541 : site is not enabled
  • ora-16108 : database is no longer a standby database
  • ora-06578 : output parameter cannot be a duplicate bind
  • ora-22286 : insufficient privileges on file or directory to perform string operation
  • ora-31398 : DBMS_LDAP: Shared servers are not supported.
  • ora-01104 : number of control files (string) does not equal string
  • ora-16137 : No terminal recovery is required
  • ora-27455 : Only "SYS" is a valid schema for a string.
  • ora-28263 : Insufficient memory in global context pool
  • ora-10616 : Operation not allowed on this tablespace
  • ora-08119 : The new initrans will make the index too big
  • ora-33292 : (DBERR18) insufficient permissions to access analytic workspace string using the specified access mode.
  • ora-10582 : The control file is not a backup control file
  • ora-01308 : initialization parameter utl_file_dir is not set
  • ora-24063 : cannot downgrade QUEUE_TABLE that has queues with rule-based subscribers
  • ora-28515 : cannot get external object definitions from string
  • ora-16628 : the broker protection mode is inconsistent with the database setting
  • ora-34901 : (PPWKDAYS01) Blank lines are not allowed in the DAYNAMES option.
  • ora-25295 : Subscriber is not allowed to dequeue buffered messages
  • ora-02057 : 2PC: string: bad two-phase recovery state number string from string
  • ora-07500 : scglaa: $cantim unexpected return
  • ora-31464 : target table for the change table no longer exists
  • ora-16068 : redo log file activation identifier mismatch
  • ora-00021 : session attached to some other process; cannot switch session
  • 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.