It should NOT however, be edited!
--- "Freeman, Robert" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > 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. > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).