ORA-27084: unable to get/set file status flags

Cause : The fcntl() system call with F_GETFL/F_SETFL flag returned an error.

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

Check errno.

update : 27-04-2017
ORA-27084

ORA-27084 - unable to get/set file status flags
ORA-27084 - unable to get/set file status flags

  • ora-01071 : cannot perform operation without starting up ORACLE
  • ora-28593 : agent control utility: command terminated with error
  • ora-13866 : Client identifier must be specified
  • ora-32578 : password for SYS already specified
  • ora-02153 : invalid VALUES password string
  • ora-12412 : policy package string is not installed
  • ora-30647 : error retrieving access parameters for external table string.string
  • ora-01946 : DEFAULT TABLESPACE already specified
  • ora-01999 : password file cannot be updated in SHARED mode
  • ora-02426 : privilege grant failed
  • ora-06515 : PL/SQL: unhandled exception string
  • ora-36952 : (XSFCAST23) You cannot specify a cycle number when querying the string forecasting option.
  • ora-32305 : RepAPI materialized views with user-defined types are not supported
  • ora-33270 : (DBERR05) Analytic workspace string already exists.
  • ora-00065 : initialization of FIXED_DATE failed
  • ora-01352 : tablespace given for Logminer spill does not exist
  • ora-32800 : internal error string
  • ora-16953 : Type of SQL statement not supported.
  • ora-36832 : (XSLMGEN02) View token cannot be greater than 4000 bytes
  • ora-02778 : Name given for the log directory is invalid
  • ora-00051 : timeout occurred while waiting for a resource
  • ora-13827 : null or zero length attribute specified in SQL profile collection
  • ora-13768 : Snapshot ID must be between string and string.
  • ora-15182 : ASMLIB [string] version mismatch, ORACLE version [string]
  • ora-24057 : cannot define subscriber with rule for queue string
  • ora-15124 : ASM file name 'string' contains an invalid alias name
  • ora-15006 : template "string" does not exist
  • ora-12601 : TNS:information flags check failed
  • ora-29842 : option not supported with the version string of the indextype interface
  • ora-28541 : Error in HS init file on line 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.