Dave,
> by simply shutting down the service.
Are you on NT? If so and you've set the registry
entries to shutdown the db when the service or the
server is shutdown, this could be what happened.
- Anita
- "Farnsworth, Dave"
<DFarnsworth_at_Ashleyfurniture.com> wrote:
> I am looking into this possibility now. The network
> admins all can do this
> by simply shutting down the service. It is good to
> know that if it crashes,
> that it will either create an error or nothing at
> all.
>
> Thanks for the help,
>
> Dave
>
> -----Original Message-----
> From: A. Bardeen [mailto:abardeen1_at_yahoo.com]
> Sent: Monday, June 25, 2001 11:28 AM
> To: ORACLE-L_at_fatcity.com;
> DFarnsworth_at_Ashleyfurniture.com
> Subject: RE: License high water mark
>
>
> 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/
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 - 12:04:28 CDT
