Oracle命令行建库

hunter

１、 创建必要的相关目录
跟踪文件目录 bdump、cdump、udump：mkdir adump bdump cdump udump pfile
数据文件目录 mkdir hunter02
2、创建初始化参数文件
3.设置环境变量Oracle_sid
export ORACLE_SID=hunter02
4.创建口令文件 orapwd file=orapwhunter02 password=oracle entries=5
5.将数据库启动nomount
6.运行create database建库脚本
CREATE DATABASE hunter02
   USER SYS IDENTIFIED BY oracle
   USER SYSTEM IDENTIFIED BY oracle
   LOGFILE GROUP 1 ('/u01/oracle/oradata/hunter02/redo01.log') SIZE 100M,
           GROUP 2 ('/u01/oracle/oradata/hunter02/redo02.log') SIZE 100M,
           GROUP 3 ('/u01/oracle/oradata/hunter02/redo03.log') SIZE 100M
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 100
   MAXINSTANCES 1
   CHARACTER SET US7ASCII
   NATIONAL CHARACTER SET AL16UTF16
   DATAFILE '/u01/oracle/oradata/hunter02/system01.dbf' SIZE 325M REUSE
   EXTENT MANAGEMENT LOCAL
   SYSAUX DATAFILE '/u01/oracle/oradata/hunter02/sysaux01.dbf' SIZE 325M REUSE   
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE '/u01/oracle/oradata/hunter02/temp01.dbf'
      SIZE 20M REUSE
   UNDO TABLESPACE UNDOTBS1--这里的undotbs1要和初始换参数中的一样
      DATAFILE '/u01/oracle/oradata/hunter02/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
7.创建数据字典
SQL>@?/rdbms/admin/catalog
SQL>@?/rdbms/admin/catproc
SQL>conn system/oracle
SQL>@?/sqlplus/admin/pupbld