One of the reasons why I do not use enterprise manager is that it has a
hard time dealing with flat files. To start up you need a pfile local
to the machine OEM is running on, I just don't like that. But you might
want to see where OEM is getting the pfile from, if it is local then
find it and edit it. If on the host machine, get your hands on it and
edit it. It is the only way I feel that you can be sure of what you are
doing.
Glen
Piotr Cieslewicz wrote:
>
> If you have SQL Worksheet (as you wrote) than you can check the actual number of
> rollback segments and parameters in init.ora file:
> 1. select * from dba_rollback_segs; (this will show you all rollback segments with
> their status)
> 2. show parameter roll*; (this will show all of the entries in the init.ora that
> contain "roll" string
>
> hope this helps
>
> Peter
>
> gilhirsch_at_my-dejanews.com wrote:
>
> > Hi,
> >
> > We've installed an oracle 7.3.3.X server at a remote site, and we ran into
> > this weird situation, that I'm hoping someone can help me with.
> >
> > Keep in mind that the only access tools we have are the Oracle Enterprise
> > Manager tools (Instance/Schema/Security/Storage Manager clients, and the
> > Worksheet) over a TCP/IP link.
> >
> > Here's an overview of the situation:
> > - We defined 17 (RB##) PUBLIC rollback segments.
> > - All segments have been manually altered to be ONLINE
> > - We altered the ROLLBACK_SEGMENTS parameter to include all RB##'s, and
> > restarted the instance - ALL VIA INSTANCE MANAGER CLIENT, because currently
> > we have no other way of getting our hands on the init.ora file.
> > When re-accessing the Instance Manager, the new ROLLBACK_SEGMENTS value
> > appears in the running value column.
> > - All rollback segments were ONLINE after instance restart.
> >
> > Observed behavior (after a couple of days): - Only 5 of the defined RB##'s
> > are ONLINE, the rest are OFFLINE. - When accessing the Instance Manager, the
> > newly-entered definition of the ROLLBACK_SEGMENTS parameter has been changed
> > back to NOTHING (default value).
> >
> > We have no reason to believe that anyone from the remote site has been
> > altering our configuration, shutting down the instance, altering the
> > rollbacks to OFFLINE state, or anything else we might think of. Based on that
> > assumption, it's obvious that we're missing out on something...
> >
> > Please, if any of you gurus can enlighten us as to how to solve this situation
> > - we need all of our 17 rollbacks ONLINE, all the time
> > - does changing the ROLLBACK_SEGMENTS parameter from the Instance Manager
> > client
> > affects the init.ora, or is it a temporary change of some sort?
> >
> > Thanks,
> > Gil.
> >
> > -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Thu Aug 20 1998 - 09:34:38 CDT
