From DFarnsworth@Ashleyfurniture.com Mon, 25 Jun 2001 07:32:56 -0700 From: "Farnsworth, Dave" Date: Mon, 25 Jun 2001 07:32:56 -0700 Subject: RE: License high water mark Message-ID: MIME-Version: 1.0 Content-Type: text/plain I mentioned the license high water mark as the culprit because I do not see it listed in my Alert file any other time that the database was shut down.  For all I know I am way off base.  I was looking for something different from the other shutdowns.  I should also be considering the EMNO process that restarted right before the database shutdown.  Someone else on the list mentioned that this was a problem for them also.  What I do not like is that the database just up and shut itself down with no warning.  I suppose this is the time to open a TAR(oh the agony of it) with Oracle.   Thanks,   Dave -----Original Message-----From: JOE TESTA [mailto:JTESTA@longaberger.com]Sent: Monday, June 25, 2001 8:58 AMTo: DFarnsworth@Ashleyfurniture.com; ORACLE-L@fatcity.comSubject: Re: License high water mark License high water mark is exactly that, the max number of connections to the database(if i remember correctly), what lends you to believe thats the culprit?   Also what is emn0 process?   thanks, joe >>> DFarnsworth@Ashleyfurniture.com 06/25/01 10:01AM >>>My database is down!!  In my Alert file is the following entriesFri Jun 22 19:00:00 2001Restarting dead background process EMN0EMN0 started with pid=18Fri Jun 22 19:00:00 2001Shutting down instance (immediate)License high water mark = 9Fri Jun 22 19:00:04 2001ALTER DATABASE CLOSE NORMALFri Jun 22 19:00:04 2001SMON: disabling tx recoverySMON: disabling cache recoveryFri Jun 22 19:00:04 2001Thread 1 closed at log sequence 438Fri Jun 22 19:00:05 2001Completed: ALTER DATABASE CLOSE NORMALFri Jun 22 19:00:05 2001ALTER DATABASE DISMOUNTCompleted: ALTER DATABASE DISMOUNTarchiving is disabledI would think that the high water mark is the culprit.  What exactly is thehigh water mark??  When I type in svrmgrl I get the following errorORA-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.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).