Oracle ERP系統(tǒng)管理培訓(xùn)課件

1、Oracle ERP系統(tǒng)管理 Date: 1/29/2022 1. 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)容 Oracle ERP 結(jié)構(gòu)客戶端應(yīng)用層網(wǎng)頁(yè)服務(wù)器Forms 服務(wù)器Oracle 數(shù)據(jù)庫(kù)Report 服務(wù)器并行處理服務(wù)器TCF Server (Thin Client Framework) 數(shù)據(jù)庫(kù)層Oracle 數(shù)據(jù)庫(kù)Oracle 數(shù)據(jù)庫(kù)檔案互聯(lián)網(wǎng)架構(gòu) 系統(tǒng)架構(gòu)文件目錄結(jié)構(gòu)文件目錄結(jié)構(gòu)文件目錄結(jié)構(gòu)文件目錄結(jié)構(gòu) 開(kāi)啟和關(guān)閉 Oracle ERP關(guān)閉

2、 Oracle ERP關(guān)閉 AP Tier關(guān)閉Concurrent Server關(guān)閉 Reports Server關(guān)閉 iAS Server關(guān)閉 Forms Server關(guān)閉 Oracle ERPForms 服務(wù)器login as applprodChange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/ $ adfrmctl.sh stop (Form Server)$ adfmcctl.sh stop (not required) (Metrics Client) $ adfmsctl.sh

3、 stop (not required) (Metrics Server)關(guān)閉 Oracle ERP網(wǎng)頁(yè)服務(wù)器login as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/ $ adapcctl.sh stop (Apache Server)關(guān)閉 Oracle ERP并行處理服務(wù)器login as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/script

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

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

6、(DB)$ addlnctl.sh start PROD (Listener)開(kāi)啟 Oracle ERP開(kāi)啟 AP Tier開(kāi)啟 iAS 服務(wù)器開(kāi)啟 Concurrent 服務(wù)器開(kāi)啟 Forms 服務(wù)器開(kāi)啟 Reports 服務(wù)器開(kāi)啟 Oracle ERPForms 服務(wù)器login as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/ $ adfmsctl.sh start (not required) (Metrics Server) $ adfmcctl.sh

7、start (not required) (Metrics Client) $ adfrmctl.sh start (Form Server)開(kāi)啟 Oracle ERP網(wǎng)頁(yè)服務(wù)器login as applprodChange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/$ adapcctl.sh start (Apache Server)$ adtcfctl.sh start (not required) (TCF SocketServer) 開(kāi)啟 Oracle ERP并行處理服務(wù)器login

8、as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/$ adcmctl.sh start apps/apps (Concurrent Manager)開(kāi)啟 Oracle ERP所有AP 層login as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/$ adstrtal.sh apps/apps ERP安全性管理職責(zé)Responsibili

9、ty菜單 & 子菜單 & 程序子菜單子菜單程序程序菜單菜單NavigateWindows請(qǐng)求組 & 請(qǐng)求 & 請(qǐng)求集請(qǐng)求組請(qǐng)求組請(qǐng)求集請(qǐng)求集請(qǐng)求請(qǐng)求SRS form程序 & 子程序Sub FunctionOracle ERP 安全性概論使用者使用者職責(zé)職責(zé)職責(zé)職責(zé)職責(zé)職責(zé)菜單菜單請(qǐng)求組請(qǐng)求組數(shù)據(jù)組數(shù)據(jù)組報(bào)表報(bào)表請(qǐng)求集請(qǐng)求集程式程式子菜單子菜單子菜單子菜單程式程式子程式子程式Oracle ERP 系統(tǒng)的權(quán)限管控職責(zé)職責(zé) 2職責(zé)職責(zé) 1使用者使用者程式程式 1程式程式 2報(bào)表報(bào)表 2報(bào)表報(bào)表 3程式程式 1程式程式 3報(bào)表報(bào)表 3報(bào)表報(bào)表 4菜單 : 可以執(zhí)

10、行哪個(gè)表單請(qǐng)求: 可以執(zhí)行哪個(gè)報(bào)表數(shù)據(jù)組 : 如何連接數(shù)據(jù)庫(kù)職責(zé)關(guān)系圖數(shù)據(jù)組數(shù)據(jù)組菜單菜單請(qǐng)求組請(qǐng)求組菜單菜單菜單子菜單子菜單程序程序程序程序程序程序子菜單子菜單子菜單子菜單程序程序程序程序程序程序職責(zé)職責(zé) (A)將設(shè)定好的Menu指派給Responsibility.請(qǐng)求組職責(zé)職責(zé) (A)職責(zé)職責(zé) (B)職責(zé)職責(zé) (C).報(bào)表報(bào)表報(bào)表報(bào)表數(shù)據(jù)組Oracle數(shù)據(jù)庫(kù)職責(zé)職責(zé)職責(zé)職責(zé)職責(zé)職責(zé)職責(zé)職責(zé)職責(zé)職責(zé)職責(zé)職責(zé)定義ERP 使用者使用者User Name名稱Password 密碼Password Expiration 密碼到期日Effective Dates 有效日職責(zé)職責(zé)Effective Da

11、tes 有效日定義新的使用者定義新的職責(zé)定義菜單如何定義報(bào)表定義執(zhí)行檔定義值集定義程序設(shè)定請(qǐng)求設(shè)定職責(zé)-請(qǐng)求群組定義執(zhí)行檔定義值集定義值集定義程式定義程式設(shè)定職責(zé)-請(qǐng)求群組系統(tǒng)參數(shù)系統(tǒng)參數(shù) (Profile Option) 主要在設(shè)定Oracle ERP系統(tǒng)或各模塊相關(guān)的重要參數(shù)。系統(tǒng)參數(shù)的設(shè)定層級(jí)有：SiteApplicationResponsibilityUserSite、Application及Responsibility 層級(jí)須由系統(tǒng)管理員設(shè)定，一般使用者可設(shè)定User Level。設(shè)定層影響范圍地點(diǎn)地點(diǎn)應(yīng)用模組應(yīng)用模組職責(zé)職責(zé)使用者使用者個(gè)人設(shè)定層選項(xiàng)系統(tǒng)設(shè)定層選項(xiàng)NoImageIC

12、X 設(shè)定ICX:Session Timeout連接Timeout時(shí)間，以分鐘計(jì)，若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)系統(tǒng)管理設(shè)定Concurrent:Report Access LevelUserResponsibilityConcurrent:Active Request一個(gè)user能同時(shí) Running的Request

13、Concurrent: 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í),所使用的Viewer系統(tǒng)管理設(shè)定PrinterDefault Printer,通常設(shè)為noprintSite NameSite

14、 Name, 會(huì)Show 在Windows 的Title,通常在做完Clone 后,需手動(dòng)修改與正式環(huán)境區(qū)分Java Color Scheme Form 的顏色并行請(qǐng)求的四階段Inactive 階段No manager is defined to run the request. Check with your system administrator.No ManagerPending request is placed on hold, by selecting Holding the Status field of the Request Details zone.On HoldProg

15、ram to run request is not enabled. Contact your system administrator.DisabledInactiveDescriptionStatusPhasePending 階段A child request is waiting for its Parent request to mark it ready to run. For example, a report in a report set that runs sequentially must wait for aprior report to complete.Waiting

16、Request 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.NormalPendingDescriptionStatusPhaseRunning 階段Running request is terminated, by selecting Terminate i

17、n 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 requests to complete. For example, a report set pauses for all reports in the se

18、t to complete.PausedRequest is running normally.NormalRunningDescriptionStatusPhaseRunning request is terminated, by selecting Terminate in the Status field of the Request Details zone.TerminatedPending or Inactive request is cancelled, by selecting Cancel in the Status field of the Request Details

19、zone.CancelledRequest completes with warnings. For example, a report is generated successfully but fails to print.WarningRequest failed to complete successfullyErrorRequest completes normally.NormalCompletedDescriptionStatusPhaseCompleted 階段管理并行請(qǐng)求NoImage監(jiān)控并行管理器定義工作班次定義并行管理器概論監(jiān)控并行管理器NoImage定義工作班次NoImage定義并行管理器NoImage將工作班次分配給管理器啟動(dòng)并行管理器NoImage并行