如何在RedHat Linux AS4+Oracle 10G 手工創(chuàng)建數(shù)據(jù)庫？

水平低

環(huán)境描述：
RedHat Linux AS4 + oracle 10g，oracle軟件已經安裝

請教大家如何手工創(chuàng)建數(shù)據(jù)庫，不使用DBCA，十分感謝。

lzj65166

create database mydb;

水平低

然后呢？

水平低

自己頂頂！

kekexili_mao

$su - oracle
1．設置系統(tǒng)環(huán)境變量：
ORACLE_HOME=/home/oracle/product/10.2.0 ORACLE_BASE=/home/oracle
2．系統(tǒng)規(guī)劃：
實例名稱ORACLE_SID=test
數(shù)據(jù)庫名稱：test
3．手工創(chuàng)建如下目錄：
/home/oracle/admin/test/cdump
/home/oracle/admin/test/bdump
/home/oracle/admin/test/udump
/home/oracle/admin/test/pfile
/home/oracle/oradata/test
4．建立密碼文件：
/home/oracle/product/10.2.0/bin/orapwd  file=/home/oracle/product/10.2.0/dbs/orapwtest password=test
5．修改參數(shù)文件：
格式：/home/oracle/product/10.2.0/dbs/init.ora
實例：/ home/oracle/product/10.2.0/dbs/inittest.ora
內容如下：
large_pool_size=4194304
shared_pool_size=48265318
core_dump_dest='/home/oracle/admin/test/cdump'
db_block_size=8192
db_domain='com'
db_file_multiblock_read_count=16
db_name='test'
db_recovery_file_dest='/home/oracle/flash_recovery_area'
db_recovery_file_dest_size=2147483648
dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)'
job_queue_processes=10
open_cursors=300
pga_aggregate_target=12777216
processes=150
undo_management='auto'
undo_tablespace='undotbs1'
user_dump_dest='/home/oracle/admin/test/udump'
NLS_DATE_FORMAT="Mon DD YYYY HH24:MI:SS"
NLS_DATE_LANGUAGE=AMERICAN
6．設置當前工作實例：
export ORACLE_SID=test
7．登陸oracle：
>sqlplus “/ as sysdba”
8．啟動實例：
SQL>startup nomount
9．創(chuàng)建數(shù)據(jù)庫的腳本：
create database test
logfile group 1 '/home/oracle/oradata/test/redo01.log' size 10m reuse,
group 2 '/home/oracle/oradata/test/redo02.log' size 10m reuse,
group 3 '/home/oracle/oradata/test/redo03.log' size 10m reuse
datafile '/home/oracle/oradata/test/test01.dbf' size 500m reuse
maxdatafiles 100
archivelog
character set UTF8
national character set UTF8
sysaux datafile '/home/oracle/oradata/test/sys01.dbf' size 230m autoextend on next 10m maxsize unlimited
undo tablespace undotbs1 datafile '/home/oracle/oradata/test/undo.dbf' size 100m
create temporary tablespace temp tempfile '/home/oracle/oradata/test/temp01.dbf'
size 100m autoextend on next 10m maxsize unlimited
create tablespace users datafile '/home/oracle/oradata/test/users01.dbf' size
500m autoextend on next 10m maxsize unlimited;
create user test identified by test default tablespace users;
grant connect,resource to test;
create tablespace rbs datafile '/home/oracle/oradata/test/rbs01.dbf' size 200m
reuse autoextend on next 5m
create tablespace tools datafile '/home/oracle/oradata/test/tools01.dbf' size
64m reuse autoextend on next 320k
create tablespace indx datafile '/home/oracle/oradata/test/indx01.dbf' size
32m reuse autoextend on next 1280k
create public rollback segment rbs0 tablespace rbs storage (optimal 4096k)
create public rollback segment rbs1 tablespace rbs storage (optimal 4096k)
create public rollback segment rbs2 tablespace rbs storage (optimal 4096k)
create public rollback segment rbs3 tablespace rbs storage (optimal 4096k)
alter rollback segment "rbs0" online
alter rollback segment "rbs1" online
alter rollback segment "rbs2" online
alter rollback segment "rbs3" online
10．運行如下文件：
/home/oracle/product/10.2.0/rdbms/admin/catalog.sql
/home/oracle/product/10.2.0/rdbms/admin/catproc.sql

xn_sung

用dbca生成腳本，然后存起來以后備用，當作模版呵呵

remen

從網上找一個create db的腳本，簡單修改一下，手工創(chuàng)建db不得了

水平低

十分感謝kekexili_mao ，測試中

kekexili_mao

我也是剛剛開始學習，以后可以相互探討一下，^_^