| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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_0069_01BFECC4.495EADB0 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.
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
LISTENER =3D
(ADDRESS_LIST =3D
(ADDRESS=3D
(PROTOCOL=3D IPC)
(KEY=3D ORCL)
)
(ADDRESS=3D
(PROTOCOL=3D IPC)
(KEY=3D EXTPROC1)
)
(ADDRESS=3D
(COMMUNITY=3D NMP.world)
(PROTOCOL=3D NMP)
(SERVER=3D PAUL)
(PIPE=3D ORAPIPE)
)
(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.
=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
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], [], [], [], [], []
TNSLSNR80 for 32-bit Windows: Version 8.0.5.0.0 - Production on =
13-JUL-00
11:54:02
(c) Copyright 1997 Oracle Corporation. All rights reserved.
System parameter file is E:\ORANT\NET80\admin\listener.ora Log messages written to E:\ORANT\NET80\log\listener.log
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], [], [], [], [], []
-
------=_NextPart_000_0069_01BFECC4.495EADB0 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,<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= =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> =20
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= =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> </DIV> <DIV><FONT color=3D#000000 size=3D2>Listening on:=20 (ADDRESS=3D(PROTOCOL=3Dipc)(PIPENAME=3D\\.\pipe\ORCLipc))<BR>Listening = on:=20
 |
 |