oracle手工建库

确定环境，安装软件，配置init.ora参数文件，创建spfile然后create database，最后在执行脚本就OK。

ORACLE 10G 手动建库
1）确定实例名。
export ORACLE_SID=test
2）建立密码文件。
orapwd file=orapwtest password=oracle
3）建立pfile。
cat init.ora|grep -v ^ #|grep -v ^ $ > inittest.ora
在inittest.ora里只包含如下初始化参数：
db_name=test
processes=150
control_files='/opt/oracle/oradata/control01.ctl'
db_block_size=8192
log_buffer=50000000
sga_target=300m
undo_management=auto
undo_tablespace=undotbs
background_dump_dest
core_dump_dest
user_dump_dest
4）建立spfile并启动实例。
sql>sqlplus / as sysdba
sql>create spfile from pfile
sql>startup nomount
5）手工创建数据库（使用create database命令）
ˎ̥CREATE DATABASE test
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/opt/oracle/oradata/test/redo01.log') SIZE 100M,
GROUP 2 ('/opt/oracle/oradata/test/redo02.log') SIZE 100M,
GROUP 3 ('/opt/oracle/oradata/test/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/opt/oracle/oradata/test/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/opt/oracle/oradata/test/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/opt/oracle/oradata/test/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/opt/oracle/oradata/test/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
6）运行相关脚本。
CONNECT SYS/password AS SYSDBA
@/u01/oracle/rdbms/admin/catalog.sql
@/u01/oracle/rdbms/admin/catproc.sql
@?/rdbms/admin/catblock.sql
@?/rdbms/admin/catoctk.sql
@?/rdbms/admin/owminst.plb
connect system/oracle
@?/sqlplus/admin/pupbld.sql

Oracle 10G增加了drop database 命令：

startup mount exclusive force；

alter system enable restricted session；

drop database;