Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ora-00205

ora-00205

From: paul <pjohnpeter_at_qssnet.com>
Date: Wed, 12 Jul 2000 17:21:55 -0500
Message-Id: <10556.111910@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_0036_01BFEC25.AD426D20 Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi All,
  I got the error ora-00205 when trying to startup a newly created = database,
error mesage is error in identifying control file. check alert log for = more info.
kindly give me ur suggestions to over ome this problem. thanks,
paul

the content of alert log file is :
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

Dump file E:\ORANT\RDBMS80\trace\tryALRT.LOG Wed Jul 12 16:36:01 2000
ORACLE V8.0.5.0.0 - Production vsnsta=3D0 vsnsql=3Dc vsnxtr=3D3
Windows NT V4.0, OS V5.101, CPU type 586 Wed Jul 12 16:36:01 2000
Starting ORACLE instance (normal)
Shutting down instance (normal)
License high water mark =3D 3
Wed Jul 12 16:36:11 2000
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL... Starting up ORACLE RDBMS Version: 8.0.5.0.0. System parameters with non-default values:

  processes                =3D 59
  shared_pool_size         =3D 11534336
  control_files            =3D E:\NEWDB\DATEBASE\ctl1try.ora
  db_block_buffers         =3D 1000
  db_block_size            =3D 2048
  log_buffer               =3D 8192
  log_checkpoint_interval  =3D 10000
  db_files                 =3D 1024

  db_file_multiblock_read_count=3D 8
  sequence_cache_entries =3D 10
  sequence_cache_hash_buckets=3D 10
  remote_login_passwordfile=3D EXCLUSIVE
  global_names             =3D TRUE
  distributed_lock_timeout =3D 300
  distributed_transactions =3D 5
  open_links               =3D 4
  db_name                  =3D TRY
  text_enable              =3D TRUE
  job_queue_processes      =3D 2
  job_queue_interval       =3D 10
  job_queue_keep_connections=3D FALSE
  parallel_max_servers     =3D 5
  background_dump_dest     =3D %RDBMS80%\trace
  user_dump_dest           =3D %RDBMS80%\trace
  max_dump_file_size       =3D 10240
PMON started with pid=3D2
DBW0 started with pid=3D3
LGWR started with pid=3D4
CKPT started with pid=3D5
SMON started with pid=3D6
RECO started with pid=3D7

SNP0 started with pid=3D8
SNP1 started with pid=3D9
Wed Jul 12 16:41:26 2000
alter database mount
Wed Jul 12 16:41:26 2000
ORA-00202: controlfile: 'E:\NEWDB\DATEBASE\ctl1try.ora'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

Wed Jul 12 16:41:26 2000
ORA-205 signalled during: alter database mount... Wed Jul 12 16:42:34 2000
Starting ORACLE instance (normal)
Shutting down instance (normal)
License high water mark =3D 3
Wed Jul 12 16:42:41 2000
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL... Starting up ORACLE RDBMS Version: 8.0.5.0.0. System parameters with non-default values:

  processes                =3D 59
  shared_pool_size         =3D 11534336
  control_files            =3D E:\NEWDB\DATEBASE\ctl1try.ora
  db_block_buffers         =3D 1000
  db_block_size            =3D 2048
  log_buffer               =3D 8192
  log_checkpoint_interval  =3D 10000
  db_files                 =3D 1024

  db_file_multiblock_read_count=3D 8
  sequence_cache_entries =3D 10
  sequence_cache_hash_buckets=3D 10
  remote_login_passwordfile=3D EXCLUSIVE
  global_names             =3D TRUE
  distributed_lock_timeout =3D 300
  distributed_transactions =3D 5
  open_links               =3D 4
  db_name                  =3D TRY
  text_enable              =3D TRUE
  job_queue_processes      =3D 2
  job_queue_interval       =3D 10
  job_queue_keep_connections=3D FALSE
  parallel_max_servers     =3D 5
  background_dump_dest     =3D %RDBMS80%\trace
  user_dump_dest           =3D %RDBMS80%\trace
  max_dump_file_size       =3D 10240
PMON started with pid=3D2
DBW0 started with pid=3D3
LGWR started with pid=3D4
CKPT started with pid=3D5
SMON started with pid=3D6
RECO started with pid=3D7

SNP0 started with pid=3D8
SNP1 started with pid=3D9
Wed Jul 12 16:42:49 2000
alter database mount
Wed Jul 12 16:42:49 2000
ORA-00202: controlfile: 'E:\NEWDB\DATEBASE\ctl1try.ora'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

Wed Jul 12 16:42:49 2000
ORA-205 signalled during: alter database mount...

------=_NextPart_000_0036_01BFEC25.AD426D20 Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>

<META content=3Dtext/html;charset=3Diso-8859-1 = http-equiv=3DContent-Type>

<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 size=3D2>Hi All,</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>&nbsp; I got the error&nbsp; =
ora-00205 when=20
trying to startup&nbsp; a newly created database,</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>error mesage is error in identifying = control=20
file. check alert log for more info.</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT><FONT size=3D2>kindly give me = ur=20
suggestions to over ome this problem.</FONT></DIV>
<DIV><FONT size=3D2>thanks,</FONT></DIV>
<DIV><FONT size=3D2>paul</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000000 size=3D2>the content of alert log file is =
:</FONT></DIV>
<DIV><FONT color=3D#000000 =
size=3D2>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>Dump file=20 E:\ORANT\RDBMS80\trace\tryALRT.LOG<BR>Wed Jul 12 16:36:01 2000<BR>ORACLE =

V8.0.5.0.0 - Production vsnsta=3D0<BR>vsnsql=3Dc vsnxtr=3D3<BR>Windows = NT V4.0, OS=20
V5.101, CPU type 586<BR>Wed Jul 12 16:36:01 2000<BR>Starting ORACLE = instance=20
(normal)<BR>Shutting down instance (normal)<BR>License high water mark =
=3D=20

3<BR>Wed Jul 12 16:36:11 2000<BR>ALTER DATABASE CLOSE NORMAL<BR>ORA-1507 =

signalled during: ALTER DATABASE CLOSE NORMAL...<BR>Starting up ORACLE = RDBMS=20
Version: 8.0.5.0.0.<BR>System parameters with non-default = values:<BR>&nbsp;=20
processes&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;&nbsp;&nbsp;=20
=3D 59<BR>&nbsp; =

shared_pool_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
=3D 11534336<BR>&nbsp;=20

control_files&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= &nbsp;=20
=3D E:\NEWDB\DATEBASE\ctl1try.ora<BR>&nbsp;=20
db_block_buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =3D=20 1000<BR>&nbsp;=20
db_block_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= &nbsp;=20
=3D 2048<BR>&nbsp;=20

log_buffer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp;=20
=3D 8192<BR>&nbsp; log_checkpoint_interval&nbsp; =3D 10000<BR>&nbsp;=20
db_files&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp= ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
=3D 1024<BR>&nbsp; db_file_multiblock_read_count=3D 8<BR>&nbsp;=20
sequence_cache_entries&nbsp;&nbsp; =3D 10<BR>&nbsp; = sequence_cache_hash_buckets=3D=20
10<BR>&nbsp; remote_login_passwordfile=3D EXCLUSIVE<BR>&nbsp;=20 global_names&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&= nbsp;&nbsp;=20
=3D TRUE<BR>&nbsp; distributed_lock_timeout =3D 300<BR>&nbsp;=20
distributed_transactions =3D 5<BR>&nbsp;=20 open_links&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp;=20
=3D 4<BR>&nbsp;=20

db_name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
=3D TRY<BR>&nbsp;=20

text_enable&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n= bsp;&nbsp;&nbsp;=20
=3D TRUE<BR>&nbsp; job_queue_processes&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =3D =
2<BR>&nbsp;=20
job_queue_interval&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =3D 10<BR>&nbsp;=20

job_queue_keep_connections=3D FALSE<BR>&nbsp;=20
parallel_max_servers&nbsp;&nbsp;&nbsp;&nbsp; =3D 5<BR>&nbsp;=20
background_dump_dest&nbsp;&nbsp;&nbsp;&nbsp; =3D =
%RDBMS80%\trace<BR>&nbsp;=20
user_dump_dest&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp= ; =3D=20
%RDBMS80%\trace<BR>&nbsp; =
max_dump_file_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
=3D 10240<BR>PMON started with pid=3D2<BR>DBW0 started with =
pid=3D3<BR>LGWR started=20
with pid=3D4<BR>CKPT started with pid=3D5<BR>SMON started with = pid=3D6<BR>RECO started=20
with pid=3D7<BR>SNP0 started with pid=3D8<BR>SNP1 started with = pid=3D9<BR>Wed Jul 12=20
16:41:26 2000<BR>alter database&nbsp; mount<BR>Wed Jul 12 16:41:26=20 2000<BR>ORA-00202: controlfile: =
'E:\NEWDB\DATEBASE\ctl1try.ora'<BR>ORA-27041:=20 unable to open file<BR>OSD-04002: unable to open file<BR>O/S-Error: (OS = 3) The=20
system cannot find the path specified.</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV> <DIV><FONT color=3D#000000 size=3D2>Wed Jul 12 16:41:26 2000<BR>ORA-205 = signalled=20
during: alter database&nbsp; mount...<BR>Wed Jul 12 16:42:34 = 2000<BR>Starting=20
ORACLE instance (normal)<BR>Shutting down instance (normal)<BR>License = high=20
water mark =3D 3<BR>Wed Jul 12 16:42:41 2000<BR>ALTER DATABASE CLOSE=20 NORMAL<BR>ORA-1507 signalled during: ALTER DATABASE CLOSE = NORMAL...<BR>Starting=20
up ORACLE RDBMS Version: 8.0.5.0.0.<BR>System parameters with = non-default=20
values:<BR>&nbsp;=20
processes&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;&nbsp;&nbsp;=20
=3D 59<BR>&nbsp; =

shared_pool_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
=3D 11534336<BR>&nbsp;=20

control_files&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= &nbsp;=20
=3D E:\NEWDB\DATEBASE\ctl1try.ora<BR>&nbsp;=20
db_block_buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =3D=20 1000<BR>&nbsp;=20
db_block_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= &nbsp;=20
=3D 2048<BR>&nbsp;=20

log_buffer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp;=20
=3D 8192<BR>&nbsp; log_checkpoint_interval&nbsp; =3D 10000<BR>&nbsp;=20
db_files&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp= ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
=3D 1024<BR>&nbsp; db_file_multiblock_read_count=3D 8<BR>&nbsp;=20
sequence_cache_entries&nbsp;&nbsp; =3D 10<BR>&nbsp; = sequence_cache_hash_buckets=3D=20
10<BR>&nbsp; remote_login_passwordfile=3D EXCLUSIVE<BR>&nbsp;=20 global_names&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&= nbsp;&nbsp;=20
=3D TRUE<BR>&nbsp; distributed_lock_timeout =3D 300<BR>&nbsp;=20
distributed_transactions =3D 5<BR>&nbsp;=20 open_links&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp;=20
=3D 4<BR>&nbsp;=20

db_name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
=3D TRY<BR>&nbsp;=20

text_enable&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n= bsp;&nbsp;&nbsp;=20
=3D TRUE<BR>&nbsp; job_queue_processes&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =3D =
2<BR>&nbsp;=20
job_queue_interval&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =3D 10<BR>&nbsp;=20
job_queue_keep_connections=3D FALSE<BR>&nbsp;=20
parallel_max_servers&nbsp;&nbsp;&nbsp;&nbsp; =3D 5<BR>&nbsp;=20
background_dump_dest&nbsp;&nbsp;&nbsp;&nbsp; =3D =
%RDBMS80%\trace<BR>&nbsp;=20
user_dump_dest&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp= ; =3D=20
%RDBMS80%\trace<BR>&nbsp; =
max_dump_file_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
=3D 10240<BR>PMON started with pid=3D2<BR>DBW0 started with =
pid=3D3<BR>LGWR started=20
with pid=3D4<BR>CKPT started with pid=3D5<BR>SMON started with = pid=3D6<BR>RECO started=20
with pid=3D7<BR>SNP0 started with pid=3D8<BR>SNP1 started with = pid=3D9<BR>Wed Jul 12=20
16:42:49 2000<BR>alter database&nbsp; mount<BR>Wed Jul 12 16:42:49=20 2000<BR>ORA-00202: controlfile: =
'E:\NEWDB\DATEBASE\ctl1try.ora'<BR>ORA-27041:=20 unable to open file<BR>OSD-04002: unable to open file<BR>O/S-Error: (OS = 3) The=20
system cannot find the path specified.</FONT></DIV> Received on Wed Jul 12 2000 - 17:21:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US