Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: License high water mark

RE: License high water mark

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Mon, 25 Jun 2001 08:35:11 -0700
Message-ID: <F001.003368E4.20010625075649@fatcity.com>

naught in udump, bdump?  

what is listener.log activity around then?  

<shrug> just a thought

-----Original Message-----
Sent: Monday, June 25, 2001 11:07 AM
To: Multiple recipients of list ORACLE-L

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

-----Original Message-----
Sent: Monday, June 25, 2001 8:58 AM
To: DFarnsworth_at_Ashleyfurniture.com; ORACLE-L_at_fatcity.com

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 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

<http://www.orafaq.com>
-- Author: Farnsworth, Dave INET: DFarnsworth_at_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_at_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). ------_=_NextPart_001_01C0FD86.6AE5BD60 Content-Type: text/html; charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.50.4616.200" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 6pt MS Sans Serif; MARGIN-LEFT: 2px">
<DIV><SPAN class=840575114-25062001><FONT size=1>naught in udump,
bdump?</FONT></SPAN></DIV>
<DIV><SPAN class=840575114-25062001><FONT size=1></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=840575114-25062001><FONT size=1>what is listener.log
activity around then?</FONT></SPAN></DIV>
<DIV><SPAN class=840575114-25062001><FONT size=1></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=840575114-25062001><FONT size=1>&lt;shrug&gt; just a
thought</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Farnsworth, Dave [mailto:DFarnsworth_at_Ashleyfurniture.com]<BR><B>Sent:</B> Monday, June 25, 2001 11:07 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: License high water mark<BR><BR></FONT></DIV> <DIV><FONT size=1><SPAN class=204525613-25062001>I mentioned the license high water mark as the culprit because I do not see it listed in my &lt;SID&gt;Alert file any other time that the database was shut down.&nbsp; For all I know I am way off base.&nbsp; I was looking for something different from the other shutdowns.&nbsp; I should also be considering the EMNO process that restarted right before the database shutdown.&nbsp; Someone else on the list mentioned that this was a problem for them also.&nbsp; What I do not like is that the database just up and shut itself down with no warning.&nbsp; I suppose this is the time to open a TAR(oh the agony of it) with Oracle.</SPAN></FONT></DIV> <DIV><FONT size=1><SPAN class=204525613-25062001></SPAN></FONT>&nbsp;</DIV> <DIV><FONT size=1><SPAN class=204525613-25062001>Thanks,</SPAN></FONT></DIV> <DIV><FONT size=1><SPAN class=204525613-25062001></SPAN></FONT>&nbsp;</DIV> <DIV><FONT size=1><SPAN class=204525613-25062001>Dave</SPAN></FONT></DIV> <BLOCKQUOTE style="MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> JOE TESTA [mailto:JTESTA_at_longaberger.com]<BR><B>Sent:</B> Monday, June 25, 2001 8:58 AM<BR><B>To:</B> DFarnsworth_at_Ashleyfurniture.com; ORACLE-L_at_fatcity.com<BR><B>Subject:</B> Re: License high water mark<BR><BR></DIV></FONT> <DIV><FONT size=1>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?</FONT></DIV> <DIV><FONT size=1></FONT>&nbsp;</DIV> <DIV><FONT size=1>Also what is emn0 process?</FONT></DIV> <DIV><FONT size=1></FONT>&nbsp;</DIV> <DIV><FONT size=1>thanks, joe</FONT></DIV> <DIV><BR><BR>&gt;&gt;&gt; DFarnsworth_at_Ashleyfurniture.com 06/25/01 10:01AM &gt;&gt;&gt;<BR>My database is down!!&nbsp; In my &lt;SID&gt;Alert file is the following entries<BR><BR>Fri Jun 22 19:00:00 2001<BR>Restarting dead background process EMN0<BR>EMN0 started with pid=18<BR>Fri Jun 22 19:00:00 2001<BR>Shutting down instance (immediate)<BR>License high water mark = 9<BR>Fri Jun 22 19:00:04 2001<BR>ALTER DATABASE CLOSE NORMAL<BR>Fri Jun 22 19:00:04 2001<BR>SMON: disabling tx recovery<BR>SMON: disabling cache recovery<BR>Fri Jun 22 19:00:04 2001<BR>Thread 1 closed at log sequence 438<BR>Fri Jun 22 19:00:05 2001<BR>Completed: ALTER DATABASE CLOSE NORMAL<BR>Fri Jun 22 19:00:05 2001<BR>ALTER DATABASE DISMOUNT<BR>Completed: ALTER DATABASE DISMOUNT<BR>archiving is disabled<BR><BR>I would think that the high water mark is the culprit.&nbsp; What exactly is the<BR>high water mark??&nbsp; When I type in svrmgrl I get the following error<BR><BR>ORA-12540 TNS: internal limit restriction exceeded.<BR><BR>Any help or hints would be greatly appreciated.<BR><BR>Thanks,<BR><BR>Dave<BR>-- <BR>Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.com">http://www.orafaq.com</A><BR>-- <BR>Author: Farnsworth, Dave<BR>&nbsp; INET: DFarnsworth_at_Ashleyfurniture.com<BR><BR>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051<BR>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists<BR>------------------------------------------------------------------- -<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from).&nbsp; You may<BR>also send the HELP command for other information (like subscribing).<BR></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML> ------_=_NextPart_001_01C0FD86.6AE5BD60-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: MohanR_at_STARS-SMI.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_at_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).
Received on Mon Jun 25 2001 - 10:35:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US