创建实例
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;