From VanE@uanet.org Mon, 25 Jun 2001 07:05:46 -0700 From: "Van M. Etheridge" Date: Mon, 25 Jun 2001 07:05:46 -0700 Subject: RE: License high water mark Message-ID: MIME-Version: 1.0 Content-Type: text/plain This is what the manual says: Oracle Product Document Library (C) Oracle Corporation Manual: ORACLE 8.1.5 SERVER CODES Reference: A67785-01 ORA-12540 TNS:internal limit restriction exceeded Cause: Too many TNS connections open simultaneously. Action: Wait for connections to close and retry. -----Original Message----- Sent: Monday, June 25, 2001 10:01 AM To: Multiple recipients of list ORACLE-L My database is down!! In my Alert file is the following entries Fri Jun 22 19:00:00 2001 Restarting dead background process EMN0 EMN0 started with pid=18 Fri Jun 22 19:00:00 2001 Shutting down instance (immediate) License high water mark = 9 Fri Jun 22 19:00:04 2001 ALTER DATABASE CLOSE NORMAL Fri Jun 22 19:00:04 2001 SMON: disabling tx recovery SMON: disabling cache recovery Fri Jun 22 19:00:04 2001 Thread 1 closed at log sequence 438 Fri Jun 22 19:00:05 2001 Completed: ALTER DATABASE CLOSE NORMAL Fri Jun 22 19:00:05 2001 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT archiving is disabled I would think that the high water mark is the culprit. What exactly is the high water mark?? When I type in svrmgrl I get the following error ORA-12540 TNS: internal limit restriction exceeded. Any help or hints would be greatly appreciated. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: DFarnsworth@Ashleyfurniture.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Van M. Etheridge INET: VanE@UANET.ORG Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).