RE: where can I find sample db creation script (9.2.0.1.0 install

Guang - If you run dbca, Oracle's Database Creation Assistant, there is an option that will create a script for you instead of a database. I was never able to get this to work, but others on this list reported success.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, October 08, 2003 9:40 PM To: Multiple recipients of list ORACLE-L installation)?

Hi:

I am on unix and I can not find the file you menetioned. Looks like your box is Microsoft one.

essex$ pwd
/oracle/product/9.2.0.1.0/rdbms/admin
essex$ ls -l b*
b*: No such file or directory

Guang

On Wed, 8 Oct 2003, Bob Metelsky wrote:

> %ORACLEHOME%\rdbms\admin\build.db is one of them check this script which
> calls several others
>
> bob
>
> -----Original Message-----
> Sent: Wednesday, October 08, 2003 5:39 PM
> To: Multiple recipients of list ORACLE-L
> installation)?
>
> Hi:
>
> I just installed Oracle 9.2.0.1.0 on our Solaris 9 box for the 1st time.
> I
> let the installation to create a sample db. Now I am trying to see where
> I
> can find the db creation script, so I can study it and use it to create
> db
> instance manually. I can only find a bounch of log files in
> $ORACLE_ADMIN/<sid>/create directory, such as
>
> cloneDBCreation.log lockAccount.log postDBCreation.log
> postScripts.log ultraSearchCfg.log
>
>
> So does anyone know where I can find the script? Thanks.
>
> Guang
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Guang Mei
> INET: gmei_at_incyte.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: Bob Metelsky
> INET: bmetelsky_at_cps92.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: Guang Mei
  INET: gmei_at_incyte.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).