Cannot change ARCHIVELOG-MODE via EM

#11

On 2010-03-05, gazzag <gareth (AT) jamms (DOT) org> wrote:

Quote:

On 4 Mar, 13:43, Mladen Gogala <gogala.mla... (AT) gmail (DOT) 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!

Quote:

sqlplus "/ as sysdba" could also be

sqlplus / as sysdba

-g

#12

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

Quote:

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

#13

On Mar 5, 2:31*pm, Mladen Gogala <n... (AT) email (DOT) here.invalid> wrote:

snip

Quote:

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!

#14

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

Quote:

Holly platform? Holy platform? Hollister?

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

--
http://mgogala.freehostia.com

#15

"gazzag" <gareth (AT) jamms (DOT) org> wrote

Quote:

On 4 Mar, 13:43, Mladen Gogala <gogala.mla... (AT) gmail (DOT) 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

#16

On 6 Mar, 13:03, "Matthias Hoys" <a... (AT) spam (DOT) com> wrote:

Quote:

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

#17

John Hurley wrote:

Quote:

On Mar 4, 9:47 am, "Chris Seidel" <csei... (AT) arcor (DOT) 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...hange_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)

#18

On Mar 8, 6:16*pm, gs <g... (AT) gs (DOT) com> wrote:

snip

Quote:

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.

#19

John Hurley wrote:

Quote:

On Mar 8, 6:16 pm, gs <g... (AT) gs (DOT) 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

#20

On 9 Mar, 14:37, gs <g... (AT) gs (DOT) com> wrote:

Quote:

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