Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: License high water mark
Dave, yea i understand, oracle should be putting that "high
water" entry everytime is shuts down.
yea oracle support, what a joy :)
joe
>>> "Farnsworth, Dave"
<DFarnsworth_at_Ashleyfurniture.com> 06/25/01 10:04AM
>>>
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--------------------------------------------------------------------ToREMOVE 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