手动建库的步骤

1.创建相关目录

在ORACLE_BASE/admin/ORACLE_SID/

[oracle@rac1 lzy]$ mkdir udump
[oracle@rac1 lzy]$ mkdir pfile
[oracle@rac1 lzy]$ mkdir dpdump
[oracle@rac1 lzy]$ mkdir create
[oracle@rac1 lzy]$ mkdir adump
[oracle@rac1 lzy]$ mkdir cdump

[oracle@rac1 lzy]$ mkdir bdump

在ORACLE_BASE下创建oradata/ORACLE_SID/

2.创建初始化参数文件

db_block_size=8192
db_file_multiblock_read_count =32
pga_aggregate_target=60M
sga_target=300M

nls_date_format="yyyy-MM-DD"
open_cursors=300

db_domain=""
time_statistics=FALSE

job_queue_processes=10

processes=200
remote_os_authent=true
os_authent_profix=""
compatible=10.2.0.1.0

remote_login_paswordfile=EXCLUSIVE
undo_management=AUTO

processes=200
remote_os_authent=true
os_authent_profix=""
compatible=10.2.0.1.0

remote_login_paswordfile=EXCLUSIVE
undo_management=AUTO
undo_tablespace=UNDOTBS1
_optimizer_cost_based_transformation=off
db_name=lzy
instance_name=lzy
background_dump_dest=/oracle/admin/lzy/bdump
core_dump_dest=/oracle/admin/lzy/cdump
user_dump_dest=/oracle/admin/lzy/udump
audit_file_dest=/oracle/admin/lzy/adump
control_files=("/oracle/oradata/lzy/control01.ctl","/oracle/oradata/lzy/control02.ctl")

并在ORACLE_HOME/dbs(xp 在database下) 创建一个initlzy.ora 文件

文件内容：IFILE='/oracle/admin/lzy/pfile/init.ora'

 

 

 

3创建口令文件

设置一下环境变量

ORACLE_SID=lzy

ORACLE_BASE=/oracle
ORACLE_CRS_HOME=/oracle/product/10.2.0/crs
ORACLE_HOME=/add/product/10.2.0/db_1

orapwd file=/add/product/10.2.0/db_1/dbs/PWDlzy.ora password=lzy force=y

4.创建ORACLE实例

在win中oradim -new -sid lzy -startmode manual -pfile /oracle/admin/lzy/pfile/init.ora 

在linux中只要设置环境变量即可

 export ORACLE_SID=newsid

$ sqlplus / as sysdba

5.连接实例

建立listener and tnsname

sqlplus / as sysdba

 

6启动实例到nomount状态

startup nomount pfile=/oracle/admin/lzy/pfile/ini.ora

 

7创建数据库

create database lzy
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
DATAFILE
'/oracle/oradata/lzy/system01.dbf' size 100m reuse autoextend on next 1m maxsize unlimited extent management local
SYSAUX DATAFILE
'/oracle/oradata/lzy/sysaux01.dbf' size 100m reuse autoextend on next 1m maxsize unlimited
default temporary tablespace TEMP tempfile
'/oracle/oradata/lzy/temp01.dbf' size 20m reuse autoextend on next 640k maxsize unlimited
undo tablespace UNDOTBS1 datafile
'/oracle/oradata/lzy/undo01.dbf' size 20m reuse autoextend on next 5M maxsize unlimited
logfile
GROUP 1 ('/oracle/oradata/lzy/redo1.dbf') size 10m,
GROUP 2 ('/oracle/oradata/lzy/redo2.dbf') size 10m,
GROUP 3 ('/oracle/oradata/lzy/redo3.dbf') size 10m
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
;

 

 

8创建表空间

create smallfile tablespace "users" logging
datafile '/oracle/oradata/lzy/exp01.dbf' size 30M
reuse autoextend on next 5 maxsize unlimited
extent management local segment space management auto

create smallfile tablespace "example" logging
datafile '/oracle/oradata/lzy/exp01.dbf' size 30M
reuse autoextend on next 5 maxsize unlimited
extent management local segment space management auto

9创建数据字典

@?/rdbms/admin/catalog.sql

@?/rdbms/admin/catproc.sql

 

10.创建EM档案库（可选）

 

11.创建服务器参数文件（可选）

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26879006/viewspace-721534/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26879006/viewspace-721534/