Re: 9i Enterprise manager - no db restart

I'm slightly confused, since I use OEM (which isn't a new name for DBA Studio at all) all the time to start and stop my 9i database on my laptop.

Have you set up the Management Server, which you needed in 8i just as much as in 9i, to perform such tasks (you can't exactly start something the direct connection to which you lost by shutting it down -you have to get the Management Server to contact the Intelligent Agent whose job it is to do this sort of thing.)?

For the record, Oracle Enterprise Manager (OEM) has been the GUI management tool for Oracle databases since at least 8.0. A component part of OEM was the DBA Studio. That has now been superceded by the new 9i feature that you can start the OEM console *without* connecting to a Management Server (previously impossible), at which point the console loses its ability to schedule jobs and monitor for events, and looks suspiciously like DBA Studio used to do.

There is, of course, always the ability to forsake the misleading pastures of GUI and dive into the trusted lagoons of a Command Line Interface. Click Start-Run, type "cmd", at the C:\ prompt type 'sqlplus /nolog', and then issue a 'connect / as sysdba', followed by the magic word "startup".

Regards
HJR

--
Resources for OracleT: www.geocities.com/howardjr2000
=========================================


"pklosky" <member_at_dbforums.com> wrote in message
news:3bbb7efe$1_at_usenetgateway.com...


> In Oracle 8.1.6, I've been very happy with DBA Studio providing a

> mechanism to stop and start a DB. However, in Oracle 9i, the renamed DBA

> Studio, now Oracle Enterprise Manager (OEM), will only stop the DB. When

> you try to start it, it says "the db is not running," roughly. The only

> workaround I've found is to reboot the host to get the DB running again.

> This is a significant inconvenience. Anyone know how to start a Windows

> DB by any mechanism, including OEM?

>

> Peter

>

>

>

> --

> Posted via dBforums

> http://dbforums.com

>