RE: where can I find sample db creation script (9.2.0.1.0 installation)?

From: Bob Metelsky <bmetelsky_at_cps92.com>
Date: Thu, 09 Oct 2003 05:54:26 -0800
Message-ID: <F001.005D28E4.20031009055426@fatcity.com>

Yes Im on Windows xp the script names and dir structure should be the same though...

Here is buildall.sql

######## buildall.sql  ################

spool \build.log
SET TERMOUT OFF
SET ECHO OFF
connect internal

@@build_db.sql
@C:\oracle\ora81\RDBMS\admin\catalog.sql
@C:\oracle\ora81\RDBMS\admin\catsnmp.sql

connect internal

@C:\oracle\ora81\RDBMS\admin\catexp7.sql
@C:\oracle\ora81\RDBMS\admin\catproc.sql
@@scott.sql

connect internal
@@demo.sql
connect system/manager
@C:\oracle\ora81\RDBMS\admin\catdbsyn.sql @C:\oracle\ora81\SQLPLUS\admin\pupbld.sql connect internal
@C:\oracle\ora81\RDBMS\admin\caths.sql
@C:\oracle\ora81\RDBMS\admin\oramts.sql
connect internal
alter rollback segment rb_temp offline;
shutdown;
spool off

##########################################

########## build_db.sql ##################

--

• $Header: build_db.sql 1.1 94/10/18 15:55:37 gdudey Osd<desktop/netware> $ Copyr (c) 1994 Oracle
  --
  
• This file must be run out of the directory containing the
• initialization file.

startup nomount pfile=\%AVAILABLE_SID%\pfile\initsmpl.ora

• Create database

create database %AVAILABLE_SID%

    controlfile reuse
    logfile '%seedl_path%\%AVAILABLE_SID%\redo01.log' size %seedl_size%M reuse,

            '%seedl_path%\%AVAILABLE_SID%\redo02.log' size %seedl_size%M reuse,

            '%seedl_path%\%AVAILABLE_SID%\redo03.log' size %seedl_size%M reuse,

            '%seedl_path%\%AVAILABLE_SID%\redo04.log' size %seedl_size%M reuse

    datafile '%seedd_path%\%AVAILABLE_SID%\system01.dbf' size %seedd_sysi_size%M reuse autoextend on

      next %seedd_syse_size%M maxsize %seedd_sysm_size%M     character set %seed_charset%;

create rollback segment rb_temp storage (initial 100 k next 250 k);

• Create additional tablespaces ...
• USERs: Create user sets this as the default tablespace
• TEMP: Create user sets this as the temporary tablespace
• RBS: For rollback segments

create tablespace users

    datafile '%seedd_path%\%AVAILABLE_SID%\users01.dbf' size %seedd_usri_size%M reuse autoextend on

      next %seedd_usre_size%M maxsize %seedd_usrm_size%M; create tablespace rbs

    datafile '%seedd_path%\%AVAILABLE_SID%\rbs01.dbf' size %seedd_rbsi_size%M reuse autoextend on

      next %seedd_rbse_size%M maxsize %seedd_rbsm_size%M; create temporary tablespace temp

    tempfile '%seedd_path%\%AVAILABLE_SID%\temp01.dbf' size %seedd_tmpi_size%M reuse autoextend on

      next %seedd_tmpe_size%M maxsize %seedd_tmpm_size%M; create tablespace oem_repository

    datafile '%seedd_path%\%AVAILABLE_SID%\oemrep01.dbf' size %seedd_usri_size%M reuse autoextend on

      next %seedd_usre_size%M maxsize %seedd_usrm_size%M; create tablespace indx

    datafile '%seedd_path%\%AVAILABLE_SID%\indx01.dbf' size %seedd_tmpi_size%M reuse autoextend on

      next %seedd_tmpe_size%M maxsize %seedd_tmpm_size%M;


--      next %seedd_usre_size%M maxsize %seedd_usrm_size%M;

alter rollback segment rb_temp online;

• Change the SYSTEM users' password, default tablespace and
• temporary tablespace.

alter user system temporary tablespace temp; alter user system default tablespace users;

• Create 16 rollback segments. Allows 16 concurrent users with open
• transactions updating the database. This should be enough.

create public rollback segment rb1 storage(initial 50K next 250K)   tablespace rbs;
create public rollback segment rb2 storage(initial 50K next 250K)   tablespace rbs;
create public rollback segment rb3 storage(initial 50K next 250K)   tablespace rbs;
create public rollback segment rb4 storage(initial 50K next 250K)   tablespace rbs;
create public rollback segment rb5 storage(initial 50K next 250K)   tablespace rbs;
create public rollback segment rb6 storage(initial 50K next 250K)   tablespace rbs;
create public rollback segment rb7 storage(initial 50K next 250K)   tablespace rbs;
create public rollback segment rb8 storage(initial 50K next 250K)   tablespace rbs;
create public rollback segment rb9 storage(initial 50K next 250K)   tablespace rbs;
create public rollback segment rb10 storage(initial 50K next 250K)   tablespace rbs;
create public rollback segment rb11 storage(initial 50K next 250K)   tablespace rbs;
create public rollback segment rb12 storage(initial 50K next 250K)   tablespace rbs;
create public rollback segment rb13 storage(initial 50K next 250K)   tablespace rbs;
create public rollback segment rb14 storage(initial 50K next 250K)   tablespace rbs;
create public rollback segment rb15 storage(initial 50K next 250K)   tablespace rbs;
create public rollback segment rb16 storage(initial 50K next 250K)   tablespace rbs;

#############################################

-----Original Message-----

Sent: Wednesday, October 08, 2003 10: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

--

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). Received on Thu Oct 09 2003 - 08:54:26 CDT