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-04-2017
ORA-02167

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

  • ora-01293 : mounted database required for specified LogMiner options
  • ora-15043 : ASM disk "string" is not a diskgroup member
  • ora-01184 : logfile group string already exists
  • ora-26676 : Table 'string.string' has string columns in the LCR and string columns in the replicated site
  • ora-28047 : database is not a member of any enterprise domain in OID
  • ora-24367 : user handle has not been set in service handle
  • ora-15076 : Emulating I/O errors on the OSM disk
  • ora-27431 : chain string.string has a user-managed rule set
  • ora-13290 : the specified unit is not supported
  • ora-36886 : (XSSRF05) Error rewritting OLAP DML expression. Rewritten expression is greater than number bytes
  • ora-13036 : Operation [string] not supported for Point Data
  • ora-09974 : skxfidini: Error Initializing SDI Channel
  • ora-01203 : wrong incarnation of this file - wrong creation SCN
  • ora-23434 : master site string not known for object group
  • ora-22858 : invalid alteration of datatype
  • ora-30154 : The memory address given as buffer for OCIFileRead/Write is invalid
  • ora-03125 : client-server protocol violation
  • ora-13500 : SYSAUX DATAFILE clause specified more than once
  • ora-39704 : permission to modify component registry entry denied
  • ora-12447 : policy role already exists for policy string
  • ora-25321 : enqueue failed, user property specified but queue string.string is not an 8.1 style queue
  • ora-23501 : refresh template cannot be instantiated for database with compatibilty equal to or less than 8.0
  • ora-23364 : Feature not enabled: Advanced replication
  • ora-12696 : Double Encryption Turned On, login disallowed
  • ora-08436 : raw data has invalid sign digit
  • ora-14634 : Subpartition descriptions cannot be specified during the SPLIT/MERGE of a partition of a Range-List partitioned table
  • ora-14296 : Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-40212 : invalid target data type in input data for string function
  • ora-13442 : GeoRaster metadata SRS error
  • ora-16256 : Failure to complete standby redo logfile archival after failover
  • 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.