Solved

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

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Retreiving column names in Windows but not in Unix 11 47
use lov values 2 50
migration MS SQL database to Oracle 30 61
SQL Workhours Count beetween Workhours 3 17
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
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 video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

777 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