ORA-01222: MAXINSTANCES of string requires MAXLOGFILES be at
least string, not string



ORA-01222: MAXINSTANCES of string requires MAXLOGFILES be at least string, not string..

Answer / guest

Cause: Attemping to create a database or controlfile that
does not have room for at least two logs per thread of redo.
A thread of redo must have two online logs in order to be
enabled. It does not make sense to allow more redo threads
than can be supported by the logs.

Action: Either reduce the MAXINSTANCES argument or increase
MAXLOGFILES.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16005: database requires recovery

1 Answers  


ORA-26094: stream format error: input column overflow

0 Answers   HP,


ORA-37044: (XSACQUIRE_OLDGEN) Cannot acquire object workspace object without resync.

1 Answers  


RMAN-06099: error occurred in source file: string, line: number

1 Answers  


ORA-14601: Illegal to specify SUBPARTITIONS or STORE-IN while specifying a subpartition template

1 Answers  






DRG-10100: invalid argument found: string

1 Answers  


ORA-38498: invalid stored attribute for the index object : string

1 Answers  


ORA-23610: internal dbms_streams_tablespaces error: [string] [string] [string] [string]

1 Answers  


ORA-30155: An I/O Error occured during an OCIFile function call

1 Answers  


DRG-51101: argument processing callback failed

1 Answers  


ORA-13758: "SQL Tuning Set" "string" is in use.

1 Answers  


SQL-02115: Code interpretation problem -- check COMMON_NAME usage

1 Answers  


Categories