Oracle-L: Re: creating a 9.2 database

From: <Reginald.W.Bailey_at_jpmorgan.com>
Date: Thu, 31 Oct 2002 13:54:29 -0800
Message-ID: <F001.004F9194.20021031135429@fatcity.com>

I must disagree. There is no $ORACLE_HOME/admin/<SID>/scripts. There is no admin directory under $ORACLE_HOME. In 9.2.0 you must create a template first by using the default configuration, save it, then exit the OUI. Then start it up again and use the existing template. Go through the normal prompts and then select the option to have it generate a shell script file near the end of the process. Have it save the script file in a directory of your choosing or it will put it in
$ORACLE_HOME/assistants/dbca/templates by default.

RWB "Adriano Freire" <adriano.f_at_uol.com.br>@fatcity.com on 10/31/2002 02:59:10 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

normally in $ORACLE_HOME/admin/<SID>/scripts ----- Original Message -----
To: Multiple recipients of list ORACLE-L Sent: Thursday, October 31, 2002 5:40 PM

I always like to create my databases by hand via the create database statement. However, whenever a new version comes out I use the dbca assistant to generate the create database script so I can see what Oracle does by default (although I usually don't run this generated script.)

I'm trying to do this with my new 9.2 installation, but at the end (step 7), it doesn't seem to allow the generation of the script without creating the database.

Is dbca creating a script to run and if so, where is it storing it?

9.2.0 on HP-UX 11i

Matt

Matt Adams - GE Appliances - matt.adams_at_appl.ge.com My computer beat me at chess, but I won when it came to kick boxing.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Reginald.W.Bailey_at_jpmorgan.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). Received on Thu Oct 31 2002 - 15:54:29 CST