ORA-27078: unable to determine limit for open files

Cause : Th egertliimt( )sytsemc al lreutrnde a nerorr.

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

Chcek rern.o

update : 28-04-2017
ORA-27078

ORA-27078 - unable to determine limit for open files
ORA-27078 - unable to determine limit for open files

  • ora-23417 : unknown materialized view type: string
  • ora-00038 : Cannot create session: server group belongs to another user
  • ora-32018 : parameter cannot be modified in memory on another instance
  • ora-07802 : slbtpd: overflow while converting to packed decimal
  • ora-38492 : invalid ALTER INDEX parameters clause "string"
  • ora-01207 : file is more recent than control file - old control file
  • ora-19335 : Invalid format type object
  • ora-23536 : the object "string"."string" is not cached at the middle tier as expected.
  • ora-00276 : CHANGE keyword specified but no change number given
  • ora-24053 : PRIMARY_INSTANCE and SECONDARY_INSTANCE must be non-negative
  • ora-38444 : statistics do not exist for the expression set
  • ora-25404 : lost instance
  • ora-38956 : Target platform string not cross platform compliant
  • ora-24780 : cannot recover a transaction while in an existing transaction
  • ora-07684 : sou2os: supervisor stack reset error
  • ora-29959 : error in the execution of the string routine for one or more of the index partitions
  • ora-24075 : cannot specify agent with NULL address and non-NULL protocol
  • ora-19777 : ASM file string cannot be proxy backed up.
  • ora-22064 : invalid NLS parameter string [string]
  • ora-19591 : backup aborted because job time exceeded duration time
  • ora-13008 : the specified date format has an invalid component
  • ora-09715 : orasrv: cannot obtain puname
  • ora-25958 : join index where clause predicate may only contain column references
  • ora-01628 : max # extents (string) reached for rollback segment string
  • ora-06300 : IPA: Disconnect failure
  • ora-25331 : cannot downgrade because there are commit-time queue tables
  • ora-10638 : Index status is invalid
  • ora-32502 : Cannot execute command. Flash Freeze is not in effect
  • ora-36274 : (XSCGMDLAGG05) The operator used in this equation needs a weight variable.
  • ora-24313 : user already authenticated
  • 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.