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:

> 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!

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@gmail.com> wrote:

> Database can only be switched between
> archivelog and noarchivelog when it's mounted and not open. Also, it must
> be shut down cleanly.

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.

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

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

> I dunno how to do that in EM.

But this was the question ;)

Thank you.

On Mar 4, 7:24=A0am, "Chris Seidel" <csei...@arcor.de> wrote:

snip

> 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!

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@sbcglobal.net> wrote:

> 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.

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?

> Is this grid control you are going thru

No.

In EM 9.2 you can find it under:

Instance/Configuration and then the Recovery tab.

http://www.oracle.com/technology/obe/paa/obe-arc/html/Change_Arch_Mode.htm#c

On Mar 4, 9:47=A0am, "Chris Seidel" <csei...@arcor.de> wrote:

snip

> In EM 9.2 you can find it under:
>
> Instance/Configuration and then the Recovery tab.
>
> http://www.oracle.com/technology/obe/paa/obe-arc/html/Change_Arch_Mod...

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:

> 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.

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



-- 
http://mgogala.byethost5.com

On Mar 4, 10:43=A0am, Mladen Gogala <n...@email.here.invalid> wrote:

snip

> > 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.
>
> Beautiful! I cannot wait to do that in the middle of working hours.

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

On 4 Mar, 13:43, Mladen Gogala <gogala.mla...@gmail.com> 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.

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@arcor.de> wrote:

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

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.

On 2010-03-05, gazzag <gareth@jamms.org> wrote:
> On 4 Mar, 13:43, Mladen Gogala <gogala.mla...@gmail.com> 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.
>
> OP stated version 10.2.  The quotes aren't needed:

Platform dependent!

>
> sqlplus "/ as sysdba" could also be
>
> sqlplus / as sysdba
>
> ;)
>
> -g

On Fri, 05 Mar 2010 18:44:39 +0000, Eric wrote:

>> OP stated version 10.2.  The quotes aren't needed:
> 
> Platform dependent!

I am on the holly platform and he is right, but I do like my double 
quotes. Don't take away my double quotes, I see no reason for changing my 
bad habits.

uname -a
Linux lpo-oracle11-01 2.6.9-55.ELsmp #1 SMP Fri Apr 20 17:03:35 EDT 2007 
i686 i686 i386 GNU/Linux



-- 
http://mgogala.byethost5.com

On Mar 5, 2:31=A0pm, Mladen Gogala <n...@email.here.invalid> wrote:

snip

> I am on the holly platform and he is right, but I do like my double
> quotes. Don't take away my double quotes, I see no reason for changing my
> bad habits.

Holly platform?  Holy platform?  Hollister?

My daughters have definitely spent a fair amount of my former income
on Hollister but I didn't know they offered a linux flavor!

On Fri, 05 Mar 2010 16:43:20 -0800, John Hurley wrote:


> Holly platform?  Holy platform?  Hollister?

Consecrated by the Oracle Corp. and having Oracle*Halo(TM)



-- 
http://mgogala.freehostia.com

"gazzag" <gareth@jamms.org> wrote in message 
news:ca3f5932-5881-4ffc-986d-b0bdd4ded8db@33g2000yqj.googlegroups.com...
> On 4 Mar, 13:43, Mladen Gogala <gogala.mla...@gmail.com> 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.
>
> OP stated version 10.2.  The quotes aren't needed:
>
> sqlplus "/ as sysdba" could also be
>
> sqlplus / as sysdba
>
> ;)
>
> -g

I believe on Windoze the quotes are still needed!

Matthias 

On 6 Mar, 13:03, "Matthias Hoys" <a...@spam.com> wrote:
>
> I believe on Windoze the quotes are still needed!
>
> Matthias- Hide quoted text -
>

Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation.  All rights reserved.

C:\>set ORACLE_SID=XXXXXXXX

C:\>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 8 10:57:03 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production


Session altered.

SYS@XXXXXXXX>

HTH

-g

John Hurley wrote:
> On Mar 4, 9:47 am, "Chris Seidel" <csei...@arcor.de> wrote:
> 
> snip
> 
>> In EM 9.2 you can find it under:
>>
>> Instance/Configuration and then the Recovery tab.
>>
>> http://www.oracle.com/technology/obe/paa/obe-arc/html/Change_Arch_Mod...
> 
> 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 ...


I hate the dbconsole - just in case you were wondering.. having a look 
at Oracle SQL Developer for a quick & easy gui for checking things as I 
speak - not too impressed (yet)

On Mar 8, 6:16=A0pm, gs <g...@gs.com> wrote:

snip

> > Okay then =A0... 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 ...
>
> I hate the dbconsole - just in case you were wondering.. having a look
> at Oracle SQL Developer for a quick & easy gui for checking things as I
> speak - not too impressed (yet)

I am still a Toad user although that product has become kind of
bloated over the years.  Our developers are using SQL Developer
because of the cost ( or lack thereof ).

Mladen made an excellent point here though ... when switching between
archive log modes  you really want to do it outside of a GUI.

John Hurley wrote:
> On Mar 8, 6:16 pm, gs <g...@gs.com> 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 ...
>> I hate the dbconsole - just in case you were wondering.. having a look
>> at Oracle SQL Developer for a quick & easy gui for checking things as I
>> speak - not too impressed (yet)
> 
> I am still a Toad user although that product has become kind of
> bloated over the years.  Our developers are using SQL Developer
> because of the cost ( or lack thereof ).
> 
> Mladen made an excellent point here though ... when switching between
> archive log modes  you really want to do it outside of a GUI.
> 
I always use command line for switching archive on/off - I will admit 
using EM in 9i once just to see how well it worked, but I just feel much 
more comfortable using command line rather than wondering if the GUI is 
really doing something or just sitting there hung.

One thing I don't like about SQL developer is you need to be logged in 
as the user whose schema you want to see, which is a pain when you want 
to see tables from different schemas in the same session. Unless I am 
missing something, the only way to do this in SD is disconnect/reconnect

On 9 Mar, 14:37, gs <g...@gs.com> wrote:
> I always use command line for switching archive on/off - I will admit
> using EM in 9i once just to see how well it worked, but I just feel much
> more comfortable using command line rather than wondering if the GUI is
> really doing something or just sitting there hung.
>
> One thing I don't like about SQL developer is you need to be logged in
> as the user whose schema you want to see, which is a pain when you want
> to see tables from different schemas in the same session. Unless I am
> missing something, the only way to do this in SD is disconnect/reconnect- Hide quoted text -
>

gs,

If you log into SQL*Developer as SYSTEM, you will see "Other Users" at
the bottom of your object browser tree.  Expand this to see other
schemas.

HTH

-g

gazzag wrote:
> On 9 Mar, 14:37, gs <g...@gs.com> wrote:
>> I always use command line for switching archive on/off - I will admit
>> using EM in 9i once just to see how well it worked, but I just feel much
>> more comfortable using command line rather than wondering if the GUI is
>> really doing something or just sitting there hung.
>>
>> One thing I don't like about SQL developer is you need to be logged in
>> as the user whose schema you want to see, which is a pain when you want
>> to see tables from different schemas in the same session. Unless I am
>> missing something, the only way to do this in SD is disconnect/reconnect- Hide quoted text -
>>
> 
> gs,
> 
> If you log into SQL*Developer as SYSTEM, you will see "Other Users" at
> the bottom of your object browser tree.  Expand this to see other
> schemas.
> 
> HTH
> 
> -g
> 
> 
thanks - must have missed that, I was in as system

On Mar 9, 10:14=A0am, gazzag <gar...@jamms.org> wrote:

snip

> If you log into SQL*Developer as SYSTEM, you will see "Other Users" at
> the bottom of your object browser tree. =A0Expand this to see other
> schemas.

Ummm ... you don't need to be logged in as SYSTEM to see other
schemas.  It all depends on what has been granted ... etc.

"gazzag" <gareth@jamms.org> wrote in message 
news:a66f4682-ade0-4ffd-9eb6-bb6182859b12@z11g2000yqz.googlegroups.com...
> On 6 Mar, 13:03, "Matthias Hoys" <a...@spam.com> wrote:
>>
>> I believe on Windoze the quotes are still needed!
>>
>> Matthias- Hide quoted text -
>>
>
> Microsoft Windows [Version 6.0.6001]
> Copyright (c) 2006 Microsoft Corporation.  All rights reserved.
>
> C:\>set ORACLE_SID=XXXXXXXX
>
> C:\>sqlplus / as sysdba
>
> SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 8 10:57:03 2010
>
> Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
>
>
> Connected to:
> Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
>
>
> Session altered.
>
> SYS@XXXXXXXX>
>
> HTH
>
> -g

Guess not then :-)

Matthias 

Op 9-3-2010 23:10, Matthias Hoys schreef:
> "gazzag"<gareth@jamms.org>  wrote in message
> news:a66f4682-ade0-4ffd-9eb6-bb6182859b12@z11g2000yqz.googlegroups.com...
>> On 6 Mar, 13:03, "Matthias Hoys"<a...@spam.com>  wrote:
>>>
>>> I believe on Windoze the quotes are still needed!
>>>
>>> Matthias- Hide quoted text -
>>>
>>
>> Microsoft Windows [Version 6.0.6001]
>> Copyright (c) 2006 Microsoft Corporation.  All rights reserved.
>>
>> C:\>set ORACLE_SID=XXXXXXXX
>>
>> C:\>sqlplus / as sysdba
>>
>> SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 8 10:57:03 2010
>>
>> Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
>>
>>
>> Connected to:
>> Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
>>
>>
>> Session altered.
>>
>> SYS@XXXXXXXX>
>>
>> HTH
>>
>> -g
>
> Guess not then :-)
>
> Matthias
>
>
They never were....

Shakespeare

Shakespeare wrote:
> Op 9-3-2010 23:10, Matthias Hoys schreef:

>> Guess not then :-)
>>
>> Matthias
>>
>>
> They never were....
> 
> Shakespeare

Try with 9.2: they are!
-- 

Regards, Frank van Bortel

Topposting in Usenet groups I regard as offensive - I will not reply

On Mar 10, 3:39=A0am, Frank van Bortel <frank.van.bor...@gmail.com>
wrote:

snip

> Try with 9.2: they are!

This was on the original post ... "connected to an Oracle 10.2" which
is what I believe Shakespeare was referring to with the "They never
were" part.

On 9 Mar, 23:25, Shakespeare <what...@xs4all.nl> wrote:
> They never were....
>
> Shakespeare-

Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\>set ORACLE_SID=XXXXXX

C:\>sqlplus / as sysdba
Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]
where <option> ::= -H | -V | [ [-L] [-M <o>] [-R <n>] [-S] ]
      <logon>  ::= <username>[/<password>][@<connect_string>] | / | /
NOLOG
      <start>  ::= @<URI>|<filename>[.<ext>] [<parameter> ...]
        "-H" displays the SQL*Plus version banner and usage syntax
        "-V" displays the SQL*Plus version banner
        "-L" attempts log on just once
        "-M <o>" uses HTML markup options <o>
        "-R <n>" uses restricted mode <n>
        "-S" uses silent mode

C:\>sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.8.0 - Production on Wed Mar 10 13:10:57 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Release 9.2.0.8.0 - Production
JServer Release 9.2.0.8.0 - Production

SQL>

On Mar 10, 8:13=A0am, gazzag <gar...@jamms.org> wrote:

snip

> Microsoft Windows 2000 [Version 5.00.2195]
> (C) Copyright 1985-2000 Microsoft Corp.
>
> C:\>set ORACLE_SID=3DXXXXXX
>
> C:\>sqlplus / as sysdba
> Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]
> where <option> ::=3D -H | -V | [ [-L] [-M <o>] [-R <n>] [-S] ]
> =A0 =A0 =A0 <logon> =A0::=3D <username>[/<password>][@<connect_string>] |=
 / | /
> NOLOG
> =A0 =A0 =A0 <start> =A0::=3D @<URI>|<filename>[.<ext>] [<parameter> ...]
> =A0 =A0 =A0 =A0 "-H" displays the SQL*Plus version banner and usage synta=
x
> =A0 =A0 =A0 =A0 "-V" displays the SQL*Plus version banner
> =A0 =A0 =A0 =A0 "-L" attempts log on just once
> =A0 =A0 =A0 =A0 "-M <o>" uses HTML markup options <o>
> =A0 =A0 =A0 =A0 "-R <n>" uses restricted mode <n>
> =A0 =A0 =A0 =A0 "-S" uses silent mode
>
> C:\>sqlplus "/ as sysdba"
>
> SQL*Plus: Release 9.2.0.8.0 - Production on Wed Mar 10 13:10:57 2010
>
> Copyright (c) 1982, 2002, Oracle Corporation. =A0All rights reserved.
>
> Connected to:
> Oracle9i Release 9.2.0.8.0 - Production
> JServer Release 9.2.0.8.0 - Production
>
> SQL>

The OP posted 10.2 in the original post in this thread.

On Mar 10, 3:03=A0pm, John Hurley <johnbhur...@sbcglobal.net> wrote:
> On Mar 10, 8:13=A0am, gazzag <gar...@jamms.org> wrote:
>
> snip
>
>
>
> > Microsoft Windows 2000 [Version 5.00.2195]
> > (C) Copyright 1985-2000 Microsoft Corp.
>
> > C:\>set ORACLE_SID=3DXXXXXX
>
> > C:\>sqlplus / as sysdba
> > Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]
> > where <option> ::=3D -H | -V | [ [-L] [-M <o>] [-R <n>] [-S] ]
> > =A0 =A0 =A0 <logon> =A0::=3D <username>[/<password>][@<connect_string>]=
 | / | /
> > NOLOG
> > =A0 =A0 =A0 <start> =A0::=3D @<URI>|<filename>[.<ext>] [<parameter> ...=
]
> > =A0 =A0 =A0 =A0 "-H" displays the SQL*Plus version banner and usage syn=
tax
> > =A0 =A0 =A0 =A0 "-V" displays the SQL*Plus version banner
> > =A0 =A0 =A0 =A0 "-L" attempts log on just once
> > =A0 =A0 =A0 =A0 "-M <o>" uses HTML markup options <o>
> > =A0 =A0 =A0 =A0 "-R <n>" uses restricted mode <n>
> > =A0 =A0 =A0 =A0 "-S" uses silent mode
>
> > C:\>sqlplus "/ as sysdba"
>
> > SQL*Plus: Release 9.2.0.8.0 - Production on Wed Mar 10 13:10:57 2010
>
> > Copyright (c) 1982, 2002, Oracle Corporation. =A0All rights reserved.
>
> > Connected to:
> > Oracle9i Release 9.2.0.8.0 - Production
> > JServer Release 9.2.0.8.0 - Production
>
> > SQL>
>
> The OP posted 10.2 in the original post in this thread.

And Shakespeare said "they never were" and gazzag showed they
were.

Thread drift happens, deal with it.

jg
--
@home.com is bogus.
http://1.bp.blogspot.com/_bMH90GEkTL4/S3rQVkg-bbI/AAAAAAAABuo/uQvrvTT_NZc/s=
1600-h/drive.jpg

On Mar 10, 8:35=A0pm, joel garry <joel-ga...@home.com> wrote:

snip

> > The OP posted 10.2 in the original post in this thread.
>
> And Shakespeare said "they never were" and gazzag showed they
> were.
>
> Thread drift happens, deal with it.

Unless Shakespeare replies back hard to know for sure if his reply was
specifically targeted to the posting by the OP.

I thought almost everyone in the Oracle DBA world realized that the
double quotes were gone after version 9.  It certainly was talked
about a lot back then.

On 11 Mar, 11:01, John Hurley <johnbhur...@sbcglobal.net> wrote:
> Unless Shakespeare replies back hard to know for sure if his reply was
> specifically targeted to the posting by the OP.
>
> I thought almost everyone in the Oracle DBA world realized that the
> double quotes were gone after version 9. =A0It certainly was talked
> about a lot back then.

Nothing like filling the thread with idle speculation though, eh?

-g

Op 11-3-2010 12:07, gazzag schreef:
> On 11 Mar, 11:01, John Hurley<johnbhur...@sbcglobal.net>  wrote:
>> Unless Shakespeare replies back hard to know for sure if his reply was
>> specifically targeted to the posting by the OP.
>>
>> I thought almost everyone in the Oracle DBA world realized that the
>> double quotes were gone after version 9.  It certainly was talked
>> about a lot back then.
>
> Nothing like filling the thread with idle speculation though, eh?
>
> -g

Well, I'm back. I was wrong. Sorry! Strange enough, I do not recall ever 
have used the " with Windows. I'm getting old....

Shakespeare