1、创建目录：D:\app\Administrator\oradata\myoraD:\app\Administrator\admin\myora（adump，dpdump，pfile，scripts）2、创建初始化参数文件：把这个路径下的D:\app\Administrator\admin\xbc\pfile叫“init.ora.10252011111850”的文件拷贝，然后后改名为“initmyora.ora”打开后修改以下内容：1、audit_file_dest=D:\app\Administrator\admin\myora\adump2、db_name=myoracontrol_files=("D:\app\Administrator\oradata\myora\control01.ctl","D:\app\Administrator\oradata\myora\control02.ctl","D:\app\Administrator\oradata\myora\control03.ctl")4、undo_tablespace=UNDOTBS1其它都不用改了3、设置环境变量：C:\>setoracle_sid=myora4、创建服务：C:\>oradim-new-sidmyora实例已创建。C:\>5、启动数据库：C:\>sqlplus/assysdbaSQL*Plus:Release11.1.0.6.0-Productionon星期二11月2918:17:052011Copyright(c)1982,2007,Oracle.Allrightsreserved.已连接到空闲例程。SQL>startupnomountORACLE例程已经启动。TotalSystemGlobalArea560771072bytesFixedSize1334548bytesVariableSize155189996bytesDatabaseBuffers398458880bytesRedoBuffers5787648bytesSQL>startC:\11数据库已创建。SQL>其中11.sql的内容为：createdatabasemyoradatafile'D:\app\Administrator\oradata\myora\system01.dbf'size350mautoextendonnext10240kextentmanagementlocalsysauxdatafile'D:\app\Administrator\oradata\myora\sysaux01.dbf'size120mundotablespaceundotbs1datafile'D:\app\Administrator\oradata\myora\undotbs1.dbf'size200mdefaulttemporarytablespacetemptbs1tempfile'D:\app\Administrator\oradata\myora\temp01.dbf'size20mlogfilegroup1('D:\app\Administrator\oradata\myora\redo01.log')size100m,group2('D:\app\Administrator\oradata\myora\redo02.log')size100m,group3('D:\app\Administrator\oradata\myora\redo03.log')size100m;6创建数据字典：SQL>startD:\app\Administrator\product\11.1.0\db_1\RDBMS\ADMIN\catalog.sql7、执行catproc创建包：SQL>startD:\app\Administrator\product\11.1.0\db_1\RDBMS\ADMIN\catproc.sql8、执行pupbld.sql脚本文件：SQL>connsystem/manager已连接。SQL>startD:\app\Administrator\product\11.1.0\db_1\sqlplus\admin\pupbld.sql9、创建spfile：SQL>createspfilefrompfile2/文件已创建。SQL>10、执行scott脚本创建scott模式：SQL>startD:\app\Administrator\product\11.1.0\db_1\RDBMS\ADMIN\scott.s