Oracle11G在Linux上手動創(chuàng)建數(shù)據(jù)庫.doc

《Oracle11G在Linux上手動創(chuàng)建數(shù)據(jù)庫.doc》由會員上傳分享，免費在線閱讀，更多相關內容在教育資源-天天文庫。

1、Oracle11G在Linux上手動創(chuàng)建數(shù)據(jù)庫手動創(chuàng)建數(shù)據(jù)庫：1）定義實例名、數(shù)據(jù)庫名實例名：mysid數(shù)據(jù)庫名：mydb.bash_profileexportORACLE_SID=mysidexportORACLE_2)創(chuàng)建目錄su-oraclemkdir-p/u01/app/oradata/mydbmkdir-p/u01/app/flash_recovery_areamkdir-p/u01/app/admin/mysid/adump3)創(chuàng)建參數(shù)文件vi/u01/app/product/11.2.0/dbhome_1/dbs/initmysid.ora*.compa

2、tible='11.2.0.0.0'*.control_files='/u01/app/oradata/mydb/control01.ctl'*.db_block_size=8192*.db_name='mydb'*.db_recovery_file_dest='/u01/app/flash_recovery_area'*.db_recovery_file_dest_size=2G*.diagnostic_dest='/u01/app'*.memory_target=800M*.open_cursors=300*.processes=150*.remote_login

3、_passwordfile='EXCLUSIVE'*.undo_tablespace='UNDOTBS1'*.undo_management=auto4)啟動實例sqlplus/assysdbastartupselectinstance_name,statusfromv$instance;5)創(chuàng)建數(shù)據(jù)庫createdatabasemydbusersysidentifiedbyoracleusersystemidentifiedbyoraclemaxinstances1maxloghistory100maxlogfiles5maxlogmembers3maxdatafi

4、les1000charactersetzhs16gbknationalcharactersetal16utf16logfilegroup1('/u01/app/oradata/mydb/redo01.log')size10m,group2('/u01/app/oradata/mydb/redo02.log')size10m,group3('/u01/app/oradata/mydb/redo03.log')size10mdatafile'/u01/app/oradata/mydb/system.dbf'size100mautoextendonnext1mmaxsize

5、unlimitedsysauxdatafile'/u01/app/oradata/mydb/sysaux.dbf'size50mautoextendonnext1mmaxsizeunlimiteddefaulttablespaceusersdatafile'/u01/app/oradata/mydb/user01.dbf'size50mautoextendonnext1mmaxsizeunlimiteddefaulttemporarytablespacetemptempfile'/u01/app/oradata/mydb/temp01.dbf'size50mautoe

6、xtendonnext1mmaxsizeunlimitedundotablespaceundotbs1datafile'/u01/app/oradata/mydb/undotbs01.dbf'size50mautoextendonnext1mmaxsizeunlimited;6)創(chuàng)建視圖和過程SQL>@/u01/app/product/11.2.0/dbhome_1/rdbms/admin/catalog.sql;SQL>@/u01/app/product/11.2.0/dbhome_1/rdbms/admin/catproc.sql;