Re: New Installation of Oracle -> disgarding default database

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 29 Jul 1999 19:37:57 -0500
Message-ID: <7nqs55$7n3$1@garnet.tc.umn.edu>

at www.oreilly.com look at the oracle admin book for example scripts.

I used it for the following script.

set echo on
spool create_ATY2.log

REM * Start the <sid> instance (ORACLE_SID here must be set to <sid>). REM *
connect internal
startup nomount pfile=/apps/oracle/product/7.3.4/dbs/initATY2.ora

create database "ATY2"

    maxinstances 8
    maxlogfiles 32
    maxdatafiles 100
    character set "US7ASCII"
datafile

    '/vol04/oradata/ATY2/system01.dbf' size 100M logfile

    '/vol04/oradata/ATY2/redo01.01' size 5m,
    '/vol04/oradata/ATY2/redo02.01' size 5m,
    '/vol04/oradata/ATY2/redo03.01' size 5m;



@/apps/oracle/product/7.3.4/rdbms/admin/catalog.sql

@/apps/oracle/product/7.3.4/rdbms/admin/catproc.sql
@/apps/oracle/product/7.3.4/rdbms/admin/catparr.sql

alter database add logfile member
'/vol04/oradata/ATY2/redo01.02' to group 1; alter database add logfile member
'/vol04/oradata/ATY2/redo02.02' to group 2; alter database add logfile member
'/vol04/oradata/ATY2/redo03.02' to group 3;

create rollback segment temprbs
 tablespace system
storage (initial 25K next 25K minextents 2 maxextents 99);

alter rollback segment temprbs online;

drop tablespace rlbk01;
create tablespace rlbk01
 datafile '/vol04/oradata/ATY2/rlbk01.01' size 100M   default storage (initial 1m next 1m);

drop tablespace temp01 ;
create tablespace temp01
 datafile '/vol01/oradata/ATY2/temp01.01' size 100M  default storage (initial 2m next 2m);

drop tablespace user01 ;
create tablespace user01
 datafile '/vol01/oradata/ATY2/user01.01' size 200M  default storage (initial 100k next 100k);

create rollback segment r01
 tablespace rlbk01
 storage (initial 100k

          next     100k
          optimal 2100k
          minextents 20
          maxextents 250);

create rollback segment r02
 tablespace rlbk01
 storage (initial 100k

          next     100k
          optimal 2100k
          minextents 20
          maxextents 250);

create rollback segment r03
 tablespace rlbk01
 storage (initial 100k

          next     100k
          optimal 2100k
          minextents 20
          maxextents 250);
alter rollback segment r01 online;

alter rollback segment r02 online;
alter rollback segment r03 online;

alter rollback segment temprbs offline;

REM * Alter SYS and SYSTEM users, because Oracle will make SYSTEM
REM * the default and temporary tablespace by default.
REM *

alter user sys temporary tablespace temp01; alter user system default tablespace user01 temporary tablespace temp01;

REM * Now run the Oracle-supplied scripts we need for this DB REM *
@/apps/oracle/product/7.3.4/rdbms/admin/dbmspool.sql

REM * All done, so close the log file and exit. REM *
spool off
exit

--

---

Steven Hauser
email: hause011@tc.umn.edu URL: http://www.tc.umn.edu/~hause011

---

Received on Thu Jul 29 1999 - 19:37:57 CDT