Hemant - I believe this applies to Oracle8i versions. The key point is "try it". If you have a small test database you can bounce, it will take you just a couple of minutes to comment out the COMPATIBLE parameter and bounce the database. I agree with you that my assumption was that it was unnecessary -- until I proved it for myself. In college I was really looking forward to my philosophy class. Thought I would learn the secret of life or something. Anyway one of the main ideas I recall was a bunch of Greek philosophers (Aristotle ?) that spent an afternoon speculating on how many teeth a horse should have, and wrote up the discussion. My reaction was "go count them". If you think you have a bad horse, take a survey. Oh well, the career paths for a philosophy major are limited, so I guess I didn't miss much.
Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Tuesday, January 14, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Which version and platform ? I've never found COMPATIBLE to be mandatory to startup a database. Every version does set a default value for COMPATIBLE [I believe it is "8.0" in 8.0.x and 8.1.x]. Hemant At 12:58 AM 14-01-03 -0800, you wrote: >No, I tried to startup the DB without compatible parameter. It throws >message as >the same parameter is required. > >Nirmal. > >-----Original Message----- >Sent: Monday, January 13, 2003 5:55 PM >To: Multiple recipients of list ORACLE-L > > > >"compatibility" or "compatible" is not a mandatory init.ora parameter. >I would think that only the first three are required. > >Hemant > >At 06:08 AM 13-01-03 -0800, you wrote: > >Nirmal - I believe there are four: > > db_name > > control_file > > db_block_size > > compatibility > > > >This is from John Hibbard, a great Oracle Education instructor. > >But why not try for yourself? Save off your init.ora, then create a new > >init.ora with just the above parameters. If Oracle comes up, then remove > >parameters. If there is another parameter, Oracle will tell you. > > > > > > > >Dennis Williams > >DBA, 40%OCP > >Lifetouch, Inc. > >[EMAIL PROTECTED] > > > >-----Original Message----- > >Sent: Monday, January 13, 2003 4:59 AM > >To: Multiple recipients of list ORACLE-L > > > > > >List, > > > >I'm interested to know the minimum required parameters to startup the > >database. > > > >Pls anybody list out that? > > > >Nirmal., > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.net > >-- > >Author: DENNIS WILLIAMS > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services -- 858-538-5051 http://www.fatcity.com > >San Diego, California -- Mailing list and web hosting services > >--------------------------------------------------------------------- > >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). > >Hemant K Chitale >My web site page is : http://hkchital.tripod.com > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Hemant K Chitale > INET: [EMAIL PROTECTED] > >Fat City Network Services -- 858-538-5051 http://www.fatcity.com >San Diego, California -- Mailing list and web hosting services >--------------------------------------------------------------------- >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.net >-- >Author: Nirmal Kumar Muthu Kumaran > INET: [EMAIL PROTECTED] > >Fat City Network Services -- 858-538-5051 http://www.fatcity.com >San Diego, California -- Mailing list and web hosting services >--------------------------------------------------------------------- >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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
