RE: License high water mark

[JOE TESTA]

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" <[EMAIL PROTECTED]> 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 -----Original Message----- From: JOE TESTA [mailto:[EMAIL PROTECTED]] Sent: Monday, June 25, 2001 8:58 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: 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 >>> [EMAIL PROTECTED] 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 -- Author: Farnsworth, Dave   INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).