suse-linux安裝oracle11gr2作業(yè)指導(dǎo)書(shū)

SUSE-LinuxOracle11gR2x86_64作業(yè)指導(dǎo)SUSE-LinuxOracle11gR2x86_64作業(yè)指導(dǎo) 目1說(shuō)一、安裝前21.1RAM&SWAP檢222344671.2CPU1.4ORACLE1.8修改用戶(hù)ORACLESHELL9二、安裝過(guò)2.19目1說(shuō)一、安裝前21.1RAM&SWAP檢222344671.2CPU1.4ORACLE1.8修改用戶(hù)ORACLESHELL9二、安裝過(guò)2.1992.22.43.1調(diào)整DEFERRED_SEGMENT_CREATION為 3.2調(diào)整參數(shù)3.3調(diào)整DEFAULT概要文件PASSWORD_LIFE_TIME參 3.4說(shuō)說(shuō)11gRelease211.2)forLinuxx86-64Oracle?SUSElinux#lsb-release#uname一、安裝前準(zhǔn)1.1RAM&swap檢1GRAM，最好一、安裝前準(zhǔn)1.1RAM&swap檢1GRAM，最好#1.2CPU#getconf#grep“clflushsize”1.3rpm依賴(lài)包檢查安#rpm-qbinutilsgccgcc-32bitgcc-c++glibcglibc-32bitglibc-develglibc-devel-32bitkshlibaiolibaio-32bitlibaio-devellibaio-devel-32bitlibstdc++33libstdc++33-32bitlibstdc++46libstdc++46-32bitlibstdc++43-devellibstdc++43-devel-32bitlibgcc46libstdc++-develmakeRAMswap1GB~21.5倍2GB~16同RAM16缺什么補(bǔ)什么(盡量找安裝系統(tǒng)自帶包1.4缺什么補(bǔ)什么(盡量找安裝系統(tǒng)自帶包1.4oracle用戶(hù)及其屬主SLESoracle#userdel–r#groupadd//oinstalldba#groupadd#useradd–goinstall–Gdba–d/home/oracle/-m#passwd1.5安裝目錄創(chuàng)#mkdir–p#chown–Roracle:oinstall#chmod–R7551.6內(nèi)核參數(shù)修Minimum1.5安裝目錄創(chuàng)#mkdir–p#chown–Roracle:oinstall#chmod–R7551.6內(nèi)核參數(shù)修MinimumMinimum:Maximum:Avaluethatis1bytelessthanthephysicalRecommended:MorethanhalfthephysicalmemorySeeMyOracleSupportNote567506.1foradditionalinformationaboutconfiguringshmmax.file-/proc/sys/fs/file-Minimum:Maximum:/proc/sys/fs/aio-max-shmmax計(jì)算：RAM(GB)*1024*1024*1024/2-shmall計(jì)算：RAM(GB)*1024*1024/4(64bit64GRAM=vietc/sysctl.confshmmax計(jì)算：RAM(GB)*1024*1024*1024/2-shmall計(jì)算：RAM(GB)*1024*1024/4(64bit64GRAM=vietc/sysctl.confandsemmni#/sbin/sysctl-a|grepThiscommanddisplaysthevalueofthesemaphoreparametersintheordershmall,shmmax,and#/sbin/sysctl-a|grepfile-#/sbin/sysctl-a|grepfile-#/sbin/sysctl-a|grep#/sbin/sysctl-a|grep#/sbin/sysctl-a|grep#/sbin/sysctl-a|grep#/sbin/sysctl-a|grepMinimumNote:ThisvaluelimitsconcurrentoutstandingrequestsandshouldbesettoavoidI/Osubsystemfailures.fsfile-max=kernel.shmall=kernel.shmmax=kernel.shmmni=fsfile-max=kernel.shmall=kernel.shmmax=kernel.shmmni=kernel.sem125032000100256//系統(tǒng)初始值，oracle最小25032000100net.ipv4.ip_local_port_range=9000net.corermem_default=net.corermem_max=net.core.wmem_default=net.core.wmem_max=#sysctl#/sbin/chkconfigboot.sysctl1.7環(huán)境變量修發(fā)現(xiàn)/oracle/目錄下沒(méi)有環(huán)境變量配置文件.bash_profile或.profile,#chownoracle:oinstall#chmod755file#OracleexportexportORACLE_SID=xzrsexportORACLE_TERM=xtermexportLD_LIBRARY_PATHexport#SetshellsearchexportPATH=$ORACLE_HOME/bin:/usr/sbin:$PATH:/usr/local/bin#exportDBCA_RAW_CONFIG=/opt/oracle/rawdevpath[wwp5]#exportNLS_LANG=AMERICAN_AMERICA.ZHS16GBK//#source#vi#source#vi#ForexportORA_CRS_HOME=$ORACLE_BASE/product/11.2/crs以及/etc/profile#vietc/profileif[$USER="oracle"];if[$SHELL="/bin/ksh"];thenulimit-p16384source/etc/profile1.8修改用戶(hù)oracleshell限vietc/security/limits.conf#visessionrequired二、安裝過(guò)部署本地接受安二、安裝過(guò)部署本地接受安#chown–Roracle.oinstall#chmod–R755#su–#安裝軟#//databaseIwishNestSkipsoftwareInstallSkipsoftwareInstalldatabasesofteareonly>只裝軟件，之后建庫(kù)和聽(tīng)SinglelnstancedatabaseSinglelnstancedatabaseinstallation>安裝單監(jiān)聽(tīng)模式數(shù)庫(kù)選上支持簡(jiǎn)選上支持簡(jiǎn)體中文- Edition>配置了Edition>配置了環(huán)境變量，這里默認(rèn)就好默認(rèn)默認(rèn)數(shù)據(jù)庫(kù)用戶(hù)組數(shù)據(jù)庫(kù)用戶(hù)組報(bào)的兩個(gè)缺失包，Ignore確認(rèn)下列安確認(rèn)下列安裝信息無(wú)誤 完成2.3完成2.3創(chuàng)建監(jiān)聽(tīng)和#netca//一直默認(rèn)下一步。LocalNetNameconfiguration，創(chuàng)Nameconfiguration，創(chuàng)建跟實(shí)例一樣名稱(chēng)的tns就好2.4創(chuàng)建#2.4創(chuàng)建#歡迎界面-CreateaCreateaCustom實(shí)例Custom實(shí)例名，環(huán)境變量中定義的那個(gè)默認(rèn)默認(rèn)所有數(shù)據(jù)庫(kù)所有數(shù)據(jù)庫(kù)用戶(hù)共用一個(gè)密碼選在數(shù)據(jù)文件存放目錄啟用并編輯啟用并編輯歸檔模式>EditArchiveMode修改歸檔日修改歸檔日志文件格式、路徑OracleText/OLAP/Spatial>Nest如果內(nèi)核按照計(jì)算修改了，這里可以定制需要的Memory如果內(nèi)核按照計(jì)算修改了，這里可以定制需要的Memory不需要完全精準(zhǔn)>Processes1500>Processes1500>CharacterSets>Next選擇支持的字符集ZHS16GBK、語(yǔ)定制表空間定制表空間大小，合理編輯大小編輯大小后面還有個(gè)自擴(kuò)展大小，去掉編輯完成Next編輯完成Next三、oracle11g參數(shù)調(diào)三、oracle11g參數(shù)調(diào)Oracle11g中的deferred_segment_creation默認(rèn)設(shè)置為true，空表不產(chǎn)生segment，導(dǎo)SQL>showparameterSQL>altersystemsetdeferred_segment_creation=falseSystemSQL>showparameterSQL>altersystemsetdeferred_segment_creation=falseSystemSQL>showparameterOracle11g之前的數(shù)據(jù)庫(kù)會(huì)把密碼自動(dòng)轉(zhuǎn)為大寫(xiě),oracle11g數(shù)據(jù)庫(kù)記錄的密碼區(qū)分大小寫(xiě)，當(dāng)參數(shù)為false時(shí)，只是不驗(yàn)證大小寫(xiě)。當(dāng)參數(shù)為ture,在參數(shù)為false時(shí)建立的用戶(hù)sec_case_sensitive_logontrue查看參數(shù)設(shè)置情況：true識(shí)別大小寫(xiě)，false不識(shí)別altersystemsetsec_case_sensitive_logon=trueoracle11g中默認(rèn)在defaultoracle11g中默認(rèn)在default概要文件中設(shè)置了“PASSWORD_LIFE_TIME=180天”，密SQL>alterprofiledefaultlimitpassword_life_time1proifledefault：sql>SELECTusername,PROFILEFROM如* $sqlplus/assqlalteruserndnsidentifiedby原來(lái)的密碼3.4SQL>altersystemsetopen_cursors=500SQL>altersystemsetoptimizer_index_cost_adj=25scope=spfile;SQL>