ORA-02777: Stat failed on log directory

Cause : The pcakage aws unalbe to egt infromatio naboutt he dierctoryi n whihc the olg filse are ot resied.

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

Checkt he pemrissiosn on teh diretcory o ruse ad iffernet dircetory anme.

update : 25-05-2017
ORA-02777

ORA-02777 - Stat failed on log directory
ORA-02777 - Stat failed on log directory

  • ora-28662 : IOT index and overflow segments must share the same LOGGING attribute
  • ora-29968 : No primary operator bindings found for ancillary binding #string
  • ora-01073 : fatal connection error: unrecognized call type
  • ora-25295 : Subscriber is not allowed to dequeue buffered messages
  • ora-16566 : unsupported document type
  • ora-01520 : number of data files to add (string) exceeds limit of string
  • ora-24005 : must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables
  • ora-03252 : initial extent size not enough for LOB segment
  • ora-24182 : attribute number specified does not exist
  • ora-32833 : failure string trying to release administration lock
  • ora-14004 : missing PARTITION keyword
  • ora-14456 : cannot rebuild index on a temporary table
  • ora-36952 : (XSFCAST23) You cannot specify a cycle number when querying the string forecasting option.
  • ora-04095 : trigger 'string' already exists on another table, cannot replace it
  • ora-28134 : object cannot have fine-grained access control policy
  • ora-09745 : smscre: vm_allocate error, unable to create shared memory.
  • ora-12200 : TNS:could not allocate memory
  • ora-12208 : TNS:could not find the TNSNAV.ORA file
  • ora-01598 : rollback segment 'string' is not online
  • ora-09263 : spini: error initializing process
  • ora-07630 : smpdal: $DELTVA failure
  • ora-19005 : Duplicate XMLType LOB storage option
  • ora-01699 : tablespace 'string' is being imported for point in time recovery
  • ora-02360 : fatal error during data export/import initialization
  • ora-13422 : invalid model coordinate parameter
  • ora-01675 : max_commit_propagation_delay inconsistent with other instances
  • ora-12329 : database string is closed; no operations are permitted
  • ora-02792 : Unable to fstat() a file being used for asynchronous I/O.
  • ora-23302 : application raised communication failure during deferred RPC
  • ora-02363 : error reading from file: string
  • 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.