Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> ora-00205
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
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
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
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
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> I got the error =ora-00205 when=20
<DIV><FONT size=3D2>thanks,</FONT></DIV> <DIV><FONT size=3D2>paul</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT color=3D#000000 size=3D2>the content of alert log file is =:</FONT></DIV>
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> =20
processes &nbs=
p; =20
=3D 59<BR> =
shared_pool_size =20
=3D 11534336<BR> =20
control_files =
=20
=3D E:\NEWDB\DATEBASE\ctl1try.ora<BR> =20
db_block_buffers =3D=20
1000<BR> =20
db_block_size =
=20
=3D 2048<BR> =20
log_buffer &nb=
sp; =20
=3D 8192<BR> log_checkpoint_interval =3D 10000<BR> =20
db_files  =
; =20
=3D 1024<BR> db_file_multiblock_read_count=3D 8<BR> =20
sequence_cache_entries =3D 10<BR> =
sequence_cache_hash_buckets=3D=20
10<BR> remote_login_passwordfile=3D EXCLUSIVE<BR> =20
global_names &=
nbsp; =20
=3D TRUE<BR> distributed_lock_timeout =3D 300<BR> =20
distributed_transactions =3D 5<BR> =20
open_links &nb=
sp; =20
=3D 4<BR> =20
db_name =
=20
=3D TRY<BR> =20
text_enable &n=
bsp; =20
=3D TRUE<BR> job_queue_processes =3D =
2<BR> =20
job_queue_interval =3D 10<BR> =20
job_queue_keep_connections=3D FALSE<BR> =20 parallel_max_servers =3D 5<BR> =20 background_dump_dest =3D =%RDBMS80%\trace<BR> =20
job_queue_keep_connections=3D FALSE<BR> =20 parallel_max_servers =3D 5<BR> =20 background_dump_dest =3D =%RDBMS80%\trace<BR> =20