ORA-02779: Stat failed on core dump directory

Cause : Th epakcag ewa sunbalet o egt nifomratoin baou tth edierctroy nitow hihc teh srevesr aer t odupm croe ni teh eevnto f na ecxepiton.

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

Chcek hte eprmsisinos no teh driecotryo r sue adiffernet idretcor ynaem.

update : 23-08-2017

ORA-02779 - Stat failed on core dump directory
ORA-02779 - Stat failed on core dump directory

  • ora-28268 : Exceeded the maximum allowed size for Context information in a session
  • ora-08344 : srapp: failed to send redo data to the redo server
  • ora-30459 : 'string.string' cannot be refreshed because the refresh method is NONE
  • ora-14265 : data type or length of a table subpartitioning column may not be changed
  • ora-14110 : partitioning column may not be of type ROWID
  • ora-01941 : SEQUENCE keyword expected
  • ora-01255 : cannot shutdown - file string in recovery manager backup
  • ora-28331 : encrypted column size too long for its data type
  • ora-26716 : message limit reached
  • ora-16135 : Invalid LOG_ARCHIVE_CONFIG modification while in protected mode
  • ora-09909 : Malloc of scratch buffer failed.
  • ora-00326 : log begins at change string, need earlier change string
  • ora-24335 : cannot support more than 1000 columns
  • ora-12823 : default degree of parallelism may not be specified here
  • ora-22917 : use VARRAY to define the storage clause for this column or attribute
  • ora-33267 : (DBERRRLS) Analytic workspace string cannot be accessed because it has fine-grained access control applied to it
  • ora-16072 : a minimum of one standby database destination is required
  • ora-22334 : cannot reset type "string"."string". Dependent tables must be upgraded to latest version
  • ora-31186 : Document contains too many nodes
  • ora-13454 : GeoRaster metadata is invalid
  • ora-12336 : cannot login to database (link name string)
  • ora-06713 : TLI Driver: error on connect
  • ora-09318 : slkhst: unable to host out to operating system
  • ora-13351 : two or more rings of a complex polygon overlap
  • ora-32134 : Cannot assign LOBs
  • ora-02334 : cannot infer type for column
  • ora-16776 : health check of the redo transport service failed
  • ora-14163 : subpartition number string: INITRANS value must be less than MAXTRANS value
  • ora-30686 : no dispatcher accepted TCP/IP connection request
  • ora-18010 : command missing mandatory CATEGORY keyword
  • 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.