RedHatLinuxASUpdate靜默安裝及升級(jí)OracleG

可修改歡迎下載精品Word可修改歡迎下載精品Word可修改歡迎下載精品WordRedHatEnterriseLinux4Update5環(huán)境下靜默方安裝Oracle10.2.0.1升級(jí)到10.2.0.3數(shù)據(jù)庫，并創(chuàng)立數(shù)據(jù)庫Oracle10G安裝

目錄一、檢查安裝環(huán)境： 3二、靜默安裝Oracle10G數(shù)據(jù)庫軟件 9三、靜默安裝監(jiān)聽器： 10四、靜默升級(jí)Oracle10G軟件 11五、靜默創(chuàng)立Oracle10G數(shù)據(jù)庫 13六、設(shè)置oracle效勞自啟動(dòng) 16

一、檢查安裝環(huán)境：LinuxAS4Update5在安裝時(shí)，將所有開發(fā)相關(guān)的組件全部安裝；[root@localhost~]#rpm-qbinutilscompat-dbcontrol-centergccgcc-c++glibcglibc-commongnome-libslibstdc++libstdc++-develmakepdkshsysstatxscreensaverlibaiomake-3.80-6.EL4packagesysstatisnotinstalled[root@localhost~]#sysstat沒有安裝，在安裝盤4中的\RedHat\RPMS\下找到，上傳至LINUX機(jī)器并安裝Preparing...###########################################[100%]1:sysstat###########################################[100%][root@localhost~]#安裝后檢查：[root@localhost~]#rpm-qsysstat[root@localhost~]#安裝成功！判斷本機(jī)是否安裝過oracle：[root@localhost~]#more/etc/oraInst.loc/etc/oraInst.loc:Nosuchfileordirectory[root@localhost~]#表示沒有安裝過oracle創(chuàng)立安裝Oracle需要的用戶和組：[root@localhost~]#groupaddoinstall[root@localhost~]#groupadddba[root@localhost~]#useradd-m-goinstall-Gdbaoracle[root@localhost~]#設(shè)置oracle用戶密碼，這里設(shè)置為“oracle〞[root@localhost~]#passwdoracleChangingpasswordforuseroracle.NewUNIXpassword:BADPASSWORD:itisbasedonadictionarywordRetypenewUNIXpassword:passwd:allauthenticationtokensupdatedsuccessfully.[root@localhost~]#創(chuàng)立安裝oracle所需的目錄：[root@localhost~]#mkdir-p/u01/app/oracle/db_1[root@localhost~]#chownoracle.oinstall/u01/app/oracle[root@localhost~]#chownoracle.oinstall/u01/app/oracle/db_1[root@localhost~]#配置Linux系統(tǒng)內(nèi)核參數(shù)：[root@localhost~]#vi/etc/sysctl.conf修改或添加以下參數(shù)：kernel.shmall=2097152kernel.shmmax=256000000kernel.shmmni=4096kernel.sem=25032000100128fs.file-max=65536lt=1048576注：一般而言我們只需要修改kernel.shmmax這個(gè)值，該參數(shù)應(yīng)該是物理內(nèi)存的一半〔字節(jié)〕編輯完之后存盤退出，然后運(yùn)行以下命令重新加載并驗(yàn)證參數(shù)是否正確：[root@localhost~]#sysctl-pault.rp_filter=1kernel.sysrq=0kernel.core_uses_pid=1kernel.shmall=2097152kernel.shmmax=256000000kernel.shmmni=4096kernel.sem=25032000100128fs.file-max=65536[root@localhost~]#Oracle建議對(duì)每個(gè)Linux賬戶可以使用的進(jìn)程數(shù)和翻開的文件數(shù)設(shè)置限制〔可選設(shè)置〕翻開文件limits.conf[root@localhost~]#vi/etc/security/limits.conf參加以下參數(shù)：*softnproc2047*hardnproc16384*softnofile1024*hardnofile65536修改/etc/pam.d/login文件[root@localhost~]#vi/etc/pam.d/login參加參數(shù)：sessionrequired/lib/security/pam_limits.sosessionrequiredpam_limits.so[root@localhost~]#vi/etc/selinux/config確保存在以下內(nèi)容：SELINUX=disabled配置oracle用戶的環(huán)境變量[root@localhost~]#su-oracle[oracle@localhost~]$vi.bash_profile文件內(nèi)容修改為：#.bash_profile#Getthealiasesandfunctionsif[-f~/.bashrc];then.~/.bashrcfi#Userspecificenvironmentandstartupprograms#OracleEnvironmentexportORACLE_BASE=/u01/app/oracleexportORACLE_HOME=$ORACLE_BASE/db_1exportORACLE_SID=orclexportORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/dataLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libLD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/libexportLD_LIBRARY_PATHexportPATH=$HOME/bin:$ORACLE_HOME/bin:$PATHexportNLS_LANG="AMERICAN_AMERICA.ZHS16GBK"exportPATHunsetUSERNAMEif[$USER="oracle"];thenif[$SHELL="/bin/ksh"];thenulimit-p16384ulimit-n65536elseulimit-u16384-n65536fifi到此，安裝Oracle的準(zhǔn)備工作根本完成，下一步，可以選擇圖形界面安裝或靜默安裝方式，這里使用靜默安裝方式：二、靜默安裝Oracle10G數(shù)據(jù)庫軟件修改響應(yīng)文件：[oracle@localhostdatabase]$cdresponse/[oracle@localhostresponse]$vienterprise.rsp修改必要的參數(shù)UNIX_GROUP_NAME=〞oinstall〞

FROM_LOCATION="../stage/products.xml"

ORACLE_HOME="/u01/app/oracle/db_1"

ORACLE_HOME_NAME="OraDbHome1"

RESTART_SYSTEM=false

RESTART_REMOTE_SYSTEM=false

ORACLE_HOSTNAME=localhostCOMPONENT_LANGUAGES={"zh_CN"}

s_nameForDBAGrp="dba"

n_configurationOption=3

回到Oracle10G的安裝程序目錄，開始安裝：[oracle@localhostdatabase]$./runInstaller-silent-responseFile/home/oracle/database/response/enterprise.rsp安裝完成后，執(zhí)行兩個(gè)腳本〔使用root用戶〕：#.$ORACLE_BASE/oraInventory/orainstRoot.sh#.$ORACLE_HOME/root.sh三、靜默安裝監(jiān)聽器：安裝網(wǎng)絡(luò)監(jiān)聽器

沒有網(wǎng)絡(luò)監(jiān)聽器，客戶端就無法通過網(wǎng)絡(luò)連接Oralce效勞器。要在命令行安裝網(wǎng)絡(luò)監(jiān)聽器，也只能使用靜默模式。

編輯Oracle安裝目錄里response子目錄下的應(yīng)答文件netca.rsp，修改以下工程。

INSTALL_TYPE=""custom""安裝的類型

LISTENER_NUMBER=1監(jiān)聽器數(shù)量

LISTENER_NAMES={"LISTENER"}監(jiān)聽器的名稱列表

LISTENER_PROTOCOLS={"TCP;1521"}監(jiān)聽器使用的通訊協(xié)議列表

LISTENER_START=""LISTENER""監(jiān)聽器啟動(dòng)的名稱然后執(zhí)行：[oracle@localhostresponse]$netca/silent/responseFile/home/oracle/database/response/netca.rsp四、靜默升級(jí)Oracle10G軟件進(jìn)入補(bǔ)丁包安裝目錄#cd/root/Disk1/response修改響應(yīng)文件：patchset.rspUNIX_GROUP_NAME=〞oinstall〞

FROM_LOCATION="../stage/products.xml"

ORACLE_HOME="/u01/app/oracle/db_1"ORACLE_HOME_NAME="OraDbHome1"RESTART_SYSTEM=falseCOMPONENT_LANGUAGES={"zh_CN"}修改后回到補(bǔ)丁程序目錄執(zhí)行：[oracle@localhostresponse]$cd..[oracle@localhostDisk1]$./runInstaller-silent-responseFile/home/oracle/Disk1/response/patchset.rsp安裝成功后，會(huì)提示：100%Done.SetupsuccessfulEndofinstallphases.〔ThuJun0418:47:05CST2021〕Startingtoexecuteconfigurationassistants[oracle@localhostDisk1]$Configurationassistant"OneoffPatchApplication"succeededWARNING:Thefollowingconfigurationscriptsneedtobeexecutedasthe"root"user.#!/bin/sh#Rootscripttorun/u01/app/oracle/db_1/root.shToexecutetheconfigurationscripts:1.Openaterminalwindow2.Loginas"root"3.RunthescriptsTheinstallationofOracleDatabase10gRelease2PatchSet2wassuccessful.Pleasecheck'/u01/app/oracle/oraInventory/logs/silentInstall2021-06-04_06-43-40PM.log'formoredetails.使用root用戶登錄，執(zhí)行：/u01/app/oracle/db_1/root.sh[root@localhostdb_1]#./root.shRunningOracle10root.shscript...Thefollowingenvironmentvariablesaresetas:ORACLE_OWNER=oracleORACLE_HOME=/u01/app/oracle/db_1Enterthefullpathnameofthelocalbindirectory:[/usr/local/bin]:Thefile"dbhome"alreadyexistsin/usr/local/bin.Overwriteit?〔y/n〕[n]:yCopyingdbhometo/usr/local/bin...Thefile"oraenv"alreadyexistsin/usr/local/bin.Overwriteit?〔y/n〕[n]:yCopyingoraenvto/usr/local/bin...Thefile"coraenv"alreadyexistsin/usr/local/bin.Overwriteit?〔y/n〕[n]:yCopyingcoraenvto/usr/local/bin...Entrieswillbeaddedtothe/etc/oratabfileasneededbyDatabaseConfigurationAssistantwhenadatabaseiscreatedFinishedrunninggenericpartofroot.shscript.Nowproduct-specificrootactionswillbeperformed.[root@localhostdb_1]#五、靜默創(chuàng)立Oracle10G數(shù)據(jù)庫修改響應(yīng)文件編輯Oracle安裝目錄里response子目錄下的應(yīng)答文件dbca.rspOPERATION_TYPE="createDatabase"GDBNAME="orcl"SID="orcl"SYSPASSWORD="sys"SYSTEMPASSWORD="system"CHARACTERSET="ZHS16GBK"TEMPLATENAME="/u01/app/oracle/db_1/assistants/dbca/templates/General_Purpose.dbc"EMCONFIGURATION="LOCAL"SYSMANPASSWORD="sysman"DBSNMPPASSWORD="dbsnmp"執(zhí)行：[oracle@localhostresponse]$dbca-silent-responseFile/home/oracle/database/response/dbca.rspCopyingdatabasefiles1%complete3%complete11%complete18%complete26%complete37%completeCreatingandstartingOracleinstance40%complete45%complete50%complete55%complete56%complete60%complete62%completeCompletingDatabaseCreation66%complete70%complete73%complete85%complete96%complete100%completeLookatthelogfile"/u01/app/oracle/db_1/cfgtoollogs/dbca/orcl/orcl.log"forfurtherdetails.[oracle@localhostresponse]$數(shù)據(jù)庫創(chuàng)立成功后須要注冊(cè)一些信息，運(yùn)行

$ORACLE_BASE/oraInventory/orainstRoot.sh

然后編輯/etc/oratab

將

<Oracle的SID>:<Oracle的主目錄>:N

修改為

<Oracle的SID>:<Oracle的主目錄>:Y

安裝完成！啟動(dòng)數(shù)據(jù)庫效勞,sys用戶登錄SQLPLUS：Sql>startup啟動(dòng)監(jiān)聽器：[oracle@localhost~]$lsnrctlstart啟動(dòng)企業(yè)管理器效勞[oracle@localhost~]$emctlstartdbconsole訪問地址為：://IP:1158/em/如果有多個(gè)實(shí)例，那么從第二個(gè)實(shí)例開始，訪問的端口依次為5500、5501……如需使用iSQL*PLUS，那么啟動(dòng)相應(yīng)效勞[oracle@localhost~]$isqlplusctlstart訪問地址為：://IP:5560/isqlplus六、設(shè)置oracle效勞自啟動(dòng)在oracle用戶下修改文件$ORACLE_HOME/bin/dbstart查找ORACLE_HOME_LISTNER=改為ORACLE_HOME_LISTNER=$ORACLE_HOME在root用戶下編輯文件#cd/etc/rc.d/init.d/

#vioradb寫入如下文件內(nèi)容：#!/bin/bash#chkconfig:3459910#description:StartupScriptforOracleDatabases#/etc/rc.d/init.d/dbstartexportORACLE_BASE=/u01/app/oracleexportORACLE_HOME=/u01/app/oracle/db_1exportORACLE_SID=orclexportPATH=$PATH:$ORACLE_HOME/binORA_OWNR="oracle"#iftheexecutablesdonotexist--displayerrorif[!-f$ORACLE_HOME/bin/dbstart-o!-d$ORACLE_HOME]thenecho"Oraclestartup:cannotstart"exit1fi#dependingonpara