By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,501 Members | 1,859 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,501 IT Pros & Developers. It's quick & easy.

Missing ora_control1 ???

P: n/a
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.

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
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.log
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.sourceforge.net>
<http://gagne.homedns.org/~tgagne/>
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Thomas Gagné" <tg****@wide-open-west.com> wrote in message
news:-u********************@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.

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
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.log
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.sourceforge.net>
<http://gagne.homedns.org/~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
Jul 19 '05 #2

P: n/a


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.sourceforge.net>
<http://gagne.homedns.org/~tgagne/>
Jul 19 '05 #3

P: n/a
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

<tg****@wide-open-west.com> wrote in message news:<tL********************@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.

Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.