Hi,

I connected to an Oracle 10.2 via Enterprise Manager (EM) as sysdba.
The checkbox to enable/disable Archivelog-Mode is disabled (grayed out).

Why?

Thank you!

On Thu, 04 Mar 2010 13:24:20 +0100, Chris Seidel wrote:

You're a DBA 2.0? Not a problem. Database can only be switched between
archivelog and noarchivelog when it's mounted and not open. Also, it must
be shut down cleanly. So, at approximately 10:30 AM, do the following:

sqlplus "/ as sysdba"
shutdown immediate
startup mount
alter database archivelog;
alter database open;

Being just an old DBA 1.0 hack, I dunno how to do that in EM.



--
http://mgogala.freehostia.com

On Thu, 04 Mar 2010 14:43:08 +0100, Mladen Gogala
<gogala.mladen (AT) gmail (DOT) com> wrote:

Doing this via EM allows it to do this in "open mode" because when you set
the checkbox all the stuff (shutdown, startup, alter ...) is done for you
by the EM.

For an unknown reason this checkbox is grayed out on one system. All other
systems are working well with an enabled checkbox.
All these systems have an open database and are fully operational.

Yes of course. But the customer needs it via EM too.

But this was the question

Thank you.

On Mar 4, 7:24*am, "Chris Seidel" <csei... (AT) arcor (DOT) de> wrote:

snip

Which OEM?

I cannot even find the option ( so far ) to change it going thru the
screens in a 10.2.0.4 OEM database control type setup.

Is this grid control you are going thru or am I just not finding it on
the GUI screen?

On Thu, 04 Mar 2010 15:26:36 +0100, John Hurley
<johnbhurley (AT) sbcglobal (DOT) net> wrote:

Ah... it works with EM 9.2 on server 9.2.
The server where it does not work is 10.
Could this be the reason that with EM 9.2 one cannot change this option on
a V 10 server?

No.

In EM 9.2 you can find it under:

Instance/Configuration and then the Recovery tab.

http://www.oracle.com/technology/obe...rch_Mode.htm#c

On Mar 4, 9:47*am, "Chris Seidel" <csei... (AT) arcor (DOT) de> wrote:

snip

Okay then ... the "old old" EM ... I haven't used that one in a long
time.

The terminology people use gets a little confusing trying to sort out
old EM from new OEM thru dbconsole from new OEM thru grid control ...

On Thu, 04 Mar 2010 15:00:59 +0100, Chris Seidel wrote:

Beautiful! I cannot wait to do that in the middle of working hours.



--
http://mgogala.byethost5.com

On Mar 4, 10:43*am, Mladen Gogala <n... (AT) email (DOT) here.invalid> wrote:

snip

Even a little more drastic than recreating the OEM repository on a
live database!

On 4 Mar, 13:43, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote:
OP stated version 10.2. The quotes aren't needed:

sqlplus "/ as sysdba" could also be

sqlplus / as sysdba



-g

On Thu, 04 Mar 2010 13:24:20 +0100, Chris Seidel <cseidel (AT) arcor (DOT) de> wrote:

Using the HTML-based EM from 10.2 - it works.
Seems to be a problem with the old 9.2 Java-based EM against a 10.2
database.