Cette page vous affiche les différences entre la révision choisie et la version actuelle de la page.
enterprise_manager_em12c [2014/11/16 08:28] admin [Principe du GRID] |
enterprise_manager_em12c [2015/02/22 10:46] (Version actuelle) admin [Création de la base de données] |
||
---|---|---|---|
Ligne 290: | Ligne 290: | ||
</code> | </code> | ||
===== Création de la base de données ===== | ===== Création de la base de données ===== | ||
- | Se connecter sqlplus en sysdba | + | Création du script createGRID.sql |
<code> | <code> | ||
- | export ORACLE_SID=GRID | + | create database GRID |
- | sqlplus "/ as sysdba" | + | character set AL32UTF8 |
- | SQL> startup nomount; | + | national character set AL16UTF16 |
- | SQL> create spfile from pfile; | + | |
- | SQL> shutdown immediate; | + | |
- | SQL> startup nomount; | + | |
- | SQL> create database GRID | + | |
- | character set UTF8 | + | |
- | national character set UTF8 | + | |
logfile | logfile | ||
group 1 ('/u01/app/oracle/oradata/GRID/redo01a.log','/u02/app/oracle/oradata/GRID/redo01b.log' ) size 300M , | group 1 ('/u01/app/oracle/oradata/GRID/redo01a.log','/u02/app/oracle/oradata/GRID/redo01b.log' ) size 300M , | ||
Ligne 308: | Ligne 302: | ||
sysaux datafile '/u01/app/oracle/oradata/GRID/sysaux01.dbf' size 500M autoextend on next 100M maxsize 2G | sysaux datafile '/u01/app/oracle/oradata/GRID/sysaux01.dbf' size 500M autoextend on next 100M maxsize 2G | ||
undo tablespace UNDO_TBS datafile '/u02/app/oracle/oradata/GRID/undo_tbs01.dbf' size 500M autoextend on next 100M maxsize 2G | undo tablespace UNDO_TBS datafile '/u02/app/oracle/oradata/GRID/undo_tbs01.dbf' size 500M autoextend on next 100M maxsize 2G | ||
- | default temporary tablespace TEMP tempfile '/u03/app/oracle/oradata/GRID/temp01.dbf' size 1G; | + | default temporary tablespace TEMP tempfile '/u03/app/oracle/oradata/GRID/temp01.dbf' size 1G autoextend on next 100M maxsize 10G; |
+ | </code> | ||
+ | Se connecter sqlplus en sysdba | ||
+ | <code> | ||
+ | export ORACLE_SID=GRID | ||
+ | sqlplus "/ as sysdba" | ||
+ | SQL> startup nomount; | ||
+ | SQL> create spfile from pfile; | ||
+ | SQL> shutdown immediate; | ||
+ | SQL> startup nomount; | ||
+ | SQL> start createGRID: | ||
</code> | </code> | ||
==== Tables du dictionnaire ==== | ==== Tables du dictionnaire ==== |