Oracle11g手工創(chuàng)建數(shù)據(jù)庫(kù)_第1頁(yè)
Oracle11g手工創(chuàng)建數(shù)據(jù)庫(kù)_第2頁(yè)
Oracle11g手工創(chuàng)建數(shù)據(jù)庫(kù)_第3頁(yè)
Oracle11g手工創(chuàng)建數(shù)據(jù)庫(kù)_第4頁(yè)
Oracle11g手工創(chuàng)建數(shù)據(jù)庫(kù)_第5頁(yè)
已閱讀5頁(yè)，還剩6頁(yè)未讀， 繼續(xù)免費(fèi)閱讀

下載本文檔

版權(quán)說(shuō)明：本文檔由用戶(hù)提供并上傳，收益歸屬內(nèi)容提供方，若內(nèi)容存在侵權(quán)，請(qǐng)進(jìn)行舉報(bào)或認(rèn)領(lǐng)

文檔簡(jiǎn)介

1、- #- *1. Linux 下：- *01). 修改初始化參數(shù)文件：($ORACLE_HOME/dbs目錄下)- inityktdora.ora-yktdora._db_cache_size=6576668672yktdora._java_pool_size=67108864yktdora._large_pool_size=67108864yktdora._oracle_base='/opt/oracle'#ORACLE_BASE set from environmentyktdora._pga_aggregate_target=5435817984yktdora._sga_

2、target=8120172544yktdora._shared_io_pool_size=0yktdora._shared_pool_size=1275068416yktdora._streams_pool_size=0*.audit_'/opt/oracle/admin/yktdora/adump'*.audit_trail='db'*.compatible='.0'*.control_files='/data/oracle/oradata/yktdora/control01.ctl','/opt/or

3、acle/flash_recovery_area/yktdora/control02.ctl'*.db_block_size=32768*.db_domain=''*.db_name='yktdora'*.db_recovery_'/opt/oracle/flash_recovery_area'*.db_recovery_*.LOG_ARCHIVE_DEST_1='LOCATION=/opt/oracle/arch'*.LOG_ARCHIVE_DEST_STATE_1=ENABLE*.LOG_ARCHIVE_FORMAT=

4、%r_%t_%s.arc*.diagnostic_dest='/opt/oracle'*.dispatchers='(PROTOCOL=TCP) (SERVICE=yktdoraXDB)'*.memory_target=*.open_cursors=300*.processes=150*.remote_login_passwordfile='EXCLUSIVE'*.star_transformation_enabled='TRUE'*.undo_tablespace='UNDOTBS1'- *02). 運(yùn)行下面的腳

5、本，創(chuàng)建數(shù)據(jù)庫(kù)：(相關(guān)的目錄事先創(chuàng)建好)- createdatabase.sqlstartup nomount;CREATE DATABASE yktdadv datafile '/data/oraadv/oraadv_data/yktdadv/system01.dbf' size 2048M autoextend on next 1024M extent management local sysaux datafile '/data/oraadv/oraadv_data/yktdadv/sysaux01.dbf' size 2048M undo tablesp

6、ace undotbs1 datafile '/data/oraadv/oraadv_data/yktdadv/undotbs01.dbf' size 20480M default temporary tablespace temp tempfile '/data/oraadv/oraadv_data/yktdadv/temp01.dbf' size 20480M logfile group 1 ('/data/oraadv/oraadv_data/yktdadv/redo01.log') size 1024M, group 2 ('/d

7、ata/oraadv/oraadv_data/yktdadv/redo02.log') size 1024M, group 3 ('/data/oraadv/oraadv_data/yktdadv/redo03.log') size 1024M, group 4 ('/data/oraadv/oraadv_data/yktdadv/redo04.log') size 1024M CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16user sys identified by bee56915use

8、r system identified by bee56915;- *03). 創(chuàng)建數(shù)據(jù)庫(kù)默認(rèn)表空間：CREATE TABLESPACE users datafile '/data/oraadv/oraadv_data/yktdadv/users01.dbf' size 2048M;alter database default tablespace users;- *04). 創(chuàng)建數(shù)據(jù)字典：/opt/oraadv/product/oraadv_11.2.0/db_2/rdbms/admin/catalog.sql- *05). 執(zhí)行catproc創(chuàng)建包：/opt/oraadv/

9、product/oraadv_11.2.0/db_2/rdbms/admin/catproc.sql/opt/oraadv/product/oraadv_11.2.0/db_2/rdbms/admin/catexp.sql- *06). 執(zhí)行pupbld.sql腳本文件：/opt/oraadv/product/oraadv_11.2.0/db_2/sqlplus/admin/pupbld.sql- *07). 創(chuàng)建spfileSQL> create sp pfile;- *08). 創(chuàng)建scott測(cè)試用戶(hù)/opt/oraadv/product/oraadv_11.2.0/db_2/rdb

10、ms/admin/scott.sql- 核對(duì)數(shù)據(jù)庫(kù)字符集：sysYKTDORA> select * from v$nls_parameters;PARAMETER VALUE- -NLS_LANGUAGE AMERICANNLS_TERRITORY AMERICANLS_CURRENCY $NLS_ISO_CURRENCY AMERICANLS_NUMERIC_CHARACTERS .,NLS_CALENDAR GREGORIANNLS_DATE_FORMAT DD-MON-RRNLS_DATE_LANGUAGE AMERICANNLS_CHARACTERSET AL32UTF8NLS_

11、SORT BINARYNLS_TIME_FORMAT HH.MI.SSXFF AMNLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AMNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZRNLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZRNLS_DUAL_CURRENCY $NLS_NCHAR_CHARACTERSET AL16UTF16NLS_COMP BINARYNLS_LENGTH_SEMANTICS BYTENLS_NCHAR_CONV_EXCP FALSE19 rows s

12、elected.- 1* select * from v$nls_parametersSQL> /PARAMETER VALUE- -NLS_LANGUAGE AMERICANNLS_TERRITORY AMERICANLS_CURRENCY $NLS_ISO_CURRENCY AMERICANLS_NUMERIC_CHARACTERS .,NLS_CALENDAR GREGORIANNLS_DATE_FORMAT DD-MON-RRNLS_DATE_LANGUAGE AMERICANNLS_CHARACTERSET AL32UTF8NLS_SORT BINARYNLS_TIME_FOR

13、MAT HH.MI.SSXFF AMNLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AMNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZRNLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZRNLS_DUAL_CURRENCY $NLS_NCHAR_CHARACTERSET AL16UTF16NLS_COMP BINARYNLS_LENGTH_SEMANTICS BYTENLS_NCHAR_CONV_EXCP FALSE19 rows selected.-yktdadv._db_ca

14、che_size=6576668672yktdadv._java_pool_size=67108864yktdadv._large_pool_size=67108864yktdadv._oracle_base='/opt/oraadv'#ORACLE_BASE set from environmentyktdadv._pga_aggregate_target=5435817984yktdadv._sga_target=8120172544yktdadv._shared_io_pool_size=0yktdadv._shared_pool_size=1275068416yktda

15、dv._streams_pool_size=0*.audit_'/opt/oraadv/admin/yktdadv/adump'*.audit_trail='db'*.compatible='.0'*.control_files='/data/oraadv/oraadv_data/yktdadv/control01.ctl','/data/oraadv/oraadv_data/yktdadv/control02.ctl'*.db_block_size=32768*.db_domain='&#

16、39;*.db_name='yktdadv'*.db_recovery_'/opt/oraadv/flash_recovery_area'*.db_recovery_*.LOG_ARCHIVE_DEST_1='LOCATION=/opt/oraadv/arch'*.LOG_ARCHIVE_DEST_STATE_1=ENABLE*.LOG_ARCHIVE_FORMAT=%r_%t_%s.arc*.diagnostic_dest='/opt/oraadv'*.dispatchers='(PROTOCOL=TCP) (SERVI

17、CE=yktdadvXDB)'*.memory_target=*.open_cursors=300*.processes=150*.remote_login_passwordfile='EXCLUSIVE'*.star_transformation_enabled='TRUE'*.undo_tablespace='UNDOTBS1'- #- *2. Windows 下：- *02). 運(yùn)行下面的腳本，創(chuàng)建數(shù)據(jù)庫(kù)：(相關(guān)的目錄事先創(chuàng)建好)- createdatabase.sqlCREATE DATABASE tdwora datafile

18、'D:appAdministratororadatatdworasystem01.dbf' size 2048M autoextend on next 1024M extent management local sysaux datafile 'D:appAdministratororadatatdworasysaux01.dbf' size 2048M undo tablespace undotbs1 datafile 'D:appAdministratororadatatdworaundotbs01.dbf' size 20480M defa

19、ult temporary tablespace temp tempfile 'D:appAdministratororadatatdworatemp01.dbf' size 20480M logfile group 1 ('D:appAdministratororadatatdworaredo01.log') size 1024M, group 2 ('D:appAdministratororadatatdworaredo02.log') size 1024M, group 3 ('D:appAdministratororadatatd

20、woraredo03.log') size 1024M, group 4 ('D:appAdministratororadatatdworaredo04.log') size 1024M CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16user sys identified by bee56915user system identified by bee56915;- *03). 創(chuàng)建數(shù)據(jù)庫(kù)默認(rèn)表空間：CREATE TABLESPACE users datafile 'D:appAdministrat

21、ororadatatdworausers01.dbf' size 2048M;alter database default tablespace users;- *04). 創(chuàng)建數(shù)據(jù)字典：/opt/oraadv/product/oraadv_11.2.0/db_2/rdbms/admin/catalog.sql- *05). 執(zhí)行catproc創(chuàng)建包：/opt/oraadv/product/oraadv_11.2.0/db_2/rdbms/admin/catproc.sql- *06). 執(zhí)行pupbld.sql腳本文件：/opt/oraadv/product/oraadv_11.2.

22、0/db_2/sqlplus/admin/pupbld.sql- *07). 創(chuàng)建spfileSQL> create sp pfile;- *08). 創(chuàng)建scott測(cè)試用戶(hù)/opt/oraadv/product/oraadv_11.2.0/db_2/rdbms/admin/scott.sql- 核對(duì)數(shù)據(jù)庫(kù)字符集：sysYKTDORA> select * from v$nls_parameters;- #- *1. Linux 下：- *01). 修改初始化參數(shù)文件：($ORACLE_HOME/dbs目錄下)- inityktdtest.ora-yktdtest._db_cache

23、_size=6576668672yktdtest._java_pool_size=67108864yktdtest._large_pool_size=67108864yktdtest._oracle_base='/opt/oracle/oraadv'#ORACLE_BASE set from environmentyktdtest._pga_aggregate_target=5435817984yktdtest._sga_target=8120172544yktdtest._shared_io_pool_size=0yktdtest._shared_pool_size=1275

24、068416yktdtest._streams_pool_size=0*.audit_'/opt/oracle/oraadv/admin/yktdtest/adump'*.audit_trail='db'*.compatible='.0'*.control_files='/data/oraadv/oraadv_data/yktdtest/control01.ctl','/data/oraadv/oraadv_data/yktdtest/control02.ctl'*.db_block_size=32

25、768*.db_domain=''*.db_name='yktdtest'*.db_recovery_'/opt/oracle/oraadv/flash_recovery_area'*.db_recovery_*.LOG_ARCHIVE_DEST_1='LOCATION=/opt/oracle/oraadv/arch'*.LOG_ARCHIVE_DEST_STATE_1=ENABLE*.LOG_ARCHIVE_FORMAT=%r_%t_%s.arc*.diagnostic_dest='/opt/oracle'*.d

26、ispatchers='(PROTOCOL=TCP) (SERVICE=yktdtestXDB)'*.memory_target=*.open_cursors=300*.processes=150*.remote_login_passwordfile='EXCLUSIVE'*.star_transformation_enabled='TRUE'*.undo_tablespace='UNDOTBS1'- *02). 運(yùn)行下面的腳本，創(chuàng)建數(shù)據(jù)庫(kù)：(相關(guān)的目錄事先創(chuàng)建好)- createdatabase.sqlCREATE DATABA

27、SE yktdtest datafile '/data/oraadv/oraadv_data/yktdtest/system01.dbf' size 2048M autoextend on next 1024M extent management local sysaux datafile '/data/oraadv/oraadv_data/yktdtest/sysaux01.dbf' size 2048M undo tablespace undotbs1 datafile '/data/oraadv/oraadv_data/yktdtest/undot

28、bs01.dbf' size 20480M default temporary tablespace temp tempfile '/data/oraadv/oraadv_data/yktdtest/temp01.dbf' size 20480M logfile group 1 ('/data/oraadv/oraadv_data/yktdtest/redo01.log') size 1024M, group 2 ('/data/oraadv/oraadv_data/yktdtest/redo02.log') size 1024M, gr

29、oup 3 ('/data/oraadv/oraadv_data/yktdtest/redo03.log') size 1024M, group 4 ('/data/oraadv/oraadv_data/yktdtest/redo04.log') size 1024M CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16user sys identified by bee56915user system identified by bee56915;- *03). 創(chuàng)建數(shù)據(jù)庫(kù)默認(rèn)表空間：CREATE TA

30、BLESPACE users datafile '/data/oraadv/oraadv_data/yktdtest/users01.dbf' size 2048M;alter database default tablespace users;- *04). 創(chuàng)建數(shù)據(jù)字典：/opt/oracle/oraadv//db_1/rdbms/admin/catalog.sql- *05). 執(zhí)行catproc創(chuàng)建包：/opt/oracle/oraadv//db_1/rdbms/admin/catproc.sql- *06). 執(zhí)行pupbld.sql腳

31、本文件：/opt/oracle/oraadv//db_1/sqlplus/admin/pupbld.sql- *07). 創(chuàng)建spfileSQL> create sp pfile;- *08). 創(chuàng)建scott測(cè)試用戶(hù)/opt/oracle/oraadv//db_1/rdbms/admin/scott.sql-ORATEST._db_cache_size=ORATEST._java_pool_size=268435456ORATEST._large_pool_size=201326592ORATEST._oracle_base='/data/11g

32、/oratest'#ORACLE_BASE set from environmentORATEST._pga_aggregate_target=32078036992ORATEST._sga_target=19461570560ORATEST._shared_io_pool_size=536870912ORATEST._shared_pool_size=4697620480ORATEST._streams_pool_size=268435456*._pga_max_size=4294967296*.audit_'/data/11g/oratest/admin/ORATEST/a

33、dump'*.audit_sys_operations=TRUE*.audit_syslog_level='LOCAL1.WARNING'*.audit_trail='OS'*.compatible='.0'*.control_files='/data/11g/oratest/oradata/ORATEST/control01.ctl','/data/11g/oratest/flash_recovery_area/ORATEST/control02.ctl'#Restore Controlf

34、ile*.cursor_sharing='FORCE'*.db_block_size=32768*.db_domain='com'*.db_*.db_name='ORATEST'*.db_recovery_'/data/11g/oratest/flash_recovery_area'*.db_recovery_*.db_securefile='PERMITTED'*.db_unique_name='ORATESTDG1'*.diagnostic_dest='/data/11g/oratest

35、'*.log_archive_dest_1='LOCATION=/data/11g/oratest/ora_arch'*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'*.log_archive_format='%r_%t_%s.arc'*.memory_max_target=45834574848*.memory_target=45834574848*.open_cursors=800*.open_links=60*.pga_aggregate_cesses=1200*.

36、remote_login_passwordfile='EXCLUSIVE'*.session_cached_cursors=80*.sga_max_size=12884901888*.sga_target=12884901888*.shared_pool_size=4294967296*.smtp_out_server='00:25'*.standby_'AUTO'*.star_transformation_enabled='TRUE'*.undo_retention=86400*.undo_tablespa

37、ce='UNDOTBS1'- createdatabase.sqlCREATE DATABASE oratest datafile '/data/11g/oratest/oradata/ORATEST/system01.dbf' size 2048M autoextend on next 1024M extent management local sysaux datafile '/data/11g/oratest/oradata/ORATEST/sysaux01.dbf' size 2048M undo tablespace undotbs1 datafile '/data/11g/oratest/oradata/ORATEST/undotbs01.dbf' size 20480M default temporary tablespace temp tempfile '/data/11g/oratest/oradata/ORATEST/temp01.dbf' size 20480M logfile group 1 ('/data/11g/oratest/oradata/ORA

溫馨提示

  • 1. 本站所有資源如無(wú)特殊說(shuō)明，都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等，如果需要附件，請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶(hù)所有。
  • 3. 本站RAR壓縮包中若帶圖紙，網(wǎng)頁(yè)內(nèi)容里面會(huì)有圖紙預(yù)覽，若沒(méi)有圖紙預(yù)覽就沒(méi)有圖紙。
  • 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
  • 5. 人人文庫(kù)網(wǎng)僅提供信息存儲(chǔ)空間，僅對(duì)用戶(hù)上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理，對(duì)用戶(hù)上傳分享的文檔內(nèi)容本身不做任何修改或編輯，并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
  • 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容，請(qǐng)與我們聯(lián)系，我們立即糾正。
  • 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶(hù)因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。

評(píng)論

0/150

提交評(píng)論