| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: License high water mark
Check the audit folder as well
under $ORACLE_HOME
"Walking on water and developing software from a
specification are easy if both are frozen."
Christopher R. Spence <FONT
face="Comic Sans MS" size=2>Oracle DBA <FONT face="Comic Sans MS"
size=2>Fuelspot
<FONT face=Tahoma
size=2>-----Original Message-----From: Mercadante, Thomas F
[mailto:NDATFM_at_labor.state.ny.us]Sent: Monday, June 25, 2001 12:02
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
License high water mark
Dave,
who else can submit a
Shutdown? Your alert.log file shows someone issuing a "shutdown
immediate".
As far as I know, If Oracle
crashes, you get next to nothing in the Alert.log. You certainly do NOT
get a shutdown immediate.
Who else in your organization
has the privs to shut your database down? That's where you should look
first.
hope this
helps
Tom Mercadante <FONT face=Arial
size=2>Oracle Certified Professional
<FONT face=Tahoma
size=2>-----Original Message-----From: Farnsworth, Dave
[mailto:DFarnsworth_at_Ashleyfurniture.com]Sent: Monday, June 25,
2001 11:07 AMTo: Multiple recipients of list
ORACLE-LSubject: 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
<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--------------------------------------------------------------------To
REMOVE 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
subscribing).
Received on Mon Jun 25 2001 - 12:05:48 CDT
 |
 |