Missing ora_control1 ???

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • =?ISO-8859-1?Q?Thomas_Gagn=E9?=
    #1

    Missing ora_control1 ???

    I've never installed Oracle, and have just worked my way through getting
    9i installed on RedHat 9.

    When I try to start it up I get the following:

    [oracle@cod1 oracle]$ sqlplus /nolog

    SQL*Plus: Release 9.2.0.4.0 - Production on Sat Apr 24 23:37:05 2004

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    SQLconnect / as sysdba
    Connected to an idle instance.
    SQLstartup
    ORACLE instance started.

    Total System Global Area 42742804 bytes
    Fixed Size 451604 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

    I'm not exactly sure which file they're talking about, but I did find
    something that looked interesting:

    [oracle@cod1 oracle]$ cat rdbms/log/alert_oracle.lo g
    Sat Apr 24 23:37:14 2004
    Starting ORACLE instance (normal)
    Disable cache advisory with old cache parameters
    Sat Apr 24 23:37:14 2004
    Running with 1 strand for Non-Enterprise Edition
    ...
    Sat Apr 24 23:37:15 2004
    ALTER DATABASE MOUNT
    Sat Apr 24 23:37:16 2004
    ORA-00202: controlfile: 'ora_control1'
    ORA-27037: unable to obtain file status
    Linux Error: 2: No such file or directory
    Additional information: 3
    Sat Apr 24 23:37:16 2004
    ORA-205 signalled during: ALTER DATABASE MOUNT...
    Any help, pointers, etc., would be apprecated.

    So why am I doing this? My background is Sybase but I'm not excited
    about their XML support. I've only read about Oracle's and wanted to
    try it out.

    --
    ..tom
    remove email address' dashes for replies
    opensource middleware at <http://isectd.sourcefo rge.net>
    <http://gagne.homedns.o rg/~tgagne/>
    Tags: None
    • Douglas Hawthorne
      #2
      Re: Missing ora_control1 ???

      "Thomas Gagné" <tgagne@wide-open-west.comwrote in message
      news:-uydne8rwuMsqRbd RVn-hA@wideopenwest .com...
      I've never installed Oracle, and have just worked my way through getting
      9i installed on RedHat 9.
      >
      When I try to start it up I get the following:
      >
      [oracle@cod1 oracle]$ sqlplus /nolog
      >
      SQL*Plus: Release 9.2.0.4.0 - Production on Sat Apr 24 23:37:05 2004
      >
      Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
      >
      SQLconnect / as sysdba
      Connected to an idle instance.
      SQLstartup
      ORACLE instance started.
      >
      Total System Global Area 42742804 bytes
      Fixed Size 451604 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
      >
      I'm not exactly sure which file they're talking about, but I did find
      something that looked interesting:
      >
      [oracle@cod1 oracle]$ cat rdbms/log/alert_oracle.lo g
      Sat Apr 24 23:37:14 2004
      Starting ORACLE instance (normal)
      Disable cache advisory with old cache parameters
      Sat Apr 24 23:37:14 2004
      Running with 1 strand for Non-Enterprise Edition
      ...
      Sat Apr 24 23:37:15 2004
      ALTER DATABASE MOUNT
      Sat Apr 24 23:37:16 2004
      ORA-00202: controlfile: 'ora_control1'
      ORA-27037: unable to obtain file status
      Linux Error: 2: No such file or directory
      Additional information: 3
      Sat Apr 24 23:37:16 2004
      ORA-205 signalled during: ALTER DATABASE MOUNT...
      Any help, pointers, etc., would be apprecated.
      >
      So why am I doing this? My background is Sybase but I'm not excited
      about their XML support. I've only read about Oracle's and wanted to
      try it out.
      >
      --
      .tom
      remove email address' dashes for replies
      opensource middleware at <http://isectd.sourcefo rge.net>
      <http://gagne.homedns.o rg/~tgagne/>
      Tom,

      Have you checked out the documentation at
      http://www.dizwell.com/html/9i_-_red_hat_9.html for how to install Oracle 9i
      on RH9 ?

      It would appear that you have not created the database as yet. You may also
      wish to review the instructions in Chapter 2 of the "Oracle 9i Database
      Administrator's Guide" with emphasis on the dbca utility to automate much of
      the process as possible.

      Douglas Hawthorne


        Comment

        • =?ISO-8859-1?Q?Thomas_Gagn=E9?=
          #3
          Re: Missing ora_control1 ???



          Douglas Hawthorne wrote:
          ><snip>
          >
          >Tom,
          >
          >Have you checked out the documentation at
          >http://www.dizwell.com/html/9i_-_red_hat_9.html for how to install Oracle 9i
          >on RH9 ?
          >
          >It would appear that you have not created the database as yet. You may also
          >wish to review the instructions in Chapter 2 of the "Oracle 9i Database
          >Administrator' s Guide" with emphasis on the dbca utility to automate much of
          >the process as possible.
          >
          >
          >
          I thought I had but apparently not well enough. I thought I'd even
          grepped the document. I've installed it four times (I think) already so
          perhaps there's some debris lying around in directories that's
          messing-up subsequent installs. I'll try again tonight.

          --
          ..tom
          remove email address' dashes for replies
          opensource middleware at <http://isectd.sourcefo rge.net>
          <http://gagne.homedns.o rg/~tgagne/>

            Comment

            • Dhana
              #4
              Re: Missing ora_control1 ???

              Hi,

              Oracle could not able to read your control file and failed to mount
              the database.

              Please provide the following information.

              Do you have backup of your files or first time creation ?
              Produciton database or test database ?

              sqlplus /nolog
              connect /as sysdba
              startup nomount pfile=<your pfile location>
              show parameter control

              ls -lrt <Value listed out above under value column>

              Pick up the contents available in value column and check whether the
              file is available or not in OS, If available, please check the file
              permission.

              CASE 1 : If Database was already created and running.
              You have to restore the control file from backup.

              CASE 2: If database created newly then you can recreate the
              controlfile.
              But you have to do it with EXTREME CARE. To recreate the
              control file
              you must know the datafiles and redolog files location and
              size.

              Please post the message, if you need further help on this.

              NOTE : PLEASE DONT DO ANYTHING WITH ASSUMPTION WHICH WILL CAUSE LOSS
              OF DATA.

              Rgds
              Dhana

              <tgagne@wide-open-west.comwrote in message news:<tLednQr7W Puj_RPdRVn-sA@wideopenwest .com>...
              Douglas Hawthorne wrote:
              >
              <snip>

              Tom,

              Have you checked out the documentation at
              http://www.dizwell.com/html/9i_-_red_hat_9.html for how to install Oracle 9i
              on RH9 ?

              It would appear that you have not created the database as yet. You may also
              wish to review the instructions in Chapter 2 of the "Oracle 9i Database
              Administrator's Guide" with emphasis on the dbca utility to automate much of
              the process as possible.

              >
              I thought I had but apparently not well enough. I thought I'd even
              grepped the document. I've installed it four times (I think) already so
              perhaps there's some debris lying around in directories that's
              messing-up subsequent installs. I'll try again tonight.

                Comment

                Previous template Next
                Working...