Re: ORACLE errors "-2709 & -2709"

From: Alvin W. Law <alaw_at_oracle.com>
Date: 22 Jun 93 18:20:53 GMT
Message-ID: <ALAW.93Jun22102053_at_ap221sun.oracle.com>


>I got these errors running SQL*Report*Writer (V1.1.10.4.4):
 

>SQL*ReportWriter: Version 1.1.10.4.4 - Production on Mon Jun 21 12:51:27 1993
 

>Copyright (c) Oracle Corporation 1979, 1989. All rights reserved.
 

>ORACLE error number: -2709
>Error during Connect - 2709
 

>Does any one know what these are?

% oerr ora 2709
02709, 00000, "osnpop: pipe creation failed"

// *Cause:   The pipe driver failed to create pipes for two-task communications
//           with the oracle shadow process.
// *Action:  You have probably exceeded the maximum number of open file
//           descriptors per user or the system file table is full.  Note the
//           operating system error code and contact your system administrator.

It probably means the machine where the database is running is maxing out on processes.

--
 Alvin W. Law .............................................. Oracle Corporation
 Senior Software Engineer ...................... 300 Oracle Parkway, Box 659306
 Manufacturing Applications .......................... Redwood Shores, CA 94065
 Email: alaw_at_oracle.com ........... Voice: 1.415.506.3390 . Fax: 1.415.506.7299

      "Geez, it's an UNIX system."
			- Alexis Murphy, from Jurassic Park
Received on Tue Jun 22 1993 - 20:20:53 CEST

Original text of this message