1、Oracle ERP系統(tǒng)管理 Date: 2022/10/12 1.OracleERP架構2.啟動和關關閉OracleERP3.ERP安全性管管理4.設定檔5.并行管理理6.并行管理理程序7.使用者監(jiān)監(jiān)控8.維護OracleERP內(nèi)容OracleERP 結構構客戶端應用層網(wǎng)頁服務務器Forms服務器Oracle數(shù)據(jù)庫Report服務器并行處理理服務器器TCFServer(ThinClientFramework)FormsServerReports ServerAS10g(web server)OracleDatabaseTCFServerConcurrentProcessing ServerA

2、pplication數(shù)據(jù)庫層層Oracle數(shù)據(jù)庫Oracle數(shù)據(jù)庫檔檔案OracleDatabase11gData FileDatabase互聯(lián)網(wǎng)架架構客戶端應應用層數(shù)數(shù)據(jù)據(jù)庫層FormsServerReports ServerAS10g(web server)ConcurrentProcessing ServerBrowserOracleDatabase11gR1PCOracleDatabaseData FileTCFServerJava Console系統(tǒng)架構文件目錄錄結構文件目錄錄結構文件目錄錄結構文件目錄錄結構開啟和關關閉OracleERP關閉OracleERP關閉APTier關閉Co

3、ncurrent Server關閉Reports Server關閉iASServer關閉FormsServer關閉OracleERPForms服務器loginasapplprodChangedir to Applicationsstart/stop scriptslocation$INST_TOP/admin/scripts/$ adfrmctl.sh stop(Form Server)$ adfmcctl.sh stop(notrequired)(Metrics Client)$ adfmsctl.sh stop(notrequired)(Metrics Server)關閉OracleERP

4、網(wǎng)頁服務務器loginasapplprodchangedir to Applicationsstart/stop scriptslocation$INST_TOP/admin/scripts/$ adapcctl.sh stop(ApacheServer)關閉OracleERP并行處理理服務器器loginasapplprodchangedir to Applicationsstart/stop scriptslocation$INST_TOP/admin/scripts/$ adcmctl.shstopapps/apps(ConcurrentManager)關閉OracleERP整個AP層lo

5、ginasapplprodchangedir to Applicationsstart/stop scriptslocation$INST_TOP/admin/scripts/$ adstpall.sh apps/apps關閉OracleERP關閉DB層關閉數(shù)據(jù)據(jù)庫監(jiān)聽聽器關閉數(shù)據(jù)據(jù)庫關閉OracleERPloginasoraprodchangedir to Database startup/shutdownscriptslocation$ORACLE_HOME/appsutil/scripts/PROD_mcerpdb1$ addlnctl.sh stopPROD(Listener)$ ad

6、dbctl.shstopimmediate(DB)開啟OracleERP開啟DB層開啟數(shù)據(jù)據(jù)庫開啟監(jiān)聽聽器開啟OracleERPloginasoraprodchangedir to Database startup/shutdownscriptslocation$ORACLE_HOME/appsutil/scripts/PROD_mcerpdb1$ addbctl.shstart(DB)$ addlnctl.sh start PROD(Listener)開啟OracleERP開啟APTier開啟iAS服務器開啟Concurrent服務器開啟Forms服務器開啟Reports服務器開啟Oracl

7、eERPForms服務器loginasapplprodchangedir to Applicationsstart/stop scriptslocation$INST_TOP/admin/scripts/$ adfmsctl.sh start (notrequired) (Metrics Server)$ adfmcctl.sh start (notrequired) (Metrics Client)$ adfrmctl.sh start (Form Server)開啟OracleERP網(wǎng)頁服務務器loginasapplprodChangedir to Applicationsstart/st

8、op scriptslocation$INST_TOP/admin/scripts/$ adapcctl.sh start(ApacheServer)$ adtcfctl.sh start (notrequired)(TCFSocketServer)開啟OracleERP并行處理理服務器器loginasapplprodchangedir to Applicationsstart/stop scriptslocation$INST_TOP/admin/scripts/$ adcmctl.shstartapps/apps (Concurrent Manager)開啟OracleERP所有AP層lo

9、ginasapplprodchangedir to Applicationsstart/stop scriptslocation$INST_TOP/admin/scripts/$ adstrtal.sh apps/appsERP安全性管管理職責Responsibility菜單&子菜單& 程序序子菜單程序菜單NavigateWindows請求組&請求&請求集請求組請求集請求SRSform程序&子程序SubFunctionOracleERP安全性概概論使用者職責職責職責菜單請求組數(shù)據(jù)組報表請求集程式子菜單子菜單程式子程式OracleERP系統(tǒng)的權權限管控控職責2職責1使用者程式1程式2報表2報表3

10、程式1程式3報表3報表4菜單:可以執(zhí)行行哪個表表單請求:可以執(zhí)行行哪個報報表數(shù)據(jù)組:如何連接接數(shù)據(jù)庫庫職責關系系圖職責數(shù)據(jù)組菜單請求組菜單菜單子菜單程序程序程序子菜單子菜單程序程序程序職責(A)將設定好好的Menu指派給Responsibility.請求組職責(A)職責(B)職責(C).報表報表數(shù)據(jù)組Oracle數(shù)據(jù)庫Groupname :StandardOracleID:APPS職責職責職責職責職責職責定義ERP使用者使用者User Name名稱Password密碼PasswordExpiration密碼到期期日EffectiveDates有效日職責職責EffectiveDates有效日定義

11、新的的使用者者定義新的的職責定義菜單單如何定義義報表定義執(zhí)行行檔定義值集集定義程序序設定請求求設定職責責-請求群組組定義執(zhí)行行檔定義值集集定義值集定義程式式定義程式式設定職責責-請求群組組系統(tǒng)參數(shù)數(shù)系統(tǒng)參數(shù)數(shù)(ProfileOption)主要在設設定OracleERP系統(tǒng)或各各模塊相相關的重重要參數(shù)數(shù)。系統(tǒng)參數(shù)數(shù)的設定定層級有有：SiteApplicationResponsibilityUserSite、Application及Responsibility層級須由由系統(tǒng)管管理員設設定，一一般使用用者可設設定User Level。設定層影響范圍圍DEMOOMPOMRPOMSuperUserOMA

12、dministratorOMVisionOperations(USA)Roger地點應用模組組職責使用者Kevin個人設定定層選項系統(tǒng)設定定層選項ICX設定ICX:SessionTimeout連接Timeout時時間，以分鐘計計，若idle時間超超過限制制，系統(tǒng)統(tǒng)會要求求重新登登錄，0或空白白代表沒沒有連接接時間限限制ICX: Limit timeSession可以在系系統(tǒng)停留留的最長時間間(包括active&inactive)ICX: Limit connectICX: Dateformat mask日期格式式(eg. 12-31-1999)系統(tǒng)管理理設定Concurrent:ReportA

13、ccessLevelUserResponsibilityConcurrent:ActiveRequest一個user能同時Running的RequestConcurrent:Show Requests SummaryAfterEachRequest SubmissionYes/No是否在Submit後,自動進入入Request Summary的畫面Sign-on NotificationYes/No在Login成功后，提醒醒是否有有人試圖圖用你的的賬號Login而未未成功Sign-On Password Length密碼長度度不得小小于設定定數(shù)Viewer: TextView ReportOu

14、tputorLog時時,所使用的的Viewer系統(tǒng)管理理設定PrinterDefault Printer,通常設為noprintSite NameSite Name, 會Show在Windows的Title,通常在做做完Clone后后,需手動修改與正式環(huán)環(huán)境區(qū)分分Java Color SchemeForm的顏色并行請求求的四階階段InactivePendingRunningCompletedInactive階段No manager is defined to run the request. Check with your system administrator.No ManagerPend

15、ing request is placed on hold, by selecting Holding the Status field of the Request Details zone.On HoldProgram 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. F

16、or example, a report in a report 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 m

17、anager.NormalPendingDescriptionStatusPhaseRunning階段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

18、 pauses for all its child requests to complete. For example, a report set pauses for all reports in the set to complete.PausedRequest is running normally.NormalRunningDescriptionStatusPhaseRunning request is terminated, by selecting Terminate in the Status field of the Request Details zone.Terminate

19、dPending or Inactive request 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階段管理并行行請求監(jiān)控并行行管理器器定義工作作班次定義并行行管理器器概論監(jiān)控并行行管理器器定