As you said it is a binary file. Therefore it is not
saved in the database, it is outside in $OH/dbs.
Regarding what our colleague said, he mentioned a
solution to get the parameters of the spfile to a
plain file. But this can de done after at least one
startup.
Regards.
- Joe Testa <teci_at_the-testas.net> wrote:
> i didnt think the info was stored in the database.
> I thought it was
> stored as a binary file in the $ORACLE_HOME/dbs
> directory.
>
>
> i thought the oracle startup code looked for a
> spfile first in the dbs
> directory.
>
> if its literally stored in the database, how is
> oracle able to read it
> during startup?
>
> joe
>
>
> Rich Holland wrote:
>
> > 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.
> >>
> >
> >
>
>
> --
> Joe Testa, Oracle DBA
> Nothing new to put here, hmmmmmm
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Joe Testa
> INET: teci_at_the-testas.net
>
> 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).
Ing. Christian Trassens
Senior DBA & Unix Administrator
Phone: 0034-699240979
0034-649824704
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christian Trassens
INET: ctrassens_at_yahoo.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 - 08:18:25 CST
