《AIX61安装oracle11gv1.docx》由会员分享，可在线阅读，更多相关《AIX61安装oracle11gv1.docx（30页珍藏版）》请在课桌文档上搜索。
1、一、系统准备1.1、 操作系统版本需求执行命令OSIeVe1.-s来查看Os1.eve1.-S#OS1.eve1.-s61OO-O7-O5-12281.2、 内存需求执行命令Isattr-E-1SySo-area1.mem显示内存大小*Isattr-E1.SySO-area1.11e11#Isattr-E1.sys-area1.memrea1.mem4194304Amountofusab1.ephysica1.memoryinKbytesFa1.se1.3、 SWAP空间需求执行命令ISPS-a伐看SWAP空间大小t*1.ss-a#Isps-aPageSpacesumPhysica1.Vo1.
2、umeVo1.umeGroupSizesedActiveAUtOTypeChkhd60hdiskrootvg8192MB1yesyesIv1.4、 确认操作系统位数执行getcanfHARDfARE_BinWDE命令i若getconfHARDWAREBITMODE#getconfhardware.B11mode641.5、 软件包需求AIX61系统御膜如下软件包bos.adt.basebos.adt.1ibbos.adt.1ibmbos.perf.1ibperfstat6.1.2.1or1.aterbos.perf.perfstatbos.perf.proctIsx1.C.aix61.rte:
3、10.1.0.0or1.ater执行命令Is1.pp-1bos.adt.basebos.adt.Iibbos.adt.1.ibsbos.perf.1ibperfstatbos.perf.perfstatbos.perf.proctoo1.sx1.C.aix61.r1.c杳看软件包安装情况#Is1.pp1bos.adt.basebos.adt.1ibbos.adt.Iibmbos.perf.1ibperfstatbos.perf.perfstatbos.perf.proctooIsx1.C.aix61.rte1.eve1.StateDescriptionPath:usr1.ib/objrepos
4、Ixjs.adt.base6.1.6.1COMMITTEDBaseApp1.icationDeve1.opmentToo1.kit1.xs.adt.1.ib6.1.2.0CoMMITTEDBaseApp1.icationDeve1.opment1.ibrariesbos.adt.Iibm6.1.6.0COMMITTEDBaseApp1.icationDeve1.opmentMath1.ibrarybos.perf.Iibperfstat6.1.6.1CQMM1TTI*DPerformanceStatistics1.ibraryInterfacebos.perf.perfstat6.1.6.0C
5、OMM1TTKDPerformanceStatisticsTnterface1bos.perf.proctoo1.s6.1.6.0C()MM111EDProcToo1.sxIC.aix61.rte11.1.0.1COMM1.TTEDX1.CC+RuntimeforAIX6.1Path:etcobjreposbos.adt.base6.1.6.1COMMITTEDBaseApp1.icationDeve1.opmentToo1.kit1.xs.perf.1.i1.perfstat6.1.6.1COMMITTEDPerformanceStatistics1.ibraryTnterface11.xs
6、.perf.perfstat6.1.6.0COMMITTEDPerformanceStatisticsnterface1.6、系统补丁需求1.1.gR2需要以下补丁,执行命令instfix-i查询instfix-iIgrepIZI1855instfix-iKrCPIZ51456instfix-igrepIZ523191.7、创立用户组和用户使用smittymkgroup命令创立用户坦dba和oinsta1.I,组号分别为301和302：使用s11ittymkuser命令迸行创立用户orac1.euseradd-dhomeorac1.em-u401-goinsta1.1-Gdbaorac1.eu
7、seradd-dhomegrid-m-u402-goinsta1.I-GdbagridPaSSWdorac1.eChangingpasswordfor*orac1.e*orac1.e*sNewpassword:Enterthenewpasswordagain:1. 8、增加orac1.e用户she1.1.能力查看grid和OraCIe用户SheI1.能力Isuser-acapabi1.itiesorac1.e增加OrHCIe用户she1.1.能力ChusercapabiHties=CAP,NUMA.A11CH,CAP_mTASS_RAC_VX!M,CAPPROPAGATEorac1.e1.9、
8、 系统参数配置1.9.1、 配置进程数执行命令saittyChgsysf改.拘PRoCESSES修改为163841.9.2、 配置grid用户和orac1.e用户She1.1.权限修改/etc/securitIiBitS文件defau1.t:fsizc=-1core=2097151cpu=-1data=-1rss=-1stack=-1nofi1.es三-11.9.3、 查看异步aio数执行ift令100-oaio-三axreqs#100-oaio_maxreqsaio_maxreqs-655361.9.4、 配置网络参数看看多数# nu-afgrehcmera1.tcp_ephenera1._
9、high二65535tcp.ephe三era1_1ow=32768udp_cpheeera1._hiKh=65535udp_epheaera1._1.ow二32768配置参数# no-P-OtCP_opheeera1.OW=9000Ptcp-ephera1.-high=5500Settingtcp_ephemera1.1.wto9000Settingtcpephemera1.1.owto9000innextbootfiIeSettingtcp_ephemeraI_highto65500Settingtcp_ephemera1_highto65500innextbootfi1.e# no-p-o
10、udp_epheeera1._1.ow=9000Pudp-epheera1.-high=65500SCtIing1.idp_cPheff1.CraI1.owto9000Settirgudpephemera1.1.wto9000innextbootfi1.eSettingudpephemera1.highto65500Settingudp_ephemera1._highto65500innext1.otfi1.e1.9.5、 配置主机虚拟内存VrDo-p-ominper11=3vmo-p-omaxper11ft=90VmO-poinaxc1ient-90vmo-p-o1.ru_vmo-p-oS1
11、.rieIJnaXCIient=Iv(do-p-ostric1._maxperin=O1.9.6、 增加操作系统块分配大小chdev1sysancargs=*128*如果报错Methoderror(usr1.ibcthodschgen):0514-018Theva1.uesspecifiedforIhefo1.1.owingattributesarenotva1.id:ncargsARG/ENV1.istsizeinIKbyteb1.ocks则使用命令smitchgsys查看ARG/ENV列的数值.1.9.7、 增加操作系统最大进程数使用命令Smi1.chgsys,将mMaximumnumbe
12、rofPROCESSESa1.1.owedperuser,列修改为163841.9.8、 创立orac1.e用户#mkgroupid=600oinsta1.1*nkgroupid=601dba#mkuserid=800pgrp=oinsta1.Igroups=dbaorac1.e1.1.0、配置Orac1.e用户环境变量Orac1.e用户exportW?AC1.E_BASE=ho三eOraCIeexportORACIEK)ME=$0RAa_BASE/product/11.2.0/dbhnme_2exportORAC1.E_SI)=orc1.exportPATH=SORAC1.EJIOMEZbi
13、n:$PATH$cddatabase$Isdocresponserootpre.shruninsta1.1.erstage1nsta1.1$Irootprerpmsshsetupe.htm1.在root下执行./rootpre.sh命令,然后在执行./uninsta1.1.er命令,会提示是否在root下执行了rtpre.sh输入y并按enter$./runinsta1.1.er*林*，*林择择锌*林铮收(林*机铮收*枳铮铮林*，林铮铮林*Yourp1.atformrequirestherootusertoperformcertainpre-insta1.1.ationOSpreparatio
14、n.Therootusershou1.druntheshe1.1.script*rtpre.sh*beforeyouproceedwithOrac1einsta1.1.ation,rtpre.shcanbefoundatthetop1.eve1.oftheCDorthestagearea.Answer,y*ifroothasrunrootpre.shsoyoucanproceedwithOrac1einsta1.1.ation.Answer*n,toabortinsta1.1.ationandthenaskroottorunrootpre.sh,.*g*w*a*g*g*g*g*京*余*8/*名
15、*余*g*g*金*I1.asrootpre.sh*beenrunbyroot?yn(n)yStartingOrac1.eUniversa1.Insta1.1.er.CheckingTcmpspace:mustbegreaterthan190MB.Actua1.5072MBPassedCheckings:mustbegreaterthan150MB.Actua1.1638*1MBPassedCheckingnonitor:mustbeconfiguredtodisp1.ayat1.east256co1.ors.Actua1.16777216PassedPreparingto1.aunchOrac
16、1.eUniversa1.Insta1.1.erfro./1mp0raInsta1120110922_0532OOPM.P1.easewait,$2.2、更新方式询问询问是否不侦写ETAI1.地址，去掠对勾，点击nex1.,伸出错误提示，点击YES2.5、选择安装的语言选择英语和简体中文ORACUSe1.ectProduct1.anguagesDATABASESe*eIheI1n9u必，m*rhyourproxtM1.run.TTTTPIoduaUnguaQefDMxeEdrtif1.nU2Avjitibje1.AnjuagtJMr1.MGAmerKanSPVV讣1.tfvnbtu*nimM-
17、UyMxicnSpanishN0r*9c*nPoWshPo11u9utRomnnRU“onS3,SiOMeniinSarthWsdS11.TrtdrtiorMiChrteTUrWshUixainitrtven11eseU1.tciedUf9u*9tSg1.，hCance1.2.6、选择数据库要安装的版本选择第项企业版2.7、 指定软件安装的目录由于此板屏是第一次安装时所做，创立数据库时出错又曳新安装所以目录跟之前的不对应，在这里将作好择.只要环境变址.profi1.e里的对，Orac1.e1.1.g能通过这个选项来选择要安装的路径即使不创立目录也会有默认的路径SpprifyInstA1.1.A
18、tion1.orationORA1.DATABASESpKifyHOmCKbSpihtop1.cW1.OrCofrnJconf*gur*in-r1.ed&sedirectoryOrc1.e6a”：/howe/orack11feFfSttonSpecifyIoctiionfor10nn9OrckjrftwvtC1.esThH(co*“thOrctboredrononinsosx.Specifyarectotfor*5i1.vnn*esTh.5rectoryiscti1.edtherwemoryO1.mCgrYeTMnstweutowVKWfy$upSMbirec*0rie5forehproduc
19、ttoCon1.an*we111.ordteDmSQdIrsorforetchproducttpc3匕r*qurtt150Egv，”0/dttkp*c*wmcrDwwctofYhc1e0fWr*e10ry归a*”；sJ1.MQn1.cM,onOeMvImentorySpeIfyinOpemtinf1.syne9r0upNhose11embersh*e*mept11n551.ontotheinver*orydrtrequired10CfeuedM*tseUasOperMingWautcmcM*on.MerrberspOSMAgrantshS,YSOAprr4gezndmembershipthe5
20、Y3OW1.0rMege,M*,*cbIssubsetofSYSCXAPrMHge5Se1.ectIKtruetohSDM9r0upto9rv*1heSYSMAprw1.egeYou11u5ibeImemberofthisgroupDwabareAdm1.n1.sirworCroupSaD*b*sOptrwor(8MCR)Croup上峥Wx1.A2.10、产品预安装检查同样提示缺少操作系统补丁包,选择忽略冷11ome/OrainventoryzorainsIKOOt.s11ChangingpermissionsOfZhoineZoraInventory.Addingread,writeperm
21、issionsforgroup.Removingread,write,executepermissionsforwor1.dChanginggroupnameofZhomeZoraInventorytoOInStaI1.TheexecutionofthescriptIScomp1.ete.执行第二个脚本的结果:#homeorac1.e/product/11.2.0/db_1./root.shRunningOrac1.e11groot.shscript.Thefo1.1.owingenvironmentvariab1.esaresetas:ORAC1.E-OWNER=orac1.eORAC1.E
22、JOME=homeorac1.e/product/11.2.0/db_1Enterthefu1.1.pathnameofthe1.oca1.bindirectory：usr1.oca1.b1n:Creatingusr1.oca1./bindirectory.Copyingdbhometousr1.oca1.b1nCopyingOraenVtousr/1.oca1.b1nCopyingcoraenvtousr1.oca1./binCreatingZetcZoratcibfi1.e.Entrieswi1.1.beaddedotheetcoraabfi1.easneededbyDatabaseCon
23、fIgurationAssistantwhenadatabaseiscreatedFinishedrunninggenericpartofrootshscript.Nowproduct-specificrootactionswi1.1.beperformed.Finishedproduct-specificrootactions.2.13、安装完成三、配置监听程序3.3指定监听名称3.4、选择网络协议（保持默认）3.6、完成配置单击FiniSh完成配置四、安装数据库4.1、启动安装界面以orac1.e用户登录系统.执行dbca命令T7iwrcomtg0*9”。Cfr3n7$咐frOracuUD
24、Q”TheOxaOS4Cowtf1.iriMnMOUm,nabsyou:ocr*e*c11jure(WaDastccronjranaseIoXe5profi1.e-5I1.nes,i；S/.profi1.e%e*5u-orac1.e$netcaOrac1.eketServicesGConfiguring1.1.seneru1.istenerConfIgUrat1.aOrac1.eNet1.istenerSRUnrHn91.istenertboneorac1.epr1.istenerContro1.1.istenerstartedSOrac1.e际ServicesUidXaC*P4.3、选择数据
25、库类型4.4、指定数据库名4.5、是否配置EnterpriseManagerCance1.He1.p4.6、指定数据库SYS用户密码密码为：a这里提示密码不平安，选择YES忽珞DatabaseConfigurationAssistant,Step5of13:DatabaseCredentia1.sForSeCUntVreaSOns,V(MJmustspecifypasswordsforthefo1.1.cwmguseraccountsinthenewdatabaseCmct4.7.选择数据库文件的存储类型1.DatabaseConfigura1.ionAssistant.S1.ep7of13D
26、atabaseIi1.e1.ocahonsSpecirvstoraoetypeand1.ocationsfordaraoasefi1.esSwrageType:R1.eSystem二二二一S1.OraGe1.ocationsUseDatabaseFi1.e1.ocationsfromTemp1.aterUseCommon1.ocationforAi1.DatabaseFi1.esDatabaseRie1.OCa1.iOrTUseOrac1.e-ManagedNesDaxaDaseArea:Muir1.p1.exRedoSgandContro1.Fi1.r8rcwjcBrSySe.)Oifcuw
27、anttoIpfCifvdiffertf1.tIoceiioniforanydaiaba(fs.picknyoftheabowoptionsexceptOracie-ManagedFi1.esandusetbeStoragepage1.atertocustomizeeachfi1.e1.ocationIfVoIJUSeOrac1.e-ManaodFi1.es,Orac1.eautomaticairyQerveratesthenamesfordaxabasefi1.es,wncannobechangedontheSioragepageFi1.e1.ocaiiionVanab1.esCance1.
28、IHe1.pfiackIWext(wish、-J1.1.4.8 、指定闪回区及归档模式EfDatabaseConfigurationAssistant,Step8of13:RecoveryConfigurationChoosemeressryoptionsforthedatabaseSpecifyF1.ashRec(nryAfeaThisisusedasInedefau1.tfora1.1.diskbasedbackupandrecoveryoperawns,andisa1.sorequiredforau4chMng(ORM1.E.8ASEj11a5.recovery.Browse)3852:
29、IM&yiS”Efi:HCmvSMocfeParameters.Cance1.He1.pFi1.e1.ocaiionVadabies.*xtEi曲J4.9 选择例如方案DatabaseConfigurationAssistant.Step8of!1:DatabaseContentSarreonModeDatabaseCharacterSetrUseIbeCfefau1.tTbeCfefau1.tcharactersetfor田databaseistasedonIFie1.anguagese11rofthisOptrMngsyMwnWE8MSWU252rUS0Unicode(A1.32UTf8)
30、SottingChardCfersettoUnicode(A1.32UTF8)erub1.s、ou1.ostoremu1.t如果想以SCOtt用户连接,如果先在SySdba下对scott用户解锁.命令是：a1.teruserscottaccountun1.ockidentifiedbytiger;withthePartitioning,o1.ap,DataMiningandRea1.App1.icationTestingoptionsSQ1.a1.teruserscottaccountun1.ockidentifiedbytiger；Usera1.tered.SQ1.connscott/tig
31、er；Connected.SQ1.I4.16、关闭和启动数据库启动和关闭都需要在SySdba下才可执行，关闭数据许可以用命令shutdownimmediateiS行,致性关闭（ShU1.doWnabort为非一诙性关闭）可以通过se1.ectstatusfronv$instance;来杳合实例的状态.sq1.conn/assysdbaConnected.SQ1.shutdownimmediateDatabasec1.osed.Databasedismounted.ORAC1.E1nsanceshutdown.SQ1.seiectstatusfromv$instance;se1.ectstatu
32、sfromv$instance.ERRORat1ine1：ORA-O1O34：ORAC1.Enotavai1.ab1.eProcessID：9109696SessionID:125Seria1.number:9SQ1.启动数据薛实例用命令StartUp,并用Se1.eCtstatusfromVSinS1.anCo来查看实例的状态:SQ1.startupORAC1.Einstancestarted.Tota1.SystemG1.oba1.Area1720328192bytesFixedSize2207488bytesVariab1.eSize1023410432bytesDatabaseBuff
33、ers687865856bytesRedoBuffers6844416bytesDatabasemounted.Databaseopened.SQ1.Se1.eCtstatusfromv$Instance；STATUSOPENSQ1.4. 17验证数据库在数据库中进行杳询表操作，创立表在SCott用户下查询所有表SQ1.connscottt1gerConnected.SQ1.se1.ect*fromtab;TNAMETABTYPEC1.usteridBONUSTAB1.EDEPTTAB1.EEMPTAB1.ESa1.gradeTAB1.ESQ1.查询dept表中的内容:SQ1.se1.ect*
34、fromdept；DEPTNODNAME1.OC10ACCOUNTINGNEWYORK20RESEARCHDA1.1.AS30SA1.ESCHICAGO40OPERATIONSBOSTON创立表test内容为我dept中的内容:SQ1.createtab1.etestasse1.ect*fromdept；ITab1.ecreated.SQ1.Se1.eCtfromtest;OEPTNODNAME1.OC10ACCOUNTINGNEWYORK20RESEARCHDA1.1.AS30SA1.ESCHICAGO40OPERATIONSBOSTONSQ1.五.OraeIe的卸载5. 1删除数据库在。r
35、ack，用户卜dbca选择驯除数据库DatabaseConfigurationAssistant.Step2of2:DatabaseSe1.ectwedatabaseIha1.youwarntode1.eteIdatabasefi1.eswi1.1.bede1.etedDatabaseCance1.He1.pBackI提示菜单点击YESAssistant:DatabaseSe1.ectiediabaseihaouwarntode1.eteA1.1.databasefi1.eswi1.1.bede1.etedDatabase:DatabaseConfigurationAssistantTheDatabaseConfKjurationAssistantVrt1.1.de1.etetheOrac1.einstanceanddatafi1.esforwurdatabaseAI1.informationinthediabasewi1.1.bed冈孙DoVCUwantproceed?NOCanCe1.He1.p14BaCKHniSh点击OK5.2删除orac1.e的安装目录QP一IQDnQrn#rm-rfdbhome_2删除etcoratab以及/etc/*.IOC如果要彻底删除，需要删除.profiIe文件和用户组，并删除/home下的OraInventory,最后再重启机器
