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