RE: Where is Oracle 9.2 init.ora?

I've also heard that it should not be edited. It can be more'd to see contents. No need to edit it directly since SCOPE can be used.

Gerardo

-----Original Message-----
Sent: Friday, July 12, 2002 2:54 PM
To: Multiple recipients of list ORACLE-L

I did edit it and had no problems while teting my 9i R1 on HP-UX 11.0 :)

• Kirti

> -----Original Message-----
> From: Rachel Carmichael [SMTP:wisernet100_at_yahoo.com]
> Sent: Friday, July 12, 2002 3:18 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Where is Oracle 9.2 init.ora?
>
> It should NOT however, be edited!
>
>
> --- "Freeman, Robert" <Robert_Freeman_at_csx.com> wrote:
> > >> Oracle created the SPFILE which is not humanly readable.
> >
> > Mine is pretty easy to read! Maybe you need to check your character
> > set???
> > :-))
> >
> > RF
> >
> > Robert G. Freeman - Oracle OCP
> > Oracle Database Architect
> > CSX Midtier Database Administration
> > Author
> > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> > Oracle9i New Features (Oracle Press)
> > Mastering Oracle8i (Sybex)
> >
> > Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> > Cousin Eddie: Those were my mother's dying words. But I
> > guess if your body's covered in third degree burns, and
> > your foot's caught in a bear trap, you tend to start talkin'
> > crazy.
> >
> >
> >
> > -----Original Message-----
> > Sent: Thursday, July 11, 2002 12:09 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Dennis,
> >
> > Oracle created the SPFILE which is not humanly readable. There
> > should
> > be an
> > alter database/system command that does the change for you.
> > According to
> > what I
> > heard at Oratechs 2000 editing the init.ora file is now longer
> > effective.
> >
> > Dick Goulet
> >
> > ____________________Reply Separator____________________
> > Author: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
> > Date: 7/11/2002 7:43 AM
> >
> > For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
> > expecting the
> > init.ora file?
> >
> > I created the database using dbca. It created an init.ora in
> > admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
> > the
> > original init.ora file. Then I discovered that Oracle is not reading
> > the new
> > init.ora. The database starts fine, with no errors. I tried moving
> > the
> > init.ora file back to the original pfile location, but it is still
> > not
> > reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
> > true, but I
> > have made other changes and they are not taking effect either.
> >
> > I have searched the documentation, and while there is the new SPFILE,
> > there
> > is no indication how this might affect my problem.
> >
> > Any insights from someone that has turned archiving on with 9.2 would
> > be
> > appreciated.
> >
> > Dennis Williams
> > DBA, 20% OCP
> > Lifetouch, Inc.
> > dwilliams_at_lifetouch.com
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: DENNIS WILLIAMS
> > INET: DWILLIAMS_at_LIFETOUCH.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:
> > INET: dgoulet_at_vicr.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: Freeman, Robert
> > INET: Robert_Freeman_at_csx.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).
>
>
> __________________________________________________
> Do You Yahoo!?
> Sign up for SBC Yahoo! Dial - First Month Free
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: wisernet100_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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.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: Molina, Gerardo
  INET: Gerardo.Molina_at_schwab.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).