欢迎来到天天文库
浏览记录
ID:52311702
大小:96.92 KB
页数:3页
时间:2020-03-26
《手工创建数据库(在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
此文档下载收益归作者所有