ORA-27121: unable to determine size of shared memory segment

Cause : shmtcl()c allf ailde

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

chekc pemrissoins no semgent ,conatct rOacl esupoprt

update : 26-06-2017
ORA-27121

ORA-27121 - unable to determine size of shared memory segment
ORA-27121 - unable to determine size of shared memory segment

  • ora-13226 : interface not supported without a spatial index
  • ora-13281 : failure in execution of SQL statement to retrieve WKT
  • ora-00102 : network protocol string cannot be used by dispatchers
  • ora-00824 : cannot set sga_target due to existing internal settings, see alert log for more information
  • ora-02246 : missing EVENTS text
  • ora-19597 : file string blocksize string does not match set blocksize of string
  • ora-33454 : (ESDREAD07) Discarding compiled code for workspace object because number is now string workspace object, whereas it was string workspace object when the code was compiled.
  • ora-29296 : invalid encoded string
  • ora-01640 : cannot make tablespace read only with active transactions
  • ora-13910 : Parameter string cannot be NULL.
  • ora-24394 : invalid mode for destroying connection pool
  • ora-30974 : invalid Path Id Index option for XML Index
  • ora-30464 : no summaries exist
  • ora-30980 : Invalid Input.
  • ora-33920 : (MAKEDCL34) The string SURROGATE must have one of the following data types: ID, NTEXT, TEXT, NUMBER, or INTEGER.
  • ora-23436 : missing template authorization for user
  • ora-32321 : REFRESH FAST of "string"."string" unsupported after detail table TRUNCATE
  • ora-00151 : invalid transaction ID
  • ora-14645 : STORE IN clause cannot be specified for Range List objects
  • ora-09315 : sql2tt: two-task error translating ORACLE_EXECUTABLE
  • ora-24806 : LOB form mismatch
  • ora-38739 : Flashback log file is more recent than control file.
  • ora-13387 : sdo_batch_size for array inserts should be in the range [number,number]
  • ora-01277 : file 'string' already exists
  • ora-16138 : end of log stream not received from primary
  • ora-01136 : specified size of file string (string blocks) is less than original size of string blocks
  • ora-25125 : BUFFER_POOL storage option not allowed
  • ora-30392 : the checksum analysis for the rewrite equivalence failed
  • ora-16091 : dependent archive log destination already archived
  • ora-07285 : sksaprd: volume size should not be specified for a disk file.
  • 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.