Re: Off-Line/On-Line Rollback segments question

Things are slightly different
- Within Oracle Enterprise Manager, startup Oracle Instance Manager and go to the item configuration parameters. You will see the parameters from the server now. Beneath this window there is a button save. This saves your init.ora file to a file in the \orant\sysman structure. When you startup the instance, it will show you a list box with available configurations. I agree it is a flat file on a PC, I don't advocate throwing away the servers init.ora. You should probably make sure you maintain the configuration in one place, syncing client and server will be a bit of a hassle as you may end up ftp-ing files to an Unix system.
Just found out this myself yesterday. They don't seem to provide any doc for OEM in the Oracle 7.3.4 software for AIX.
Hth
Sybrand Bakker

Glen Upreti wrote:

> 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 Sat Aug 22 1998 - 03:57:00 CDT