Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2005

    Unanswered: Error in identifying Control file

    I am running Oracle 10g on Linux.

    SQL> startup
    ORACLE instance started.

    Total System Global Area 88080384 bytes
    Fixed Size 777812 bytes
    Variable Size 87040428 bytes
    Database Buffers 0 bytes
    Redo Buffers 262144 bytes
    ORA-00205: error in identifying controlfile, check alert log for more info

    Any suggestion???


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >Any suggestion???
    check alert log for more info

    Are the control files actually in the same location where you told Oracle they are supposed to be?

    When was the last the last time this instance sucessfully opened?
    What's changed since then?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Feb 2005
    This is a Controlfile log

    SQL*Loader: Release - Production on Wed Feb 23 10:46:42 2005

    Copyright (c) 1982, 2004, Oracle. All rights reserved.

    SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
    ORA-12154: TNS:could not resolve the connect identifier specified

  4. #4
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    Hm, I'm afraid you mixed things up ... control file in your first post isn't the same you're talking about in the second one.

    If I'm not wrong, first control file should be the one that stores the status of the physical structure of the database and is crucial to database operation. Your DB must have at least one control file. And this is the one you're really looking for.

    And the second one is control file used by SQL*Loader utility, and this one stores information about loading data from a file into table(s) in your database.

    It seems you're reading the wrong log file ...

    To see where your control file(s) should be (just like Anacedent asked), check your INIT.ORA file. Then see if it (they) really are in that directory.

    I guess we'll hear from you again

  5. #5
    Join Date
    Feb 2005
    I changed the Control_files in INIT.ora . That change fixed the problem.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts