手动建库——Oracle数据库技术与实验指导

(1)创建相关目录

mkdir C:\app\DayDayUp\admin\KCGL
mkdir C:\app\DayDayUp\admin\KCGL\adump
mkdir C:\app\DayDayUp\admin\KCGL\dpdump
mkdir C:\app\DayDayUp\admin\KCGL\pfile
mkdir C:\app\DayDayUp\oradata\KCGL

下面这条书上没写,可以先不创建O(∩_∩)O

mkdir C:\app\DayDayUp\flash_recovery_area\KCGL

(2)创建初始化参数文件
复制 C:\app\DayDayUp\admin\orcl\pfile\init.ora.xxxxxxx 到 C:\app\DayDayUp\product\11.2.0\dbhome_1\database 下,并改名为initKCGL.ora然后修改其中参数

audit_file_dest=C:\app\DayDayUp\admin\KCGL\adump
db_name=KCGL
control_files=("C:\app\DayDayUp\oradata\KCGL\control01.ctl", "C:\app\DayDayUp\flash_recovery_area\KCGL\control02.ctl")

(3)设置环境变量

Set oracle_sid=KCGL

(4)创建服务(注意空格)

Oradim -new -sid KCGL

(5)创建口令文件

Orapwd file=C:\app\DayDayUp\product\11.2.0\dbhome_1\database\pwdKCGL.ora

Password=12345
(6)启动服务器

Sqlplus/nolog
Conn/as sysdba
Startup nomount

(7)执行建库脚本

CREATE DATABASE KCGL
datafile 'C:\app\DayDayUp\oradata\KCGL\system01.dbf' size 300m
autoextend on next 10m extent management local
Sysaux datafile 'C:\app\DayDayUp\oradata\KCGL\sysaux01.dbf' size 120m
undo tablespace undotbs1
datafile 'C:\app\DayDayUp\oradata\KCGL\undotbs01.dbf' size 100m
	default temporary tablespace temptbs1
tempfile 'C:\app\DayDayUp\oradata\KCGL\temp01.dbf' size 50m
logfile group 1('C:\app\DayDayUp\oradata\KCGL\redo01.log') size 50m,
		group 2('C:\app\DayDayUp\oradata\KCGL\redo02.log') size 50m,
		group 3('C:\app\DayDayUp\oradata\KCGL\redo03.log') size 50m;

Start C:\CREATEKCGL.sql

此处如果报错

.第 1 行出现错误: ORA-01501: CREATE DATABASE ?? ORA-…

解决办法,创建缺少的目录,然后连接重新执行

mkdir C:\app\DayDayUp\flash_recovery_area\KCGL

(8)创建数据字典和包(比较漫长,不要退出)

Start C:\app\DayDayUp\product\11.2.0\dbhome_1\RDBMS\ADMIN\catalog
Start C:\app\DayDayUp\product\11.2.0\dbhome_1\RDBMS\ADMIN\catproc

(9)执行pupbld.sql脚本文件

Conn system/manager
Start C:\app\DayDayUp\product\11.2.0\dbhome_1\sqlplus\admin\pupbld

(10)执行scott脚本创建scott方案

Start C:\app\DayDayUp\product\11.2.0\dbhome_1\RDBMS\ADMIN\scott.sql
Conn/as sysdba
Alter user scott identified by tiger;
Conn scott/tiger

(11)执行以下命令

select * from dept;

(12)打开DBCA,可以看到手动建的库