XP下手动创建数据库

1 准备初始化参数文件initorcl.ora,将其保存在 E:/oracle/product/10.2.0/admin/orcl/pfile 内容如下：

 

##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################
###########################################
# SGA Memory
###########################################
sga_target=167772160
###########################################
# Job Queues
###########################################
job_queue_processes=1
###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=orclXDB)"
###########################################
# Miscellaneous
###########################################
compatible=10.2.0.1.0
###########################################
# Security and Auditing
###########################################
audit_file_dest=E:/oracle/product/10.2.0/admin/orcl/adump
remote_login_passwordfile=EXCLUSIVE
###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=16777216
###########################################
# Database Identification
###########################################
db_domain=""
db_name=orcl
###########################################
# File Configuration
###########################################
control_files=("E:/oracle/product/10.2.0/oradata/orcl/control01.ctl", "E:/oracle/product/10.2.0/oradata/orcl/control02.ctl", "E:/oracle/product/10.2.0/oradata/orcl/control03.ctl")
###########################################
# Cursors and Library Cache
###########################################
open_cursors=300
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS1
##########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=E:/oracle/product/10.2.0/admin/orcl/bdump
core_dump_dest=E:/oracle/product/10.2.0/admin/orcl/cdump
user_dump_dest=E:/oracle/product/10.2.0/admin/orcl/udump
###########################################
# Processes and Sessions
###########################################
processes=150
###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_file_multiblock_read_count=16

 

2准备建库脚本createdb.sql,将其保存在 E:/oracle/product/10.2.0/admin/orcl/pfile，内容如下：

 

CREATE DATABASE "orcl"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'E:/oracle/product/10.2.0/oradata/orcl/system01.dbf' SIZE 300M REUSE
SYSAUX DATAFILE 'E:/oracle/product/10.2.0/oradata/orcl/sysaux01.dbf' SIZE 120M REUSE
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'E:/oracle/product/10.2.0/oradata/orcl/temp01.dbf' SIZE 20M REUSE
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'E:/oracle/product/10.2.0/oradata/orcl/undotbs01.dbf' SIZE 200M REUSE
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('E:/oracle/product/10.2.0/oradata/orcl/redo01.log') SIZE 51200K,
GROUP 2 ('E:/oracle/product/10.2.0/oradata/orcl/redo02.log') SIZE 51200K,
GROUP 3 ('E:/oracle/product/10.2.0/oradata/orcl/redo03.log') SIZE 51200K;

 

3创建必要的目录

 

C:/Documents and Settings/Administrator> mkdir E:/oracle/product/10.2.0/admin/orcl/adump
C:/Documents and Settings/Administrator> mkdir E:/oracle/product/10.2.0/admin/orcl/bdump
C:/Documents and Settings/Administrator> mkdir E:/oracle/product/10.2.0/admin/orcl/cdump
C:/Documents and Settings/Administrator> mkdir E:/oracle/product/10.2.0/admin/orcl/dpdump
C:/Documents and Settings/Administrator> mkdir E:/oracle/product/10.2.0/admin/orcl/udump
C:/Documents and Settings/Administrator> mkdir E:/oracle/product/10.2.0/admin/orcl/pfile
C:/Documents and Settings/Administrator> mkdir E:/oracle/product/10.2.0/oradata/orcl

4 设置环境变量

 

set ORACLE_SID=orcl
 
5 创建密码文件

 

C:/Documents and Settings/Administrator>
orapwd file=E:/oracle/product/10.2.0/db_1/database/PWDorcl.ora password=admin force=y

 

6 创建服务

 

C:/Documents and Settings/Administrator>oradim -NEW -SID orcl -STARTMODE auto -SRVCSTART system -PFILE 'E:/oracle/product/10.2.0/admin/orcl/pfile/initorcl.ora'
实例已创建。

 

7 以nomount方式启动数据库

 

C:/Documents and Settings/Administrator>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 8月 22 20:16:18 2006
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn / as sysdba
已连接到空闲例程。
SQL> startup nomount pfile='E:/oracle/product/10.2.0/admin/orcl/pfile/initorcl.ora'
ORACLE 例程已经启动。
Total System Global Area  167772160 bytes
Fixed Size                  1247900 bytes
Variable Size              62915940 bytes
Database Buffers          100663296 bytes
Redo Buffers                2945024 bytes

 

8 调用建库脚本创建数据库

 

SQL>@E:/oracle/product/10.2.0/admin/orcl/pfile/createdb.sql
数据库已创建。

 

9 创建其他数据字典

 

@E:/oracle/product/10.2.0/db_1/rdbms/admin/catalog.sql;
@E:/oracle/product/10.2.0/db_1/rdbms/admin/catblock.sql;
@E:/oracle/product/10.2.0/db_1/rdbms/admin/catproc.sql;
@E:/oracle/product/10.2.0/db_1/rdbms/admin/catoctk.sql;
@E:/oracle/product/10.2.0/db_1/rdbms/admin/owminst.plb;
@E:/oracle/product/10.2.0/db_1/rdbms/admin/catclust.sql;
@E:/oracle/product/10.2.0/db_1/sqlplus/admin/pupbld.sql;

 

10 在sys用户下，创建spfile

 

SQL> create spfile from pfile='E:/oracle/product/10.2.0/admin/orcl/pfile/initorcl.ora';
文件已创建

 

11 执行scott脚本创建scott模式

SQL>@E:/oracle/product/10.2.0/db_1/rdbms/admin/scott.sql

 

12 把数据库打开到正常状态

SQL>alter database open;

13 测试新建数据库是否可以正常运行

 

问题：

(1)————————初始化参数问题
之前的初始化参数db_recovery_file_dest=E:/oracle/product/10.2.0/flash_recovery_area db_recovery_file_dest_size=2147483648这两项有问题，导致数据库脚本执行错误，删除这两项后恢复正常，Why？

(2)-------------------如何创建监听器？

 

 

参考网址：http://www.cnblogs.com/xuanyuanvista/archive/2009/08/25/1553672.html