EBSR12系統(tǒng)管理培訓(xùn)稿

1、Oracle ERP系統(tǒng)管理 Date: 7/14/2022 11. Oracle ERP 架構(gòu)2. 啟動(dòng)和關(guān)閉 Oracle ERP3. ERP平安性管理4. 設(shè)定檔5. 并行管理6. 并行管理程序7. 使用者監(jiān)控8. 維護(hù) Oracle ERP內(nèi)容2 Oracle ERP 結(jié)構(gòu)3客戶(hù)端4應(yīng)用層網(wǎng)頁(yè)效勞器Forms 效勞器Oracle 數(shù)據(jù)庫(kù)Report 效勞器并行處理效勞器TCF Server (Thin Client Framework)Forms ServerReports ServerAS 10g (web server)Oracle DatabaseTCF ServerConcur

2、rent Processing ServerApplication5數(shù)據(jù)庫(kù)層Oracle 數(shù)據(jù)庫(kù)Oracle 數(shù)據(jù)庫(kù)檔案Oracle Database11gData FileDatabase6互聯(lián)網(wǎng)架構(gòu) 客戶(hù)端 應(yīng)用層 數(shù)據(jù)庫(kù)層Forms ServerReports ServerAS 10g(web server)Concurrent Processing ServerBrowserOracle Database11g R1PCOracle DatabaseData FileTCF ServerJava Console7系統(tǒng)架構(gòu)89文件目錄結(jié)構(gòu)10文件目錄結(jié)構(gòu)11文件目錄結(jié)構(gòu)12文件目錄結(jié)構(gòu)1

3、3 開(kāi)啟和關(guān)閉 Oracle ERP14關(guān)閉 Oracle ERP關(guān)閉 AP Tier關(guān)閉Concurrent Server關(guān)閉 Reports Server關(guān)閉 iAS Server關(guān)閉 Forms Server15關(guān)閉 Oracle ERPForms 效勞器login as applprodChange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/ $ adfrmctl.sh stop (Form Server)$ adfmcctl.sh stop (not required) (Metri

4、cs Client) $ adfmsctl.sh stop (not required) (Metrics Server)16關(guān)閉 Oracle ERP網(wǎng)頁(yè)效勞器login as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/ $ adapcctl.sh stop (Apache Server)17關(guān)閉 Oracle ERP并行處理效勞器login as applprodchange dir to Applications start/stop scripts loc

5、ation $INST_TOP/admin/scripts/$ adcmctl.sh stop apps/apps (Concurrent Manager) 18關(guān)閉 Oracle ERP整個(gè) AP 層login as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/ $ adstpall.sh apps/apps 19關(guān)閉 Oracle ERP關(guān)閉 DB 層關(guān)閉數(shù)據(jù)庫(kù)監(jiān)聽(tīng)器關(guān)閉數(shù)據(jù)庫(kù)20關(guān)閉 Oracle ERPlogin as oraprodchange dir t

6、o Database startup/shutdown scripts location $ORACLE_HOME/appsutil/scripts/PROD_mcerpdb1 $ addlnctl.sh stop PROD (Listener)$ addbctl.sh stop immediate (DB)21開(kāi)啟 Oracle ERP開(kāi)啟 DB 層開(kāi)啟數(shù)據(jù)庫(kù)開(kāi)啟監(jiān)聽(tīng)器22開(kāi)啟 Oracle ERPlogin as oraprodchange dir to Database startup/shutdown scripts location $ORACLE_HOME/appsutil/scr

7、ipts/PROD_mcerpdb1 $ addbctl.sh start (DB)$ addlnctl.sh start PROD (Listener)23開(kāi)啟 Oracle ERP開(kāi)啟 AP Tier開(kāi)啟 iAS 效勞器開(kāi)啟 Concurrent 效勞器開(kāi)啟 Forms 效勞器開(kāi)啟 Reports 效勞器24開(kāi)啟 Oracle ERPForms 效勞器login as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/ $ adfmsctl.sh start (not

8、 required) (Metrics Server) $ adfmcctl.sh start (not required) (Metrics Client) $ adfrmctl.sh start (Form Server)25開(kāi)啟 Oracle ERP網(wǎng)頁(yè)效勞器login as applprodChange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/$ adapcctl.sh start (Apache Server)$ adtcfctl.sh start (not required) (

9、TCF SocketServer) 26開(kāi)啟 Oracle ERP并行處理效勞器login as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/$ adcmctl.sh start apps/apps (Concurrent Manager)27開(kāi)啟 Oracle ERP所有AP 層login as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/script

10、s/$ adstrtal.sh apps/apps 28 ERP平安性管理29職責(zé)Responsibility30菜單 & 子菜單 & 程序子菜單程序菜單NavigateWindows31請(qǐng)求組 & 請(qǐng)求 & 請(qǐng)求集請(qǐng)求組請(qǐng)求集請(qǐng)求SRS form32程序 & 子程序Sub Function33Oracle ERP 平安性概論使用者職責(zé)職責(zé)職責(zé)菜單請(qǐng)求組數(shù)據(jù)組報(bào)表請(qǐng)求集程式子菜單子菜單程式子程式34Oracle ERP 系統(tǒng)的權(quán)限管控職責(zé) 2職責(zé) 1使用者程式 1程式 2報(bào)表 2報(bào)表 3程式 1程式 3報(bào)表 3報(bào)表 435菜單 : 可以執(zhí)行哪個(gè)表單請(qǐng)求: 可以執(zhí)行哪個(gè)報(bào)表數(shù)據(jù)組 : 如何連接數(shù)

11、據(jù)庫(kù)職責(zé)關(guān)系圖職責(zé)數(shù)據(jù)組菜單請(qǐng)求組36菜單菜單子菜單程序程序程序子菜單子菜單程序程序程序職責(zé) (A)將設(shè)定好的Menu指派給Responsibility37.請(qǐng)求組職責(zé) (A)職責(zé) (B)職責(zé) (C).報(bào)表報(bào)表38數(shù)據(jù)組Oracle數(shù)據(jù)庫(kù)Group name : StandardOracle ID : APPS職責(zé)職責(zé)職責(zé)職責(zé)職責(zé)職責(zé)39定義ERP 使用者使用者User Name名稱(chēng)Password 密碼Password Expiration 密碼到期日Effective Dates 有效日職責(zé)職責(zé)Effective Dates 有效日40定義新的使用者41定義新的職責(zé)42定義菜單43如何定義

12、報(bào)表定義執(zhí)行檔定義值集定義程序設(shè)定請(qǐng)求設(shè)定職責(zé)-請(qǐng)求群組44定義執(zhí)行檔45定義值集46定義值集47定義程式48定義程式49設(shè)定職責(zé)-請(qǐng)求群組50系統(tǒng)參數(shù)系統(tǒng)參數(shù) (Pro) 主要在設(shè)定Oracle ERP系統(tǒng)或各模塊相關(guān)的重要參數(shù)。系統(tǒng)參數(shù)的設(shè)定層級(jí)有：SiteApplicationResponsibilityUserSite、Application及Responsibility 層級(jí)須由系統(tǒng)管理員設(shè)定,一般使用者可設(shè)定User Level。51設(shè)定層影響范圍DEMOOMPOMRPOM Super UserOM AdministratorOM Vision Operations (USA)Ro

13、ger地點(diǎn)應(yīng)用模組職責(zé)使用者Kevin52個(gè)人設(shè)定層選項(xiàng)53系統(tǒng)設(shè)定層選項(xiàng)54ICX 設(shè)定ICX:Session Timeout連接Timeout時(shí)間,以分鐘計(jì),假設(shè)idle時(shí)間超過(guò)限制,系統(tǒng)會(huì)要求重新登錄,0或空白代表沒(méi)有連接時(shí)間限制ICX: Limit timeSession 可以在系統(tǒng)停留的最長(zhǎng)時(shí)間(包括active & inactive)ICX: Limit connectICX: Date format mask日期格式 (eg. 12-31-1999)55系統(tǒng)管理設(shè)定Concurrent:Report Access LevelUserResponsibilityConcurrent

14、:Active Request一個(gè)user能同時(shí) Running的RequestConcurrent: Show Requests Summary After Each Request SubmissionYes/No 是否在Submit後,自動(dòng)進(jìn)入Request Summary的畫(huà)面Sign-on NotificationYes/No 在Login成功后,提醒是否有人試圖用你的賬號(hào)Login而未成功Sign-On Password Length密碼長(zhǎng)度不得小于設(shè)定數(shù)Viewer: Text View Report Output or Log 時(shí),所使用的Viewer56系統(tǒng)管理設(shè)定Print

15、erDefault Printer,通常設(shè)為noprintSite NameSite Name, 會(huì)Show 在Windows 的Title,通常在做完Clone 后,需手動(dòng)修改與正式環(huán)境區(qū)分Java Color Scheme Form 的顏色57并行請(qǐng)求的四階段InactivePendingRunningCompleted58Inactive 階段No manager is defined to run the request. Check with your system administrator.No ManagerPending request is placed on hold,

16、by selecting Holding the Status field of the Request Details zone.On HoldProgram to run request is not enabled. Contact your system administrator.DisabledInactiveDescriptionStatusPhase59Pending 階段A child request is waiting for its Parent request to mark it ready to run. For example, a report in a re

17、port set that runs sequentially must wait for aprior report to complete.WaitingRequest is scheduled to start at a future time or date.ScheduledProgram to run request is incompatible with other program(s) currently running.StandbyRequest is waiting for the next available manager.NormalPendingDescript

18、ionStatusPhase60Running 階段Running request is terminated, by selecting Terminate in the status field of Request Detail ZoneTerminatingAll requests submitted by the same parent request have completed running. The Parent request is waiting to be restarted.ResumingParent request pauses for all its child

19、 requests to complete. For example, a report set pauses for all reports in the set to complete.PausedRequest is running normally.NormalRunningDescriptionStatusPhase61Running request is terminated, by selecting Terminate in the Status field of the Request Details zone.TerminatedPending or Inactive re

20、quest is cancelled, by selecting Cancel in the Status field of the Request Details zone.CancelledRequest completes with warnings. For example, a report is generated successfully but fails to print.WarningRequest failed to complete successfullyErrorRequest completes normally.NormalCompletedDescriptionStatusPhaseCompleted 階段62管理并行請(qǐng)求63監(jiān)控并行管理器定義工作班次定義并行管理器概論64監(jiān)控并行管理器65定義工作班次66定義并行管理器67將工作班次分配給管理器68啟動(dòng)并行管理器69并行管理器規(guī)則70