Différences

Cette page vous affiche les différences entre la révision choisie et la version actuelle de la page.

--- mise_en_place_d_un_dataguard_oracle_10g [2011/12/17 16:25]
admin [Création des VM]
+++ mise_en_place_d_un_dataguard_oracle_10g [2011/12/17 16:34] (Version actuelle)
admin
@@ Ligne 62: / Ligne 62: @@
 orapwd file=orapwYODA password=manager10
 </code>
+Création de la base YODA
+<code>
+create database YODA
+character set UTF8
+national character set UTF8
+logfile
+group 1 '/u01/app/oracle/oradata/YODA/redo01a.log' size 50M,
+group 2 '/u01/app/oracle/oradata/YODA/redo02a.log' size 50M,
+group 3 '/u01/app/oracle/oradata/YODA/redo03a.log' size 50M
+datafile '/u01/app/oracle/oradata/YODA/system01.dbf' size 500M autoextend on next 100M maxsize 2G extent management local
+sysaux datafile '/u01/app/oracle/oradata/YODA/sysaux01.dbf' size 500M autoextend on next 100M maxsize 2G
+undo tablespace UNDO_TBS datafile '/u01/app/oracle/oradata/YODA/undo_tbs01.dbf' size 25M
+default temporary tablespace TEMP tempfile '/u01/app/oracle/oradata/YODA/temp01.dbf' size 50M;
+@?/rdbms/admin/catalog.sql
+@?/rdbms/admin/catproc.sql
+alter user sys identified by manager10;
+alter user system identified by manager10;
 </code>

Le wiki de Silverlake