neugi
asked on
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/ora cle/
product/10.2.0/server/dbs/ ora_
control1, /usr/lib/oracle/xe/a
pp/oracle/product/10.2.0/s erve
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
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/ora
product/10.2.0/server/dbs/
control1, /usr/lib/oracle/xe/a
pp/oracle/product/10.2.0/s
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What about the initXE.ora file?
ASKER
all enviroment variables ar set to the correct paths
initXE.ora is seems also to be correct
best
initXE.ora is seems also to be correct
best
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
PS: Post the code for "CREATE CONTROLFILE " you are using...