手工创建数据库

系统环境
操作系统：Windows 2000 Server
数据库：Oracle 9i
安装路径：C:Oracle
1、手工创建相关目录
e：Oracle\admin\wx
e：Oracle\admin\wx\bdump
e：Oracle\admin\wx\udump
e：Oracleadminwebcdump
e：Oracle\admin\wx\pfile
e：Oracle\admin\wx\create
e：Oracle\oradata\wx

2、手工创建初始化参数文件e:\oracle\admin\wx\pfile\init.ora，内容可以copy别的实例init.ora文件后修改。

3、手工创建initweb.ora文件，内容：：ifile= e:\oracle\admin\wx\pfile\init.ora

4、使用orapwd.exe命令，创建口令文件pwdwx.ora,命令格式如下：

orapwd file=d:\oracle\ora92\database\pwdwx.ora   password=xg_test   entries=5

5、通过oradim.exe命令，在服务里生成一个新的实例管理服务，启动方式为手工

set ORACLE_SID=wx

oradim -NEW -SID wx -INTPWD xg_test -STARTMODE manual -PFILE "e:\oracle\admin\wx\pfile\init.ora

6、创建数据库，执行createdb.sql脚本命令

C:\Documents and Settings\guanxg>sqlplus /nolog

SQL*Plus: Release 9.2.0.6.0 - Production on 星期一 5月 5 10:18:33 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn /as sysdba
已连接。
SQL> startup nomount pfile="e:\oracle\admin\wx\pfile\init.ora";

CREATE DATABASE wx
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'e:\oracle\oradata\wx\system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'e:\oracle\oradata\wx\temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'e:\oracle\oradata\wx\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('e:\oracle\oradata\wx\redo01.log') SIZE 102400K,
GROUP 2 ('e:\oracle\oradata\wx\redo02.log') SIZE 102400K,
GROUP 3 ('e:\oracle\oradata\wx\redo03.log') SIZE 102400K;

7、创建数据库数据文件，执行脚本createfiles.sql
connect SYS/change_on_install as SYSDBA
set echo on
spool d:\oracle\ora92\assistants\dbca\logs\CreateDBFiles.log
CREATE TABLESPACE "CWMLITE" LOGGING DATAFILE 'e:\oracle\oradata\wx\cwmlite01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;
CREATE TABLESPACE "DRSYS" LOGGING DATAFILE 'e:\oracle\oradata\wx\drsys01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;
CREATE TABLESPACE "EXAMPLE" LOGGING DATAFILE 'e:\oracle\oradata\wx\example01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;
CREATE TABLESPACE "INDX" LOGGING DATAFILE 'e:\oracle\oradata\wx\indx01.dbf' SIZE 25M REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;
CREATE TABLESPACE "ODM" LOGGING DATAFILE 'e:\oracle\oradata\wx\odm01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;
CREATE TABLESPACE "TOOLS" LOGGING DATAFILE 'e:\oracle\oradata\wx\tools01.dbf' SIZE 10M REUSE AUTOEXTEND ON NEXT  320K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;
CREATE TABLESPACE "USERS" LOGGING DATAFILE 'e:\oracle\oradata\wx\users01.dbf' SIZE 25M REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;
CREATE TABLESPACE "XDB" LOGGING DATAFILE 'e:\oracle\oradata\wx\xdb01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;
spool off
exit;
8、创建数据字典，运行createdbcatalog.sql脚本命令
connect SYS/change_on_install as SYSDBA
set echo on
spool d:\oracle\ora92\assistants\dbca\logs\CreateDBCatalog.log
@d:\oracle\ora92\rdbms\admin\catalog.sql;
@d:\oracle\ora92\rdbms\admin\catexp7.sql;
@d:\oracle\ora92\rdbms\admin\catblock.sql;
@d:\oracle\ora92\rdbms\admin\catproc.sql;
@d:\oracle\ora92\rdbms\admin\catoctk.sql;
@d:\oracle\ora92\rdbms\admin\owminst.plb;
connect SYSTEM/manager
@d:\oracle\ora92\sqlplus\admin\pupbld.sql;
connect SYSTEM/manager
set echo on
spool d:\oracle\ora92\assistants\dbca\logs\sqlPlusHelp.log
@d:\oracle\ora92\sqlplus\admin\help\hlpbld.sql helpus.sql;
spool off
spool off
exit;

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