Re: Rollback segment question (need help)

In article <50560_at_seismo.CSS.GOV> cooper_at_beno.CSS.GOV (Dale Cooper) writes:

    [good text deleted]

> Now, before we go any further, when you created the database, what
> name did you give the database? The reason that I ask, is that the
> file init.ora is a "template" init file that Oracle uses when
> building the database from ground zero. Once the database is
> created, an init file called init[oracle_sid].ora is created (where
> [oracle_sid] is the name that you gave your instance). If you
> edited the init.ora file and restarted using the command:
 

> SQLDBA>startup  

> without adding
 

> dfile=?/path/init.ora  

> you have done nothing other than start the database with the
> init[oracle_sid].ora file not the init.ora file that you just
> edited! This is the default! Tricky, eh?

I have used Oracle RDBMS v. 6.0 in VAX/VMS-machines for couple of years and edited only init.ora file. Works fine. In VMS every Oracle instance have its own directory with its own init.ora file and that's where startup command will find it. There is a "template" init.ora file in RDBMS directory that is copied into instance directory during database/instance creation.

Might it be that it works differently in UNIX? (By the way, what is your operating system?) I don't have any experience from there.

    [more text deleted]

> The fun thing about Oracle and their glorious manuals is that there
> is a lot going on in the background that they either neglect to
> mention or some of the things in the manuals are downright WRONG.
 

> DBA Guide Pg B-43 Under STARTUP. PFILE=filespec  

>	   And I quote: "Uses the specified parameter file while
>	   starting up."
 
>	   This is true, but...
 
>	   "If no file is specified, the default is the INIT.ORA file
>	   found in its default location."
 
>	   WRONG!  That should read ...is the INIT[oracle_sid].ORA
>	   file...

But if it is system depented, it should be in ORACLE for [operating system] Installation and Users Guide. Anyway, I agree that manuals could be easier to use, thought I have seen worse :-(.

   [end deleted]

> Dale Cooper, DBA Center for Seismic Studies Arlington, VA
> (703)276-7900 x27 cooper_at_seismo.css.gov

Mikko Lahti, Finnish Meteorological Institute, P.O.Box 503,

             Helsinki, Finland, Europe lahti_at_fmi.fi Received on Fri Mar 20 1992 - 12:44:08 CET