Oracle课程设计-手动创建数据库stu1 详细步骤附图文教程

1. Step1:手工创建相关目录

   C:oracleproduct10.2.0adminstu1adump

   C:oracleproduct10.2.0adminstu1dump

   C:oracleproduct10.2.0adminstu1cdump

   C:oracleproduct10.2.0adminstu1dpdump

   C:oracleproduct10.2.0adminstu1pfile

   C:oracleproduct10.2.0adminstu1udump

2. Step2:把C:oracleproduct10.2.0adminorclpfile文件拷贝到

   C:oracleproduct10.2.0adminstu1pfile,并把它重命名为:initstu1.ora,

   并把该参数文件里面的orcl全部替换成stu1。

   

3. 1.在cmd下执行下列命令设置操作系统环境变量。

   

   2.通过oradim.exe命令,在服务里生成一个新的实例管理服务,启动方式：

   

4. Step4：

   连接oracle实例

   启动一个空实例：

   

5. Step5：

   1.执行create database语句，创建数据库。

   2.创建附加表空间student表空间和indx表空间

   创建数据库语句

   create database stu1 

   user sys identified by tiger

   user system identified by tiger

   maxinstances 1

   maxloghistory 100

   maxlogfiles 5

   maxlogmembers 5

   maxdatafiles 100

   noarchivelog

   character set us7ascii

   logfile

   group 1('C:oracleproduct10.2.0oradatastu1 edo01.log') size 10M,

   group 2('C:oracleproduct10.2.0oradatastu1 edo02.log') size 10M,

   group 3('C:oracleproduct10.2.0oradatastu1redo03.log') size 10M

   extent management local

   datafile 'C:oracleproduct10.2.0oradatastu1system01.dbf'size 50M

   autoextend on next 512K maxsize unlimited

   sysaux datafile

   'C:oracleproduct10.2.0oradatastu1sysaux01.dbf' size 50M

   autoextend on next 512K maxsize unlimited

   default tablespace users datafile

   'C:oracleproduct10.2.0oradatastu1user01.dbf' size 20M

   autoextend on next 512K maxsize unlimited

   default temporary tablespace temp tempfile

   'C:oracleproduct10.2.0oradatastu1 emp01.dbf' size 10M

   autoextend on next 512K maxsize unlimited

   undo tablespace undotbs1 datafile

   'C:oracleproduct10.2.0oradatastu1undotbs01.dbf' size 10M

   autoextend on next 512K maxsize unlimited;

   创建表空间语句

   create tablespace student

   datafile 'c:oracleproduct10.2.0oradatastu1student01.dbf' size 25M

   autoextend on next 512K maxsize unlimited

   extent management local;

   create tablespace indx

   datafile 'c:oracleproduct10.2.0oradatastu1index01.dbf' size 25M

   autoextend on next 512K maxsize unlimited

   extent management local;

   

   

6. Step6：运行脚本创建数据字典视图（catalog.sql和catproc.sql）

   @C:ORACLEPRODUCT10.2.0DB_1RDBMSADMINCATALOG.SQL;

   @C:ORACLEPRODUCT10.2.0DB_1RDBMSADMINCATPROCSQL;

7. Step7：创建服务器初始化参数文件

   create spfile=’c:oracleproduct10.2.0db_1databasespfilestu1.ora’

   from pfile=’c:oracleproduct10.2.0adminstu1pfileinitstu1.ora’;

8. Step8：备份数据库，对数据库进行一次完全备份。

   冷备份和热备份自己选择。