[SunHELP] On TNS and listener errors ???
MUHAMED, Mohd. Khairul
sunhelp at sunhelp.org
Wed Jul 25 04:04:52 CDT 2001
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C114E8.DD932220
Content-Type: text/plain;
charset="iso-8859-1"
Hi all,
Anybody has any idea why I keep getting this errors when I try to start my
oracle SQLNet or RMAN. Somebody at oracle suggested that this is a resource
issue on system level.
Thanks in advance
==from the vmstat and ulimit command===
oracle at pstksr01> vmstat 2
procs memory page disk faults cpu
r b w swap free re mf pi po fr de sr f0 s1 s1 s1 in sy cs us sy
id
0 0 0 8240 18920 0 89 51 48 55 0 1 0 2 1 0 492 1413 624 1 1
98
0 0 0 1811080 21920 0 1 0 0 0 0 0 0 0 1 0 243 1270 594 0 0
100
0 0 0 1811080 21920 0 0 0 0 0 0 0 0 0 1 0 1174 1205 570 0 2
98
0 0 0 1811080 21920 0 0 0 0 0 0 0 0 0 0 0 540 1206 572 0 0
100
0 0 0 1811080 21920 0 0 0 0 0 0 0 0 0 1 0 270 1259 590 0 0
100
0 0 0 1811080 21920 0 0 0 4 4 0 0 0 1 1 0 291 1287 624 0 1
99
0 0 0 1811080 21920 0 0 0 0 0 0 0 0 0 0 0 279 1442 765 0 0
100
oracle at pstksr01> ulimit
unlimited
oracle at pstksr01>
==from the listener.log===
25-JUL-2001 15:51:27 * service_died * 0
25-JUL-2001 15:52:29 * service_died * 0
25-JUL-2001 15:53:30 * service_died * 0
25-JUL-2001 15:54:32 * service_died * 0
25-JUL-2001 15:55:34 * service_died * 0
25-JUL-2001 15:55:34 *
(CONNECT_DATA=(SERVICE_NAME=DP51)(CID=(PROGRAM=)(HOST=pstksr01)(USER=oracl
e))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.27.105.12)(PORT=46322)) * establish
* DP51 * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
Solaris Error: 12: Not enough space
25-JUL-2001 15:56:35 * service_died * 0
25-JUL-2001 15:57:37 * service_died * 0
25-JUL-2001 15:58:39 * service_died * 0
25-JUL-2001 15:59:40 * service_died * 0
25-JUL-2001 16:00:42 * service_died * 0
25-JUL-2001 16:01:43 * service_died * 0
25-JUL-2001 16:02:10 *
(CONNECT_DATA=(SERVICE_NAME=DP51)(CID=(PROGRAM=)(HOST=pstksr01)(USER=oracl
e))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.27.105.12)(PORT=46353)) * establish
* DP51 * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
Solaris Error: 12: Not enough space
25-JUL-2001 16:02:45 * service_died * 0
25-JUL-2001 16:03:47 * service_died * 0
25-JUL-2001 16:04:48 * service_died * 0
25-JUL-2001 16:05:50 * service_died * 0
==from the sqlnet.log===
Fatal NI connect error 12500, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.27.105.12)(PORT=1521))(CONNECT
_DATA=(SERVICE_NAME=
DP51)(CID=(PROGRAM=)(HOST=pstksr01)(USER=oracle))))
VERSION INFORMATION:
TNS for Solaris: Version 8.1.6.0.0 - Production
TCP/IP NT Protocol Adapter for Solaris: Version 8.1.6.0.0 -
Production
Time: 25-JUL-2001 16:02:10
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
==from the backup log===
Recovery Manager: Release 8.1.6.1.0 - Production
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database: ORA-12500: TNS:listener failed to
start a dedicated server process
Regards,
Mohd Khairul Muhamed
IT Services Division
MEASAT Broadcast Network Systems
> Tel : 03 9543 6688 x 8035
> Fax : 03 9543 6874
> Visit us at http://www.astro.com.my
>
>
>
>
------_=_NextPart_001_01C114E8.DD932220
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>On TNS and listener errors ???</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2 FACE=3D"Arial">Hi all,</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Anybody has any idea why I keep =
getting this errors when I try to start my oracle SQLNet or RMAN. =
Somebody at oracle suggested that this is a resource issue on system =
level. </FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks in advance</FONT>
</P>
<BR>
<BR>
<P><FONT COLOR=3D"#FF0000" SIZE=3D2 FACE=3D"Arial">=3D=3Dfrom the =
vmstat and ulimit command=3D=3D=3D</FONT>
</P>
<P><FONT SIZE=3D1 FACE=3D"Courier New">oracle at pstksr01> vmstat =
2</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Courier =
New"> procs =
memory =
page =
disk =
faults cpu</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Courier New"> r b w =
swap free re mf pi po fr de sr f0 s1 s1 =
s1 in sy cs us sy id</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Courier New"> 0 0 0 8240 =
18920 0 89 51 48 55 0 1 0 =
2 1 0 492 1413 624 1 1 98</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Courier New"> 0 0 0 1811080 21920 =
0 1 0 0 0 0 0 0 =
0 1 0 243 1270 594 0 0 100</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Courier New"> 0 0 0 1811080 21920 =
0 0 0 0 0 0 0 0 =
0 1 0 1174 1205 570 0 2 98</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Courier New"> 0 0 0 1811080 21920 =
0 0 0 0 0 0 0 0 =
0 0 0 540 1206 572 0 0 100</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Courier New"> 0 0 0 1811080 21920 =
0 0 0 0 0 0 0 0 =
0 1 0 270 1259 590 0 0 100</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Courier New"> 0 0 0 1811080 21920 =
0 0 0 4 4 0 0 0 =
1 1 0 291 1287 624 0 1 99</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Courier New"> 0 0 0 1811080 21920 =
0 0 0 0 0 0 0 0 =
0 0 0 279 1442 765 0 0 100</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Courier New">oracle at pstksr01> =
ulimit</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Courier New">unlimited</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Courier New">oracle at pstksr01></FONT>
</P>
<BR>
<P><FONT COLOR=3D"#FF0000" SIZE=3D2 FACE=3D"Arial">=3D=3Dfrom the =
listener.log=3D=3D=3D</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Courier New">25-JUL-2001 15:51:27 * =
service_died * 0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">25-JUL-2001 15:52:29 * =
service_died * 0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">25-JUL-2001 15:53:30 * =
service_died * 0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">25-JUL-2001 15:54:32 * =
service_died * 0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">25-JUL-2001 15:55:34 * =
service_died * 0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">25-JUL-2001 15:55:34 * =
(CONNECT_DATA=3D(SERVICE_NAME=3DDP51)(CID=3D(PROGRAM=3D)(HOST=3Dpstksr01=
)(USER=3Doracl</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">e))) * =
(ADDRESS=3D(PROTOCOL=3Dtcp)(HOST=3D172.27.105.12)(PORT=3D46322)) * =
establish * DP51 * 12500</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">TNS-12500: TNS:listener failed =
to start a dedicated server process</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New"> TNS-12540: TNS:internal =
limit restriction exceeded</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New"> TNS-12560: TNS:protocol =
adapter error</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New"> TNS-00510: =
Internal limit restriction exceeded</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New"> Solaris =
Error: 12: Not enough space</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">25-JUL-2001 15:56:35 * =
service_died * 0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">25-JUL-2001 15:57:37 * =
service_died * 0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">25-JUL-2001 15:58:39 * =
service_died * 0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">25-JUL-2001 15:59:40 * =
service_died * 0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">25-JUL-2001 16:00:42 * =
service_died * 0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">25-JUL-2001 16:01:43 * =
service_died * 0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">25-JUL-2001 16:02:10 * =
(CONNECT_DATA=3D(SERVICE_NAME=3DDP51)(CID=3D(PROGRAM=3D)(HOST=3Dpstksr01=
)(USER=3Doracl</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">e))) * =
(ADDRESS=3D(PROTOCOL=3Dtcp)(HOST=3D172.27.105.12)(PORT=3D46353)) * =
establish * DP51 * 12500</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">TNS-12500: TNS:listener failed =
to start a dedicated server process</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New"> TNS-12540: TNS:internal =
limit restriction exceeded</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New"> TNS-12560: TNS:protocol =
adapter error</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New"> TNS-00510: =
Internal limit restriction exceeded</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New"> Solaris =
Error: 12: Not enough space</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">25-JUL-2001 16:02:45 * =
service_died * 0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">25-JUL-2001 16:03:47 * =
service_died * 0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">25-JUL-2001 16:04:48 * =
service_died * 0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">25-JUL-2001 16:05:50 * =
service_died * 0</FONT>
</P>
<BR>
<BR>
<P><FONT COLOR=3D"#FF0000" SIZE=3D2 FACE=3D"Arial">=3D=3Dfrom the =
sqlnet.log=3D=3D=3D</FONT>
</P>
<P><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier New">Fatal NI =
connect error 12500, connecting to:</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier =
New"> (DESCRIPTION=3D(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3D172.27.105.=
12)(PORT=3D1521))(CONNECT_DATA=3D(SERVICE_NAME=3D</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier =
New">DP51)(CID=3D(PROGRAM=3D)(HOST=3Dpstksr01)(USER=3Doracle))))</FONT>
</P>
<P><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier New"> VERSION =
INFORMATION:</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier =
New"> TNS for Solaris: =
Version 8.1.6.0.0 - Production</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier =
New"> TCP/IP NT Protocol =
Adapter for Solaris: Version 8.1.6.0.0 - Production</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier New"> Time: =
25-JUL-2001 16:02:10</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier New"> =
Tracing not turned on.</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier New"> Tns =
error struct:</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier =
New"> nr err code: 0</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier =
New"> ns main err code: 12564</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier =
New"> TNS-12564: TNS:connection refused</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier =
New"> ns secondary err code: 0</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier =
New"> nt main err code: 0</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier =
New"> nt secondary err code: 0</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier =
New"> nt OS err code: 0</FONT>
</P>
<BR>
<P><FONT COLOR=3D"#FF0000" SIZE=3D2 FACE=3D"Arial">=3D=3Dfrom the =
backup log=3D=3D=3D</FONT>
</P>
<P><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier New">Recovery =
Manager: Release 8.1.6.1.0 - Production</FONT>
</P>
<P><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier New">RMAN-00571: =
=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=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier New">RMAN-00569: =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ERROR MESSAGE STACK =
FOLLOWS =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier New">RMAN-00571: =
=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=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier New">RMAN-00554: =
initialization of internal recovery manager package failed</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Courier New">RMAN-04005: =
error from target database: ORA-12500: TNS:listener failed to start a =
dedicated server process</FONT>
</P>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<P><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Tahoma">Regards,</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Tahoma"> =
Mohd Khairul Muhamed</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D2 =
FACE=3D"Tahoma"> I</FONT><FONT =
COLOR=3D"#000000" SIZE=3D1 FACE=3D"Tahoma">T Services Division</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D1 =
FACE=3D"Tahoma"> MEASAT Broadcast Network =
Systems</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D1 =
FACE=3D"Tahoma"> Tel : 03 9543 6688 x =
8035</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D1 =
FACE=3D"Tahoma"> Fax : 03 9543 6874</FONT>
<BR><FONT COLOR=3D"#000000" SIZE=3D1 =
FACE=3D"Tahoma"> Visit us at</FONT><U> <FONT =
COLOR=3D"#0000FF" SIZE=3D1 FACE=3D"Tahoma"><A =
HREF=3D"http://www.astro.com.my" =
TARGET=3D"_blank">http://www.astro.com.my</A></FONT></U>
</P>
<BR>
<BR>
<BR>
</BODY>
</HTML>
------_=_NextPart_001_01C114E8.DD932220--
More information about the SunHELP
mailing list