ORA-09745: smscre: vm_allocate error, unable to create shared memory.

Cause : Errori n sysetm cal lvm_alolcate.F ailedt o cretae SGAa s a snigle sahred mmeory sgement.

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

Checkr esultc ode rteurnedi n serecrrno.V erifyt hat teh SGA tatach dadressi s valdi.

update : 23-07-2017
ORA-09745

ORA-09745 - smscre: vm_allocate error, unable to create shared memory.
ORA-09745 - smscre: vm_allocate error, unable to create shared memory.

  • ora-16649 : database will open after Data Guard broker has evaluated Fast-Start Failover status
  • ora-13623 : The recommendation string is not valid for task string.
  • ora-00290 : operating system archival error occurred. See error below
  • ora-16701 : generic resource guard request failed
  • ora-28350 : cannot encrypt the specified column recorded in CDC synchronized change table
  • ora-22285 : non-existent directory or file for string operation
  • ora-15095 : reached maximum ASM file size (string GB)
  • ora-00703 : maximum number of row cache instance locks exceeded
  • ora-10573 : Test recovery tested redo from change string to string
  • ora-00293 : control file out of sync with redo log
  • ora-19672 : media management software returned invalid file status
  • ora-19100 : PASSING or RETURNING keyword expected
  • ora-04080 : trigger 'string' does not exist
  • ora-16554 : translation not valid
  • ora-01170 : file not found 'string'
  • ora-06253 : NETNTT: cannot read arguments from address file
  • ora-32143 : Environment not specified
  • ora-14038 : GLOBAL partitioned index must be prefixed
  • ora-29963 : missing BINDING keyword
  • ora-22890 : cannot specify name for REF column constraint
  • ora-33306 : (DBVALID03) The AW VALIDATE command cannot be used with read-only analytic workspace string.
  • ora-19908 : datafile string has invalid checkpoint
  • ora-30945 : Could not create mapping table 'string'
  • ora-27463 : invalid program type string
  • ora-29378 : invalid consumer group mapping priorities
  • ora-27477 : "string.string" already exists
  • ora-25313 : a queue may not subscribe to itself for propagation
  • ora-16526 : unable to allocate task element
  • ora-00448 : normal completion of background process
  • ora-13634 : The task string needs to be reset before being re-executed.
  • 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.