Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5613
  • Last Modified:

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

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
neugi
Asked:
neugi
  • 4
1 Solution
 
MikeOM_DBACommented:
Did you set the Oracle environment?

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


0
 
MikeOM_DBACommented:
What about the initXE.ora file?

0
 
neugiAuthor Commented:
all enviroment variables ar set to the correct paths

initXE.ora is seems also to be correct

best
0
 
MikeOM_DBACommented:
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
 
MikeOM_DBACommented:
PS: Post the code for "CREATE CONTROLFILE " you are using...
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now