windows下手工建库

时间:2021-04-01 08:40:03

创建实例
C:\Users\Administrator>oradim -new -sid tan02 -syspwd system -startmode manual

在C:\oracle\product\10.2.0\db_1\database增加INITTAN02.ora文件
db_name=tan02
sga_target=100m
sga_max_size=100m
instance_name=tan02
compatible='10.2.0.1.0'
control_files='C:\oracle\tan02/ora_control1','C:\oracle\tan02/ora_control2'
db_create_file_dest='C:\oracle\tan02/'
global_names=TRUE

建库
SQL>startup nomount

CREATE DATABASE tan02
   USER SYS IDENTIFIED BY pz6r58
   USER SYSTEM IDENTIFIED BY y1tz5p
   LOGFILE GROUP 1 ('C:\oracle\tan02\redo01.log') SIZE 100M,
           GROUP 2 ('C:\oracle\tan02\redo02.log') SIZE 100M,
           GROUP 3 ('C:\oracle\tan02\redo03.log') SIZE 100M
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 100
   MAXINSTANCES 1
   CHARACTER SET US7ASCII
   NATIONAL CHARACTER SET AL16UTF16
   DATAFILE 'C:\oracle\tan02\system01.dbf' SIZE 325M REUSE
   EXTENT MANAGEMENT LOCAL
   SYSAUX DATAFILE 'C:\oracle\tan02\sysaux01.dbf' SIZE 325M REUSE
   DEFAULT TABLESPACE tbs_1
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE 'C:\oracle\tan02\temp01.dbf'
      SIZE 20M REUSE
   UNDO TABLESPACE undotbs
      DATAFILE 'C:\oracle\tan02\undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;


执行数据字典脚本
SQL> @?/rdbms/admin/catalog.sql;
SQL> @?/rdbms/admin/catproc.sql;