Re: Rollback segment question (need help)
From: <mark_at_sugaree.uu.net>
Date: 23 Mar 92 13:25:25 GMT
Message-ID: <1992Mar23.092525.136_at_sugaree.uu.net>
>
> DC> Now, before we go any further, when you created the database, what
> DC> name did you give the database? The reason that I ask, is that the
> DC> file init.ora is a "template" init file that Oracle uses when
> DC> building the database from ground zero. Once the database is
> DC> created, an init file called init[oracle_sid].ora is created (where
> DC> [oracle_sid] is the name that you gave your instance). If you
> DC> edited the init.ora file and restarted using the command:
>
> DC> SQLDBA>startup
>
> DC> without adding
>
> DC> dfile=?/path/init.ora
>
> DC> you have done nothing other than start the database with the
> DC> init[oracle_sid].ora file not the init.ora file that you just
> DC> edited! This is the default! Tricky, eh?
>
>
> Sounds like it to me. I work with Oracle 6.0.33 on SUN 4 and DEC ULTRIX.
> I am unfamiliar with Oracle 6X on VAX/VMS. I would love to see their DBA guide
> and/or platform installation and user's guide with regard to this topic.
> Any other VMS folks out there who would like to comment on this?
>
> [remaining stuff deleted]
>
> If this is really the case (and I don't doubt you in the least bit)...so much
> for consistency across platforms. :(
>
>
> Dale Cooper, DBA And they ask me why I drink...
> Center for Seismic Studies
> Arlington, VA
Date: 23 Mar 92 13:25:25 GMT
Message-ID: <1992Mar23.092525.136_at_sugaree.uu.net>
In article <50567_at_seismo.CSS.GOV>, cooper_at_beno.CSS.GOV (Dale Cooper) writes:
> In article <LAHTI.92Mar20124408_at_pouta.fmi.fi> lahti_at_pouta.fmi.fi (Mikko Lahti) writes:
>>In article <50560_at_seismo.CSS.GOV> cooper_at_beno.CSS.GOV (Dale Cooper) writes: >> [good text deleted]
>
> DC> Now, before we go any further, when you created the database, what
> DC> name did you give the database? The reason that I ask, is that the
> DC> file init.ora is a "template" init file that Oracle uses when
> DC> building the database from ground zero. Once the database is
> DC> created, an init file called init[oracle_sid].ora is created (where
> DC> [oracle_sid] is the name that you gave your instance). If you
> DC> edited the init.ora file and restarted using the command:
>
> DC> SQLDBA>startup
>
> DC> without adding
>
> DC> dfile=?/path/init.ora
>
> DC> you have done nothing other than start the database with the
> DC> init[oracle_sid].ora file not the init.ora file that you just
> DC> 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.
>
> Sounds like it to me. I work with Oracle 6.0.33 on SUN 4 and DEC ULTRIX.
> I am unfamiliar with Oracle 6X on VAX/VMS. I would love to see their DBA guide
> and/or platform installation and user's guide with regard to this topic.
> Any other VMS folks out there who would like to comment on this?
>
> [remaining stuff deleted]
>
> If this is really the case (and I don't doubt you in the least bit)...so much
> for consistency across platforms. :(
>
>
> Dale Cooper, DBA And they ask me why I drink...
> Center for Seismic Studies
> Arlington, VA
-- Yes, in Oracle 6.0.34 on VAX/VMS the default init.ora file is ORA_INSTANCE:init.ora.......... |----------------------------------------\*******/-----------------------------| | Mark Mitman \*****/ "We have not inherited the | | Departmental Database Administrator \***/ Earth from our fathers, | | IKEA North American Information Systems \*/ we are borrowing it from | | Plymouth Commons /*\ our children." <unknown> | | Plymouth Meeting, PA 19462 /***\ | |-----------------------------------------/*****\------------------------------|Received on Mon Mar 23 1992 - 14:25:25 CET