在linux中安装oracle10g.docx
- 文档编号:29436814
- 上传时间:2023-07-23
- 格式:DOCX
- 页数:27
- 大小:491.12KB
在linux中安装oracle10g.docx
《在linux中安装oracle10g.docx》由会员分享,可在线阅读,更多相关《在linux中安装oracle10g.docx(27页珍藏版)》请在冰豆网上搜索。
在linux中安装oracle10g
InstallingOELandOracle 10gR2
InordertouseOracleDatabase,firstofallweneedtosetupOracleSoftware.InstallationofOracleDatabaseonWindowsisveryeasy.Byrunningsetup.exefrominstallationCDofOracleforWindows,wecaninvokeasetupandbyclickingNEXTbuttonswecaninstallOracleSoftwareandDatabasewithoutanyproblem.Wedon’tneedanyprerequisiteactionsbeforeinstallation.ButinLinuxit’sdifferent.IfwewanttoinstallOracleDatabaseonLinuxOS,weshouldfollowsomeprerequisiteactions.
Today,we’regoingtoinstallOracleDatabaseonCentOS.Todoit,weuselastversionofCentOS(thelatestreleasefornow)–“CentOS-5.2”andmostlyusedreleaseofOracleDatabase–“OracleDatabase10gRelease2”.Andwe’regoingtopracticethiswholeprojectonVMware6.0.0
Beforestarting,weneedtoinstallVMware.Then,weneedtoinstallCentOSonVMware.Afterthat,wearegoingtoinstallOracleDatabase.YoushouldrefertomypreviouspostsinordertoinstallVMwareandCentos
StepbystepinstallingVMware
StepbyStepInstallingCentOSonVMware
Butthere’sonethingweshouldkeepinmind.DuringinstallationofCentOS,onthe“packagelists”page,weshouldbehavedifferently.Itwillbediscussedinthenextparagraphs.
Thisprojectcoversfollowingsteps:
1.Checkingminimumhardwarerequirements
2.InstallingrpmpackageswhicharerequiredforOracleinstallation
3.Configuringkernelparameters
4.CreatinggroupsanduserforOracleInstallation
5.InstallingOracleSoftware
6.CreatinganOracleDatabase
7.ConnectingtoDatabasewithEnterpriseManager
8.AUTOMATINGallprocessesandstepsofinstallationOracle10gR2onCentosusingShellScript
Asyouseefromthelistabove,inordertosetupOracleDatabase,weneedtochangesomeparametersinthesystem.Changingtheseparameterseachtimecouldleadtomistakesandwasteoftime.Themainpurposeofourarticleistoautomatealltheseprocessesandsaveyourtime.Forthispurposewe’regoingtouse“ShellScript”
NowI’mgoingtoexplainabovementionedstepsonebyone
1.Checkingminimumhardwarerequirements
Atleast,yoursystemshouldmeetthefollowingrequirements:
- 1GBRAM
- RequirementforswapspaceinOracleinstallationisasfollows:
AvailableRAM SwapSpaceRequired
Between1GBand2GB 1.5timesthesizeofRAM
Between2GBand8GB EqualtothesizeofRAM
Morethan8GB .75timesthesizeofRAM
- 400MBfreespacein/tmpdirectory
- Dependingontypeoftheinstallation,1.5-3.5GBfreespaceforOracleSoftware
- 1.5GBfreespaceifnewOracleDatabaseiscreated
Gettingfamiliarwithrequirementsmentionedabove,weneedtogethardwareinformationofoursystem.TocheckthesizeofRAM,Swapspaceandtmpdirectory,werunthesecommands:
- Tocheckthesizeofphysicalmemory,execute grepMemTotal /proc/meminfo
- Tocheckthesizeofswapspace,execute grepSwapTotal /proc/meminfo
- Tocheckthespacein /tmpdirectory,execute df–h/tmp
2.InstallingrpmpackageswhicharerequiredforOracleinstallation
WhileinstallingCentOS,wehavetoinstallsomerpmpackages.Duringtheinstallation,ontheinstallationwindowyougetlistofpackages.Here,weselect“Customize”choice
On“Customized”window,wecheckrequiredpackagesanduncheckpackagesthatarenotrequiredforOracleInstallation
Inthepackageslist,checkfollowingpackages.Uncheckallpackagesthatarenotinthelistbelow
DesktopEnvironments
GNOMEDesktopEnvironment
Applications
GraphicalInternet
Development
DevelopmentLibraries
DevelopmentTools
GNOMESoftwareDevelopment
JavaDevelopment
LegacySoftwareDevelopment
XSoftwareDevelopment
Servers
ServerConfigurationTools
WebServer
WindowsFileServer
BaseSystem
AdministrationTools
Base
Java
LegacySoftwareSupport
SystemTools
XWindowSystem
Furthermore,afterinstallationofCentOS,wehavemanuallytoinstallthesefourrpmpackages.Surely,youcanselectthem(exceptlibaio-develpackage)fromthepackagelistduringsetup,formanypeoplewhodon’twanttofindthesepackagesinthepackagelist,installingitmanuallyaftersysteminstallationisthebestoption.ThesearepackageswhichshouldbeinstalledbeforeOracleinstallation
- compat-db-4.2.52-5.1.i386.rpm
- sysstat-7.0.2-1.el5.i386.rpm
- libaio-devel-0.3.106-3.2.i386.rpm
- libXp-1.0.0-8.1.el5.i386.rpm
Inordertoinstallthesepackages,youcanuserpm–UvhcommandbychangingdirectorytoCentOSdirectoryinsidetheCD(DVD)ofCentOSinstallationasshownbelow
3.ChangestobemadetoKernelparameters
Afterinstallingabovementionedpackages,weneedtochangesomeKernelparametersandmakethemmatchtoOraclerequirements.Parameterswhichshouldbechangedareshownbelow
shmmax
2147483648
shmmni
4096
shmall
2097152
shmmin
1
semmsl
250
semmns
32000
semopm
100
semmni
128
file-max
65536
ip_local_port_range
1024 65000
rmem_default
1048576
rmem_max
1048576
wmem_default
262144
wmem_max
262144
Wedoallthesechangesinthe/etc/sysctl.conffilebyaddingtheselinestothatfile:
kernel.shmmax=2147483648
kernel.shmall=2097152
kernel.shmmni=4096
kernel.sem=25032000100128
fs.file-max=65536
net.ipv4.ip_local_port_range=102465000
net.core.rmem_default=1048576
net.core.rmem_max=1048576
net.core.wmem_default=262144
net.core.wmem_max=262144
Afterappendingthoselineswesavethatfileandrunthefollowingcommandtomakethesechangeseffectiveimmediatelyintherunningsystem
/sbin/sysctl–p
SettingShelllimitsfortheOracleUserToimprovetheperformanceofthesoftwareonLinuxsystems,youmustincreasethefollowingshelllimitsfortheoracleuser:
1.Addthefollowinglinesto/etc/security/limits.conffile
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
2.Addthefollowinglinesto/etc/pam.d/loginfile
session required /lib/security/pam_limits.so
session required pam_limits.so
3.InordertouseOracleSoftware,weneedtomakeachangein“oracle”user’sbuffersizeandnumberofopenedfiledescriptors.Inordertodoit,weaddbelowlinesto/etc/profilefile
if[$USER="oracle"];then
if[$SHELL="/bin/ksh"];then
ulimit-p16384
ulimit-n65536
else
ulimit-u16384-n65536
fi
fi
4.Changingredhat-releasefile
OneofthefirstchecksperformedbytheOracleUniversalInstaller(OUI)istodetermineifthehostplatformissupported.TheOUIusesthefile/etc/redhat-releasetodeterminetheplatform.ForthecaseofRedHatEnterpriseLinux,OracleDatabase10gRelease2expectseitherRHEL3orRHEL/OEL4.
Theeasiestwaytogetaroundthiserroristomodifythe/etc/redhat-releasefilereplacingthecurrentreleaseinformation(CentOSrelease5(Final))withthefollowing:
redhat-4
Beforemodifying/etc/redhat-release,makeabackupcopyofthefileandensuretoreplacetheoriginaloneaftertheOracleinstallationandpatchprocesshasbeencompleted.
cp/etc/redhat-release/etc/redhat-release.original
echo“redhat-4″>/etc/redhat-release
Afteralltheseconfigurations,youshouldgetthisresult:
4.CreategroupsanduserforOracleInstallation
Inthisstep,wecreate“oinstall”and“dba”groupsand“oracle”usertoinstallOracleSoftware,andcreatenewDatabase
groupadd oinstall
groupadd dba
useradd-m-goinstall-Gdba-d/home/oracle-s/bin/bash-c“OracleSoftwareOwner”oracle
passwdoracle
5.InstallingOracleDatabase10gRelease2
Firstofall,weneedtodownloadOracleDatabase10gR2.Todownloadit,usethislink:
Afterdownloadfinish,weneedtocopythisfiletotheVirtualMachine.Tocopyit,wehavetwochoices:
∙CopyitusingUSBFlashDrive
∙CopyitusingSambaservice
∙Createanimagefile(.iso)fromzippedinstallationandmountittoVirtualMachine
Here,we’regoingtocopythezippedfileusingsecondtechnique.WithanyISOcreatorprogram,create.isofilefromzippedinstallationfileofOracleDatabase.AndthenmountittotheVirtualMachineasshownbelow:
NowswitchtothedesktopofCentOS,rightclickonDVDofCentOSinstallationonthedesktopandclick“Eject”asshownbelow:
Nowenterto“Computer”anddoubleclickon“CD-ROM”icon.
InstallationfileofOracleDatabasewillbeopened:
Now,createinstallfolderon
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- linux 安装 oracle10g