-- Author: Farnsworth, Dave INET: DFarnsworth@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@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"

naught in udump, bdump?

what is listener.log activity around then?

<shrug> just a thought

-----Original Message-----
From: Farnsworth, Dave [mailto:DFarnsworth@Ashleyfurniture.com]
Sent: Monday, June 25, 2001 11:07 AM
To: Multiple recipients of list ORACLE-L
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@longaberger.com]
Sent: Monday, June 25, 2001 8:58 AM
To: DFarnsworth@Ashleyfurniture.com; ORACLE-L@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@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@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@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-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: MohanR@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@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).