手工创建数据库 一、相关信息
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
