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

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

Re: ora-00205

From: paul <pjohnpeter_at_qssnet.com>
Date: Thu, 13 Jul 2000 14:02:46 -0500
Message-Id: <10557.111994@fatcity.com>


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) )

  )
STARTUP_WAIT_TIME_LISTENER =3D 0
CONNECT_TIMEOUT_LISTENER =3D 10
TRACE_LEVEL_LISTENER =3D 0
SID_LIST_LISTENER =3D
  (SID_LIST =3D
    (SID_DESC =3D
      (GLOBAL_DBNAME =3D paul)
      (SID_NAME =3D ORCL)

    )
(SID_DESC =3D
      (SID_NAME =3D extproc)
      (PROGRAM=3Dextproc))

    (SID_DESC =3D(SID_NAME =3D TRY)))
PASSWORDS_LISTENER =3D (oracle)
=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=3D=3D=3D=3D=3D=3D=3D=3D=3D
problem:

     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

    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.
    =20
    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.
    =20
    Wed Jul 12 16:42:49 2000
    ORA-205 signalled during: alter database mount...

------=_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
CORRECCTED IT ON INITORA FILE.<BR>When i&nbsp; connect&nbsp; to database = thru=20
sqlplus it says no listener.<BR>then i altered the listner file and = started it=20
is giving error.<BR>i attache the listener and file and listener log=20 file.<BR>please give me ur valuble solutions to this problem.<BR>i was = able to=20
connect thru svrmgr only.</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV> <DIV><FONT color=3D#000000 size=3D2><BR>desc:<BR>sid names orcl,try.i = added the sid=20
in to the listener.=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;=20
<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3Dcopy of = listner.orafile=3D=3D=3D=3D=3D=3D=3D</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV> <DIV><FONT color=3D#000000 size=3D2>LISTENER =3D<BR>&nbsp; (ADDRESS_LIST =

=3D<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
(ADDRESS=3D<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = (PROTOCOL=3D=20
IPC)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (KEY=3D=20

ORCL)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000000 =

size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 (ADDRESS=3D<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = (PROTOCOL=3D=20
IPC)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (KEY=3D=20 EXTPROC1)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 )<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 (ADDRESS=3D<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = (COMMUNITY=3D=20
NMP.world)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = (PROTOCOL=3D=20
NMP)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = (SERVER=3D=20
PAUL)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (PIPE=3D =

ORAPIPE)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV> <DIV><FONT color=3D#000000 =
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 (ADDRESS=3D<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = (PROTOCOL=3D=20
TCP)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Host=3D=20 paul)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Port=3D =

1521)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 )<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 (ADDRESS=3D<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = (PROTOCOL=3D=20
TCP)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Host=3D=20 paul)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Port=3D =

1526)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 )<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 (ADDRESS=3D<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = (PROTOCOL=3D=20
TCP)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Host=3D=20 127.0.0.1)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = (Port=3D=20
1521)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 )<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 (ADDRESS=3D<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = (PROTOCOL=3D=20
SPX)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = (Service=3D=20
paul_lsnr)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )<BR>&nbsp;=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>&nbsp; = (SID_LIST=20
=3D<BR>&nbsp;&nbsp;&nbsp; (SID_DESC =
=3D<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
(GLOBAL_DBNAME =3D paul)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SID_NAME =3D =

ORCL)<BR>&nbsp;&nbsp;&nbsp; )<BR>(SID_DESC =
=3D<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
(SID_NAME =3D extproc)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 (PROGRAM=3Dextproc))<BR>&nbsp;&nbsp;&nbsp; (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=

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>=
problem:<BR>&nbsp;&nbsp;&nbsp;&nbsp;=20
The problem in connecting to the database&nbsp; thru sql plus&nbsp; .It = says=20
no<BR>listener.i altered listener .even though it is giveing<BR>error.no =

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>&nbsp;</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=20
is<BR>=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<BR>System parameter file is=20
E:\ORANT\NET80\admin\listener.ora<BR>Log messages written to=20 E:\ORANT\NET80\log\listener.log</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV> <DIV><FONT color=3D#000000 size=3D2>Listening on:=20 (ADDRESS=3D(PROTOCOL=3Dipc)(PIPENAME=3D\\.\pipe\ORCLipc))<BR>Listening = on:=20
(ADDRESS=3D(PROTOCOL=3Dipc)(PIPENAME=3D\\.\pipe\EXTPROC1ipc))<BR>Listenin= g on:=20
(ADDRESS=3D(PROTOCOL=3Dnmp)(PIPENAME=3D\\PAUL\pipe\ORAPIPE))<BR>Listening=
=20

on:<BR>(ADDRESS=3D(PROTOCOL=3Dtcp)(DEV=3D160)(HOST=3D192.168.1.163)(PORT=3D= 1521))<BR>Listening=20
on:<BR>(ADDRESS=3D(PROTOCOL=3Dtcp)(DEV=3D168)(HOST=3D192.168.1.163)(PORT=3D= 1526))<BR>Listening=20
on: =
(ADDRESS=3D(PROTOCOL=3Dtcp)(DEV=3D164)(HOST=3D127.0.0.1)(PORT=3D1521))<BR= >Listening=20
on:<BR>(ADDRESS=3D(PROTOCOL=3Dspx)(DEV=3D208)(NET=3D00000000)(NODE=3D0010= 5ae7a704)(SOCKET=3D600<BR>2))<BR>TIMESTAMP=20 * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN = CODE<BR>NL-00051:=20
internal error code, arguments: [302], [1], [], [], [], [], = []</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV> <DIV><FONT color=3D#000000 size=3D2>TNSLSNR80 for 32-bit Windows: = Version 8.0.5.0.0=20
- Production on 13-JUL-00<BR>11:54:02</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV> <DIV><FONT color=3D#000000 size=3D2>(c) Copyright 1997 Oracle = Corporation.&nbsp; All=20
rights reserved.</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV> <DIV><FONT color=3D#000000 size=3D2>System parameter file is=20 E:\ORANT\NET80\admin\listener.ora<BR>Log messages written to=20 E:\ORANT\NET80\log\listener.log</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV> <DIV><FONT color=3D#000000 size=3D2>Listening on:=20 (ADDRESS=3D(PROTOCOL=3Dipc)(PIPENAME=3D\\.\pipe\ORCLipc))<BR>Listening = on:=20
(ADDRESS=3D(PROTOCOL=3Dipc)(PIPENAME=3D\\.\pipe\EXTPROC1ipc))<BR>Listenin= g on:=20
(ADDRESS=3D(PROTOCOL=3Dnmp)(PIPENAME=3D\\PAUL\pipe\ORAPIPE))<BR>Listening=
=20

on:<BR>(ADDRESS=3D(PROTOCOL=3Dtcp)(DEV=3D160)(HOST=3D192.168.1.163)(PORT=3D= 1521))<BR>Listening=20
on:<BR>(ADDRESS=3D(PROTOCOL=3Dtcp)(DEV=3D168)(HOST=3D192.168.1.163)(PORT=3D= 1526))<BR>Listening=20
on: =
(ADDRESS=3D(PROTOCOL=3Dtcp)(DEV=3D164)(HOST=3D127.0.0.1)(PORT=3D1521))<BR= >Listening=20
on:<BR>(ADDRESS=3D(PROTOCOL=3Dspx)(DEV=3D208)(NET=3D00000000)(NODE=3D0010= 5ae7a704)(SOCKET=3D600<BR>3))<BR>TIMESTAMP=20 * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN = CODE<BR>NL-00051:=20
internal error code, arguments: [302], [1], [], [], [], [], = []</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000000 size=3D2>-</FONT></DIV></DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: = 5px">

    <DIV><FONT face=3DArial size=3D2><B>-----Original = Message-----</B><BR><B>From:=20

    </B>paul &lt;<A=20

    =
href=3D"mailto:pjohnpeter_at_qssnet.com">pjohnpeter_at_qssnet.com</A>&gt;<BR><B=
>To:=20

    </B><A href=3D"mailto:ORACLE-L_at_fatcity.com">ORACLE-L_at_fatcity.com</A> = &lt;<A=20

    =
href=3D"mailto:ORACLE-L_at_fatcity.com">ORACLE-L_at_fatcity.com</A>&gt;<BR><B>D=
ate:=20
    </B>Wednesday, July 12, 2000 5:21 PM<BR><B>Subject:=20
    </B>ora-00205<BR><BR></DIV></FONT>

    <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=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>&nbsp;=20

    =
processes&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;&nbsp;&nbsp;=20

    =3D 59<BR>&nbsp;=20
    shared_pool_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =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 =

    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; =

    =
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;=20
    sequence_cache_hash_buckets=3D 10<BR>&nbsp; =
remote_login_passwordfile=3D=20

    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=20

    2<BR>&nbsp; job_queue_interval&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
=3D=20

    10<BR>&nbsp; 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;=20
    max_dump_file_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =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&nbsp; 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>&nbsp;</DIV>
    <DIV><FONT color=3D#000000 size=3D2>Wed Jul 12 16:41:26 =
2000<BR>ORA-205=20

    signalled during: alter database&nbsp; 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>&nbsp;=20     =
processes&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;&nbsp;&nbsp;=20

    =3D 59<BR>&nbsp;=20
    shared_pool_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =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 =

    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; =

    =
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;=20
    sequence_cache_hash_buckets=3D 10<BR>&nbsp; =
remote_login_passwordfile=3D=20

    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=20

    2<BR>&nbsp; job_queue_interval&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
=3D=20

    10<BR>&nbsp; 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;=20
    max_dump_file_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =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

Original text of this message

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