oracle手工代码建库

说明，此手工代码建库方法，适用于oracle 10g 单机环境。

oracle环境变量

more .bash_profile

ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
ORACLE_SID=orcl
PATH=$ORACLE_HOME/bin:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_LIB
umask 022


1、建目录
mkdir -p /u01/app/oracle/admin/orcl/adump
mkdir -p /u01/app/oracle/admin/orcl/bdump
mkdir -p /u01/app/oracle/admin/orcl/cdump
mkdir -p /u01/app/oracle/admin/orcl/udump

mkdir -p /u01/oradata/orcl

2、创建密码文件
orapwd file=$ORACLE_HOME/dbs/orapworcl password=YOUR_PASSWORD

3、编辑参数文件
vi $ORACLE_HOME/dbs/initorcl.ora

*.control_files='/u01/oradata/orcl/control01.ctl','/u01/oradata/orcl/control02.ctl','/u01/oradata/orcl/control03.ctl'
*.db_name=orcl
*.db_block_size=8192
*.undo_management=auto
*.undo_tablespace=undotbs
*.sga_target=500M

export ORACLE_SID=orcl

sqlplus / as sysdba

create spfile from pfile;

4、启动实例，创建数据库
startup nomount;

create database orcl
user sys identified by oracle
user system identified by oracle
logfile group 1('/u01/oradata/orcl/redo01.log') size 50M,
        group 2('/u01/oradata/orcl/redo02.log') size 50M,
        group 3('/u01/oradata/orcl/redo03.log') size 50M
maxlogfiles 5
maxlogmembers 5
maxloghistory 1
maxdatafiles 500
maxinstances 1
character set AL32UTF8
national character set UTF8
datafile '/u01/oradata/orcl/system.dbf' size 500M
extent management local
sysaux datafile '/u01/oradata/orcl/sysaux01.dbf' size 500M
default  tablespace users
datafile '/u01/oradata/orcl/users01.dbf' size 100M
default temporary tablespace temp
tempfile '/u01/oradata/orcl/temp01.dbf' size 50M
undo tablespace undotbs 
datafile '/u01/oradata/orcl/undo01.dbf'size 50M;

5、执行脚本
--以sys执行脚本
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catblock.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/catoctk.sql
@?/rdbms/admin/owminst.plb

--以system执行脚本
conn system/YOUR_PASSWORD
@?/sqlplus/admin/pupbld.sql

conn system/YOUR_PASSWORD
@?/sqlplus/admin/help/hlpbld.sql helpus.sql