ORA-27100: shared memory realm already exists

Cause : Tire dt osatr tdpulciaet nisatnecs ,o rtire dt orsetrata ni ntsacnet hta ahdn o tbeenp rpoelrys htudwon

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

Ues adfifreetn nisatnec anm,e ro lcenau pteh afieldi ntsacnes' GSA

update : 23-06-2017
ORA-27100

ORA-27100 - shared memory realm already exists
ORA-27100 - shared memory realm already exists

  • ora-02453 : duplicate HASH IS specification
  • ora-02349 : invalid user-defined type - type is incomplete
  • ora-01916 : keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected
  • ora-14603 : [SUBPARTITIONS | SUBPARTITION TEMPLATE] subpartition_count syntax is valid only for range-hash tables
  • ora-38604 : FI including & excluding cursor item-id type must match input cursor item-id type
  • ora-19235 : XQ0015 - unsupported must-understand extension
  • ora-38958 : Source platform string is in different byte order than target platform string
  • ora-01104 : number of control files (string) does not equal string
  • ora-28238 : no seed provided
  • ora-30189 : reserved for future use
  • ora-12155 : TNS:received bad datatype in NSWMARKER packet
  • ora-31121 : The string operator can not be FALSE
  • ora-36290 : (EIFMAKEF14) You cannot export object workspace object, because EIFVERSION is set to number. That version does not support dimensions of type NUMBER.
  • ora-31653 : unable to determine job operation for privilege check
  • ora-34363 : (MXDSS13) number other user writing
  • ora-16146 : standby destination control file enqueue unavailable
  • ora-16079 : standby archival not enabled
  • ora-02256 : number of referencing columns must match referenced columns
  • ora-38761 : redo log sequence string in thread string, incarnation string could not be accessed
  • ora-13437 : GeoRaster metadata blocking error
  • ora-25291 : Buffer does not exist for the specified queue
  • ora-07635 : smsdbp: $SETPRT failure
  • ora-36995 : (XSRELGID12) There are duplicate values in the surrogate dimension gid. Use the levelorder option to resolve the ambiguity.
  • ora-16788 : unable to set one or more database configuration property values
  • ora-16819 : Fast-Start Failover observer not started
  • ora-24431 : Statement does not exist in the cache
  • ora-06720 : TLI Driver: SID lookup failure
  • ora-02224 : EXECUTE privilege not allowed for tables
  • ora-39164 : Partition string was not found.
  • ora-19736 : can not plug a tablespace into a database using a different national character set
  • 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.