手工创建数据库

                                                                          手工创建数据库
一、相关信息

1.手动创建数据库的步骤
 1.创建相关目录
 2.创建初始化参数文件
 3.创建口令文件
 4.创建oracle实例
 5.连接实例
 6.启动实例到nomount状态
 7.创建数据库
 8.创建表空间
 9.创建数据字典
 10.创建EM档案库(可选)
 11.创建服务器参数文件(可选)

2.相关目录
 adump:存放相关审计信息的文件。
 bdump:存放相关后台进程信息的文件，如:alter.log.
 cdump:存放核心低级文件。
 create:存放创建数据库的脚本。
 dpdump:数据棒导出的默认路径
 pfile:启动数据库的初始化文件
 udump:用户进程文件。

 

二、创建过程

 1.创建相关目录
  mkdir d:/oracle/admin/lcc/adump
  mkdir d:/oracle/admin/lcc/bdump
  mkdir d:/oracle/admin/lcc/cdump
  mkdir d:/oracle/admin/lcc/dpdump
  mkdir d:/oracle/admin/lcc/udump
  mkdir d:/oracle/admin/lcc/create
  mkdir d:/oracle/admin/lcc/pfile
  mkdir d:/oracle/oradata/lcc

 

 2.创建初始化参数文件
  1.从d:/oracle/product/10.2.0/db_1/admin/sample/pfile目录下将系统自带的
一个sample初始化参数文件initsmple.ora,修改后，命名为init.ora存放到d:/oracle/admin/lcc/pfile目录下。
  2.在d:/oracle/product/10.2./db_1/database目录下创建文件initlcc.ora里面的内容为:IFILE='d:/oracle/admin/lcc/pfile/init.ora'

 

 3.设定环境变量(cmd)
   set ORA_BASE=d:/oracle
   set ORA_HOME=d:/oracle/product/10.2.0/db_1
   set oracle_sid=lcc
 

 4.创建口令文件(cmd)
   orapwd file=d:/oracle/product/10.2.0/db_1/database/pwdlcc.ora password=root force=y

 

 5.创建oracle实例服务(cmd)
   oradim -new -sid lcc -startmode manual -pfile d:/oracle/admin/lcc/pfile/init.ora  
 
 6.建立listener.ora,tnsnames.ora和sqlnet.ora
  
 7.连接数据库到nomount状态

 8.创建数据库
  create database lcc
  datafile 'd:/oracle/oradata/lcc/system01.dbf' size 250M
  reuse autoextend on next 25M maxsize unlimited
  extent management local
  sysaux datafile 'd:/oracle/oradata/lcc/sysaux01.dbf' size 120M
  reuse autoextend on next 10240K maxsize unlimited
  smallfile default temporary tablespace temp tempfile
  'd:/oracle/oradata/lcc/temp01.dbf' size 200M
  reuse autoextend on next 20M maxsize unlimited
  smallfile undo tablespace "UNDOTBS1' datafile
  'd:/oracle/oradata/lcc/undotbs01.dbf' size 200M
  reuse autoextend on next 20M maxsize unlimited
  charactor set AL32UTF8
  national charactor set AL16UTF16
  logfile group 1 <'d:/oracle/oradata/lcc/redo01.log'> size 10M
  group 2 <'d:/oracle/oradata/lcc/redo02.log'> size 10M
  group 3 <'d:/oracle/oradata/lcc/redo03.log'> size 10M
  user sys identified by root user system identified by manager;

 

9.创建表空间
 ①
  create smallfile tablespace "USERS" logging datafile
  'd:/oracle/oradata/lcc/user01.dbf' size 25M
  reuse autoextend on next 15M maxsize unlimited
  extent management local segment space management auto;

 ②
  alter database default tablespace "USERS";

 ③
  create smalllfile table "EXAMPLE" logging datafile
 'd:/oracle/oradata/lcc/example01.dbf' size 200M
   reuse autoextend on next 15M maxsize unlimited
  extent management local segment space management auto;
 
10.创建数据字典
  @d:/oracle/product/10.2.0/db_1/rdbms/admin/catalog.sql;
  @d:/oracle/product/10.2.0/db_1/rdbms/admin/catblock.sql;
  @d:/oracle/product/10.2.0/db_1/rdbms/admin/catproc.sql;
  @d:/oracle/product/10.2.0/db_1/rdbms/admin/catoctk.sql;
  @d:/oracle/product/10.2.0/db_1/rdbms/admin/owminst.plb;

 conn system/manager@lcc
 @d:/oracle/product/10.2.0/db_1/sqlplus/admin/pubbld.sql;
 
 conn system/manager@lcc
 @d:/oracle/product/10.2.0/db_1/sqlplus/admin/help/hlpbld.sql helpus.sql;

 

11.创建em档案库
 conn sys/root as sysdba
 @d:/oracle/product/10.2.0/db_1/sysman/admin/emdrep/emreposcre d:/oracle/product/10.2.0/db_1 sysman root temp on;
 whenever sqlerror continue;
 shutdown immeidate
 startup
 alter user sysman identified by root account unlock;
 alter user dbsnmp identified by root account unlock;
 select 'utl_recomp_begin: ' || to_char(sysdata,'HH:MI:SS') from dual;
 execute utl_recomp.recomp_serial();

 

12.创建DBControl
SQL>host d:/oracle/product/10.2.0/db_1/bin/emca.bat -config dbcontrol db -silent -DB_UNIQUE_NAME lcc -PORT 1521
    -EM_HOME d:/product/10.2.0/db_1 -LISTENER LISTENER -SERVICE_NAME lcc -SYS_PWD root -SID lcc -ORACLE_HOME
    d:/oracle/product/10.2.0/db_1 -DBSNMP_PWD root -LISTENER_OH d:/oracle/product/10.2.0/db_1 -LOG_FILE
    d:/lcc_DB/emConfig.log -SYSMAN_PWD root