手工创建oracle数据库脚本及说明
手工创建数据库的全部脚本及说明
系统环境：
1、操作系统：windows 2000 server，机器内存128m
2、数据库： oracle 8i r2 (8.1.6) for nt 企业版
3、安装路径：d:\oracle
建库步骤：
1、手工创建相关目录 d:\oracle\admin\test d:\oracle\admin\test\adhoc d:\oracle\admin\test\bdump d:\oracle\admin\test\cdump d:\oracle\admin\test\create d:\oracle\admin\test\exp d:\oracle\admin\test\pfile d:\oracle\admin\test\udump d:\oracle\oradata\test d:\oracle\oradata\test\archive
2、手工创建初始化启动参数文件：d:\oracle\admin\test\pfile\inittest.ora，内容：db_name = "test" instance_name = test service_names = test db_files = 1024 control_files = ("d:\oracle\oradata\test\control01.ctl", "d:\oracle\oradata\test\control02.ctl", "d:\oracle\oradata\test\control03.ctl") open_cursors = 200 max_enabled_roles = 30 db_file_multiblock_read_count = 8 db_block_buffers = 4096 shared_pool_size = 52428800 large_pool_size = 78643200 java_pool_size = 20971520 log_checkpoint_interval = 10000 log_checkpoint_timeout = 1800 processes = 115 parallel_max_servers = 5 log_buffer = 32768 max_dump_file_size = 10240 global_names = true oracle_trace_collection_name = "" background_dump_dest = d:\oracle\admin\test\bdump user_dump_dest = d:\oracle\admin\test\udump db_block_size = 16384 remote_login_passwordfile = exclusive os_authent_prefix = "" job_queue_processes = 4 job_queue_interval = 60 open_links = 4 distributed_transactions = 10 mts_dispatchers = "(protocol=tcp)(pre=oracle.aurora.server.sgiopserver)" mts_dispatchers = "(protocol=tcp)" compatible = 8.1.0 sort_area_size = 65536 sort_area_retained_size = 65536 # log_archive_start = true # log_archive_dest_1 = "location=d:\oracle\oradata\oradb\archive" # log_archive_format = %%oracle_sid%%t%ts%s.arc
3、手工创建d:\oracle\ora81\database\inittest.ora文件，
内容：ifile=’d:\oracle\admin\test\pfile\inittest.ora’
4、使用orapwd.exe命令，创建d:\oracle\ora81\database\pwdtest.ora
命令：d:\oracle\ora81\bin\orapwd file=d:\oracle\ora81\database\pwdtest.ora password=oracle entries=5
5、通过oradim.exe命令，在服务里生成一个新的实例管理服务，启动方式为手工
set oracle_sid=test
d:\oracle\ora81\bin\oradim -new -sid test -startmode manual -pfile "d:\oracle\admin\test\pfile\inittest.ora"
6、生成各种数据库对象
d:\ >svrmgrl
--创建数据库 connect internal/oracle startup nomount pfile="d:\oracle\admin\test\pfile\inittest.ora" create database test logfile ’d:\oracle\oradata\test\redo01.log’ size 2048k, ’d:\oracle\oradata\test\redo02.log’ size 2048k, ’d:\oracle\oradata\test\redo03.log’ size 2048k maxlogfiles 32 maxlogmembers 2 maxloghistory 1 datafile ’d:\oracle\oradata\test\system01.dbf’ size 58m reuse autoextend on next 640k maxdatafiles 254 maxinstances 1 character set zhs16gbk national character set zhs16gbk;
控制文件、日志文件在上面语句执行时生成
connect internal/oracle
--修改系统表空间
alter tablespace system default storage ( initial 64k next 64k minextents 1 maxextents unlimited pctincrease 50);
alter tablespace system minimum extent 64k;
--创建回滚表空间 create tablespace rbs datafile ’d:\oracle\oradata\test\rbs01.dbf’ size 256m reuse autoextend on next 5120k minimum extent 512k default storage ( initial 512k next 512k minextents 8 maxextents 4096);
--创建用户表空间 create tablespace users datafile ’d:\oracle\oradata\test\users01.dbf’ size 128m reuse autoextend on next 1280k minimum extent 128k default storage ( initial 128k next 128k minextents 1 maxextents 4096 pctincrease 0);
--创建临时表空间 create tablespace temp datafile ’d:\oracle\oradata\test\temp01.dbf’ size 32m reuse autoextend on next 640k minimum extent 64k default storage ( initial 64k next 64k minextents 1 maxextents unlimited pctincrease 0) temporary;
--创建工具表空间 create tablespace tools datafile ’d:\oracle\oradata\test\tools01.dbf’ size 64m reuse autoextend on next 320k minimum extent 32k default storage ( initial 32k next 32k minextents 1 maxextents 4096 pctincrease 0);
--创建索引表空间 create tablespace indx datafile ’d:\oracle\oradata\test\indx01.dbf’ size 32m reuse autoextend on next 1280k minimum extent 128k default storage ( initial 128k next 128k minextents 1 maxextents 4096 pctincrease 0);
--创建回滚段 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 ); create public rollback segment rbs4 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs5 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs6 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs7 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs8 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs9 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs10 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs11 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs12 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs13 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs14 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs15 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs16 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs17 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs18 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs19 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs20 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs21 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs22 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs23 tablespace rbs storage ( optimal 4096k ); create public rollback segment rbs24 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; alter rollback segment "rbs4" online; alter rollback segment "rbs5" online; alter rollback segment "rbs6" online; alter rollback segment "rbs7" online; alter rollback segment "rbs8" online; alter rollback segment "rbs9" online; alter rollback segment "rbs10" online; alter rollback segment "rbs11" 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 rollback segment "rbs20" online; alter rollback segment "rbs21" online; alter rollback segment "rbs22" online; alter rollback segment "rbs23" online; alter rollback segment "rbs24" online;
--修改sys用户的临时表空间为temp
alter user sys temporary tablespace temp;
--创建数据字典表 @d:\oracle\ora81\rdbms\admin\catalog.sql; @d:\oracle\ora81\rdbms\admin\catexp7.sql @d:\oracle\ora81\rdbms\admin\catproc.sql @d:\oracle\ora81\rdbms\admin\caths.sql connect system/manager @d:\oracle\ora81\sqlplus\admin\pupbld.sql connect internal/oracle @d:\oracle\ora81\rdbms\admin\catrep.sql exit
--生成sql*plus帮助系统
sqlplus system/manager
@d:\oracle\ora81\sqlplus\admin\help\helpbld.sql helpus.sql
exit
--修改system用户默认表空间和临时表空间
svrmgrl
connect internal/oracle
alter user system default tablespace tools;
alter user system temporary tablespace temp;
exit
7、将test实例启动服务设置成自动启动方式
d:\oracle\ora81\bin\oradim -edit -sid test -startmode auto
(完)
- Copyright © 2001- 2010 丰搜网 All Rights Reserved
- ICP备案编号:粤ICP备06052964号
关键字 本文所属关键字
相关 与本文相关文章
分类 所有文章关键字导航
源码编程相关
Java Asp PHP .Net XML C/C++ CGI VB Jsp J2ee J2se J2me EJB Servlet Tomcat Resin Struts Weblogic Eclipse ANT GUI JMS Web servise IDEA Webphere Hibernate Spring Jboss Applet Swing Socket Javamail Perl Ajax P2P 安全 模式 框架 测试 开源 游戏
操作系统/服务器相关
Windows XP Windows 2000 Windows 2003 Windows Me Windows 9.x Linux UNIX 注册表 操作系统 服务器 应用服务器
标准 网站致力的规范
