分类：
2008-10-16 19:09:34
1.create and start services
oradim -new -sid wwj -startmode manual
2.create database
set ORACLE_SID=wwj
C:\Documents and Settings\Administrator>sqlplus /nolog
SQL> conn /as sysdba
已连接到空闲例程。
SQL> startup nomount pfile='D:\oracle\wwj\pfile\initwwj.ora';
CREATE DATABASE wwj
USER SYS IDENTIFIED BY sys
USER SYSTEM IDENTIFIED BY sys
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
DATAFILE 'D:\oracle\wwj\datafile1\system01.dbf' SIZE 325M
REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE 500M
SYSAUX DATAFILE 'D:\oracle\wwj\datafile1\sysaux01.dbf' SIZE 120M
REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE 500M
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE 'D:\oracle\wwj\datafile1\temp01.dbf' SIZE 200M REUSE EXTENT MANAGEMENT LOCAL
UNDO TABLESPACE undotbs1
DATAFILE 'D:\oracle\wwj\datafile1\undotbs01.dbf' SIZE 100M
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('D:\oracle\wwj\onlinelog\redo01a.log',
'D:\oracle\wwj\onlinelog\redo01b.log') SIZE 50M,
GROUP 2 ('D:\oracle\wwj\onlinelog\redo02a.log',
'D:\oracle\wwj\onlinelog\redo02b.log') SIZE 50M,
GROUP 3 ('D:\oracle\wwj\onlinelog\redo03a.log',
'D:\oracle\wwj\onlinelog\redo03b.log') SIZE 50M;
3.create extra tablespaces
CREATE TABLESPACE tools
DATAFILE 'D:\oracle\wwj\datafile1\tools01.dbf' SIZE 200M;
CREATE TABLESPACE users LOGGING
DATAFILE 'D:\oracle\wwj\datafile1\users01.dbf' SIZE 100M
orapwd file=D:\oracle\product\10.2.0\db_1\dbs\orapwwj password=sys entries=10
4.create the database objects
CONNECT SYS/password AS SYSDBA
$ORACLE_HOME/rdbms/admin/
@ catalog.sql
@ catblock.sql
@ catproc.sql
@ catoctk.sql
@ owminst.plb
system/
@ $ORACLE_HOME/sqlplus/admin/pupbld.sql
@ $ORACLE_HOME/sqlplus/admin/help/hlpbld.sql helpus.sql
grant select on sys.dba_data_files to system;
5.
SQL> create spfile from pfile='D:\oracle\wwj\pfile\initwwj.ora';
