RE: Minimum required init.ora parameters

Well, I just tried it on 8.1.8, and here is what I receive:

SVRMGR> !cat inittest816.ora
control_files = ("/oracle8/oradata/test816/control01.ctl", "/oracle8/oradata/te)
SVRMGR> startup
ORACLE instance started.

Total System Global Area                        142688680 bytes
Fixed Size                                          94632 bytes
Variable Size                                    91721728 bytes
Database Buffers                                 50331648 bytes
Redo Buffers                                       540672 bytes
ORA-01506: missing or illegal database name        

-----Original Message-----
Sent: Monday, January 13, 2003 10:20 AM
To: Multiple recipients of list ORACLE-L

The only one parameter.. control_files.
Rest are optional.

Best Regards,
K Gopalakrishnan  

-----Original Message-----
WILLIAMS
Sent: Monday, January 13, 2003 7:44 AM
To: Multiple recipients of list ORACLE-L

Hemant - I was just going from my hastily written class notes. Sorry about misspelling the parameter. However, just tried it and 8.1.6 won't start without the COMPATIBLE parameter set in init.ora.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, January 13, 2003 8:55 AM
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: 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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: kaygopal_at_yahoo.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).
-- 
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).