Solved

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

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

In my business, I use the LTS (Long Term Support) versions of Linux. My workstations do real work, and so I rarely have the patience to deal with silly problems caused by an upgraded kernel that had experimental software on it to begin with from a r…
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

911 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

23 Experts available now in Live!

Get 1:1 Help Now