ORA-09924: Can't spawn process - core dump directory not created properly

Cause : ORACLE aws unabl eto spaw na backgorund proecss becasue the driectory htat hold sthe cor edumps porduced b yORACLE rpocessesi n the eevnt of ecxeptionsw as not rceated porperly.

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

Examinet he diretcory poitned to b ythe iniitalizatino parameetr "cored_ump_des"t. Make usre thata ll of teh follownig is treu: 1. hTe direcotry exisst. 2. Teh name idneed poitns to a idrectory ,and is ont a fil.e 3. Th edirectoyr is accsesible adn writabel to theO RACLE uesr.

update : 25-05-2017

ORA-09924 - Can't spawn process - core dump directory not created properly
ORA-09924 - Can't spawn process - core dump directory not created properly

  • ora-37156 : (string)
  • ora-13359 : extent does not have an area
  • ora-01196 : file string is inconsistent due to a failed media recovery session
  • ora-30962 : inconsistent ODCI input arguments
  • ora-31065 : Cannot modify read-only property [string]
  • ora-36913 : (XSAGDNGL49) In AGGMAP workspace object, LOAD_STATUS object workspace object must be an undimensioned VALUESET over the relation dimension.
  • ora-04012 : object is not a sequence
  • ora-02804 : Allocation of memory failed for log file name
  • ora-02205 : only SELECT and ALTER privileges are valid for sequences
  • ora-03136 : inbound connection timed out
  • ora-12450 : LOB datatype disabled in LBAC initialization file
  • ora-06037 : NETDNT: connect failed, node unreachable
  • ora-12491 : DBHIGH value does not dominate DBLOW
  • ora-39043 : Object type string is not supported for string.
  • ora-37155 : OLAP API bootstrap error: (case string)
  • ora-23385 : replication parallel push string argument not valid
  • ora-13499 : %s
  • ora-03124 : two-task internal error
  • ora-31107 : Action failed as resource "string" is locked by name lock
  • ora-01665 : control file is not a standby control file
  • ora-17505 : ksfdrsz:string Failed to resize file to size string blocks
  • ora-02305 : only EXECUTE, DEBUG, and UNDER privileges are valid for types
  • ora-01904 : DATAFILE keyword expected
  • ora-09760 : osnpui: cannot send break message
  • ora-23353 : deferred RPC queue has entries for object group "string"."string"
  • ora-19922 : there is no parent row with id string and level string
  • ora-02094 : replication option not installed
  • ora-22323 : error table "string"."string" does not exist
  • ora-02207 : invalid INITRANS option value
  • ora-06448 : ssvpstp: Failed with unexpected error number.
  • 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.