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 : 28-07-2017

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

  • ora-01196 : file string is inconsistent due to a failed media recovery session
  • ora-12418 : user string not found
  • ora-07641 : smscre: Unable to use the system pagefile for the SGA
  • ora-13330 : invalid MASK
  • ora-29296 : invalid encoded string
  • ora-24031 : invalid value, string should be non-NULL
  • ora-24122 : invalid block range specification
  • ora-29251 : Index1 is greater than Index2 in call to dbms_sql.bind_array
  • ora-14163 : subpartition number string: INITRANS value must be less than MAXTRANS value
  • ora-36913 : (XSAGDNGL49) In AGGMAP workspace object, LOAD_STATUS object workspace object must be an undimensioned VALUESET over the relation dimension.
  • ora-07510 : scgbrm: $getlki unexpected return on lockid string
  • ora-02338 : missing or invalid column constraint specification
  • ora-14407 : partitioned table contains subpartitions in a different tablespace
  • ora-24366 : migratable user handle is set in service handle
  • ora-02040 : remote database string does not support two-phase commit
  • ora-25220 : enqueue failed, signature not specified for a non-repudiable queue
  • ora-32332 : cannot refresh materialized view "string"."string" as type evolution has occured
  • ora-24783 : Cannot switch non-migratable transactions
  • ora-31087 : insufficient privileges to delete schema "string"
  • ora-28290 : Multiple entries found for the same Kerberos Principal Name
  • ora-02211 : invalid value for PCTFREE or PCTUSED
  • ora-12845 : failed to receive interinstance parallel execution message
  • ora-07801 : slbtpd: invalid exponent
  • ora-21526 : initialization failed
  • ora-07406 : slbtpd: invalid number.
  • ora-10664 : Table has bitmap join indexes
  • ora-13906 : The tablepace is not of the right type.
  • ora-01040 : invalid character in password; logon denied
  • ora-19618 : cannot name files after restoreValidate has been called
  • ora-19262 : XQ0042 - namespace constructor not inside an element constructor
  • 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.