手动创建数据库

今天看oracle 10g 联机文档，看到手动创建数据库部分，于是尝试了一下，步骤如下：

 

 

 

 

 

Creating the Database

Step 1: Decide on Your Instance Identifier (SID)

Step 2: Establish the Database Administrator Authentication Method

Step 3: Create the Initialization Parameter File

Step 4: Connect to the Instance

Step 5: Create a Server Parameter File (Recommended)

Step 6: Start the Instance

Step 7: Issue the CREATE DATABASE Statement

Step 8: Create Additional Tablespaces

Step 9: Run Scripts to Build Data Dictionary Views

Step 10: Run Scripts to Install Additional Options (Optional)

Step 11: Back Up the Database.

－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－

根据联机文档上的步骤归纳了一下：

1 首先创建个脚本文件来设置环境变量

setenv.sh

－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－

#!/bin/bash

export ORACLE_BASE=/opt/oracle/
export ORACLE_HOME=/opt/oracle/product/10g
export ORACLE_SID=festival
export PATH=$ORACLE_HOME/bin:$PATH
#alias sqlplus='rlwrap sqlplus'
#alias rman='rlwrap rman'
export LD_lIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－

2 创建初如化参数文件 initfestival.ora

－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－

festival.__db_cache_size=188743680
festival.__java_pool_size=4194304
festival.__large_pool_size=4194304
festival.__shared_pool_size=79691776
festival.__streams_pool_size=0
audit_file_dest='/opt/oracle//admin/festival/adump'
background_dump_dest='/opt/oracle//admin/festival/bdump'
compatible='10.2.0.1.0'
control_files='/opt/oracle//oradata/festival/control01.ctl','/opt/oracle//oradata/festival/control02.ctl','/opt/oracle//oradata/festival/control03.ctl'
core_dump_dest='/opt/oracle//admin/festival/cdump'
db_block_size=8192
db_domain=''
db_file_multiblock_read_count=16
db_name='festival'
db_recovery_file_dest='/opt/oracle//flash_recovery_area'
db_recovery_file_dest_size=2147483648
dispatchers='(PROTOCOL=TCP) (SERVICE=festivalXDB)'
job_queue_processes=10
open_cursors=300
pga_aggregate_target=92274688
processes=150
remote_login_passwordfile='EXCLUSIVE'
sga_target=277872640
undo_management='AUTO'
undo_tablespace='UNDOTBS1'
user_dump_dest='/opt/oracle//admin/festival/udump'

－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－

3 创建相应目录

－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－

mkdir -p /opt/oracle/oradata/festival

mkdir -p /opt/oracle/admin/festival/

mkdir -p /opt/oracle/admin/festival/adump

mkdir -p /opt/oracle/admin/festival/bdump

mkdir -p /opt/oracle/admin/festival/cdump

mkdir -p /opt/oracle/admin/festival/dpdump

mkdir -p /opt/oracle/admin/festival/pfile

mkdir -p /opt/oracle/admin/festival/udump

－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－

4 创建数据库脚本 createdb.sql

－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－

spool dbcreate.log;

create database "festival"
 maxdatafiles 200
 maxinstances 8
 maxlogfiles 32
 character set "utf8"
 national character set al16utf16
 --archivelog
 datafile '/opt/oracle/oradata/festival/system01.dbf' size 100M
 EXTENT MANAGEMENT LOCAL
 SYSAUX DATAFILE '/opt/oracle/oradata/festival/sysaux01.dbf' SIZE 50M REUSE
 default temporary tablespace temp tempfile '/opt/oracle/oradata/festival/tempts01.dbf' size 50M
 EXTENT MANAGEMENT LOCAL
 undo tablespace "UNDOTBS1"
 datafile '/opt/oracle/oradata/festival/undotbs01.dbf' size 50M
 logfile
 group 1 (
   '/opt/oracle/oradata/festival/redo01a.rdo',
   '/opt/oracle/oradata/festival/redo01b.rdo'
 )size 30M,
 group 2 (
   '/opt/oracle/oradata/festival/redo02a.rdo',
   '/opt/oracle/oradata/festival/redo02b.rdo'
 )size 30M,
 group 3 (
   '/opt/oracle/oradata/festival/redo03a.rdo',
   '/opt/oracle/oradata/festival/redo03b.rdo'
 )size 30M
;
spool off

－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－

5 创建数据库

－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－

[oracle@db ~]$ . ./setenv.sh
[oracle@db ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 28 04:44:32 2011

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

SQL> conn /as sysdba
Connected to an idle instance.
SQL> create spfile from pfile;

File created.

SQL> startup nomount
ORACLE instance started.

Total System Global Area  281018368 bytes
Fixed Size      1218968 bytes
Variable Size     88082024 bytes
Database Buffers   188743680 bytes
Redo Buffers      2973696 bytes
SQL> @/home/oracle/dbcreate.sql

Database created.

－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－

6 生成数据字典

conn sys /as sysdba
@/opt/oracle/product/10g/rdbms/admin/catalog.sql
@/opt/oracle/product/10g/rdbms/admin/catproc.sql

exit