手工创建数据库

手工创建oracle

第一步先安装oracle软件

第二

   (1)修改环境变量

   (2)创建目录

    cd /u01/oracle/

   创建存放数据文件目录

  mkdir mkdir oradata/demo -p

  创建闪回目录

  mkdir flash_recovery_area

  创建实例管理目录

  mkdir admin/demo -p

  cd admin/demo

  mkdir adump bdump cdump udump

  cd $ORACLE_HOMOE/dbs

  创建口令文件

  orapwd file=orapwdemo password=oracle 

 第三，准备参数文件

vim initdemo.ora

compatible=10.2.0.1.0

db_name=demo

shared_pool_size=200m

audit_file_dest='/u01/oracle/admin/demo/adump'

background_dump_dest='/u01/oracle/admin/demo/bdump'

core_dump_dest='/u01/oracle/admin/demo/cdump'

user_dump_dest='/u01/oracle/admin/demo/udump'

control_files='/u01/oracle/oradata/demo/control01.dbf'

db_recovery_file_dest='/u01/oracle/flash_recovery_area'

db_recovery_file_dest=100m

undo_management=auto

undo_tablespace=undotbs1

 

启动oracle到nomount状态

startup nomount

第四创建数据库

create  database demo

maxinstances 8

maxloghistory 1

maxlogfiles 16

maxlogmembers 3

maxdatafiles 100

datafile'/u01/oracle/oradata/demo/system01.dbf' size 300m autoextend on extentmanagement local

sysaux datafile'/u01/oracle/oradata/demo/sysaux01.dbf' size 120m autoextend on

defaulttemporary tablespace temp tempfile '/u01/oracle/oradata/demo/temp01.dbf' size20m

undo tablespaceundotbs1 datafile '/u01/oracle/oradata/oradata/demo/undotbs01.dbf' size 40m

character setzhs16gbk

logfile

group 1'/u01/oracle/oradata/demo/redo01.dbf' size 20m,

group 2'/u01/oracle/oradata/demo/redo02.dbf' size 20m;

 

创建数据字典

@?/rdbms/admin/catalog

构造PL/SQL运行环境

@?/rdbms/admin/catproc

创建scott用户

@?/rdbms/admin/utlsampl

创建用户安全审核的表

connsystem/management

@?/sqlplus/admin/pupbld