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 : 25-09-2017
ORA-02167

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

  • ora-02076 : sequence not co-located with updated table or long column
  • ora-32740 : The requested operation cannot be proceeded
  • ora-13272 : geometric object string in table string is invalid
  • ora-30461 : 'string.string' cannot be refreshed because it is marked DISABLED
  • ora-30175 : invalid type given for an argument
  • ora-14000 : only one LOCAL clause may be specified
  • ora-07253 : spdes: semctl error, unable to destroy semaphore set.
  • ora-28353 : failed to open wallet
  • ora-16613 : initialization in progress for database
  • ora-03291 : Invalid truncate option - missing STORAGE keyword
  • ora-14164 : subpartition "string": INITRANS value must be less than MAXTRANS value
  • ora-00299 : must use file-level media recovery on data file string
  • ora-13108 : spatial table string not found
  • ora-13027 : unable to read dimension definition from string
  • ora-00310 : archived log contains sequence string; sequence string required
  • ora-02354 : error in exporting/importing data string
  • ora-22910 : cannot specify schema name for nested tables
  • ora-27469 : %s is not a valid string attribute
  • ora-37122 : AW Session cache disabled
  • ora-23381 : generated object for base object string.string@string does not exist
  • ora-06558 : buffer in dbms_pipe package is full. No more items allowed
  • ora-25123 : Too many components specified in the name.
  • ora-29277 : invalid SMTP operation
  • ora-19620 : %s is not of string type
  • ora-07391 : sftopn: fopen error, unable to open text file.
  • ora-12456 : label security startup in progress
  • ora-31523 : could not find change source string for CDC change set string
  • ora-08330 : Printing not supported
  • ora-29877 : failed in the execution of the ODCIINDEXUPDATE routine
  • ora-16064 : remote archival is disabled by another instance
  • 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.