473,324 Members | 2,178 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

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.

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
3 7439
"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


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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Steven T. Hatton | last post by:
If you happen to have Accelerated C++ by Koenig and Moo, and haven't gotten around to reading it, I suggest you count the pages between page 18 and page 51. I came up with zero. This is very...
7
by: Corepaul | last post by:
Missing Help Files When I enter "recordset" as the keyword and search the Visual Basic Help index, I get many topics of interest in the resulting list. But there isn't any information available...
102
by: Skybuck Flying | last post by:
Sometime ago on the comp.lang.c, I saw a teacher's post asking why C compilers produce so many error messages as soon as a closing bracket is missing. The response was simply because the compiler...
0
by: kris | last post by:
hi can any one help me out, i have written a code for Word Indexing using Dll's i think this is an incomplete code for WORD INDEX. I had encountered this error "Error! No index entries found"...
17
by: Justin Emlay | last post by:
I'm hopping someone can help me out on a payroll project I need to implement. To start we are dealing with payroll periods. So we are dealing with an exact 10 days (Monday - Friday, 2 weeks). ...
0
by: youth | last post by:
I am trying to bind the DB2 utlities to a new database that was created by our DBAs. Each time I try I get the following: db2ajgrt.bnd - No errors db2clish.bnd - 13 errors all for missing...
5
by: le0 | last post by:
Hello guys, Im really having a hard time doing this, I have a record set with the ItemNo field with the data type as Text. In the record that I have, I want to find the missing number in the...
3
by: Fred Chateau | last post by:
Still working on my XML DataSet... Having moved on past difficult and complex problems, resolved with the assistance of everyone here, I find myself facing yet another problem. My XML document...
3
by: =?ISO-8859-1?Q?Thomas_Gagn=E9?= | last post by:
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: $ sqlplus /nolog SQL*Plus: Release...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.