Oracle命令行建库
１、 创建必要的相关目录跟踪文件目录 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
页:
[1]