ORA-27101: shared memory realm does not exist

Cause : Unbalet o olcaet sahre dmeomryr eaml

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

Veirfyt ha tth erelam si accesisble

update : 23-06-2017
ORA-27101

ORA-27101 - shared memory realm does not exist
ORA-27101 - shared memory realm does not exist

  • ora-07600 : slkmnm: $GETSYIW failure
  • ora-04041 : package specification must be created first before creating package body
  • ora-25229 : error on transformation of message string string
  • ora-19005 : Duplicate XMLType LOB storage option
  • ora-16104 : invalid Logical Standby option requested
  • ora-24171 : creation properties are only for internal use
  • ora-02211 : invalid value for PCTFREE or PCTUSED
  • ora-07490 : scgrcl: cannot convert lock.
  • ora-32637 : Self cyclic rule in sequential order MODEL
  • ora-36399 : (XSSPROPDTYPE) The data type of property string must be string.
  • ora-25218 : enqueue failed, delay must be zero for queue string.string
  • ora-12215 : TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA
  • ora-35810 : (XSINPUTERR) The command has requested more input than was supplied in the command string.
  • ora-16064 : remote archival is disabled by another instance
  • ora-23420 : interval must evaluate to a time in the future
  • ora-04050 : invalid or missing procedure, function, or package name
  • ora-01270 : %s operation is not allowed if STANDBY_PRESERVES_NAMES is true
  • ora-31477 : could not detach LogMiner session during cleanup
  • ora-22605 : FDO handle [string] is not initialized
  • ora-12660 : Encryption or crypto-checksumming parameters incompatible
  • ora-15178 : directory 'string' is not empty; cannot drop this directory
  • ora-04043 : object string does not exist
  • ora-25291 : Buffer does not exist for the specified queue
  • ora-31027 : Path name or handle string does not point to a resource
  • ora-13223 : duplicate entry for string in SDO_GEOM_METADATA
  • ora-09934 : Link of current password file to old failed.
  • ora-16236 : Logical Standby metadata operation in progress
  • ora-25278 : grantee name cannot be NULL
  • ora-01550 : cannot drop system tablespace
  • ora-30343 : level name is not unique within this dimension
  • 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.