linux非图形化界面,非图形界面linux创建oracle的实例2

#打开路径

[oracle@node1 dbs]$ cd $ORACLE_BASE/oradata/cloud

[oracle@node1 cloud]$ vi createdb.sql

create database cloud

MAXINSTANCES 1

MAXLOGHISTORY 1

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXDATAFILES 100

DATAFILE

'/app/oracle/oracle11g/oradata/cloud/system01.dbf' size 100m reuse autoextend on next 1m maxsize unlimited extent management local

sysaux datafile

'/app/oracle/oracle11g/oradata/cloud/sysaux01.dbf' size 100m reuse autoextend on next 1m maxsize unlimited

default temporary tablespace TEMP tempfile

'/app/oracle/oracle11g/oradata/cloud/temp01.dbf' size 20m reuse autoextend on next 640k maxsize unlimited

undo tablespace UNDOTBS1 datafile

'/app/oracle/oracle11g/oradata/cloud/undo01.dbf' size 20m reuse autoextend on next 5M maxsize unlimited

logfile

GROUP 1 ('/app/oracle/oracle11g/oradata/cloud/redo1.dbf') size 10m,

GROUP 2 ('/app/oracle/oracle11g/oradata/cloud/redo2.dbf') size 10m,

GROUP 3 ('/app/oracle/oracle11g/oradata/cloud/redo3.dbf') size 10m

CHARACTER SET ZHS16GBK

NATIONAL CHARACTER SET AL16UTF16

;