手工创建数据库(在oracle 11g中).pdf

《手工创建数据库(在oracle 11g中).pdf》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、1、创建目录：D:appAdministratororadatamyoraD:appAdministratoradminmyora（adump，dpdump，pfile，scripts）2、创建初始化参数文件：把这个路径下的D:appAdministratoradminxbcpfile叫“init.ora.10252011111850”的文件拷贝，然后后改名为“initmyora.ora”打开后修改以下内容：1、audit_file_dest=D:appAdministratoradminmyoraadump2、db_name=m

2、yoracontrol_files=("D:appAdministratororadatamyoracontrol01.ctl","D:appAdministratororadatamyoracontrol02.ctl","D:appAdministratororadatamyoracontrol03.ctl")4、undo_tablespace=UNDOTBS1其它都不用改了3、设置环境变量：C:>setoracle_sid=myora4、创建服务：C:>oradim-new-sidmyora实例已创建。C:>5、启动数据库：C

3、:>sqlplus/assysdbaSQL*Plus:Release11.1.0.6.0-Productionon星期二11月2918:17:052011Copyright(c)1982,2007,Oracle.Allrightsreserved.已连接到空闲例程。SQL>startupnomountORACLE例程已经启动。TotalSystemGlobalArea560771072bytesFixedSize1334548bytesVariableSize155189996bytesDatabaseBuffers398458880bytesRedoBuffer

4、s5787648bytesSQL>startC:11数据库已创建。SQL>其中11.sql的内容为：createdatabasemyoradatafile'D:appAdministratororadatamyorasystem01.dbf'size350mautoextendonnext10240kextentmanagementlocalsysauxdatafile'D:appAdministratororadatamyorasysaux01.dbf'size120mundotablespaceundotbs1datafile'D:app

5、Administratororadatamyoraundotbs1.dbf'size200mdefaulttemporarytablespacetemptbs1tempfile'D:appAdministratororadatamyoratemp01.dbf'size20mlogfilegroup1('D:appAdministratororadatamyoraredo01.log')size100m,group2('D:appAdministratororadatamyoraredo02.log')size100m,group

6、3('D:appAdministratororadatamyoraredo03.log')size100m;6创建数据字典：SQL>startD:appAdministratorproduct11.1.0db_1RDBMSADMINcatalog.sql7、执行catproc创建包：SQL>startD:appAdministratorproduct11.1.0db_1RDBMSADMINcatproc.sql8、执行pupbld.sql脚本文件：SQL>connsystem/manager已连接。SQL>startD:a

7、ppAdministratorproduct11.1.0db_1sqlplusadminpupbld.sql9、创建spfile：SQL>createspfilefrompfile2/文件已创建。SQL>10、执行scott脚本创建scott模式：SQL>startD:appAdministratorproduct11.1.0db_1RDBMSADMINscott.sql11、测试新建数据库：SQL>setlinesize300SQL>setpagesize3000SQL>connscott/tigerSQL>select*from