Solved

ORA-01565: error in identifying file '?/dbs/dbs1@.dbf'

Posted on 2009-07-03
6
5,222 Views
Last Modified: 2013-12-19
Hi,

i've installed a oracle 10g XE Database on my Debian lenny system. the installation process runs without any problems, also the configuration runs perfect.

after the login to sqlplus and startup command i get this error:

SQL> startup
ORACLE instance started.

Total System Global Area  134217728 bytes
Fixed Size                  1257404 bytes
Variable Size              96469060 bytes
Database Buffers           33554432 bytes
Redo Buffers                2936832 bytes
ORA-00205: error in identifying control file, check alert log for more info

i've looked into the config for the location of the control file, but there are no config files

SQL> SHOW PARAMETERS control_files

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_files                        string      /usr/lib/oracle/xe/app/oracle/
                                                 product/10.2.0/server/dbs/ora_
                                                 control1, /usr/lib/oracle/xe/a
                                                 pp/oracle/product/10.2.0/serve
                                                 r/dbs/ora_control2

so i tried to create them with this result:

SQL> CREATE CONTROLFILE REUSE SET DATABASE DEFAULT RESETLOGS;
CREATE CONTROLFILE REUSE SET DATABASE DEFAULT RESETLOGS
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '?/dbs/dbs1@.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


i've search the whole internet since days and haven't found any solution. maybe somebody can help me on this.

best
0
Comment
Question by:neugi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
6 Comments
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 500 total points
ID: 24773215
Did you set the Oracle environment?

export ORACLE_HOME=???
export ORACLE_SID=???
export PATH=$PATH:$ORACLE_HOME/bin


0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 24773223
What about the initXE.ora file?

0
 

Author Comment

by:neugi
ID: 24783058
all enviroment variables ar set to the correct paths

initXE.ora is seems also to be correct

best
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 24785313
Do BOTH the controlfiles exist?
 

/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/ora_control1, 
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/ora_control2

Open in new window

0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 24785590
PS: Post the code for "CREATE CONTROLFILE " you are using...
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will explain how to establish a SSH connection to Ubuntu through the firewall and using a different port other then 22. I have set up a Ubuntu virtual machine in Virtualbox and I am running a Windows 7 workstation. From the Ubuntu vi…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Suggested Courses

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question