RE: creating a 9.2 database

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: creating a 9.2 database

Did you run 9.0 or 9.2?  The last page for my installer has two check boxes    - create template  - create database       ---- Matt Adams - GE Appliances - [EMAIL PROTECTED] My computer beat me at chess, but I won when it came to kick boxing.   -----Original Message----- From: David Wagoner [mailto:[EMAIL PROTECTED]] Sent: Friday, November 01, 2002 2:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: creating a 9.2 database 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----- From: Adams, Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED]] Sent: Friday, November 01, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: creating a 9.2 database   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 - [EMAIL PROTECTED] My computer beat me at chess, but I won when it came to kick boxing. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 31, 2002 4:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: creating a 9.2 database   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" <[EMAIL PROTECTED]>@fatcity.com on 10/31/2002 02:59:10 PM Please respond to [EMAIL PROTECTED]   Sent by:  [EMAIL PROTECTED]   To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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 -  [EMAIL PROTECTED] 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: [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).