SAP系統(tǒng)onRAC環(huán)境部署

RQA系統(tǒng)RAC驗(yàn)證環(huán)境部署ASCS安裝介質(zhì)準(zhǔn)備執(zhí)行安裝使用遠(yuǎn)程GUI連接root/oss789!!Pass1234DB主機(jī)準(zhǔn)備介質(zhì)準(zhǔn)備將介質(zhì)上傳到所有的節(jié)點(diǎn)上并解壓相關(guān)介質(zhì)(unrar,SAPCAR解壓)安裝unrar軟件包內(nèi)核和安裝工具RDBMS介質(zhì)創(chuàng)建用戶和組手動(dòng)創(chuàng)建orauser用戶安裝oracle軟件切換到/oracle/stage/112_64/database/下在oracle用戶下執(zhí)行./runInstaller在所有節(jié)點(diǎn)上運(yùn)行上述腳本由于不是在集群文件中創(chuàng)建符號(hào),因此需要在所有的節(jié)點(diǎn)上創(chuàng)建$ln-s/u01/app/oracle/product//dbhome_2112安裝Oracle補(bǔ)丁更新OPatch更新MOPatch執(zhí)行安裝補(bǔ)丁命令/bin/sh/oracle/RQA/112/MOPatch/mopatch.sh-v-sSAP11204P_11.ZIP轉(zhuǎn)移數(shù)據(jù)到目標(biāo)主機(jī)目標(biāo)系統(tǒng)數(shù)據(jù)導(dǎo)入Pass123417UgeUM50D001eqtd11w01A7brconnect-u/-c-osummary-fstats-oSAPSR3-tall-p8-fnocasc查看ora_sql_results.log日志解決方案:#chownoracle:asmadmin/oracle/RQA/112/bin/oracle#chmod6751/oracle/RQA/112/bin/oracle每個(gè)節(jié)點(diǎn)都做上述調(diào)整查看ora_sql_results.log日志查看alert_RQA.log日志解決方案:db_recovery_file_dest路徑更改到+FLASH磁盤(pán)組下查看ora_sql_results.log查看alert_RQA.log解決方案:usermod-a-Goinstallorarqa，然后關(guān)掉GUI，重開(kāi)GUIsession準(zhǔn)備其他節(jié)點(diǎn)節(jié)點(diǎn)二創(chuàng)建用戶和組準(zhǔn)備數(shù)據(jù)庫(kù)實(shí)例安裝介質(zhì)Pass1234節(jié)點(diǎn)三創(chuàng)建用戶和組準(zhǔn)備數(shù)據(jù)庫(kù)實(shí)例Pass1234啟動(dòng)數(shù)據(jù)庫(kù)將數(shù)據(jù)庫(kù)在所有的節(jié)點(diǎn)上啟動(dòng)啟動(dòng)前#stringsspfileRQA.ora查看本地監(jiān)聽(tīng)更改local_listener參數(shù)SQL>altersystemsetlocal_listener='hd-test-racdb02:1521'sid='RQA2';SQL>altersystemsetlocal_listener='hd-test-racdb03:1521'sid='RQA3';啟動(dòng)數(shù)據(jù)庫(kù)srvctlstartdatabase-dRQA查看數(shù)據(jù)庫(kù)狀態(tài)PAS實(shí)例安裝oss789!!sap_df10將腳本拷貝到databasehost(其中一個(gè)節(jié)點(diǎn))在oracle用戶下執(zhí)行1)設(shè)置ORACLE_HOME$exportORACLE_HOME=/oracle/RQA/1122)腳本賦予權(quán)限3)切換到相應(yīng)目錄執(zhí)行腳本查看本地監(jiān)聽(tīng)在preferinstance節(jié)點(diǎn)查看到有service“RQA_DVEBMGS05”注冊(cè)查看日志saplikey.log和dev_likeyDbSlConnect(DBSL_DEFAULT_CON_INFO):invalidconnectmethod解決方案:需要手動(dòng)查看SSFS設(shè)置是否正確(參考SAPNote1639578-SSFSaspasswordstoreforprimarydatabaseconnect)手動(dòng)在DEFAULT.PFL文件中增加rsdb/ssfs_connect=1然后執(zhí)行PAS安裝至此RAC環(huán)境下的SAP系統(tǒng)安裝完成后續(xù)活動(dòng)系統(tǒng)拷貝后續(xù)活動(dòng)執(zhí)行數(shù)據(jù)庫(kù)統(tǒng)計(jì)在rqaadm中執(zhí)行數(shù)據(jù)庫(kù)統(tǒng)計(jì)brconnect-u/-c-osummary-fstats-oSAPSR3-tall-p8-fnocasc更新DB主機(jī)上內(nèi)核系統(tǒng)檢查事務(wù)碼:SM28System->Status安裝LICENSE進(jìn)行遷移后HardwareKey發(fā)生了變化，因此原License失效，需要重新申請(qǐng)License并執(zhí)行SLICENSE事務(wù)碼安裝硬件碼:N1397915792調(diào)整參數(shù)調(diào)整SAP系統(tǒng)參數(shù)參數(shù)值install/codepage/appl_server4103login/system_client800zcsa/installed_languages1EDzcsa/system_language1zcsa/second_languageErdisp/wp_no_dia20rdisp/wp_no_btc7rdisp/wp_no_vb5rdisp/wp_no_vb22rdisp/wp_no_spo1login/no_automatic_user_sapstar0rdisp/max_wprun_time7200login/create_sso2_ticket2login/accept_sso2_ticket1rsdb/cua/buffersize12000abap/shared_objects_size_MB800icm/server_port_0PROT=HTTP,PORT=80$$,TIMEOUT=3600,PROCTIMEOUT=3600icm/host_name_fulldev-np21-srm1.dongfeng-nissan..is/SMTP/virt_host_0*:25000;icm/server_port_1PROT=SMTP,PORT=25000,TIMEOUT=3600,PROCTIMEOUT=3600執(zhí)行刪除操作SE14執(zhí)行刪除操作刪除如下表OracleDatabaseonly:DBSTATHORA,DBSTAIHORA,DBSTATIORA,DBSTATTORA2)SE14刪除如下表記錄ALCONSEG,ALSYSTEMS,DBSNP,MONI,OSMON,PAHI,SDBAD,SDBAH,SDBAP,SDBAR刪除DDLOG表記錄以進(jìn)行buffer同步刪除源系統(tǒng)profile參數(shù)變更表記錄TPFET,TPFHT刪除完成后需要執(zhí)行sapdba_role.sql腳本SE06操作登錄000Client客戶端進(jìn)行設(shè)置STMS執(zhí)行傳輸配置創(chuàng)建虛擬系統(tǒng)配置路由由顯示到更改釋放標(biāo)準(zhǔn)作業(yè)事務(wù)碼:SM36RFC調(diào)整SM59進(jìn)行RFC調(diào)整恢復(fù)掛起JOB事務(wù)碼:SE38程序BTCTRNS2恢復(fù)后需要調(diào)整作業(yè)，將重復(fù)的標(biāo)準(zhǔn)作業(yè)刪除,事務(wù)碼:SM37SGEN預(yù)編譯SGEN執(zhí)行相關(guān)組件的預(yù)編譯作