RE: License high water mark

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<FONT
color=#000000>
Tom Mercadante <FONT face=Arial
size=2>Oracle Certified Professional

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Farnsworth, Dave   [mailto:DFarnsworth_at_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   <SID>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   

    <FONT face=Tahoma
    size=2>-----Original Message-----From: JOE TESTA     [mailto:JTESTA_at_longaberger.com]Sent: Monday, June 25, 2001 8:58     AMTo: DFarnsworth_at_Ashleyfurniture.com;     ORACLE-L_at_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_at_Ashleyfurniture.com 06/25/01 10:01AM
    >>>My database is down!!  In my <SID>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: <A     href="http://www.orafaq.com">http://www.orafaq.com-- Author:     Farnsworth, Dave  INET: DFarnsworth_at_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_at_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).