1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58
|
define ORACLE_SID=POZZO10
define ORACLE_HOME=C:\oracle\Ora10
define ORACLE_BASE=D:\Database\POZZO10
define REP_DAT=D:\database\POZZO10\files
define REP_IDX=D:\database\POZZO10\files
define REP_LOB=D:\database\POZZO10\files
define REP_SYS=D:\database\POZZO10\files
define TBS_DATA=POZZO_DATA
define TBS_INDEX=POZZO_INDEX
define TBS_LOB=POZZO_LOB
connect sys/manager as sysdba
shutdown abort
startup nomount pfile="D:\Database\POZZO10"\pfile\initPOZZO10.ora
prompt Creation de l instance &ORACLE_SID
create database &ORACLE_SID
user sys identified by manager
user system identified by manager
controlfile reuse
maxdatafiles 50
logfile group 1 ('&REP_SYS.\&ORACLE_SID._01.log') size 20M reuse,
group 2 ('&REP_SYS.\&ORACLE_SID._02.log') size 20M reuse,
group 3 ('&REP_SYS.\&ORACLE_SID._03.log') size 20M reuse
datafile '&REP_SYS.\&ORACLE_SID._SYSTEM_01.ora' size 550M reuse
extent management local
default temporary tablespace TMP
tempfile '&REP_SYS.\&ORACLE_SID._TMP_01.ora' size 800M reuse
sysaux datafile '&REP_SYS.\&ORACLE_SID._SYSAUX_01.ora' size 1000M reuse
undo tablespace undotbs
datafile '&REP_SYS.\&ORACLE_SID._UNDOTBS_01.ora' size 800M reuse
character set WE8ISO8859P15
national character set UTF8
noarchivelog;
prompt <Entree> pour continuer
pause
prompt Creation des tablespaces
create tablespace &TBS_DATA
datafile '&REP_DAT.\&ORACLE_SID._&TBS_DATA._01.ora' size 1500M reuse
extent management local uniform size 256K;
create tablespace &TBS_INDEX
datafile '&REP_IDX.\&ORACLE_SID._&TBS_INDEX._01.ora' size 1500M reuse
extent management local uniform size 256K;
create tablespace &TBS_LOB
datafile '&REP_LOB.\&ORACLE_SID._&TBS_LOB._01.ora' size 1500M reuse
extent management local uniform size 256K;
prompt Creation du catalogue et des options procedurales
@&ORACLE_HOME.\rdbms\admin\catalog
@&ORACLE_HOME.\rdbms\admin\catproc
connect system/manager
@&ORACLE_HOME.\sqlplus\admin\pupbld.sql |
Partager