ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle建库过程详解

oracle建库过程详解

原创 Linux操作系统 作者:xmlct78 时间:2007-11-12 00:00:00 0 删除 编辑

DBCA生成脚本,数据库版本9.2.0.7.0,系统:WINDOWS2003 SP2

脚本路径:D:oracleadminlectscripts

建库脚本:lect.bat


1 创建目录

mkdir D:oracleadminlectbdump

mkdir D:oracleadminlectcdump

mkdir D:oracleadminlectcreate

mkdir D:oracleadminlectpfile

mkdir D:oracleadminlectudump

mkdir D:oracleora92database

mkdir D:oracleoradatalect

2 设置IBID

set ORACLE_SID=lect

3 创建系统服务

D:oracleora92binoradim.exe -new -sid lect -startmode a

4 创建密码文件PWDlect.ora

D:oracleora92binorapwd.exe file=D:oracleora92databasePWDlect.ora password=change_on_install

5 执行脚本CreateDB.sql创建数据库

5.1 以默认密码change_on_install登录

connect SYS/change_on_install as SYSDBA

5.2 设置输出CreateDB.log

set echo on

spool D:oracleora92assistantsdbcalogsCreateDB.log

5.3 根据init.ora这个pfile文件NOMOUNT数据库

startup nomount pfile="D:oracleadminlectscriptsinit.ora";

5.4 执行建库脚本创建数据库

CREATE DATABASE lect

MAXINSTANCES 1

MAXLOGHISTORY 1

MAXLOGFILES 5

MAXLOGMEMBERS 3

MAXDATAFILES 100

DATAFILE 'D:oracleoradatalectsystem01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED

EXTENT MANAGEMENT LOCAL

DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'D:oracleoradatalecttemp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED

UNDO TABLESPACE "UNDOTBS1" DATAFILE 'D:oracleoradatalectundotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED

CHARACTER SET ZHS16GBK

NATIONAL CHARACTER SET AL16UTF16

LOGFILE GROUP 1 ('D:oracleoradatalectredo01.log') SIZE 102400K,

GROUP 2 ('D:oracleoradatalectredo02.log') SIZE 102400K,

GROUP 3 ('D:oracleoradatalectredo03.log') SIZE 102400K;

6 执行脚本CreateDBFiles.sql创建数文件

6.1 SYS用户登录

connect SYS/change_on_install as SYSDBA

6.2 设置输出CreateDBFiles.log

set echo on

spool D:oracleora92assistantsdbcalogsCreateDBFiles.log

6.3 执行建立数据文件脚本

CREATE TABLESPACE "DRSYS" LOGGING DATAFILE 'D:oracleoradatalectdrsys01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;

CREATE TABLESPACE "INDX" LOGGING DATAFILE 'D:oracleoradatalectindx01.dbf' SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;

CREATE TABLESPACE "TOOLS" LOGGING DATAFILE 'D:oracleoradatalecttools01.dbf' SIZE 10M REUSE AUTOEXTEND ON NEXT 320K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;

CREATE TABLESPACE "USERS" LOGGING DATAFILE 'D:oracleoradatalectusers01.dbf' SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;

CREATE TABLESPACE "XDB" LOGGING DATAFILE 'D:oracleoradatalectxdb01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;

7 执行脚本CreateDBCatalog.sql

7.1 SYS用户登录

connect SYS/change_on_install as SYSDBA

7.2 设置输出CreateDBFiles.log

set echo on

spool D:oracleora92assistantsdbcalogs CreateDBCatalog.log

7.3 执行脚本catalog.sql建立数据字典(必须)

@D:oracleora92rdbmsadmincatalog.sql;

7.4 执行脚本catexp7.sql,解决不同版本EXP问题(可选)

@D:oracleora92rdbmsadmincatexp7.sql;

7.5 执行脚本catblock.sql(可选)

@D:oracleora92rdbmsadmincatblock.sql;

7.6 执行脚本catproc.sql,建立PL/SQL功能的使用环境(必须)

@D:oracleora92rdbmsadmincatproc.sql;

7.7 执行脚本catblock.sqlowminst.plb(可选)

@D:oracleora92rdbmsadmincatoctk.sql;

@D:oracleora92rdbmsadminowminst.plb;

7.8 SYSTEM用户登录系统

connect SYSTEM/manager

7.9 执行脚本pupbld.sql,创建产品用户配置文件” (Product User Profile) 表以及相关的过程(必须)

@D:oracleora92sqlplusadminpupbld.sql;

7.10 SYSTEM用户登录系统

connect SYSTEM/manager

7.11 设置输出sqlPlusHelp.log

spool D:oracleora92assistantsdbcalogssqlPlusHelp.log

7.12 执行脚本hlpbld.sqlhelpus.sql,建立SQL*Plus的帮助信息(可选)

@D:oracleora92sqlplusadminhelphlpbld.sql helpus.sql;

8 执行其他脚本安装一些附加的选项(可选)

D:oracleora92binsqlplus /nolog @D:oracleadminlectscriptsJServer.sql

D:oracleora92binsqlplus /nolog @D:oracleadminlectscriptsordinst.sql

D:oracleora92binsqlplus /nolog @D:oracleadminlectscriptsinterMedia.sql

D:oracleora92binsqlplus /nolog @D:oracleadminlectscriptscontext.sql

D:oracleora92binsqlplus /nolog @D:oracleadminlectscriptsxdb_protocol.sql

9 执行脚本postDBCreation.sql

9.1 SYS用户登录

connect SYS/change_on_install as SYSDBA

9.2 设置输出postDBCreation.log

set echo on

spool D:oracleora92assistantsdbcalogspostDBCreation.log

9.3 执行脚本utlrp.sql,编译所有对象

@D:oracleora92rdbmsadminutlrp.sql;

9.4 关闭数据库

shutdown ;

9.5 SYS用户登录

connect SYS/change_on_install as SYSDBA

9.6 设置输出postDBCreation.log

set echo on

spool D:oracleora92assistantsdbcalogspostDBCreation.log

9.7 根据PFILE建立SPFILE

create spfile='D:oracleora92databasespfilelect.ora' FROM pfile='D:oracleadminlectscriptsinit.ora';

9.8 启动数据库

startup ;

10 建库脚本

26143-Scripts.rar

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

上一篇: ORACLE启动步骤
请登录后发表评论 登录
全部评论

注册时间:2007-12-06

  • 博文量
    16
  • 访问量
    66768