oracle 手工建库

来源：互联网发布：i deserve it 编辑：程序博客网时间：2024/04/28 00:26

@linux

l 创建相关目录：

mkdir /oracle/oradata/purplemkdir /oracle/admin/purplemkdir /oracle/admin/purple/bdumpmkdir /oracle/admin/purple/udumpmkdir /oracle/admin/purple/cdump

l 创建初始化参数文件
vi /oacle/10.2/dbs/initpurple.ora

db_name=purplecontrol_files=("/oracle/oradata/purple/control01.ctl","/oracle/oradata/purple/control02.ctl", "/oracle/oradata/purple/control03.ctl")undo_management=AUTOundo_tablespace=UNDOTBSbackground_dump_dest=/oracle/admin/purple/bdumpcore_dump_dest=/oracle/admin/purple/cdumpuser_dump_dest=/oracle/admin/purple/udump

l 创建口令文件
orapwd file=orapwpurple password=Oracle entries=30
l 启动数据库到nomount(实例)状态

Startup nomount　pfile=/oracle/10.2/dbs/init.ora--
create spfile from pfile='/oracle/10.2/dbs/init.ora';--创建spfile文件

l 执行建库脚本

CREATE DATABASE purple   USER SYS IDENTIFIED BY Oracle   USER SYSTEM IDENTIFIED BY Oracle   LOGFILE GROUP 1 ('/oracle/oradata/purple/redo01.log') SIZE 100M,           GROUP 2 ('/oracle/oradata/purple/redo02.log') SIZE 100M,           GROUP 3 ('/oracle/oradata/purple/redo03.log') SIZE 100M   MAXLOGFILES 5   MAXLOGMEMBERS 5   MAXLOGHISTORY 1   MAXDATAFILES 100   MAXINSTANCES 1   CHARACTER SET zhs16gbk   NATIONAL CHARACTER SET AL16UTF16   DATAFILE '/oracle/oradata/purple/system01.dbf' SIZE 325M REUSE   EXTENT MANAGEMENT LOCAL   SYSAUX DATAFILE '/oracle/oradata/purple/sysaux01.dbf' SIZE 325M REUSE   DEFAULT TEMPORARY TABLESPACE tempts1      TEMPFILE '/oracle/oradata/purple/temp01.dbf'      SIZE 200M REUSE   UNDO TABLESPACE undotbs      DATAFILE '/oracle/oradata/purple/undotbs01.dbf'      SIZE 200M  AUTOEXTEND ON MAXSIZE UNLIMITED;

l 创建数据字典

@?/rdbms/admin/catalog.sql --用来创建数据库的数据字典文件@?/rdbms/admin/catproc.sql --用来创建数据库的基本过程和包