Oracle11gdatabase单机安装文档

Oracle11g1LinuxKernel在sysctl.conf文件添加一下内容kernel.shmmax=68719476736kernel.shmall=4294967296kernel.shmmni=4096kernel.sem=25032000100142fs.file-max=6815744net.ipv4.ip_local_port_range=900065500net.core.rmem_default=1048576net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=2097152vm.swappiness=40vm.vfs_cache_pressure=200vm.min_free_kbytes=409600fs.aio-max-nr=3145728[root@oraCLEDBdata]#sysctl-pnet.ipv4.ip_forward=0net.ipv4.conf.default.rp_filter=1net.ipv4.conf.default.accept_source_route=0kernel.sysrq=0kernel.core_uses_pid=1net.ipv4.tcp_syncookies=1error:"net.bridge.bridge-nf-call-ip6tables"isanunknownkeyerror:"net.bridge.bridge-nf-call-iptables"isanunknownkeyerror:"net.bridge.bridge-nf-call-arptables"isanunknownkeykernel.msgmnb=65536kernel.msgmax=65536kernel.shmmax=68719476736kernel.shmall=4294967296kernel.shmmax=68719476736kernel.shmall=4294967296kernel.shmmni=4096kernel.sem=25032000100142fs.file-max=6815744net.ipv4.ip_local_port_range=900065500net.core.rmem_default=1048576net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=2097152vm.swappiness=40vm.vfs_cache_pressure=200vm.min_free_kbytes=409600vm.min_free_kbytes=409600fs.aio-max-nr=3145728oracleResourceLimit参数在/etc/security/limits.conf文件末尾添加如下内容oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536检查防火墙、SElinux配置[root@ORACLEDB~]#iptables-L[root@ORACLEDB~]#iptables-LChainINPUT(policyACCEPT)targetprotoptsourcedestinationChainFORWARD(policyACCEPT)targetprotoptsourcedestinationChainOUTPUT(policyACCEPT)targetprotoptsourcedestination[root@ORACLEDB~]#[root@ORACLEDB~]#/usr/sbin/sestatus-vSELinuxstatus:disabled创建oracle用户及其用户组[root@ORACLEDB~]#groupADDoinstall[root@ORACLEDB~]#groupadddba[root@ORACLEDB[root@ORACLEDB~]#~]#groupaddoper[root@ORACLEDB[root@ORACLEDB~]#~]#useradd-goinstall-Gpasswdoracledba,operoracleChangingpasswordforuseroracle.Newpassword:Retypenewpassword:passwd:allauthenticationtokensupdatedsuccessfully.Changingpasswordforuseroracle.Newpassword:Retypenewpassword:passwd:allauthenticationtokensupdatedsuccessfully.[root@ORACLEDB~]#mkdir-p/u01/app/oracle/product/11.2.0/db_1[root@ORACLEDB~]#chown-Roracle:oinstall/u01/app[root@ORACLEDB[root@ORACLEDB~]#~]#chmod-R775/u01/app安装相应软件包yuminstallcompat-libcap1yuminstallcompat-libstdc++-33yuminstalllibstdc++-develyuminstallgccyuminstallgcc-c++yuminstallkshyuminstallglibc-develyuminstalllibaio-devel配置用户环境变量[oracle@ORACLEDB~]$vim.bash_profile[oracle@ORACLEDB~]$vim.bash_profile#.bash_profile#Getthealiasesandfunctionsif[-f~/.bashrc];then.~/.bashrcfi#UserspecificenvironmentandstartupprogramsPATH=$PATH:$HOME/binexportPATHORACLE_BASE=/u01/app/oracleORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1ORACLE_SID=bjbdPATH=$PATH:$ORACLE_HOME/binexportORACLE_BASEORACLE_HOMEORACLE_SIDPATH[oracle@ORACLEDB~]$[oracle@ORACLEDB~]$..bash_profile经过xmanager连接oracle用户安装，步骤如下：I orMWJI orMWJlC-BD-DBOl:吐t代心be可心l戎JI仄－n应 的中正式5p冒,1回or江cl忍:BJIOC-:BD-DII轧中tab坴］$l归岱ll - 斜心 胆ht.nl_ 晔l迩0.ht”][or江c1召2BJIIC-BD-DllOi邸ab窃 3｀/t'unI乍扫11芍砒引1 O le比1'er灾1［心切］1廿···匕I口心 1:.1 r 年工立“Ll5.七b g心凸匕牙th口1:2(JHBP已艺立dI:.1rgm正P年o!ICJ!!jI'll匕七b g心占匕守th己15(J"卫、 阰t心180尪“II Pa5!I口釭. Ior?”吐匕口计igu芒dt口d坛pl atlr!:a吐玉i口］a心X沁如比中eekfr di工尸1!:IC:[1lor:s:usin9亡口n”,ndiu工'.bm抎中出nfo+Ck iFth"IJI5“'ibl凹i了：：凹＋Fild｛SrJn,函ui~"i=intr:h"吐．!i=fil忒十”“u吐．fylfillt比石凹厂巴刁Jir凹屯nt子b巳f口厂巴cantloi..11陌1with归 心nt1心,;,(!:,i-'n)[nl li口宅lt'equed~µ扫：伍t中亡之妒ntuin1.PNPle.!IBD-]l卫md吐心吐1g卧吓可·in9o］斗ur.::1- ]e扣釭立］心tal立· t',1.PNPle.!IBD-]l卫md吐心吐1g氐心”“'片0心11中印0..cl.星虹”“'比"..2-已■rIn心0..cl.星虹”“'比"..2-已■rIn心'·知141j5—知廖印立刻`'T归h I"f....,nl..LrWtlcnn“'叮严“'｀qIIr肛-仆彴沁，叫气山哼，廿 如I一一一·一仁- 仁- ...，加�I巨－ 0..cl.D吐匕”“'比.....止比 0..cl.D吐匕”“'比.....止比＿哼d己e.N -伍p1占1i心m,fi平虹＆江mi行中如 z..,亡女 I枷功邓ImdhU,.....1:,1..,官由_hIII1pr己心....--...氐1.uu心孔冒岭1'.lr.::111叩in.11oohMlp叩l如叩叩1111心古5:,:arllg叩凶｀贮 ,r/irr•cdr,(crt1k::ill"吓妇”“”仁三 巨 OrOr.1山01o1:.11:u..11311a....2l-吐心－In中口哼dd ..·釭p2忒1jD!l'l'!TIIO'lld＆氏立U旧`to了立·11glcmn”ir m·1”“川仰叶

I～th叫叩 ·“bIup心忙"...中�•I'°'.

mnm已过u1.“■”归r 4呻匈t..mUg”“

门nr叩扣n•m中已…匹沁社U卤III·妇U(LU'idalhmnm虹dpm5IIB:t "“）一屯0心1mp~n.c1心叫2ror血·衄心1d^rr和扣玉"'- d.III， 一二 巨0..g...“匕d1均K..2h”－In...n,1·知p30沁父戊已由笠守节11gim1“”叩mr1山卯n口叩

”“”斤丁睿i归旧压可Im匡l”山mgti“I叩Ii心r””“ln,臼uK妇志ldn.g阳”5c21l吟 吐,:1歹江忙mO”“IIIm“'mcmm

丘立,-,dcm仆U1中i■l>n■i30m,'(J..ILp,Jr出uIE出只lj心心还：二 女儿八＿“士 巨 0..cbol:.a·H2-j■r-In...哼d..·知p4忒心JIn又1响叩O旧llf1巴矗立·11ghr1山由111'h甘T记“T于hnIllIT'1111

釭1mmp·rra'"．二廿扣吐l”“”“OU量S!Ir记囚灿h叫归111'1二二尸．lo 1心已哼知p5忒垃父氏`Pr吐IKt1.:11呵呵ESI.岔立·11gIT”“IIIm“'f"1T

丘1·111'1m·In叩”“ll!Jrpn111mn.邑:1”邑:|1山吓c.“bFl'IUIEh

茹芒叩如“'1h`”;“`"

C■J■Jv,czict,[IU由丘IDII圉叩Ih山归凶己anJ圉innl1hFl'!ch6代i片口H..,punbl■di:0..b凸凸虹..1均心....2-丘］■r－Int.■丐d.-土句知p6夕12`EJD让，归…因ib1111二巳m_.“士巨＄它守11g J讷U如lfflll:llldldyIIm加-平妇亡贮屯f 11“Illlim血IIi111

—吐1,11丘lrp”“"立1bn比1”r-..-,g11山心山止Ih...1,口i压PIr(or.,IU'iCll,响h｀山岫1村，嘱心”IIum..lr.-.1tarunl.,mdm“`Ina11luai-1r11闷`mIIIl111m）氐中nj巳Um8CC已｝0心·口引吐叩］］汀｀画dlnl“日mI2"'.f11口1ddIiInmIO”““111'1I杠d口nEf比可II,』1一北111因3hE丈之liI兀中和片阮U阳旬n心可r石II订pr111-d巳，叩阰伽叩cl)fflc5C0贰KI"的旧咋1(t心心邯gmm叩叩叨er"心如九Ei咄h．）立血”“itm凸1”“CI]次记n山吐如1垃，1i11日mom1”“,HurEd如·811l/l如叩mUjml妇b2小砌l,J巾m:mmii.I习d111,du忻－：如b止he品(I“．l巨'仁三 巳 一如士巨'1"'1"'Or..ch凸虹”“'立...”“衄．ta].r-Jnr.-.“哼如士 ·如p?# 1,扣红，fyIn吐豆II吐iDIILG呻'lllli矗立·11g扛心1rapah1bU江uo心c5”“”屯d03”印廿叩均印n”“”l，slrtS队br,四1Tlt””“打过t凶父｀也引丫rI比比切M17#fi,r妇归E伈贝沁心1 一飞 l已吟11al心im你的r1TT

＿ ＿ 妇如 如1加咄nn比—f]f]I“”“”“',“”—T

h如Oruk沁父矗tm叩 匕如1硒氏山enl)f'iF寸户为辽片妇劝芯emcQ比峦斤沁IIW!IP.:妞叩“严信心～如如出扭I~ 了- _J尸hvm·,”“`'“;-!"och-!"och··2上切丘-Jnr...En,darlJ3雪皿．＆：中白e12。句比m·i心h...lr-也'a- 叩丘IIl'WilllI..Jm中比ho立鼠矗已立心心血n.1d-立巧I口归d口·“··心r”“fTl11fir田叩凶...r'gmup心叮IE心匹口IIpra,,IImrl'llr,t叩：山叩伈灼心凶心一心)」石色－hn"伽im1--nIIIm－

印吓行■n...,11.“■■缸r,:h.....-o 匕dnhoIT叮r山■m叩 pN.它玉习mrmII“11cmt`rlo. TmrmII“11cmt`仁三 m_u'"士巨th■l“均u.....2上切l.r-In....“nJp901i 匹巨l'ri刘芞贮dOii,rall叩｀“七m知叩S

乍－灯囡句右乍

哑 ” “函四叩le妇沁冗叩旧10叩矶“如心设叫付，叩r心衵，ill心5)心， 叩叩［咖OO II中心h妞心，亚1hEm°' mmt叩即皿劝叩呻5中1r切陨p巾I邑吐如lch匕”:PJ沁顷沁贝妇吓低元 心， 1r.e:rt.:al11mlc贮lc心f扛“如l如砒“D1b门r,I”“Ur也比U仅扣心01"匕g“na）四晔 引1:00)8,il江呻仄 ）妇啦沁如叩忆妇奸锐恼或（中1-lr.1＿.\、--－----r mr'叩1f1m中二 ｀肛仗”u“巨 r..cl.m."均R..II2.r-InP”口『这如mm叩：：�立·11g日缸杜四．心劝阳`2区和'＾ 1”'“”

臼引伸妇l叩邸贝太“心心 d7I次凶片的？:..............,...11让Im:“巳仆im氏iJdlbu■r心on,11诏I'凶埴°'｝m5docJor<m冲P已mil..闷凡l岫1叩出中m1沁心如心由让心5il虳呤千心50陌臼叩沁片”“A”1llllllli/肛o[in51a1II芘Plap..,...FII-L 巳 声巨 I00..gb0”b..1均'::!•bll..－ld迅n,'.9pU3，几＂逞l『r吐LKI 笠它节＝II

og”“菜匕…“”“ Ir..mcR`'”.■可`'”+什+“1妇11IRI立d卢

声g严．g严．0ir0ir|．lllllll|．·i·i”gl．．夕＿飞－－｀二·i·i”gl．．夕＿飞－－｀二使用root用户执行此处两个脚本：[root@ORACLEDB~]#/u01/app/oraInventory/orainstRoot.sh[root@ORACLEDB~]#/u01/app/oraInventory/orainstRoot.shChangingpermissionsof/u01/app/oraInventory.ADDingread,writepermissionsforgroup.Removingread,write,executepermissionsforworld.Changinggroupnameof/u01/app/oraInventorytooinstall.Theexecutionofthescriptiscomplete.[root@ORACLEDB~]#/u01/app/oracle/product/11.2.0/db_1/root.shPerformingrootuseroperationforOracle11gThefollowingenvironmentvariablesaresetas:Thefollowingenvironmentvariablesaresetas:ORACLE_OWNER=oracleORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1Enterthefullpathnameofthelocalbindirectory:[/usr/local/bin]:Copyingdbhometo/usr/local/bin...Copyingoraenvto/usr/local/bin...Copyingcoraenvto/usr/local/bin...Creating/etc/oratabfile...Entrieswillbeaddedtothe/etc/oratabfileasneededbyDatabaseConfigurationAssistantwhenadatabaseiscreatedFinishedrunninggenericpartofrootscript.Nowproduct-specificrootactionswillbeperformed.Finishedproduct-specificrootactions.配置监听服务重重orade@BJlOC-BD-DBOl:/中tofcbtabase已1巴吐e,::1:.i闵 nmitor:“IJ令torade@BJlOC-BD-DBOl:/中tofcbtabase已1巴;-;->C:□uldnot釭匹uteautoch吐 中yinfo+七叶；if"e DI附｀叮i七l：e＋ l,««如ncrequi~cntchcck3foil4十丫因血:;:t.fuLPillt归cr~」jr印,::nt::;:b::forentiruin9with归 in志］l吐i.an.立�"fgu立凸n心imnt吐艺：器。阰眨圾公函胥如卫盯闭巴廿巴亡邯三一归阻归谥扂昹姑却如霜芯－笘坛盂沁、懦器书立�"fgu立凸n心imnt吐艺：器。阰眨圾公函胥如卫盯闭巴廿巴亡邯三一归阻归谥扂昹姑却如霜芯－笘坛盂沁、懦器书-915101h5lfan8a09li9lle2tTYlitd120glDBtaC-f D3IatTTolord t r111LllliBBBqae8”r1,lJ-l1aIICr9.oPJ-JI a-lba9CE� 3u-iif-1--竺洷忙亡－－BjoC”rteei1-if-a唐e竺洷忙亡－－BjoC”rteei1-if-a心I只邱．10D1凶llt哗 闱lguoneps,1elelr.,,.巳闭如压feneronf!..('Namingh1巳lho凸5C0而gur:Imr 氓』CSI闷e叩eonrlgur识Ion(''Usagecanr1gur缸IonCai1C已l Help 荨OOr吐 阰沁口nfigur立ion心3j如fl'!!Lin rCDrrflgur忒ion.Li如nrForremotEonnectIDt15tDbemade10＼U'tQracl仑d队aba5E.wumu欢CDn1'IIIureaor正leNE[.而忒怂机的,.茂之11riener.年1eClW仇江田UW仆[1D中：心cl厂兄t'ttllfiiur·r:.:eCanc仑l Help 'J OOr吐 阰,tConfi9ur立ion沁5ii:tan勹Li式MierCc.叶gur立i口n.u玉ner尺叩e心Forrem01econne口lnn510如madeto'i()UrOracle沁哎口江心II哎En「.En1:Err.hEnarr1eo1'r.hE!llsr.ener、心UW抑to它飞它-亡二.

Usler,ername Cai1C已l Help 冬氐； 三OOr立ileN芒tConfigur立记n心5虹a，，Li立 rCon什gur忒i口门，女l!!GtPr如立Canc仑l Help

丫OU[anconngur0hBlI5lgnerlaa[［0切conn氨1lanOlll!ron巳orh15|i哎巳nerK巳E口泗urmnfigur