Oracle-L: RE: creating a 9.2 database

From: David Wagoner <dwagoner_at_arsenaldigital.com>
Date: Fri, 01 Nov 2002 11:39:09 -0800
Message-ID: <F001.004FA268.20021101113909@fatcity.com>

There are two check boxes at the end of the DBCA steps. One is to create a template, the other is to create scripts. The tricky thing about the 9i DBCA is that the options are different if you choose New Database rather than the other choices. I've checked and edited the scripts after using the Create New Database option.

HTH, David Wagoner

-----Original Message-----
Sent: Friday, November 01, 2002 12:59 PM To: Multiple recipients of list ORACLE-L

I did this (create a template, exit and re-run, select template, go to step 7 (last screen)). Nowhere did I see an option to have the script to a file. Do you know which step this is found in?

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.
-----Original Message-----
[ mailto:Reginald.W.Bailey_at_jpmorgan.com
<mailto:Reginald.W.Bailey_at_jpmorgan.com> ] Sent: Thursday, October 31, 2002 4:54 PM To: Multiple recipients of list ORACLE-L

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 <http://www.orafaq.com>
--

Author:
INET: Reginald.W.Bailey_at_jpmorgan.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com <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.com
--

Author: David Wagoner
INET: dwagoner_at_arsenaldigital.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------