9版本的操作记录，有时间在11版本上试试

1、创建PFILE

CREATE PFILE='d:\TEMP\initORABJ.ora' FROM SPFILE;

修改目录

2、生成CONTROLFILE , Let Oracle to write SQL statements to a trace file  udump目录

ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

3、编辑TRACE文件内容，类似以下内容

STARTUP NOMOUNT

CREATE CONTROLFILE set DATABASE "ORABJ" RESETLOGS  NOARCHIVELOG

--  SET STANDBY TO MAXIMIZE PERFORMANCE

    MAXLOGFILES 5

    MAXLOGMEMBERS 3

    MAXDATAFILES 100

    MAXINSTANCES 1

    MAXLOGHISTORY 170

LOGFILE

  GROUP 1 'D:\ORACLE\ORADATA\ORABJ\REDO01.LOG'  SIZE 100M,

  GROUP 2 'D:\ORACLE\ORADATA\ORABJ\REDO02.LOG'  SIZE 100M,

  GROUP 3 'D:\ORACLE\ORADATA\ORABJ\REDO03.LOG'  SIZE 100M

-- STANDBY LOGFILE

DATAFILE

  'D:\ORACLE\ORADATA\ORABJ\SYSTEM01.DBF',

  。。。

CHARACTER SET ZHS16GBK

;

# Recovery is required if any of the datafiles are restored backups,

# or if the last shutdown was not normal or immediate.

RECOVER DATABASE

# Database can now be opened normally.

ALTER DATABASE OPEN resetlogs;

# Commands to add tempfiles to temporary tablespaces.

# Online tempfiles have complete space information.

# Other tempfiles may require adjustment.

ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\ORACLE\ORADATA\ORABJ\TEMP01.DBF'

     SIZE 180627456  REUSE AUTOEXTEND ON NEXT 657408  MAXSIZE 24575M;

# End of tempfile additions.

4、Create a Windows Service

WINNT> oradim -NEW -SID ORABJ -STARTMODE a

5、配置listener.ora tnsnames.ora

6、Create a Server Parameter File

CREATE SPFILE FROM PFILE='d:\TEMP\initORABJ.ora';

7、

set oracle_sid=orabj

orapwd file=D:\oracle\ora92\DATABASE\PWDorabj.ORA password=。。。 entries=30

8、执行第3步修改的命令