From NDATFM@labor.state.ny.us Mon, 25 Jun 2001 08:06:06 -0700 From: "Mercadante, Thomas F" Date: Mon, 25 Jun 2001 08:06:06 -0700 Subject: RE: License high water mark Message-ID: MIME-Version: 1.0 Content-Type: text/plain Dave,   who else can submit a Shutdown?  Your alert.log file shows someone issuing a "shutdown immediate".   As far as I know, If Oracle crashes, you get next to nothing in the Alert.log.  You certainly do NOT get a shutdown immediate.   Who else in your organization has the privs to shut your database down?  That's where you should look first.   hope this helps Tom Mercadante Oracle Certified Professional -----Original Message-----From: Farnsworth, Dave [mailto:DFarnsworth@Ashleyfurniture.com]Sent: Monday, June 25, 2001 11:07 AMTo: Multiple recipients of list ORACLE-LSubject: RE: License high water mark 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).