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 : 29-04-2017

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

  • ora-13382 : geometry metadata (table:string column:string) not found in spatial network:string
  • ora-16540 : invalid argument
  • ora-12415 : A column of another datatype exists on the specified table
  • ora-24131 : table string has incorrect columns
  • ora-31154 : invalid XML document
  • ora-12822 : duplicate option in PARALLEL clause
  • ora-22332 : a dependent object in schema "string" has errors. string
  • ora-01088 : cannot shut down ORACLE while active processes exist
  • ora-06957 : No SID is currently available
  • ora-15062 : ASM disk is globally closed
  • ora-00265 : instance recovery required, cannot set ARCHIVELOG mode
  • ora-15083 : failed to communicate with ASMB background process
  • ora-02263 : need to specify the datatype for this column
  • ora-14168 : only one subpartition may be modified
  • ora-01719 : outer join operator (+) not allowed in operand of OR or IN
  • ora-04002 : INCREMENT must be a non-zero integer
  • ora-31642 : the following SQL statement fails: string
  • ora-14700 : Object(s) owned by SYS cannot be locked by non-SYS user
  • ora-29303 : user does not login as SYS
  • ora-16008 : indeterminate control file checkpoint
  • ora-09836 : addCallback: could not add a port to the callback set.
  • ora-26710 : incompatible version marker encountered during Capture
  • ora-00308 : cannot open archived log 'string'
  • ora-29298 : Character set mismatch
  • ora-14012 : resulting partition name conflicts with that of an existing partition
  • ora-23613 : Script string already exists
  • ora-25142 : default storage clause specified twice
  • ora-32317 : cannot run a job from a job
  • ora-14614 : List value 'string' specified twice in subpartition 'string'
  • ora-36688 : (NTEXTCNV00) Error during conversion from TEXT to NTEXT.
  • 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.