Xref: alice comp.databases.oracle.server:39589
Message-ID: <36B74825.4B049F4B@cadvision.com>
Date: Tue, 02 Feb 1999 11:47:01 -0700
From: Ken Rachynski <krachyn@cadvision.com>
X-Mailer: Mozilla 4.5 [en] (Win95; U)
X-Accept-Language: en-GB,en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: (O8/NT) OEM & running jobs
References: <36B7189C.245D2FB6@cadvision.com> <36B7330D.C662FFDF@us.oracle.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: 2 Feb 1999 11:48:52 -0700, 209.91.78.22
Organization: CADVision Development Corporation (http://www.cadvision.com/)
Lines: 57
Path: alice!news-feed.fnsi.net!netnews.com!feed2.nntp.acc.ca!feed.nntp.acc.ca!nntp.cadvision.com!news.cadvision.com!209.91.78.22

Peter,

Thanks, for the reply. What I am trying to achieve is automated shutdown and
startup of my database using Enterprise Manager. The shutdown works fine since
the job lists as having succeeded and my backup doesn't complain about open
files. However, I don't know why the startup doesn't work. I was under the
impression that OEM made all the tasks point-and-click-easy. I'm not a DBA
(yet) with this database being my sole concern. I'm also writing applications
for it, so I need point-and-click-easy operation. So far, I've been able to
come in on Monday morning and finish shutting down the services using the NT
control panel and start it back up again, but this is a development environment
that can handle not coming back up right away. The production environment needs
to be back online as soon as my backup is finished.

Peter Sharman wrote:

> Ken
>
> Generally this message means the database is part way up i.e.. the instance
> is started but not mounted, or the database is mounted but not open, when
> the startup command is issued.  You need to investigate why this is the
> case, and either:
>
> 1.  Shut it down properly before issuing the startup command
> 2.  If it should b part way up use the relevant alter database mount/open
> command.
>
> HTH.
>
> Pete
>
> --
>
> Regards
>
> Pete
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Peter Sharman                              Email: psharman@us.oracle.com
> WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
> Worldwide Internal Services Education               (650)607 0109 (local)
> San Francisco
>
> "Controlling application developers is like herding cats."
> Kevin Loney, ORACLE DBA Handbook
> "Oh no it's not!  It's much harder than that!"
> Bruce Pihlamae, long term ORACLE DBA
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--
Ken Rachynski
Database Analyst
krachyn@cadvision.com
<http://www.cadvision.com/krachyn>
ICQ: 3113514