資源描述：
《手動創(chuàng)建oracle數(shù)據(jù)庫實例.doc》由會員上傳分享，免費在線閱讀，更多相關內(nèi)容在工程資料-天天文庫。
1、數(shù)據(jù)庫：Oracle?9i安裝路徑：C:Oracle1、手工創(chuàng)建相關目錄C：OracleadminWebC：OracleadminwebbdumpC：OracleadminwebudumpC：OracleadminwebcdumpC：OracleadminwebpfileC：OracleadminwebcreateC：OracleoradatawebC：Oracleoradatawebarchive2、手工創(chuàng)建初始化參數(shù)文件c:oracleadminwebpfileinit.ora，內(nèi)容可以copy別的實例in
2、it.ora文件后修改。3、手工創(chuàng)建initweb.ora文件，內(nèi)容：file=c:oracleadminwebpfileinit.ora4、使用orapwd.exe命令，創(chuàng)建口令文件pwdweb.ora,命令格式如下：??orapwdfile=c:oracleora90databasepwdweb.ora??password=ltjsb??entries=5?5、通過oradim.exe命令，在服務里生成一個新的實例管理服務，啟動方式為手工setORACLE_SID=webC:oracleora90binoradim-new??-sidWEB-start
3、modem-pfileC:oracleora90databaseinitweb.ora6、創(chuàng)建數(shù)據(jù)庫，執(zhí)行createdb.sql腳本命令，?SQL>sqlplus/nologSQL>connectSYS/change_on_installasSYSDBASQL>@Createdb.sqlCreatedb.sql腳本內(nèi)容如下：setechoonspoolC:oracleadminmydbcreateCreateDB.logstartupnomountpfile="C:oracleadminwebpfileinit.ora";CREATEDATABASEw
4、ebMAXINSTANCES1MAXLOGHISTORY1MAXLOGFILES5MAXLOGMEMBERS5MAXDATAFILES100DATAFILE'C:oracleoradatawebsystem01.dbf'SIZE325MREUSEAUTOEXTENDONNEXT??10240KMAXSIZEUNLIMITEDUNDOTABLESPACE"UNDOTBS"DATAFILE'C:oracleoradatawebundotbs01.dbf'SIZE200MREUSEAUTOEXTENDONNEXT??5120KMAXSIZEUNLIMITEDCHARACT
5、ERSETZHS16GBKNATIONALCHARACTERSETAL16UTF16LOGFILEGROUP1('C:oracleoradatawebredo01.log')SIZE100M,GROUP2('C:oracleoradatawebredo02.log')SIZE100M,GROUP3('C:oracleoradatawebredo03.log')SIZE100M;spooloffexit;注：創(chuàng)建數(shù)據(jù)庫時，執(zhí)行sql.bsqj腳本命令，此腳本命令創(chuàng)建如下內(nèi)容：??創(chuàng)建控制文件和聯(lián)機日志文件??創(chuàng)建數(shù)據(jù)庫系統(tǒng)表空system??在system表空
6、間上創(chuàng)建system系統(tǒng)回滾段??創(chuàng)建sys和system賬號??創(chuàng)建基表和簇??創(chuàng)建數(shù)據(jù)字典表、索引和序列??創(chuàng)建相關角色權(quán)限7、創(chuàng)建數(shù)據(jù)庫數(shù)據(jù)文件，執(zhí)行腳本createfiles.sqlSQL>sqlplus/nologSQL>connectSYS/change_on_installasSYSDBASQL>@createfiles.sqlCreatefiles.sql腳本內(nèi)容如下：setechoonspoolC:oracleadminmydbcreateCreateDBFiles.logCREATETABLESPACE"INDX"LOGGINGDATAFILE'C:
7、oracleoradatawebindx01.dbf'SIZE25MREUSEAUTOEXTENDONNEXT??1280KMAXSIZEUNLIMITEDEXTENTMANAGEMENTLOCAL;CREATETEMPORARYTABLESPACE"TEMP"TEMPFILE'C:oracleoradatawebtemp01.dbf'SIZE40MREUSEAUTOEXTENDONNEXT??640KMAXSIZEUNLIMITEDEXTENTMANA
