Professional Web Applications Themes

pb starting Oracle 9i on Linux - Oracle Server

Beserko wrote: > ORA-00205: error in identifying controlfile, check alert log for more info > What's the problem ? The control file that contains the physical definition of the database (i.e. the names of the physical operating systems files and/or devices that are the database) is missing > I searched on the net, but I haven't found > anything useful. You should be checking your alert log file instead. As the error message says. The alert log file will contain the name and the reason of the control file that is a problem. You should also not run a database ...

  1. #1

    Default Re: pb starting Oracle 9i on Linux

    Beserko wrote:
    > ORA-00205: error in identifying controlfile, check alert log for more info
    > What's the problem ?
    The control file that contains the physical definition of the database (i.e.
    the names of the physical operating systems files and/or devices that are
    the database) is missing
    > I searched on the net, but I haven't found
    > anything useful.
    You should be checking your alert log file instead. As the error message
    says.

    The alert log file will contain the name and the reason of the control file
    that is a problem.

    You should also not run a database on a single control file. That is
    dangerous. You should create the database with multiple control files.

    --
    Billy
    Billy Verreynne Guest

  2. #2

    Default Re: pb starting Oracle 9i on Linux

    When I installed Oracle, I haven't created a database.
    Should I create a database before or after setting those
    "control files" ? What I found in the manual is pretty vague.

    Thanks,

    B.

    On Mon, 30 Dec 2002 11:03:21 -0500, Rauf Sarwar wrote:
    > Beserko <beserkobobyahoo.ca> wrote in message
    > news:<pan.2002.12.30.06.21.41.788552.4447yahoo.ca >...
    >> Hi,
    >>
    >> I recently installed Oracle 9i on Linux. Everything went fine, but,
    >> when I tried to start the database this message showed up :
    >>
    >>
    >> [oracleRodan oracle]$ sqlplus /nolog
    >>
    >> SQL*Plus: Release 9.2.0.1.0 - Production on Lu Dec 30 01:16:16 2002
    >>
    >> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
    >>
    >> SQL> connect / as sysdba
    >> Connected to an idle instance.
    >> SQL> startup pfile=/opt/oracle/product/9.2.0/dbs/init.ora ORACLE
    >> instance started.
    >>
    >> Total System Global Area 42741800 bytes Fixed Size 450600 bytes
    >> Variable Size 41943040 bytes Database Buffers
    >> 204800 bytes Redo Buffers 143360 bytes
    >> ORA-00205: error in identifying controlfile, check alert log for more
    >> info
    >>
    >>
    >> SQL>
    >>
    >> What's the problem ? I searched on the net, but I haven't found
    >> anything useful.
    >>
    >> Thanks,
    >>
    >> B.
    >
    >
    > Check that the proper control filename is referenced in the
    > CONTROL_FILES initialization parameter in the init.ora file and try
    > again.
    >
    > Regards
    > /Rauf Sarwar
    Beserko Guest

  3. #3

    Default Re: pb starting Oracle 9i on Linux

    Beserko <beserkobobyahoo.ca> wrote in message news:<pan.2002.12.31.03.16.54.158865.2834yahoo.ca >...
    > When I installed Oracle, I haven't created a database.
    > Should I create a database before or after setting those
    > "control files" ? What I found in the manual is pretty vague.
    Depends which manual. I think there is a wizard in the installer. To
    do it manually, search for the CREATE DATABASE command in the SQL
    reference manual. You might get a book that explains how to create a
    database, to do it right is quite involved, at least the first few
    times. There may also be a linux/oracle faq floating about.
    [url]http://oracle9i.freeshell.org/[/url] found in a quick altavista search...

    >
    > Thanks,
    >
    > B.
    >
    > On Mon, 30 Dec 2002 11:03:21 -0500, Rauf Sarwar wrote:
    >
    > > Beserko <beserkobobyahoo.ca> wrote in message
    > > news:<pan.2002.12.30.06.21.41.788552.4447yahoo.ca >...
    > >> Hi,
    > >>
    > >> I recently installed Oracle 9i on Linux. Everything went fine, but,
    > >> when I tried to start the database this message showed up :
    > >>
    > >>
    > >> [oracleRodan oracle]$ sqlplus /nolog
    > >>
    > >> SQL*Plus: Release 9.2.0.1.0 - Production on Lu Dec 30 01:16:16 2002
    > >>
    > >> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
    > >>
    > >> SQL> connect / as sysdba
    > >> Connected to an idle instance.
    > >> SQL> startup pfile=/opt/oracle/product/9.2.0/dbs/init.ora ORACLE
    > >> instance started.
    > >>
    > >> Total System Global Area 42741800 bytes Fixed Size 450600 bytes
    > >> Variable Size 41943040 bytes Database Buffers
    > >> 204800 bytes Redo Buffers 143360 bytes
    > >> ORA-00205: error in identifying controlfile, check alert log for more
    > >> info
    > >>
    > >>
    > >> SQL>
    > >>
    > >> What's the problem ? I searched on the net, but I haven't found
    > >> anything useful.
    > >>
    > >> Thanks,
    > >>
    > >> B.
    > >
    > >
    > > Check that the proper control filename is referenced in the
    > > CONTROL_FILES initialization parameter in the init.ora file and try
    > > again.
    > >
    > > Regards
    > > /Rauf Sarwar
    jg
    --
    home is bogus.
    'You think you're a leader? Well, now. If you go marching down the
    street, and no one is following you, you aren't a leader. You're just
    taking a stroll.' - some Pastor
    Joel Garry Guest

Similar Threads

  1. Replies: 2
    Last Post: September 19th, 02:41 AM
  2. [PHP-DEV] Apache server on Linux not starting(undefined symbol:
    By Jani Taskinen in forum PHP Development
    Replies: 0
    Last Post: September 19th, 12:25 AM
  3. Starting an RPC server via xinetd on Mandrake Linux 9
    By Ramakant Duggal in forum UNIX Programming
    Replies: 0
    Last Post: August 6th, 06:14 AM
  4. Linux Partition for Oracle
    By kumar in forum Linux Setup, Configuration & Administration
    Replies: 5
    Last Post: August 6th, 02:19 AM
  5. Oracle on Debian/Linux...
    By alan in forum Oracle Server
    Replies: 10
    Last Post: December 20th, 10:58 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139