Oracle 10g手动建库

配置环境：

已经安装好redhat4版本软件、安装好oracle 10g数据库软件、足够的磁盘空间

 

1、创建数据库所需相关目录

[oracle@shiyueasm ~]$ mkdir -p/u01/admin/orcl/bdump

[oracle@shiyueasm ~]$ mkdir -p/u01/admin/orcl/cdump

[oracle@shiyueasm ~]$ mkdir -p /u01/admin/orcl/udump

[oracle@shiyueasm ~]$ mkdir -p /u01/admin/orcl/disk1

[oracle@shiyueasm ~]$ mkdir -p /u01/admin/orcl/disk2

 

2、创建参数文件

[root@shiyueasm ~]# su - oracle

[oracle@shiyueasm ~]$ cd $ORACLE_HOME/dbs

[oracle@shiyueasm dbs]$ ll

-rw-r----- 1 oracle oinstall  8385 Sep11  1998 init.ora

[oracle@shiyueasm dbs]$ cat init.ora |grep-v ^# > initorcl.ora

[oracle@shiyueasm dbs]$ vi initorcl.ora

编辑initorcl.ora文件并根据下面示例进行更改

————————————————————————————————

db_name=orcl

db_files = 80                                             

db_file_multiblock_read_count = 8                                   

#db_block_buffers = 100                                                

#shared_pool_size = 3500000                                           

log_checkpoint_interval = 10000

processes = 50                                                      

parallel_max_servers = 5                                             

#log_buffer = 32768                                                   

max_dump_file_size = 10240

global_names = TRUE

control_files=('/u01/oradata/orcl/disk1/control01.ctl','/u01/oradata/orcl/disk2/control02.ctl')

sga_target=300m

background_dump_dest=/u01/admin/orcl/bdump

core_dump_dest=/u01/admin/orcl/cdump

user_dump_dest=/u01/admin/orcl/udump

undo_tablespace=shiyuetbs

undo_management=auto

————————————————————————————————

更改完成后输入:wq进行保存退出

 

 

3、测试参数文件是否正确

[oracle@shiyueasm ~]$ exportORACLE_SID=orcl

[oracle@shiyueasm ~]$ sqlplus / as sysdba

 

SQL*Plus: Release 10.2.0.1.0 - Productionon Mon Aug 8 14:26:07 2011

 

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 

Connected to an idle instance.

 

SQL> startup nomount

ORACLE instance started.

 

Total System Global Area  314572800 bytes

Fixed Size                  1219136 bytes

Variable Size              96470464 bytes

Database Buffers          209715200 bytes

RedoBuffers                7168000 bytes

4、编写建库脚本文件

[oracle@shiyueasm ~]$ cd $ORACLE_HOME/dbs

[oracle@shiyueasm dbs]$ ll

total 80

-rw-rw---- 1 oracle oinstall  1544 Aug  8 14:26 hc_orcl.dat

-rw-r----- 1 oracle oinstall  8385 Sep11  1998 init.ora

-rw-r--r-- 1 oracle oinstall   975 Aug  8 14:25 initorcl.ora

 [oracle@shiyueasm dbs]$ vi orcl.sql

把如下脚本文件写进orcl.sql文件

——————————————————————————————————

create databaseorcl

user sysidentified by oracle

user systemidentified by oracle

maxloghistory 1024

maxinstances 2

maxlogfiles 20

maxdatafiles 2048

datafile'/u01/oradata/orcl/system01.dbf' size 300m autoextend on next 30m maxsizeunlimited extent management local

sysaux datafile'/u01/oradata/orcl/sysaux01.dbf' size 300m autoextend on next 30m maxsizeunlimited

default temporarytablespace temp01 tempfile '/u01/oradata/orcl/temp01.dbf' size 100m

undo tablespaceshiyuetbs datafile '/u01/oradata/orcl/shiyuetbs.dbf' size 300m autoextend onnext 30m maxsize unlimited

default tablespaceshiyue datafile '/u01/oradata/orcl/shiyue01.dbf' size 200m

logfile

group 1('/u01/oradata/orcl/disk1/redo1_1.dbf','/u01/oradata/orcl/disk2/

redo1_2.dbf') size50m,

group 2 ('/u01/oradata/orcl/disk1/redo2_1.dbf','/u01/oradata/orcl/disk2/

redo2_2.dbf') size50m,

group 3('/u01/oradata/orcl/disk1/redo3_1.dbf','/u01/oradata/orcl/disk2/

redo3_2.dbf') size50m;

——————————————————————————————————

写入完成后输入:wq进行保存退出

 

5、创建数据库

[oracle@shiyueasm dbs]$ export ORACLE_SID=orcl

[oracle@shiyueasm dbs]$ sqlplus / as sysdba

 

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 814:41:28 2011

 

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 10g Enterprise Edition Release10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

 

SQL>@orcl.sql

 

Database created

 

SQL>@?/rdbms/admin/catalog

【注】跑完改脚本后接着跑下面的脚本，请耐心等待！

SQL>@?/rdbms/admin/catproc

SQL>conn system/oracle

SQL>@?/sqlplus/admin/pupbld

SQL>select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/u01/oradata/orcl/system01.dbf

/u01/oradata/orcl/shiyuetbs.dbf

/u01/oradata/orcl/sysaux01.dbf

/u01/oradata/orcl/shiyue01.dbf

 

4 rows selected.

 

SQL>select name from v$controlfile;

NAME

--------------------------------------------------------------------------------

/u01/oradata/orcl/disk1/control01.ctl

/u01/oradata/orcl/disk2/control02.ctl

 

2 rows selected.

 

SQL>select name from v$tempfile;

NAME

--------------------------------------------------------------------------------

/u01/oradata/orcl/temp01.dbf

 

1 row selected.

 

SQL>select member from v$logfile;

 

MEMBER

--------------------------------------------------------------------------------

/u01/oradata/orcl/disk1/redo1_1.dbf

/u01/oradata/orcl/disk2/redo1_2.dbf

/u01/oradata/orcl/disk1/redo2_1.dbf

/u01/oradata/orcl/disk2/redo2_2.dbf

/u01/oradata/orcl/disk1/redo3_1.dbf

/u01/oradata/orcl/disk2/redo3_2.dbf

 

6 rows selected.

 

 

好了，脚本跑完，手动建库完成！