Yes I usually do Oracle after I'm done driving my cab :) I did edit the spfile in 9iR1 on Solaris using vi and had no problem!
The header and tail were binaries but all the rest is text. Regards, Waleed -----Original Message----- Sent: Friday, July 12, 2002 7:28 PM To: Multiple recipients of list ORACLE-L You DBA's must be drunk. Spfiles are in binary format and if you open it in a text editor, all you see are weird characters. Man. You guys are actually doing Oracle? Scares me. ltiu Quoting "Deshpande, Kirti" <[EMAIL PROTECTED]>: > 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:[EMAIL PROTECTED]] > > 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" <[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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deshpande, Kirti > 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: ltiu 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: Khedr, Waleed 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).