| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: Changing dump destinations in init.ora
Chris,
Hi there. This is Mike Killough.
(this is such a friendly list!)
>From: "Grabowy, Chris" <cgrabowy_at_fcg.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: RE: Changing dump destinations in init.ora
>Date: Mon, 25 Feb 2002 07:25:01 -0800
>
>Helen,
>
>Hi there. This is Chris Grabowy.
>
>-----Original Message-----
>Sent: Monday, February 25, 2002 9:43 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Rich,
>
>Hi there. This is Helen Mitchell.
>
>
>
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>Sent: Sunday, February 24, 2002 7:58 PM
>
>
> > Yes, the SPFILE is stored in binary format in the database, but you can
> > sort of work around it. To create a text file from the SPFILE, you can
> > issue:
> >
> > CREATE PFILE 'pfilename' FROM SPFILE 'filename';
> >
> > And vice versa with:
> >
> > CREATE SPFILE = 'filename' FROM PFILE = 'pfilename';
> >
> > When starting the instance, you can also specify an alternate SPFILE:
> >
> > SQL> startup pfile=filename
> >
> > There's also some new syntax for the ALTER SYSTEM command to specify the
> > scope of the change:
> >
> > ALTER SYSTEM set parameter = value SCOPE = MEMORY | SPFILE |
> > BOTH;
> >
> > Rich Holland
> > Guidance Technologies, Inc.
> >
> > > -----Original Message-----
> > > From: root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf Of
> > > dgoulet_at_vicr.com
> > > Sent: Wednesday, February 13, 2002 3:43 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re:RE: Changing dump destinations in init.ora
> > >
> > [...]
> > > during the discussion on database management it was revealed that init
> >
> > > files are on the way out, probably in 9i version 2. Their being
> > replaced
> > > by an SF file that is humanly unreadable and consequently
> > unmodifiable.
> > > Seems we'll have to do all modifications with the assistance of an
> > alter
> > > database or alter system command.
> > > On the plus side, if your starting a database remotely you'll not need
> > a
> > > copy of the init.ora locally.
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rich Holland
> > INET: holland_at_guidancetech.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Helen J Mitchell
> INET: HelenJMitchell_at_attbi.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Grabowy, Chris
> INET: cgrabowy_at_fcg.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: mwkillough_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Feb 25 2002 - 09:59:46 CST
 |
 |