Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ora-00205
This is a multi-part message in MIME format.
------=_NextPart_000_00E4_01BFECD3.059022D0 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
HI all,
THANKS A LOT.PATH IS A PROBLEM I CORRECCTED IT ON INITORA FILE.
When i connect to database thru sqlplus it says no listener.
then i altered the listner file and started it is giving error.
i attache the listener and file and listener log file.
please give me ur valuble solutions to this problem.
i was able to connect thru svrmgr only.
=20
desc:
sid names orcl,try.i added the sid in to the listener.=20
=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3Dcopy of =
listner.orafile=3D=3D=3D=3D=3D=3D=3D
=20
LISTENER =3D
(ADDRESS_LIST =3D
(ADDRESS=3D (PROTOCOL=3D IPC) (KEY=3D ORCL) )
=20
(ADDRESS=3D (PROTOCOL=3D IPC) (KEY=3D EXTPROC1) ) (ADDRESS=3D (COMMUNITY=3D NMP.world) (PROTOCOL=3D NMP) (SERVER=3D PAUL) (PIPE=3D ORAPIPE) )
=20
(ADDRESS=3D (PROTOCOL=3D TCP) (Host=3D paul) (Port=3D 1521) ) (ADDRESS=3D (PROTOCOL=3D TCP) (Host=3D paul) (Port=3D 1526) ) (ADDRESS=3D (PROTOCOL=3D TCP) (Host=3D 127.0.0.1) (Port=3D 1521) ) (ADDRESS=3D (PROTOCOL=3D SPX) (Service=3D paul_lsnr) )
(GLOBAL_DBNAME =3D paul) (SID_NAME =3D ORCL)
(SID_NAME =3D extproc) (PROGRAM=3Dextproc))
The problem in connecting to the database thru sql plus .It says =
no
listener.i altered listener .even though it is giveing
error.no listener.if trying to start a listner it is giving error.i
attached it to log file.
=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
listner.log file is
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
System parameter file is E:\ORANT\NET80\admin\listener.ora
Log messages written to E:\ORANT\NET80\log\listener.log
=20
Listening on: (ADDRESS=3D(PROTOCOL=3Dipc)(PIPENAME=3D\\.\pipe\ORCLipc))
Listening on: =
(ADDRESS=3D(PROTOCOL=3Dipc)(PIPENAME=3D\\.\pipe\EXTPROC1ipc))
Listening on: =
(ADDRESS=3D(PROTOCOL=3Dnmp)(PIPENAME=3D\\PAUL\pipe\ORAPIPE))
Listening on:
(ADDRESS=3D(PROTOCOL=3Dtcp)(DEV=3D160)(HOST=3D192.168.1.163)(PORT=3D1521)=
)
Listening on:
(ADDRESS=3D(PROTOCOL=3Dtcp)(DEV=3D168)(HOST=3D192.168.1.163)(PORT=3D1526)=
)
Listening on: =
(ADDRESS=3D(PROTOCOL=3Dtcp)(DEV=3D164)(HOST=3D127.0.0.1)(PORT=3D1521))
Listening on:
(ADDRESS=3D(PROTOCOL=3Dspx)(DEV=3D208)(NET=3D00000000)(NODE=3D00105ae7a70=
4)(SOCKET=3D600
2))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
NL-00051: internal error code, arguments: [302], [1], [], [], [], [], []
=20
TNSLSNR80 for 32-bit Windows: Version 8.0.5.0.0 - Production on =
13-JUL-00
11:54:02
=20
(c) Copyright 1997 Oracle Corporation. All rights reserved.
=20
System parameter file is E:\ORANT\NET80\admin\listener.ora
Log messages written to E:\ORANT\NET80\log\listener.log
=20
Listening on: (ADDRESS=3D(PROTOCOL=3Dipc)(PIPENAME=3D\\.\pipe\ORCLipc))
Listening on: =
(ADDRESS=3D(PROTOCOL=3Dipc)(PIPENAME=3D\\.\pipe\EXTPROC1ipc))
Listening on: =
(ADDRESS=3D(PROTOCOL=3Dnmp)(PIPENAME=3D\\PAUL\pipe\ORAPIPE))
Listening on:
(ADDRESS=3D(PROTOCOL=3Dtcp)(DEV=3D160)(HOST=3D192.168.1.163)(PORT=3D1521)=
)
Listening on:
(ADDRESS=3D(PROTOCOL=3Dtcp)(DEV=3D168)(HOST=3D192.168.1.163)(PORT=3D1526)=
)
Listening on: =
(ADDRESS=3D(PROTOCOL=3Dtcp)(DEV=3D164)(HOST=3D127.0.0.1)(PORT=3D1521))
Listening on:
(ADDRESS=3D(PROTOCOL=3Dspx)(DEV=3D208)(NET=3D00000000)(NODE=3D00105ae7a70=
4)(SOCKET=3D600
3))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
NL-00051: internal error code, arguments: [302], [1], [], [], [], [], []
=20
-
-----Original Message-----
From: paul <pjohnpeter_at_qssnet.com>
To: ORACLE-L_at_fatcity.com <ORACLE-L_at_fatcity.com>
Date: Wednesday, July 12, 2000 5:21 PM
Subject: ora-00205
=20
=20
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
=20
=20
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
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.=20
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
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.=20
------=_NextPart_000_00E4_01BFECD3.059022D0 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><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 = HTML//EN">
<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR> </HEAD> <BODY bgColor=3D#ffffff> <DIV> <DIV><FONT color=3D#000000 size=3D2>HI all,<BR>THANKS A LOT.PATH IS A =PROBLEM I=20
=3D<BR> =20
(ADDRESS=3D<BR> =
(PROTOCOL=3D=20
IPC)<BR> (KEY=3D=20
ORCL)<BR> )</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT color=3D#000000 =
ORAPIPE)<BR> )</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 =
size=3D2> =20
(ADDRESS=3D<BR> =
(PROTOCOL=3D=20
TCP)<BR> (Host=3D=20
paul)<BR> (Port=3D =
1521)<BR> =20
)<BR> =20
(ADDRESS=3D<BR> =
(PROTOCOL=3D=20
TCP)<BR> (Host=3D=20
paul)<BR> (Port=3D =
1526)<BR> =20
)<BR> =20
(ADDRESS=3D<BR> =
(PROTOCOL=3D=20
TCP)<BR> (Host=3D=20
127.0.0.1)<BR> =
(Port=3D=20
1521)<BR> =20
)<BR> =20
(ADDRESS=3D<BR> =
(PROTOCOL=3D=20
SPX)<BR> =
(Service=3D=20
paul_lsnr)<BR> )<BR> =20
)<BR>STARTUP_WAIT_TIME_LISTENER =3D 0<BR>CONNECT_TIMEOUT_LISTENER =3D=20
10<BR>TRACE_LEVEL_LISTENER =3D 0<BR>SID_LIST_LISTENER =3D<BR> =
(SID_LIST=20
=3D<BR> (SID_DESC =
=3D<BR> =20
(GLOBAL_DBNAME =3D paul)<BR> (SID_NAME =3D =
ORCL)<BR> )<BR>(SID_DESC =
=3D<BR> =20
(SID_NAME =3D extproc)<BR> =20
(PROGRAM=3Dextproc))<BR> (SID_DESC =3D(SID_NAME =3D=20
TRY)))<BR>PASSWORDS_LISTENER =3D=20
(oracle)<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
listener.if trying to start a listner it is giving error.i<BR>attached = it to log=20
file.</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT color=3D#000000 = size=3D2>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>listner.log file=20is<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT color=3D#000000 size=3D2>-</FONT></DIV></DIV> <BLOCKQUOTE=20
<DIV><FONT face=3DArial size=3D2><B>-----Original = Message-----</B><BR><B>From:=20
</B>paul <<A=20
= href=3D"mailto:pjohnpeter_at_qssnet.com">pjohnpeter_at_qssnet.com</A>><BR><B= >To:=20
</B><A href=3D"mailto:ORACLE-L_at_fatcity.com">ORACLE-L_at_fatcity.com</A> = <<A=20
= href=3D"mailto:ORACLE-L_at_fatcity.com">ORACLE-L_at_fatcity.com</A>><BR><B>D= ate:=20 </B>Wednesday, July 12, 2000 5:21 PM<BR><B>Subject:=20 </B>ora-00205<BR><BR></DIV></FONT>
trying to startup 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> </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>
<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=20E:\ORANT\RDBMS80\trace\tryALRT.LOG<BR>Wed Jul 12 16:36:01 = 2000<BR>ORACLE=20
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=20
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> =20
shared_pool_size =3D =
11534336<BR> =20
=
control_files =
=20
=3D E:\NEWDB\DATEBASE\ctl1try.ora<BR> =20 db_block_buffers =3D =
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> =
=
db_files  =
; =20
=3D 1024<BR> db_file_multiblock_read_count=3D 8<BR> =20
sequence_cache_entries =3D 10<BR> =20 sequence_cache_hash_buckets=3D 10<BR> = remote_login_passwordfile=3D=20
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=20
2<BR> job_queue_interval =
=3D=20
10<BR> job_queue_keep_connections=3D FALSE<BR> =20 parallel_max_servers =3D 5<BR> =20 background_dump_dest =3D = %RDBMS80%\trace<BR> =20
=
user_dump_dest  =
; =3D=20
%RDBMS80%\trace<BR> =20
max_dump_file_size =3D =
10240<BR>PMON=20
started with pid=3D2<BR>DBW0 started with pid=3D3<BR>LGWR started = with=20
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=20
12 16:41:26 2000<BR>alter database mount<BR>Wed Jul 12 = 16:41:26=20
2000<BR>ORA-00202: controlfile:=20
'E:\NEWDB\DATEBASE\ctl1try.ora'<BR>ORA-27041: unable to open=20
file<BR>OSD-04002: unable to open file<BR>O/S-Error: (OS 3) The =
system=20
cannot find the path specified.</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT color=3D#000000 size=3D2>Wed Jul 12 16:41:26 = 2000<BR>ORA-205=20
signalled during: alter database mount...<BR>Wed Jul 12 = 16:42:34=20
2000<BR>Starting ORACLE instance (normal)<BR>Shutting down instance=20 (normal)<BR>License high water mark =3D 3<BR>Wed Jul 12 16:42:41 = 2000<BR>ALTER=20
DATABASE CLOSE NORMAL<BR>ORA-1507 signalled during: ALTER DATABASE =
CLOSE=20
NORMAL...<BR>Starting up ORACLE RDBMS Version: 8.0.5.0.0.<BR>System=20
parameters with non-default values:<BR> =20
=
processes &nbs=
p; =20
=3D 59<BR> =20
shared_pool_size =3D =
11534336<BR> =20
=
control_files =
=20
=3D E:\NEWDB\DATEBASE\ctl1try.ora<BR> =20 db_block_buffers =3D =
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> =
=
db_files  =
; =20
=3D 1024<BR> db_file_multiblock_read_count=3D 8<BR> =20
sequence_cache_entries =3D 10<BR> =20 sequence_cache_hash_buckets=3D 10<BR> = remote_login_passwordfile=3D=20
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=20
2<BR> job_queue_interval =
=3D=20
10<BR> job_queue_keep_connections=3D FALSE<BR> =20 parallel_max_servers =3D 5<BR> =20 background_dump_dest =3D = %RDBMS80%\trace<BR> =20
=
user_dump_dest  =
; =3D=20
%RDBMS80%\trace<BR> =20
max_dump_file_size =3D =
10240<BR>PMON=20
started with pid=3D2<BR>DBW0 started with pid=3D3<BR>LGWR started = with=20
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 = Received on Thu Jul 13 2000 - 14:02:46 CDT
![]() |
![]() |