成果oracle11g r2for linux安裝配置

文檔控 IP規(guī)劃與/etc/hosts配置規(guī) 配置oracle用戶(hù)的s限制規(guī) Oracle用戶(hù).bash_profile配置規(guī) OracleDatabase安裝配置規(guī) 創(chuàng)建數(shù)據(jù) DB實(shí)例初始化參數(shù)設(shè)置（注意黑體字部分 參數(shù)介 軟件包安 用戶(hù)配 配 系統(tǒng)服 配 數(shù)據(jù)庫(kù)檢 文檔控日 作 版 修改記系統(tǒng)基本DNS時(shí)間服務(wù)器地址（可選IP數(shù)據(jù)文件路注意如果節(jié)點(diǎn)數(shù)多于兩個(gè)，按表中樣式分別提供主機(jī)名、IP地址、VIP地址、具體詳細(xì)規(guī)劃，需要參照實(shí)際生產(chǎn)環(huán)境的需求，以合理規(guī)劃存放Redo文件的磁盤(pán)使用RAID0+1，其他磁盤(pán)根據(jù)業(yè)務(wù)壓力于業(yè)務(wù)壓力大的使用RAID0+1，其他使用RAID5。序說(shuō)備1建議使用LV23建議使用LV4版安裝前準(zhǔn)備工IP規(guī)劃與/etc/hosts備份初始備份初始/etc/hosts文件：cpetc/hostsYYYYOracle議以O(shè)racle戶(hù)安裝Oracle據(jù)庫(kù)并且oracle戶(hù)需要屬于不同YYYY操作如groupadd-g1000oinstallgroupadd-g1001dbagroupadd-g1002operuseradd-goinstall-Gdba,oper：[root@irsdb2~]#passwdoracleChangingpasswordforuseroracle.NewUNIXpassword:oracleBADPASSWORD:itisbasedonadictionarywordRetypenewUNIXpassword:oraclepasswd:allauthenticationtokensupdated1.oracleoracle用戶(hù)的環(huán)境變量配置信息規(guī)范，見(jiàn)下述ORACLE_SID操作如mkdirmkdir-p/oracle/app/oracle/product/11.2.0/db_1chown-Roracle.oinstall/oracleod-R775配置oracle用戶(hù)的s限制規(guī)操作如//#vi修改/etc/pam.d/login配置文件規(guī)操作如備份初始備份初始/etc/pam.d/login文件：cpetc/pam.d/login#visessionrequired修改/etc/sysctl.conf文件規(guī)操作如/#vikernel.shmmni=kernel.shmall70%(bytes單位)/4096kernel.shmmax=內(nèi)存容量的70%(以bytes單位)kernel.sem=25032000100128fs.file-maxnet.ipv4.ip_local_port_range=9000net.core.rmem_default=262144net.core.rmem_max=net.core.wmem_default=262144net.core.wmem_max=net.ipv4.tcp_wmem=262144262144262144net.ipv4.tcp_rmem=fs.aio-max-nr=#sysctl-p1.kernel.shmmni*kernel.shmallkernel.shmmax(bytes單位)，kernel.shmmax的值要大于數(shù)據(jù)庫(kù)實(shí)例名規(guī)8位；數(shù)據(jù)庫(kù)服務(wù)名名格式為：XXXYY；數(shù)據(jù)庫(kù)的SID名格式為：XXXYY。XXX3Oracle用戶(hù).bash_profile##vi/home/oracle/.bash_profile RPM包安裝包規(guī)由于Oracle在不同版本和不同類(lèi)型的操作系統(tǒng)上要求的rpm盡相同，因此具體要求根據(jù)現(xiàn)場(chǎng)實(shí)際環(huán)境為準(zhǔn)，以文檔建議為參考依據(jù)。以下列出以RHEL5和RHEL6為代表的情況?；蛘咴诎惭b過(guò)程中，根據(jù)缺失的rpm提示，RPM包為RHEL5rpmrpm-Uvhbinutils-rpm-Uvhcompat-libstdc++-rpm-Uvhcompat-libstdc++-33*.i386.rpmrpm-Uvhelfutils-libelf*rpm-Uvhgcc-rpm-Uvhgcc-c++-4.*rpm-Uvhglibc-2.*rpm-Uvh rpm-Uvhglibc-devel-2.*rpm-Uvhglibc-headers-2.*rpm-Uvhksh*rpm-Uvhlibaio-rpm-Uvhlibaio-devel-0.*rpm-Uvhlibgomp-4.*rpm-Uvhlibgcc-4.*rpm-Uvhlibstdc++-rpm-Uvhlibstdc++-devel-4.*rpm-Uvhmake-3.*rpm-Uvhsysstat-rpm-UvhunixODBC-rpm-UvhunixODBC-devel-2.*rpm-Uvhnumactl-devel-*rpm-q--qf'%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n'binutils-2compat-libstdc++-compat-libstdc++-elfutils-libelfgcc-4gcc-c++-4glibc-2 monglibc-develglibc-headerskshlibaiorpm-q--qf'%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n'binutils-2compat-libstdc++-compat-libstdc++-elfutils-libelfgcc-4gcc-c++-4glibc-2 monglibc-develglibc-headerskshlibaiolibaio-devellibgomplibgcclibstdc++-libstdc++-develmakesysstatunixODBCunixODBC-以下RPM為RHEL6須安binutils-2.20.51.0.2-5.11.el6binutils-2.20.51.0.2-5.11.el6(x86_64)compat-libcap1-1.10-1(x86_64)compat-libstdc++-33-3.2.3-69.el6(x86_64)gcc-4.4.4-13.el6glibc-2.12-1.7.el6(i686)glibc-2.12-1.7.el6(x86_64)glibc-devel-2.12-1.7.el6(x86_64)libgcc-4.4.4-13.el6(i686)libgcc-4.4.4-13.el6(x86_64)libstdc++-4.4.4-13.el6(x86_64)libstdc++-devel-4.4.4-13.el6(x86_64)libaio-0.3.107-10.el6(x86_64)libaio-devel-0.3.107-10.el6(x86_64)sysstat-9.0.4-11.el6unixODBC-2.2.14-11.el6(x86_64)orlaterunixODBC-2.2.14-11.el6.i686orlaterunixODBC-devel-2.2.14-11.el6(x86_64)orlaterunixODBC-devel-2.2.14-11.el6.i686orlaterrpm-q--qf'%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n'binutilscompat-libcap1compat-libstdc++-compat-libstdc++-gcc-glibcglibc-develkshlibgcclibstdc++-libstdc++-devel-libaio-0.3.107libaio-develmakesysstatunixODBCunixODBC-devel軟件安裝配置規(guī)Oracle軟件安裝規(guī)軟件安裝過(guò)程中的規(guī)安裝步安裝內(nèi)選擇內(nèi)1oracleIwishtoreceivesecurityviaMyOracleSupport.2Skipsoftware3Installdatabasesoftware4OracleRealApplicationclustersdatabasesshconnectivityoracle5EnglishSimplified6Enterprise7ORACLEBASEORACLE8操作系統(tǒng)用戶(hù)Databaseadministratorgroup:dbaDatabaseoperatorgroup:oper9ScanOracleDatabase狀狀名開(kāi)啟（部署階段不開(kāi)AMERICAN_AMERICA.UTF8（提供塊（block）8K（業(yè)務(wù)需要來(lái)定具體安裝過(guò)程如下上傳Oracle11g安裝包至Oracle用戶(hù) 下[oracle@templet~]$ls--rwxrwxr-x1oracleMay3013:23-rwxrwxr-x1oracleMay3013:23解壓軟件安裝[oracle@templet[oracle@templet~]$unzip[oracle@templet~]$unzip解壓后，進(jìn)入database 下，執(zhí)行./runInstaller進(jìn)行Oracle軟件安選擇跳過(guò)軟件升級(jí)，點(diǎn)擊下一步選擇僅安裝數(shù)據(jù)庫(kù)軟件，點(diǎn)擊下一選擇安裝單實(shí)例數(shù)據(jù)庫(kù)安裝，點(diǎn)擊下一步默認(rèn)配置，點(diǎn)擊下一選擇企業(yè)版，點(diǎn)擊下一步不需手動(dòng)配置。點(diǎn)擊下一步。默認(rèn)配置，點(diǎn)擊下一默認(rèn)配置，點(diǎn)擊下一此處需要特別注意這里展示的解釋是數(shù)據(jù)庫(kù)自己的對(duì)將要安裝的環(huán)境rpmyum源進(jìn)行安裝后，才能進(jìn)行下一步安裝。點(diǎn)擊“install”，進(jìn)行安裝安裝完成后，彈出以上界面。注意一定要根據(jù)提示，使用root戶(hù)執(zhí)行兩個(gè)。執(zhí)行后，完成數(shù)據(jù)庫(kù)軟件安形終端工作正常。Oracle戶(hù)登錄主機(jī)，然后dbca令，出現(xiàn)如下，窗選擇”O(jiān)racleRealApplicationClusters(RAC)database”選項(xiàng)，然后單選擇”Createdatabase”選項(xiàng)，然后單擊”Next”按鈕執(zhí)行下一步選擇”CustomDatabase”選項(xiàng)，然后單擊”Next”按鈕執(zhí)行下一步選擇ConfigurationType為Admin-Manager,輸入數(shù)據(jù)庫(kù)名稱(chēng)，然后單擊”SelectAll”,選擇在2節(jié)點(diǎn)創(chuàng)建數(shù)據(jù)庫(kù)，最后單擊”Next”按鈕執(zhí)行下取消”ConfigureEnterpriseManager”設(shè)置選擇“Enableautomaticmaintenancetasks”（默認(rèn)然后單擊”Next”輸令，然后單擊”Next”按鈕執(zhí)行下一步StorageType選擇“AutomaticStorageManagement(ASM)”UseOracle-ManagerFiles”輸入磁盤(pán)組名稱(chēng):+DATA,然后單擊”Next”按鈕執(zhí)行不選上面的“SpecifyFastRecoveryArea”和“EnableArchiving”兩個(gè)如果應(yīng)用程序?qū)?shù)據(jù)庫(kù)組件沒(méi)有特殊要求，一般創(chuàng)建數(shù)據(jù)庫(kù)時(shí)不選擇”O(jiān)racleText,OracleOLAP,OracleSpatial,OracleLableSecurity,SampleSchemas,EnterpriseManagerRepository，OracleWarehouseBuilder,OracleDatabaseVault”,然后單擊”StandardDatabaseComponents”：如果應(yīng)用程序?qū)?shù)據(jù)庫(kù)組件沒(méi)有特殊要求，一般創(chuàng)建數(shù)據(jù)庫(kù)時(shí)不選OracleJVM,OracleXMLDB,OracleMultimedia,OracleApplicationExpress,然后單擊”O(jiān)K”按鈕對(duì)于SGAPGA建議SGA組件自動(dòng)分配，請(qǐng)參照本文后《初始化參數(shù)設(shè)置》部分按應(yīng)用需求進(jìn)行DBBlockSizeProcess量設(shè)置字符集設(shè)置，按照應(yīng)用要求設(shè)置字符集，單擊”Next”按鈕執(zhí)行下一步和個(gè)數(shù)，一般每個(gè)實(shí)例3組，每組2個(gè)member，大小1G~2G，單擊t按鈕執(zhí)行下一步：?jiǎn)螕簟盕inish”按鈕單擊”O(jiān)K”按鈕，出現(xiàn)創(chuàng)建數(shù)據(jù)庫(kù)的窗口，等待數(shù)據(jù)庫(kù)創(chuàng)建完成即數(shù)據(jù)庫(kù)初始化參數(shù)設(shè)序名建數(shù)據(jù)文件存放位1SYSTEM2SYSAUX3UNDOTBS14TEMPDB實(shí)例初始化參數(shù)設(shè)置（參推薦SGA和PGA內(nèi)存動(dòng)態(tài)分配，推薦SGAPGA控制SGA和PGA內(nèi)存動(dòng)態(tài)分配，推薦SGAPGASGASGA和PGA控制undoretention動(dòng)調(diào)整功能，推薦值為false，取自動(dòng)調(diào)整UNDO置根據(jù)實(shí) 設(shè)置，RAC環(huán)境下推薦用共推薦值為 24susu-sqlplus/asaltersystemsetmemory_max_target=(Physicalmemory)*60% altersystemsetmemory_target=(Physicalmemory)*60% altersystemsetsga_max_size=(Physical alteraltersystemsetprocesses=2048scope=spfile;altersystemsetdb_files=2048scope=spfile;altersystemsetparallel_ _local=truescope=spfile;altersystemset"_undo_autotune"=falsescope=spfile;altersystemsetundo_retention=36000scope=spfile;altersystemsetcontrol_file_record_keep_time=31scope=spfile;altersystemsetopen_cursors=4000;altersystemsetaltersystemsetsession_cached_cursors=200scope=spfile_name=>'autospaceadvisor',operation=>NULL,window_name=>/altersystemset“ _logging_threshold_seconds”=1800scope=both;altersystemset“ _rejection_threshold_hours”=24scope=both;數(shù)據(jù)庫(kù)歸檔設(shè)置（可選為了便于數(shù)據(jù)庫(kù)恢復(fù)及歸檔日志，建議將歸檔日志在一個(gè)共享文件系統(tǒng)中，具體 的所有者和組設(shè)置為oracle:oinstall。#chown-Roracle:oinstall/arch然后在sqlplus中執(zhí)行下面語(yǔ)句SQL>altersystemset關(guān)閉所有實(shí)例SQL>shutdown在其中一個(gè)節(jié)點(diǎn)上執(zhí)行下面語(yǔ)句SQL>startupSQL>alterdatabaseSQL>alterdatabase執(zhí)行archiveloglist認(rèn)node1檔設(shè)置成SQL>archivelogDatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestination/archOldestonlinelogsequence3Nextlogsequencetoarchive5Currentlogsequence5node2登錄SQLPLUS開(kāi)其他實(shí)例archiveloglistnode2歸檔設(shè)置成SQL>archivelogDatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestination/archOldestonlinelogsequence3Nextlogsequencetoarchive5Currentlogsequence5altersystemarchivelog數(shù)據(jù)庫(kù)安裝驗(yàn)unameunamecat/etc/redhat-cat/proc/cpuinfo|tail-ipadifconfigipadifconfig-acat/etc/sysconfig/network-scripts/ifcfg-bond0cat/etc/sysconfig/network-scripts/ifcfg-bond1cat/etc/sysconfig/network-scripts/ifcfg-eth0cat/etc/sysconfig/network-scripts/ifcfg-eth1cat/etc/sysconfig/network-scripts/ifcfg-eth2cat/etc/sysconfig/network-scripts/ifcfg-eth3cat/proc/net/bonding/bond0cat/proc/net/bonding/bond1ethtooleth0ethtooleth1ethtoolethtoolrpm-q--qf'%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n'binutilscompat-libstdc++-33elfutils-libelfelfutils-libelf-develelfutils-libelf-devel-staticgccgcc-c++glibc monrpm-q--qf'%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n'binutilscompat-libstdc++-33elfutils-libelfelfutils-libelf-develelfutils-libelf-devel-staticgccgcc-c++glibc monglibc-develglibc-headerskshlibaiolibaio-devellibgcclibstdc++libstdc++-develmakesysstatunixODBCunixODBC-develbinutils|grep"isnotinstalled"rpm-sysctlsysctl-a|grepsysctl-a|grepvfs_cache_pressuresysctl-a|grepmin_ cat/etc/sysctl.conf|grep-v'^#'sysctl-aidgrididgrididoraclecat/home/grid/.bash_profile|grep-v'^#'|grep-v'^$'cat/home/oracle/.bash_profile|grep-v'^#'|grep-v'^$'su-grid–c“ulimit–a”susu-grid–c“ulimit–a”su-oracle–c“ulimit–a”cat/etc/security/limits.conf|grep-v'^#'|grep-v'^$'cat/etc/pam.d/login|grep-v'^#'|grep-v'^$'配置cat/etc/hosts|grep-v'^#'|grep-v'^$'cat/etc/hosts|grep-v'^#'|grep-v'^$'cat/etc/ntp.conf|grep-v'^#'|grep-v'^$'cat/etc/resolv.conf|grep-v'^#'|grep-v'^$'cat/etc/nsswitch.conf|grep-v'^#'|grep-v'^$'catcat/etc/selinux/config|grep-v'^#'|grep-v'^$'chkconfig--listserviceiptablesstatuscat/etc/rc.local|grep-v'^#'|grep-v df-hls-l/dev/mapper/*ls-l/dev/dm*cat/etc/multipath.conf|grep-v'^#'|grep-v'^$'multipath-lcat/etc/udev/rules.d/12-dm-asmdevices.rules|grep-v'^#'|g