Tom,
Bingo! You were the first person to notice that a
shutdown immediate was issued. If Oracle crashes the
db you'll either get an error or nothing at all, but
never a shutdown immediate.
Dave, you need to check for cron jobs or OEM jobs that
can shutdown the db as well as checking who has
privileges to shutdown the db, as Tom suggested.
The emno process failing and the highwater mark are
not related because something or someone shutdown the
db either manually or automated. I guarantee you this
is what Oracle Support is going to tell you.
HTH,
- Anita
- "Mercadante, Thomas F" <NDATFM_at_labor.state.ny.us>
wrote:
> 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
> Oracle Certified Professional
>
> -----Original Message-----
> Sent: Monday, June 25, 2001 11:07 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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-----
> Sent: Monday, June 25, 2001 8:58 AM
> To: DFarnsworth_at_Ashleyfurniture.com;
> ORACLE-L_at_fatcity.com
>
>
> 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
> <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).
>
>
>
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.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).
Received on Mon Jun 25 2001 - 11:28:13 CDT
