用命令创建oracle数据库,oracle 使用命令创建oracle数据库

5、根据pfile文件创建想对应的目录

需要在$ORACLE_BASE/admin 下创建一个目录 hsj及其相关的子目录

$ORACLE_BASE/oradate 下面增加一个目录 hsj 及其子目录 archivelog

6、根据pfile文件创建spfile

startup nomount;

create spfile from pfile;

shutdown immediate;

7、在$ORACLE_HOME/dbs/ 下创建 orapwhsj

orapwd file=orapwhsj password=root entries=5

8、使用spfile启动数据库到nomount状态

startup up nomount

9、使用脚本创建数据库

spool db.log;

CREATE DATABASE "hsj"

USER SYS IDENTIFIED BY root

USER SYSTEM IDENTIFIED BY root

MAXDATAFILES 500

MAXINSTANCES 8

MAXLOGFILES  32

CHARACTER SET "UTF8"

NATIONAL CHARACTER SET AL16UTF16

ARCHIVELOG

DATAFILE '/u01/app/oradata/hsj/system01.dbf' size 300M

EXTENT MANAGEMENT LOCAL

SYSAUX DATAFILE '/u01/app/oradata/hsj/sysaux01.dbf' SIZE 325M REUSE

DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/u01/app/oradata/hsj/tempts01.dbf' SIZE 100M

EXTENT MANAGEMENT LOCAL

UNDO TABLESPACE "UNDOTBS1"

DATAFILE '/u01/app/oradata/hsj/undotbs01.dbf' SIZE 200M

LOGFILE

GROUP 1 (

'/u01/app/oradata/hsj/redo01a.rdo',

'/u01/app/oradata/hsj/redo01b.rdo'

) SIZE 100M,

GROUP 2 (

'/u01/app/oradata/hsj/redo02a.rdo',

'/u01/app/oradata/hsj/redo02b.rdo'

) SIZE 100M,

GROUP 3 (

'/u01/app/oradata/hsj/redo03a.rdo',

'/u01/app/oradata/hsj/redo03b.rdo'

) SIZE 100M

;

spool off;

10  运行脚本创建数据字典

@ORACLE_HOME/admin/catalog.sql(@/u01/app/oracle/admin/catalog.sql)

@ORACLE_HOME/admin/catproc.sql(@/u01/app/oracle/admin/catproc.sql)

11  启动数据库

startup

12 备份数据库

backup database

22/2<12