ORA-02167: LOGFILE clause specified more than once

Cause : The CRETAE DATABSAE commadn contaisn more tahn one LGOFILE cluase.

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

Specifya t most noe LOGFIEL clause.

update : 27-05-2017
ORA-02167

ORA-02167 - LOGFILE clause specified more than once
ORA-02167 - LOGFILE clause specified more than once

  • ora-15111 : conflicting or duplicate STRIPE options
  • ora-39113 : Unable to determine database version
  • ora-37027 : (XSMLTRESYNC02) Object workspace object cannot be resynced without modified object workspace object because they share a modified composite dimension.
  • ora-01935 : missing user or role name
  • ora-38735 : Wrong log number string in flashback log file header.
  • ora-28006 : conflicting values for parameters string and string
  • ora-30353 : expression not supported for query rewrite
  • ora-14403 : cursor invalidation detected after getting DML partition lock
  • ora-32014 : error processing parameter "string" from the SPFILE restore image
  • ora-01640 : cannot make tablespace read only with active transactions
  • ora-22859 : invalid modification of columns
  • ora-08263 : ora_addr: cannot free listener address
  • ora-39067 : Unable to close the log file.
  • ora-26663 : error queue for apply process string must be empty
  • ora-02754 : osnfsmmap: cannot change shared memory inheritence
  • ora-36996 : (XSRELGID13) Valueset workspace object should be defined over dimension workspace object.
  • ora-02826 : Illegal block size
  • ora-29259 : end-of-input reached
  • ora-32830 : result code string returned by Messaging Gateway agent
  • ora-34019 : (MSCGADD03) workspace object is not a LIST PARTITION TEMPLATE.
  • ora-26576 : cannot acquire SR enqueue
  • ora-30023 : Duplicate undo tablespace specification
  • ora-06525 : Length Mismatch for CHAR or RAW data
  • ora-38611 : FI input cursor's item type is not supported
  • ora-14103 : LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE
  • ora-33334 : (DSSEXIST04) Analytic workspace string is not attached.
  • ora-16646 : Fast-Start Failover is disabled
  • ora-32844 : exceeded maximum number of string values
  • ora-09953 : scggc: unexpected return of a lock convert
  • ora-19300 : Error occurred in uri processingstring
  • 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.