RE: License high water mark

Dave,

I've never seen the license HWM cause a problem. It's usually informational in order for the DBA or auditors to tell if them have purchased sufficient licenses.
"Internal limit" messages often indicate that a process is trying to exceed a user or system limit (memory/semaphores/file handles etc.). If your DB crashed you should look for any core or trace files that might have further info.
You could also check that the instance has not left shared memory segments lying in RAM.

EMN0 is a process which is used as part of Advanced Queueing to notify processes that a message has arrived.
If you don't use AQ then you can ignore these messages.

The alert log seems to show a perfectly normal shutdown. Is it possible that someone has accidentaly kicked off a backup?

Regards,
Mike Hately,
Oracle DBA

|--------+--------------------------------->

|        |          "Farnsworth, Dave"     |
|        |          <DFarnsworth_at_Ashleyfurn|
|        |          iture.com>             |
|        |                                 |
|        |          06/25/01 04:06 PM      |
|        |          Please respond to      |
|        |          ORACLE-L               |
|        |                                 |


|--------+--------------------------------->

  >----------------------------------------------------------------------------|
  |                                                                            |
  |       To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>  |
  |       cc:     (bcc: Mike Hately/ETECH)                                     |
  |       Subject:     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

     -----Original Message-----
     From: JOE TESTA [mailto:JTESTA_at_longaberger.com]
     Sent: Monday, June 25, 2001 8:58 AM
     To: DFarnsworth_at_Ashleyfurniture.com; ORACLE-L_at_fatcity.com
     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


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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: MHately_at_etech-uk.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).