RE: Minimum required init.ora parameters

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.
> >dwilliams_at_lifetouch.com
> >
> >-----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: DWILLIAMS_at_LIFETOUCH.COM
> >
> >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: 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).
>
>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: hkchital_at_singnet.com.sg
>
>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: 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.net
>--
>Author: Nirmal Kumar Muthu Kumaran
> INET: NIRMALK_at_qtel.com.qa
>
>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: 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).

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: hkchital_at_singnet.com.sg

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: 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).