Re: (O8/NT) OEM & running jobs

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_at_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_at_cadvision.com
<http://www.cadvision.com/krachyn>
ICQ: 3113514 Received on Tue Feb 02 1999 - 12:47:01 CST