[SunHELP] On TNS and listener errors ???

Wed Jul 25 05:42:08 CDT 2001

 man -s2 intro

[...]
12  ENOMEM   Not enough space
            During execution of an exec, brk, or sbrk routine,  a
            program  asks  for more space than the system is able
            to supply.  This is not a  temporary  condition;  the
            maximum  size  is a system parameter.  On some archi-
            tectures, the error may also occur if the arrangement
            of  text,  data, and stack segments requires too many
            segmentation registers, or if  there  is  not  enough
            swap  space  during  the fork routine.  If this error
            occurs on a  resource  associated  with  Remote  File
            Sharing  (RFS), it indicates a memory depletion which
            may be temporary, dependent on system activity at the
            time the call was invoked.
[...]


---
Sebastien DAUBIGNE=20
sebastien.daubigne at sema.fr - 05.57.26.56.36
Sema Global Services - AFM/DW/Pessac


	-----Message d'origine-----
	De:	MUHAMED, Mohd. Khairul [SMTP:khairul_muhamed at astro.com.my]
	Date:	mercredi 25 juillet 2001 11:05
	=C0:	sunhelp at sunhelp.org
	Cc:	Azlanrizal ABD. RAHMAN
	Objet:	[SunHELP] On TNS and listener errors ???

	Hi all,=20

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

	Thanks in advance=20


	=3D=3Dfrom the vmstat and ulimit command=3D=3D=3D=20

	oracle at pstksr01> vmstat 2=20
	 procs     memory            page            disk          faults
cpu=20
	 r b w   swap  free  re  mf pi po fr de sr f0 s1 s1 s1   in   sy
cs us sy id=20
	 0 0 0   8240 18920   0  89 51 48 55  0  1  0  2  1  0  492 1413
624  1  1 98=20
	 0 0 0 1811080 21920  0   1  0  0  0  0  0  0  0  1  0  243 1270
594  0  0 100=20
	 0 0 0 1811080 21920  0   0  0  0  0  0  0  0  0  1  0 1174 1205
570  0  2 98=20
	 0 0 0 1811080 21920  0   0  0  0  0  0  0  0  0  0  0  540 1206
572  0  0 100=20
	 0 0 0 1811080 21920  0   0  0  0  0  0  0  0  0  1  0  270 1259
590  0  0 100=20
	 0 0 0 1811080 21920  0   0  0  4  4  0  0  0  1  1  0  291 1287
624  0  1 99=20
	 0 0 0 1811080 21920  0   0  0  0  0  0  0  0  0  0  0  279 1442
765  0  0 100=20
	oracle at pstksr01> ulimit=20
	unlimited=20
	oracle at pstksr01>=20


	=3D=3Dfrom the listener.log=3D=3D=3D=20

	25-JUL-2001 15:51:27 * service_died * 0=20
	25-JUL-2001 15:52:29 * service_died * 0=20
	25-JUL-2001 15:53:30 * service_died * 0=20
	25-JUL-2001 15:54:32 * service_died * 0=20
	25-JUL-2001 15:55:34 * service_died * 0=20
	25-JUL-2001 15:55:34 *
(CONNECT_DATA=3D(SERVICE_NAME=3DDP51)(CID=3D(PROGRAM=3D)(HOST=3Dpstksr01=
)(USER=3Doracl=20
	e))) * =
(ADDRESS=3D(PROTOCOL=3Dtcp)(HOST=3D172.27.105.12)(PORT=3D46322)) *
establish * DP51 * 12500=20
	TNS-12500: TNS:listener failed to start a dedicated server process=20
	 TNS-12540: TNS:internal limit restriction exceeded=20
	  TNS-12560: TNS:protocol adapter error=20
	   TNS-00510: Internal limit restriction exceeded=20
	    Solaris Error: 12: Not enough space=20
	25-JUL-2001 15:56:35 * service_died * 0=20
	25-JUL-2001 15:57:37 * service_died * 0=20
	25-JUL-2001 15:58:39 * service_died * 0=20
	25-JUL-2001 15:59:40 * service_died * 0=20
	25-JUL-2001 16:00:42 * service_died * 0=20
	25-JUL-2001 16:01:43 * service_died * 0=20
	25-JUL-2001 16:02:10 *
(CONNECT_DATA=3D(SERVICE_NAME=3DDP51)(CID=3D(PROGRAM=3D)(HOST=3Dpstksr01=
)(USER=3Doracl=20
	e))) * =
(ADDRESS=3D(PROTOCOL=3Dtcp)(HOST=3D172.27.105.12)(PORT=3D46353)) *
establish * DP51 * 12500=20
	TNS-12500: TNS:listener failed to start a dedicated server process=20
	 TNS-12540: TNS:internal limit restriction exceeded=20
	  TNS-12560: TNS:protocol adapter error=20
	   TNS-00510: Internal limit restriction exceeded=20
	    Solaris Error: 12: Not enough space=20
	25-JUL-2001 16:02:45 * service_died * 0=20
	25-JUL-2001 16:03:47 * service_died * 0=20
	25-JUL-2001 16:04:48 * service_died * 0=20
	25-JUL-2001 16:05:50 * service_died * 0=20


	=3D=3Dfrom the sqlnet.log=3D=3D=3D=20

	Fatal NI connect error 12500, connecting to:=20
=09
(DESCRIPTION=3D(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3D172.27.105.12)(PORT=3D=
1521))(CONNECT
_DATA=3D(SERVICE_NAME=3D=20
	DP51)(CID=3D(PROGRAM=3D)(HOST=3Dpstksr01)(USER=3Doracle))))=20

	  VERSION INFORMATION:=20
	        TNS for Solaris: Version 8.1.6.0.0 - Production=20
	        TCP/IP NT Protocol Adapter for Solaris: Version 8.1.6.0.0 -
Production=20
	  Time: 25-JUL-2001 16:02:10=20
	  Tracing not turned on.=20
	  Tns error struct:=20
	    nr err code: 0=20
	    ns main err code: 12564=20
	    TNS-12564: TNS:connection refused=20
	    ns secondary err code: 0=20
	    nt main err code: 0=20
	    nt secondary err code: 0=20
	    nt OS err code: 0=20


	=3D=3Dfrom the backup log=3D=3D=3D=20

	Recovery Manager: Release 8.1.6.1.0 - Production=20

	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=20
	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=20
	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=20
	RMAN-00554: initialization of internal recovery manager package
failed=20
	RMAN-04005: error from target database: ORA-12500: TNS:listener
failed to start a dedicated server process=20


	Regards,=20
	    Mohd Khairul Muhamed=20
	     IT Services Division=20
	     MEASAT Broadcast Network Systems=20
	     Tel  : 03 9543 6688 x 8035=20
	     Fax : 03 9543 6874=20
	     Visit us at http://www.astro.com.my <http://www.astro.com.my> =20


=09