Linux下手工创建Oracle10g数据库

1、linux下手工创建oraclelog数据库在linux下虽然通过dbca也可以创建数据库，但是在某些环境下却是不能使用 图形环境，如数据库服务器在机房，并口开放的端口有限制，或者需要批量创建 数据库。那么，这个时候为了方便就不得不使用手工创建数据库了。以下是创建 数据库的步骤：操作系统：centos 5 （安装的时候，修改/etc/redhat-real*输入redhat enterprise 4）数据库：oracle 10g环境：己经使用dbca创建了数据库orclooracle用户所属组为：oracle, dbaoracle_base=/home/oraclc/orac1e/oracle

2、_home=$oracle_base/db1oraclesid二testoracle_owner二oraclenls_lang二'simplified chinese_china，dbjome=/homc/oraclc/oradata步骤：1、创建pfile文件使用sqlplus sys/orclorcl as sysdba登陆orcl数据库环境,使用命令 create pfile from spfile; 创建 pfile 文件再到系统下到$oracle_home/dbs/目录中使用命令cp initorcl.ora inittest.ora或者直接在系统下到$oracle_home

3、/dbs/目录中使用命令strings spfilcorc1.ora >inittest.ora完成后，修改inittest. ora文件,将orcl替换为test2、创建密码文件cd $oracle_home/dbs/orapwd file=orapwtcst password二test3、创建目录mkdir -p $0racle base/adm i n/1es tcd $oracle_base/admi n/testmkdir adump bdump cdump dpdump pfilemkdir -p $db_home/test 4、修改监听程序 vi $ oraclehome/

4、network/adm i n/1 n s name s. ora 将其中orcl部分复制粘贴，并且修改其名称为test5、开始创建数据库export oracle_sid二test sqlplus /nolog conn / as sysdba spool $oracle_base/admin/$oracle_sid/create/createdb startup nomountcreate database testlogfilegroup 1 (' $db_h0me/test/redo01. log，,9 $0racle_base/oradata/test/redo01_l. l

5、og*) size 100m reuse,group 2 (' $db_h0me/test/redo02. log，,'$db_h0me/test/redo02_l log') size 100m reuse,group 3 ('$db_h0me/oradata/test/redo03. log，,，$db_h0me/test/redo03_l. log，) size 100m reusemaxlogfiles 50maxlogmembers 5maxlogiiistory 200maxdatafiles 500maxinstances 5archivelogc

6、haracter set utf8national character set utf8datafile ' $db_h0me/test/system01. dbf size 1000m extent management local sysaux datafile '$db_h0me/test/sysaux01. dbf size 1000mundo tablespace undotbs1 datafile * $db_home/test/undo. dbf，size 500mdefault temporary tablespace temp tempftle'$db

7、j10me/tcst/tcmp. dbf size 500m等待一定时间，如果没有问题会显示数据库创建成功注意undo tablespace undotbs1中的名字，需要和inittest.ora中的名字一样。$oracle_home/rdbms/admin/catalog. sql;$oracle_home/rdbms/admin/catproc, sql;$oracle_home/rdbms/admin/catdbsyn. sql;al ter user system i dentified by test;grant sysdba to system;shutdown immediat

8、e;startup;spool offexit使用system用户登陆sqlplus system/test$oracle home/sqlplus/admin/pupbld. sqlexit数据库创建完成。如果遇到问题，可以查看日志$oracle_base/admin/$oracle_sid/create/crcatcdb下面记录一下windows上面的实例参考一下手工创建数据库的全部脚本及说明系统环境：1、操作系统:windows 2000 server,机器内存 128m2、数据库：omclc 8i r2 (&1.6) for nt 企业版3、安装路径:d: oracle建库步骤

9、：1、手工创建相关目录d:0raclcadmintcstd:oracleadmintestadhoc d:oracleadmintestbdumpd:0racleadmintestcdumpd:0racleadmintestcreated:0raclcadmintcstcxpd:oracleadmintestpfile d:oracleadmintestudumpd:oracleoradatatestd:oracleoradatatestarchive 2、手工创建初始化启动参数文件:d:oracleadmintestpfileinittest. ora, 内容：3、手工创建 d:0racle

10、0ra81databaseinittest. ora 文件, 内容：ifile二'd:oracleadmintestpfileinittest. ora,4、使用 orapwd. exe 命令，创建 d:0racle0ra81databasepwdtest. ora 命令：d: 0rac 1 e0ra81 binorapwdfi1e=d:0racle0ra81databasepwdtest. ora password二oracle entries二55、通过oradim.exe命令，在服务里生成一个新的实例管理服务，启动方式为手 工set oraclesid二testd:0racle0

11、ra81binoradim -new -sid test -startmode manual -pfile"d:oraclcadmintcstpfilcinittcst ora''6、生成各种数据库对象d:>svrmgrl-创建数据库connect internal/oraclestartup nomount pfile=,> d:oracleadmintestpfileinittest. oracreate database testlogfile "d:0racleor8d8teitestredo01.log' size 2048k,

12、'd:0raclcoradatatcstrcdo02. log, size 2048k,'d:0racleoradatatestredo03. log, size 2048kmaxlogfiles 32maxlogmembers 2maxloghtstory 1datafile d:0raclcoradatatcstsystcm01. dbfj size 58m reuseautoextend on next 640kmaxdatafiles 254maxinstances 1character set zhs16gbknational character set al16ut

13、f16;控制文件、日志文件在上面语句执行时生成connect internal/orac1e-修改系统表空间alter tablespace system default storage ( initial 64k next 64k minextents1 maxextents unlimited pct1ncrease 50);alter tablespace system minimum extent 64k;-创建冋滚表空间create tablespace rbs datafile d:0raclcoradatatcstrbs01. dbfjsize 256m reuseautoext

14、end on next 5120kminimum extent 512kdefault storage ( initial 512k next 512k mtnextents 8 maxextents 4096);-创建用户表空间create tablespace users dataftle d: 0racleoradatatestusers01. dbf'size 128m reuseautoextend on next 1280kminimum extent 128kdefault storage ( initial 128k next 128k minextents 1 max

15、extents 4096 pctincrease 0);-创建临时表空间create tablespace temp datafile 'd:0mcleoraclatatesttemp01.clbf'size 32m reuseautoextend on next 640kminimum extent 64kdefault storage ( initial 64k next 64k minextents 1 maxextents unlimitedpctincrease 0) temporary;-创建工具表空间create tablespace tools dataftle

16、 d: 0rac 1 eoradatatesttoo 1 so 1. dbf'size 64m reuseautoextend on next 320kminimum extent 32kdefault storage ( initial 32k next 32k minextents 1 maxextents 4096 pctincrease 0);-创建索引表空间create tablespace indx datafile d:0racleoradatatestindx01. dbf,size 32m reuseautoextend on next 1280kminimum ex

17、tent 128kdefault storage ( initial 128k next 128k minextents 1 maxextents 4096 pctincrease 0);-创建冋滚段 create public 4096k );create public 4096k );create public 4096k );create public 4096k );create publicrollbackrollbackrollbackrollbackrollbacksegmentsegmentsegmentsegmentsegmentrbsorbs1rbs2rbs3rbs4tab

18、lespacetablespacetablespacetablespacetablespacerbsrbsrbsrbsrbsstorage ( optimalstorage ( optimalstorage ( optimalstorage ( optimalstorage ( optimal4096k );create public 4096k );create public 4096k );create public 4096k );create public 4096k );create public 4096k );rollback segmentrollback segmentrol

19、lback segmentrollback segmentrbs5rbs6rbs7rbs8tablespacetablespacetablespacetablespacerbsrbsrbsrbsstorage (storage (storage (storage (storage (create public rollback segment rbs10 tablespace rbs storage4096k );create public rollback segment rbs11 tablespace rbs storage4096k );create public rollback s

20、egment rbs12 tablespace rbs storage4096k );create public rollback segment rbs13 tablespace rbs storage4096k );create public rollback segment rbs14 tablespace rbs storage4096k );create public rollback segment rbs15 tablespace rbs storage4096k );create public rollback segment rbs16 tablespace rbs stor

21、age4096k );create public rollback segment rbs17 tablespace rbs storage4096k );create public rollback segment rbs18 tablespace rbs storage4096k );create public rollback segment rbs19 tablespace rbs storage4096k );create public rollback segment rbs20 tablespace rbs storage4096k );create public rollbac

22、k segment rbs21 tablespace rbs storage4096k );create public rollback segment rbs22 tablespace rbs storage4096k );create public rollback segment rbs23 tablespace rbs storage4096k );create public rollback segment rbs24 tablespace rbs storage4096k );rollbacksegmentrbs9tablespacerbsoptimaloptimaloptimal

23、optimaloptimal(optimal(optimal(optimal(optimal(optimal(optimal(optimal(optimal(optimal(optimal(optimal(optimal(optimal(optimal(optimal-使lh|滚段在线alter rollback segment “rbso"alter rollback segment “rbs1"online;online;alter rollback segment“rbs2"online;alter rollback segment“rbs3"on

24、line;alter rollback segment“rbs4”onltne;alter rollback segment“rbs5"online;alter rollback segment“ rbs6”online;alter rollback segment“rbs7online;alter rollback segment“rbs8"online;alter rollback segment“rbs9"online;alter rollback segment“rbs1o"online;alter rollback segment“rbs11&

25、quot;online;alter rollback segment“rbs12"online;alter rollback segment“rbs13"online;alter rollback segment“rbs14"online;alter rollback segment“rbs15"online;alter rollback segment“rbs16"online;alter rollback segment“rbs17"online;alter rollback segment“rbs18"online;alter rollback segment“rbs19"online;alter rollbac