部署應(yīng)用項(xiàng)目-oracle4單機(jī)for rhel5on virtualbox實(shí)驗(yàn)安裝

oracleforrhel5onvirtualbox1考文1.OracleDatabaseQuickInstallationGuide11gRelease2(11.2)forLinuxx86-64[E24326-蘇2redhatenterpriselinux5.5x86_64裝介oracledatabase(RDBMS)安裝介質(zhì)oracledatabase(RDBMS)vnc客戶端工具vnc-實(shí)驗(yàn)環(huán)oraclevirtualboxoraclevirtualboxHostOnly，IP：，操作系統(tǒng)：redhatenterpriselinux5.5x86_64cpu:2，內(nèi)存：1536M，虛擬磁盤(pán)40G1host-only，IP：12，子網(wǎng)掩碼：主機(jī)名：db11g，網(wǎng)關(guān)：要求關(guān)閉和禁用用戶 用戶 前期準(zhǔn)設(shè)置主機(jī)名和默認(rèn)網(wǎng)[root@db11g~]#vi/etc/sysconfig/networkHOSTNAMEGATEWAY：[root@db11g~]#hostnamenetstatrn[root@db11g~]#netstat-rnKernelIProutingtableU000U000000eth0[root@db11g~]#vi/etc/sysconfig/network-scripts/ifcfg-#InCorporation82540EMGigabitEthernetControllerIP[root@db11g~]#servicenetworkShuttingdowninterface[]Shuttingdowninterface[]Shuttingdownloopback[]Bringinguploopback[]Bringingupinterface[]Bringingupinterface[][root@db11g~]#ifconfig- Link HWaddrinet inet6addr:fe80::a00:27ff:fe03:369/64Scope:LinkUPBROADCASTRUNNING RXpackets:185errors:0dropped:0overruns:0frame:0TXpackets:177errors:0dropped:0overruns:0carrier:0collisions:0txqueuelen:1000RXbytes:18372(17.9KiB)TXbytes:22508(21.9 Linkencap:Localinetaddr: inet6addr:::1/128Scope:HostUPLOOPBACK RXpackets:5882errors:0dropped:0overruns:0frame:0TXpackets:5882errors:0dropped:0overruns:0carrier:0collisions:0txqueuelen:0RXbytes:8160660(7.7 TXbytes:8160660(7.7 Linkencap:IPv6-in- RXpackets:0errors:0dropped:0overruns:0frame:0TXpackets:0errors:0dropped:0overruns:0carrier:0collisions:0txqueuelen:0RXbytes:0(0.0 TXbytes:0(0.0編輯/etc/hosts文件，設(shè)置主機(jī)名解[root@db11g~]#vi#Donotremovethefollowingline,orvariousprograms#thatrequirenetworkfunctionalitywillfail. localhost.local localhost6.local6 注意: localhost.locallocalhost這一行固定寫(xiě)法，不要?jiǎng)h除測(cè)試實(shí)際網(wǎng)卡上配置IP對(duì)應(yīng)的主機(jī)名解析[root@db11g~]#db11g-c2 db11g(12)56(84)bytesofdata.64bytesfromdb11g(12):icmp_seq=1ttl=64time=0.10264bytesfromdb11g(12):icmp_seq=2ttl=64time=0.104---db11gstatistics--2packetstransmitted,2received,0%packetloss,time1000msrttmin/avg/max/mdev=0.102/0.103/0.104/0.001msrootvncserver啟動(dòng)vncserver服務(wù)，第一次啟動(dòng)設(shè)置[root@db11g~]#Youwillrequire swordtoaccessyourdesktops. creatingnewauthorityfile/root/.XauthorityNew'db11g:1(root)'desktopisdb11g:1Creatingdefaultstartupscript/root/.vnc/xstartupStartingapplicationsspecifiedin/root/.vnc/xstartupLogfileis/root/.vnc/db11g:1.log這里設(shè)置的vncserver是編輯vncserver默認(rèn)啟動(dòng)配置文件/root/.vnc/xstartupvncserver啟動(dòng)配置文件/root/.vnc/xstartup修改方式一[root@db11g~]#vi mentthefollowin olinesfornormaldesktop:#unsetSESSION_MANAGER#exec[-x/etc/vnc/xstartup]&&exec/etc/vnc/xstartup[-r$HOME/.Xresources]&&xrdb$HOME/.Xresources#xsetroot-solidgrey#vncconfig-iconic#xterm-geometry80x24+10+10-ls-title"$VNCDESKTOPDesktop"&#twm&iftest-z"$DBUS_SESSION_BUS_ADDRESS";eval`dbus-launch--sh-syntax–exit-with-session`echo"D-BUSper-sessiondaemonaddressis:\ vncserver啟動(dòng)配置文件/root/.vnc/xstartup修改方式二[root@db11g~]#vi: mentthefollowin olinesfornormaldesktop:unsetSESSION_MANAGERexec[-x/etc/vnc/xstartup]&&exec/etc/vnc/xstartup[-r$HOME/.Xresources]&&xrdb$HOME/.Xresourcesxsetroot-solidgreyvncconfig-iconicxterm-geometry80x24+10+10-ls-title"$VNCDESKTOPDesktop"&#twm&gnome-session重新啟動(dòng)的vncserver進(jìn)vncserver[root@db11g~]#vncserverkill1KillingXvncproce3767vncserver[root@db11g~]#New'db11g:1(root)'desktopisStartingapplicationsspecifiedin/root/.vnc/xstartupLogfileis/root/.vnc/db11g:1.log輸入需要連接服務(wù)器的<服務(wù)器主機(jī)名對(duì)應(yīng)IP>:<vnc桌面端>點(diǎn)擊"Connect輸入vncserver第一次啟動(dòng)時(shí)設(shè)置的：rootroot關(guān)閉不是必需開(kāi)機(jī)自動(dòng)啟動(dòng)的服 ipv6服 ipv4服 [root@db11g~]#chkconfig--level2345bluetoothoffchkconfig--level23456cupsoffchkconfig--level23456ip6tablesoffchkconfig--level23456iptables chkconfig--level23456sendmail chkconfig--level23456yum-updatesd [root@db11g~]#chkconfig--list|grep [root@db11g~]#chkconfig--list|grep [root@db11g~]#chkconfig--list|grep [root@db11g~]#chkconfig--list|grep [root@db11g~]#chkconfig--list|grep [root@db11g~]#chkconfig--list|grep [root@db11g~]#chkconfig--list|grepyum- 創(chuàng)建需要的用戶組和oracle用創(chuàng)建用戶[root@db11g~]#/usr/sbin/groupadd-g501/usr/sbin/groupadd-g502創(chuàng)建oracle用戶，并設(shè)置用戶oracle[root@db11g~]#/usr/sbin/useradd-u502-goinstall-Gdba設(shè)置oracle用戶[root@db11g~]#passwdoracleChangingpasswordforuseroracle.NewUNIXpassword:BADPASSWORD:itisbasedonadictionarywordRetypenewUNIXpassword:passwd:allauthenticationtokensupdated這里oracle用戶的設(shè)置為oracle用戶的環(huán)境變[root@db11g~]#su-oracle[oracle@db11g~]$vibash_profileexportexportORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1exportORACLE_UNQNAME=db11gexportexportPATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATHexportNLS_LANG=american_america.al32utf8oracledatabase(RDBMS裝oracle[root@db11g~]#mkdir-p/u01/app/oraInventorychown-Roracle:oinstallod-R775[root@db11g~]#mkdir-p/u01/app/oraclemkdir/u01/app/oracle/cfgtoollogschown-Roracle:oinstall/u01/app/oracleod-R775/u01/app/oracleoracledatabase(RDBMS)[root@db11g~]#mkdir-p/u01/app/oracle/product/11.2.0/db_1chown-Roracle:oinstallod-R775[root@db11g~]#mkdir/oradatachown-Roracle:dba/oradata創(chuàng)建oracle安裝介質(zhì)存 ,上傳oracle安裝介質(zhì)并解[root@db11g~]#mkdir使用ftp工具(如：SecureFX,FileZilla,xftp等)通過(guò)sftp方式將oracle安裝介質(zhì)上傳到 oracledatabase(RDBMS)oracle[root@db11g~]#cdoracledatabase(RDBMS)[root@db11gsoftwareunzipp13390677_112040_Linux-x86-64_1of7.zip[root@db11gsoftwareunzipp13390677_112040_Linux-x86-64_2of7.zipdatabase修改內(nèi)核參[root@db11g~]#vikernel.shmmni=kernel.sem=25032000100fs.file-max=net.ipv4.ip_local_port_range=9000net.core.rmem_default=net.core.rmem_max=net.core.wmem_default=net.core.wmem_max=fs.aio-max-nr=執(zhí)行下面令使修改生[root@db11g~]#sysctl 修改用戶資源限制參[root@db11g~]#vioraclesoftnproc2047oraclehardnproc16384oraclesoftnofile1024oraclehardnofile65536oraclesoftstack10240修改/etc/pam.d/login文[root@db11g~]#visessionrequired修改/etc/profile文[root@db11g~]#viif[$USER="oracle"];if[$S="/bin/ksh"];thenulimit-p16384ulimit-n65536ulimit-u16384-numask手工設(shè)置時(shí)[root@db11g~]#date-s"2014-02-25TueFeb2509:24:00CST[root@db11g~]#hwclock-檢查并安裝必需下面是oracle11g.2.0.4RAC安裝在redhatenterpriselinux5上必需的compat-libstdc++-33-3.2.3(32bit)glibc-2.3.4-2.41(32libaio-0.3.105(32 libaio-devel-0.3.105(32 libgcc-libgcc-3.4.6(32-bit)libstdc++-3.4.6(32bit)libstdc++-devel3.4.6 unixODBC-2.2.11(32 unixODBC-devel-2.2.11(32 rpm-q--qf'%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n'binutilscompat-libstdc++-33\elfutils-libelf\elfutils-libelf-devel\expat\gcc\gcc-c++\glibc\mon\glibc-devel\glibc-headers\ksh\libaio\libaio-devel\libgcc\libstdc++\libstdc++-devel\make\pdksh\sysstat\unixODBC\binutils-.6-14.el5(x86_64)compat-libstdc++-33-3.2.3-61(x86_64)compat-libstdc++-33-3.2.3-61(i386)elfutils-libelf-0.137-3.el5(x86_64)elfutils-libelf-0.137-3.el5(i386)elfutils-libelf-devel-0.137-3.el5(x86_64)expat-1.95.8-8.3.el5_4.2(x86_64)expat-1.95.8-8.3.el5_4.2(i386)gcc-4.1.2-48.el5(x86_64)gcc-c++-4.1.2-48.el5glibc-2.5-49(i686)glibc-2.5-49(x86_64)mon-2.5-49glibc-devel-2.5-49(i386)glibc-devel-2.5-49(x86_64)glibc-headers-2.5-49(x86_64)ksh-20100202-1.el5(x86_64)libaio-0.3.106-5(x86_64)libaio-0.3.106-5(i386)packagelibaio-develisnotinstalledlibgcc-4.1.2-48.el5(x86_64)libgcc-4.1.2-48.el5(i386)libstdc++-4.1.2-48.el5(x86_64)libstdc++-4.1.2-48.el5(i386)libstdc++-devel-4.1.2-48.el5(x86_64)make-3.81-3.el5(x86_64)packagepdkshisnotinstalledpackagesysstatisnotinstalledpackageunixODBCisnotpackageunixODBC-develisnotredhatenterpriselinux5.5x86_64[root@db11g~]#mount-oro/dev/hdc配置redhatenterpriselinux5.5x86_64安裝介質(zhì)作為yum本地源，安裝[root@db11g~]#vi[root@db11g~]#rpm--import/mnt/RPM-GPG-KEY-redhat-執(zhí)行yuminstall命令安裝操作系統(tǒng)安裝介質(zhì)上的[root@db11g~]#yuminstalllibaio-devel*pdksh*sysstat-7*unixODBC-2* Loadedplugins:rhnplugin,securityThissystemisnotregisteredwithRHN.RHNsupportwillbedisabled. |1.3 |6.1 |1.3 |8.9 |1.3 |868 |1.3 19 SettingupInstallProcessResolvingDependencies-->Runningtransaction--->Packagelibaio-devel.i3860:0.3.106-5settobe--->Packagelibaio-devel.x86_640:0.3.106-5settobe--->Packagepdksh.x86_640:5.2.14-36.el5settobe--->Packagesysstat.x86_640:7.0.2-3.el5settobe--->PackageunixODBC.i3860:2.2.11-7.1settobe--->PackageunixODBC.x86_640:2.2.11-7.1settobe--->PackageunixODBC-devel.i3860:2.2.11-7.1settobe--->PackageunixODBC-devel.x86_640:2.2.11-7.1settobe-->FinishedDependencyResolutionDependenciesResolved kkkkkkkkTransaction 8 0Totaldownloadsize:3.5MIsthisok[y/N]:yDownloadingPackages: 44MB/s|3.5 Runningrpm_check_debugRunningTransactionTestFinishedTransactionTestTransactionTestSucceededRunningTransaction : : :unixODBC- :unixODBC- :libaio- : :libaio- : libaio-devel.i3860:0.3.106-libaio-devel.x86_640:0.3.106-pdksh.x86_640:5.2.14-sysstat.x86_640:7.0.2-unixODBC.i3860:2.2.11-unixODBC.x86_640:2.2.11-unixODBC-devel.i3860:2.2.11-unixODBC-devel.x86_640:2.2.11-執(zhí)行l(wèi)dconfig命令更新動(dòng)態(tài)[root@db11grpm]#ldconfig-再次檢查必需的包是否安rpm-q--qf'%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n'binutilscompat-libstdc++-33\elfutils-libelf\elfutils-libelf-devel\expat\gcc\gcc-c++\glibc\mon\glibc-devel\glibc-headers\ksh\libaio\libaio-devel\libgcc\libstdc++\libstdc++-devel\make\pdksh\sysstat\unixODBC\binutils-.6-14.el5(x86_64)compat-libstdc++-33-3.2.3-61(x86_64)compat-libstdc++-33-3.2.3-61(i386)elfutils-libelf-0.137-3.el5(x86_64)elfutils-libelf-0.137-3.el5(i386)elfutils-libelf-devel-0.137-3.el5(x86_64)expat-1.95.8-8.3.el5_4.2(x86_64)expat-1.95.8-8.3.el5_4.2(i386)gcc-4.1.2-48.el5(x86_64)gcc-c++-4.1.2-48.el5glibc-2.5-49(i686)glibc-2.5-49(x86_64)mon-2.5-49glibc-devel-2.5-49(i386)glibc-devel-2.5-49(x86_64)glibc-headers-2.5-49(x86_64)ksh-20100202-1.el5(x86_64)libaio-0.3.106-5(x86_64)libaio-0.3.106-5(i386)libaio-devel-0.3.106-5(x86_64)libaio-devel-0.3.106-5(i386)libgcc-4.1.2-48.el5(x86_64)libgcc-4.1.2-48.el5(i386)libstdc++-4.1.2-48.el5(x86_64)libstdc++-4.1.2-48.el5(i386)libstdc++-devel-4.1.2-48.el5(x86_64)make-3.81-3.el5(x86_64)pdksh-5.2.14-36.el5(x86_64)sysstat-7.0.2-3.el5(x86_64)unixODBC-2.2.11-7.1(x86_64)unixODBC-2.2.11-7.1(i386)unixODBC-devel-2.2.11-7.1(i386)unixODBC-devel-2.2.11-7.1oraclevnc-vieweroracle_db，oracledatabase(RDBMS)輸入vncserver第一次啟動(dòng)時(shí)設(shè)置的"Open"OpenTerminal"輸入"xhost輸入"suoracle"oracle運(yùn)行./runInstalleroracle點(diǎn)擊"Next"選擇"SkipSoftwareupdates"，點(diǎn)擊"Next選擇"Installdatabasesoftwareonly"，點(diǎn)擊"Next選擇"Singleinstancedatabase點(diǎn)擊"Next"將"SimplifiedChinese"通過(guò)">"按鈕添加到"Selected點(diǎn)擊"Next"選擇"EnterpriseEdition"，點(diǎn)擊"Next"確認(rèn)"OracleBase","SoftwareLocation"路徑，點(diǎn)擊"Next"確認(rèn)"InventoryDirectory"路徑和"oraInventoryGroupName"用戶組，點(diǎn)擊"Next點(diǎn)擊"Install[root@db11g~]#su-oracle[oracle@db11g~]$suroot[root@db11goracle]#Changingpermissionsof/u01/app/oraInventory.Addingread,writepermissionsforgroup.Removingread,write,executepermissionsforChanginggroupnameof/u01/app/oraInventorytooinstall.Theexecutionofthescriptiscomplete.運(yùn)行/u01/app/oracle/product/11.2.0/db_1/root.sh[root@db11goracle]#/u01/app/oracle/product/11.2.0/db_1/root.shPerformingrootuseroperationforOracle11gThefollowingenvironmentvariablesaresetas:ORACLE_OWNER=oracle Enterthefullpathnameofthelocalbindirectory:[/usr/local/bin]:Copyingdbhometo/usr/local/bin...Copyingoraenvto/usr/local/bin...Copyingcoraenvto/usr/local/binCreating/etc/oratabEntrieswillbeaddedtothe/etc/oratabfileasneededbyDatabaseConfigurationAssistantwhenadatabaseiscreatedFinishedrunninggenericpartofrootscript.Nowproduct-specificrootactionswillbeperformed.Finishedproduct-specificrootcaoraclenetca選擇"Listenerconfiguration"，點(diǎn)擊"Next點(diǎn)擊"Next"點(diǎn)擊"Next"點(diǎn)擊"Next"選擇"Usethestandardportnumberof1521",點(diǎn)擊"Next"點(diǎn)擊"Finish"dbca創(chuàng)建數(shù)據(jù)點(diǎn)擊"Next"選擇"CreateaDatabase選擇"GeneralPurposeorTransactionProcessing"類型。生成環(huán)境按需求選擇，一般選擇"CustomDatabase"類型。輸入"GolbalDatabaseName","SID點(diǎn)擊"Next"不勾選"ConfigureEnterpriseManager",點(diǎn)擊"Next"輸入sys,system點(diǎn)擊"Next"選擇"StorageType"為"File選擇"UseCommonLocationforAllDatabaseFiles"，在"DatabaseFileLocation"輸入點(diǎn)擊"Next"不勾選"SpecifyFastRecoveryArea"和"EnableArchiving"，點(diǎn)擊"Next"測(cè)試環(huán)境勾選"SampleSchemas"，點(diǎn)擊"Next在"Memory"選項(xiàng)卡選擇"Custom"SGA在"CharacterSets"選項(xiàng)卡選擇"UseUnicode(AL32UTF8)"，點(diǎn)擊"Next在"Controlfile"的"Options"選項(xiàng)卡修改"umDatafiles"為30720，修改"umRedoLogFiles"為注意：生產(chǎn)環(huán)境還要修改"RedoLogGroups"redolog點(diǎn)擊"Exit"[root@db11g~]#su-[oracle@db11g~]$ps-ef|grepsmon|grep-v 1014:35 00:00:00查看狀[oracle@db11g~]$lsnrctlLSNRCTLforLinux:Version.0-Productionon25-FEB-201414:45:55Copyright(c)1991,2013,Oracle.s.Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db11g)(PORT=1521)))STATUSoftheLISTENER TNSLSNRforLinux:Version.0-Start 25-FEB-2014 0days1hr.11min.6Trace ON:LocalOS ListenerParameterFile ListenerLogFile ListeningEndpointsSummary...ServicesService"db11g"has1Instance"db11g",statusREADY,has1handler(s)forthisService"db11gXDB"has1Instance"db11g",statusREADY,has1handler(s)forthisThecommandcompleted啟動(dòng)和停止數(shù)據(jù)啟動(dòng)[root@db11g~]#su-oracle[oracle@db11g~]$lsnrctlstartLSNRCTLforLinux:Version.0-Productionon25-FEB-201419:39:16Copyright(c)1991,2013,Oracle.s.Starting/u01/app/oracle/pro