Solved

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

Posted on 2009-07-03
6
4,639 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
  • 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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to take different types of Oracle backups using RMAN.

708 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now