國稅局數(shù)據(jù)庫11g安裝流程

RHEL5.8Oracle準備工系統(tǒng)版本：RedhatLinux Oracle版本：11.2.0.4RHELIProot賬號的SELinux二．IP和終端設IPIP根據(jù)此IP地址配置好終端secureCRT和它的X三．Oracle安裝前檢Oracle-validatedRPM部RPMOraclelinuxOracle從oraclePublicYUM上并安裝多個特定的軟件包其為指定的版本(如以上示例)，softwarepackageOracleDB/RDBMSServer11gR2數(shù)據(jù)庫軟件的先決條件oracleOSuseroinstalldba修改/etc/security/limits.conf配置文件保證oracle用戶的s limitstack等參數(shù)足夠，以符合Oracle11gR2的安裝要求x86-64kernelbootnuma=offnumaoraclelinuxR5U8鏡像放入光驅(qū)，如果是ISO文件上傳到主機[root@rhel10g~]#df- UsedAvailUse%Mounted 15% 14% 0 0% 0100%/media/OL5.8x86_64創(chuàng) 加載oraclelinux鏡Mkdir[root@rhel10g/]#mount/dev/hdcmount:blockdevice/dev/hdciswrite-protected,mountingread-創(chuàng)建本地[root@rhel10g/]#vi [root@rhel10g/]#vi/etc/yum.repos.d/rhel-debuginfo.reponame=RedHatEnterpriseLinux$releasever-$basearch-Debug #mount的目標路徑#yum緩存安裝oraclevalidate[root@rhel10gServer]#yumcleLoadedplugins:kalo,product-id,security,subscription-managerUpdating-basedrepositories.UnabletoreadconsumeridentityCleaningupEverything進入掛 的 下執(zhí)行該命[root@rhel10gServer]#yuminstalloracle-validated-1.1.0-15.el5.x86_64.rpmLoadedplugins:kalo,product-id,security,subscription-managerUpdating-basedUnabletoreadconsumer|1.1|1.4SettingupInstallMarkingoracle-validated-1.1.0-15.el5.x86_64.rpmtobeinstalledResolving-->Runningtransaction--->Packageoracle-validated.x86_640:1.1.0-15.el5settobe-->ProcessingDependency:irqbalance>=2:0.55-16forpackage:oracle--->ProcessingDependency:kernel-uek>=2.6.32forpackage:oracle--->ProcessingDependency:/usr/lib/libaio.soforpackage:oracle-validatedImportingadditionalfilelistinformation |3.1 -->ProcessingDependency:/usr/lib/libodbc.so.1forpackage:oracle--->ProcessingDependency:/usr/lib/libodbccr.soforpackage:oracle--->ProcessingDependency:/usr/lib64/libaio.soforpackage:oracle--->ProcessingDependency:libXp.so.6forpackage:oracle--->ProcessingDependency:libaio-develforpackage:oracle--->ProcessingDependency:oraclelinux-releaseforpackage:oracle--->ProcessingDependency:sysstatforpackage:oracle--->ProcessingDependency:unixODBC-develforpackage:oracle--->ProcessingDependency:libodbc.so.1()(64bit)forpackage:oracle--->Runningtransaction--->Packageirqbalance.x86_642:0.55-17.el5settobe--->Packagekernel-uek.x86_640:2.6.32-300.10.1.el5ueksettobe-->ProcessingDependency:kernel-firmware=2.6.32-300.10.1.el5uekforpackage:kernel--->ProcessingDependency:mkinitrd>=5.1.19.6-75.0.5forpackage:kernel--->ProcessingDependency:device-mapper-multipath>=0.4.9-23.0.1.el5forpackage:kernel--->ProcessingDependency:ql2xxx-firmwareforpackage:kernel---->PackagelibXp.i3860:1.0.0-8.1.el5settobe--->Packagelibaio-devel.i3860:0.3.106-5settobe--->Packagelibaio-devel.x86_640:0.3.106-5settobe--->Packageoraclelinux-release.x86_640:5-8.0.2settobe--->Packagesysstat.x86_640:7.0.2-11.el5settobe--->PackageunixODBC-devel.i3860:2.2.11-10.el5settobe-->ProcessingDependency:unixODBC=2.2.11-10.el5forpackage:unixODBC---->PackageunixODBC-devel.x86_640:2.2.11-10.el5settobe--->PackageunixODBC-libs.i3860:2.2.11-10.el5settobe--->PackageunixODBC-libs.x86_640:2.2.11-10.el5settobe-->Runningtransaction--->Packagedevice-mapper-multipath.x86_640:0.4.9-23.0.9.el5settobe-->ProcessingDependency:kpartx=0.4.9-23.0.9.el5forpackage:device-mapper--->ProcessingDependency:device-mapper-multipath-libs=0.4.9-23.0.9.el5forpackage:-->ProcessingDependency:libmultipath.so()(64bit)forpackage:device-mapper---->Packagekernel-uek-firmware.noarch0:2.6.32-300.10.1.el5ueksettobe--->Packagemkinitrd.i3860:5.1.19.6-75.0.9.el5settobe-->ProcessingDependency:nash=5.1.19.6-75.0.9.el5forpackage:--->Packagemkinitrd.x86_640:5.1.19.6-75.0.9.el5settobe--->Packageql2xxx-firmware.noarch0:1.01.01-0.2.el5settobe--->PackageunixODBC.x86_640:2.2.11-10.el5settobe-->Runningtransaction--->Packagedevice-mapper-multipath-libs.x86_640:0.4.9-23.0.9.el5settobe--->Packagekpartx.x86_640:0.4.9-23.0.9.el5settobe--->Packagenash.x86_640:5.1.19.6-75.0.9.el5settobe-->Processing:kernel-ueksudev<095--->RestartingDependencyResolutionwithnew-->Runningtransaction--->Packageudev.x86_640:095-14.27.0.3.el5_7.1settobe-->FinishedDependencyResolutionDependenciesResolved 61 Installingfor 0.4.9- rhel- 153 2.6.32- rhel- 3.7 1.0.0- rhel- k 0.3.106- rhel- 12 0.3.106- rhel- k 2.7k 442k 2.2.11- rhel-291 2.2.11- rhel- k 2.2.11- rhel- k 2.2.11- rhel- 551 2.2.11- rhel- kUpdatingfor 0.4.9- rhel- 85 2:0.55- rhel- k 0.4.9- k rhel- 482 471k 5.1.19.6- rhel- M 15 7Totalsize:38Totaldownloadsize:38MIsthisok[y/N]:yDownloadingPackages: 4.2GB/s 38 warning:rpmts_HdrFromFdno:HeaderV3DSAsignature:NOKEY,keyID |1.4 ImportingGPGkey0x1E5E0159"OracleOSSgroup(OpenSourceSoftware >"from/mnt/cdrom/RPM-GPG-KEY-oracleIsthisok[y/N]:yRunningrpm_check_debugRunningTransactionTestFinishedTransactionTestRunningTransaction :device-mapper-multipath-libs :oraclelinux- libaio- Attemptingtorestore/etc/multipath.conffrombackupNobackupcopyavailable,pleasecreateamultipath.confInstalledproductsupdated.Dependencydevice-mapper-multipath-libs.x86_640:0.4.9-23.0.9.el5kernel-uek.x86_640:2.6.32-300.10.1.el5ueklibXp.i3860:1.0.0-8.1.el5oraclelinux-release.x86_640:5-8.0.2sysstat.x86_640:7.0.2-11.el5unixODBC.x86_640:2.2.11-10.el5unixODBC-devel.i3860:2.2.11-10.el5unixODBC-devel.x86_640:2.2.11-10.el5unixODBC-libs.i3860:2.2.11-10.el5unixODBC-libs.x86_640:2.2.11-10.el5Dependencydevice-mapper-multipath.x86_640:0.4.9-23.0.9.el5irqbalance.x86_642:0.55-17.el5kpartx.x86_640:0.4.9-23.0.9.el5mkinitrd.i3860:5.1.19.6-75.0.9.el5mkinitrd.x86_640:5.1.19.6-75.0.9.el5nash.x86_640:5.1.19.6-75.0.9.el5檢查預安裝包是否已創(chuàng)建賬號和修改內(nèi)核參數(shù)和限[root@rhel10gServer]#id[root@rhel10gServer]#more#KernelsysctlconfigurationfileforRedHatLinux#Forbinaryvalues,0isdisabled,1isenabled. Seesysctl(8)and#sysctl.conf(5)formoredetails.#ControlsIPpacketforwardingnet.ipv4.ip_forward=0#Controlssourcerouteverificationnet.ipv4.conf.default.rp_filter=1#Donotacceptsource#ControlstheSystemRequestdebuggingfunctionalityofthe#ControlswhethercoredumpswillappendthePIDtothecorefilename#Usefulfordebuggingmulti-threadedapplicationskernel.core_uses_pid=#ControlstheuseofTCPsynsnet.ipv4.tcp_syns=1#Controlstheumsizeofamessage,in#Controlsthedefaultmaxmimumsizeofamesagequeue#Controlstheumsharedsegmentsize,inbytes#Controlstheumnumberofsharedmemorysegments,in#For11g,Oracle-Validatedsettingforfs.file-max#For10g, ment'fs.file-max=327679',andcomment'fs.file-max= 'entryandre-runsysctl-p#fs.file-max=327679fs.file-max=#Oracle-Validatedsettingforkerne gmniis2878 gmni=2878#Oracle-Validatedsettingfor gmaxiskernegmax=#Oracle-Validatedsettingforkernegmnbis65536kernegmnb=65536#Oracle-Validatedsettingforkernel.semis'25032000100kernel.sem=25032000100#Oracle-Validatedsettingforkernel.shmmniis4096kernel.shmmni=4096#Oracle-Validatedsettingforkernel.shmalliskernel.shmall=#Oracle-Validatedsettingforkernel.shmmaxis4398046511104onx86_64andoni386architecture.ReferNoteid567506.1kernel.shmmax=#Oracle-Validatedsettingforkernel.sysrqis1kernel.sysrq=1#Oracle-Validatedsettingfornet.core.rmem_defaultis262144net.core.rmem_default=262144#For11g,Oracle-Validatedsettingfornet.core.rmem_max#For10g, ment'net.core.rmem_max= ',comment'net.core.rmem_max=4'entryandre-runsysctl-p#net.core.rmem_max=net.core.rmem_max=#Oracle-Validatedsettingfornet.core.wmem_defaultis262144net.core.wmem_default=262144#For11g,Oracle-Validatedsettingfornet.core.wmem_max#For ment'net.core.wmem_max=262144',comment'net.core.wmem_max'entryforthisparameterandre-runsysctl-p#net.core.wmem_max=262144#Oracle-Validatedsettingforfs.aio-max-nrisfs.aio-max-nr=#For11g,Oracle-Validatedsettingfornet.ipv4.ip_local_port_rangeis9000#For10g, ment'net.ipv4.ip_local_port_range=102465000',comment'net.ipv4.ip_local_port_range=900065500'entryandre-runsysctl-p#net.ipv4.ip_local_port_range=1024net.ipv4.ip_local_port_range=9000#Oracle-Validatedsettingforvm.min_free_kbytesis51200toavoidOOMkillervm.min_free_kbytes=51200[root@rhel10gServer]#more/etc/security/limits.conf#/etc/security/limits.conf##Eachlinedescribesalimitforauserinthe #<>can -anuser -agroupname,with@group -thewildcard*,fordefault -thewildcard%,canbealsousedwith%groupsyntax, formaxloginlimit#<type>canhavethetwo -"soft"forenforcingthesoft -"hard"forenforcinghardlimits#<item>canbeoneofthefollowing: -core-limitsthecorefilesize -data-maxdatasize -fsize-umfilesize -memlock-maxlocked-in-memoryaddressspace(KB) -nofile-maxnumberofopenfiles -rss-maxresidentsetsize -stack-maxstacksize -cpu-maxCPUtime -nproc-maxnumberof -as-addressspace -maxlogins-maxnumberofloginsforthis -maxsyslogins-maxnumberofloginsonthesystem -priority-theprioritytorunuserprocesswith -locks-maxnumberoffilelockstheusercanhold -sigpending-maxnumberofpendingsignals -msgqueue-maxmemoryusedbyPOSIXmessagequeues(bytes) -nice-maxnicepriorityallowedtoraiseto#-rtprio-maxrealtime 00-4#Endof#Oracle-Validatedsettingfornofilesoftlimitis131072 #Oracle-Validatedsettingfornofilehardlimitis131072 #Oracle-Validatedsettingfornprocsoftlimitis131072 #Oracle-Validatedsettingfornprochardlimitis131072 #Oracle-Validatedsettingforcoresoftlimitisunlimited #Oracle-Validatedsettingforcorehardlimitisunlimited #Oracle-Validatedsettingformemlocksoftlimitis #Oracle-Validatedsettingfo