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 : 27-06-2017

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

  • ora-24912 : Listener thread failed. string
  • ora-19613 : datafile string not found in backup set
  • ora-22150 : variable-length array has not been initialized
  • ora-19678 : RMAN configuration value exceeds maximum length of string
  • ora-39313 : call to DBMS_SCHEMA_COPY.CLONE is not legal
  • ora-31228 : DBMS_LDAP: invalid MOD_ARRAY
  • ora-01241 : an external cache has died
  • ora-26744 : STREAMS capture process "string" does not support "string"."string" because of the following reason: string
  • ora-13044 : the specified tile size is smaller than the tolerance
  • ora-10645 : Recursive Extension in SYSTEM tablespace during migration
  • ora-29903 : error in executing ODCIIndexFetch() routine
  • ora-12672 : Database logon failure
  • ora-01979 : missing or invalid password for role 'string'
  • ora-14057 : partition "string": sum of PCTUSED and PCTFREE may not exceed 100
  • ora-22315 : type "string" does not contain a map or order function
  • ora-26712 : remote object is "string"."string"@"string"
  • ora-01724 : floating point precision is out of range (1 to 126)
  • ora-09274 : szrfc: insufficient role name buffer space
  • ora-27077 : too many files open
  • ora-21605 : property [string] is not a property of value instances
  • ora-06142 : NETTCP: error getting user information
  • ora-32836 : database user string must be granted role string
  • ora-24911 : Cannot start listener thread at specified port
  • ora-22065 : number to text translation for the given format causes overflow
  • ora-09280 : sllfcf: error closing file
  • ora-07845 : sllfcl: LIB$FREE_VM failue
  • ora-16508 : channel handle not initialized
  • ora-02278 : duplicate or conflicting MAXVALUE/NOMAXVALUE specifications
  • ora-13622 : invalid recommendation annotation
  • ora-37158 : Bad clob or varray IN-args: (case string)
  • 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.