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

OracleERP系統(tǒng)管理

Date:2023/1/18

1.OracleERP架構(gòu)2.啟動(dòng)和關(guān)閉OracleERP3.ERP安全性管理4.設(shè)定檔5.并行管理6.并行管理程序7.使用者監(jiān)控8.維護(hù)OracleERP內(nèi)容

OracleERP結(jié)構(gòu)客戶端應(yīng)用層網(wǎng)頁服務(wù)器Forms服務(wù)器Oracle數(shù)據(jù)庫Report服務(wù)器并行處理服務(wù)器TCFServer(ThinClientFramework)FormsServerReportsServerAS10g

(webserver)OracleDatabaseTCFServerConcurrentProcessingServerApplication數(shù)據(jù)庫層Oracle數(shù)據(jù)庫Oracle數(shù)據(jù)庫檔案OracleDatabase11gDataFileDatabase互聯(lián)網(wǎng)架構(gòu)

客戶端應(yīng)用層數(shù)據(jù)庫層FormsServerReportsServerAS10g(webserver)ConcurrentProcessingServerBrowserOracleDatabase11gR1PCOracleDatabaseDataFileTCFServerJavaConsole系統(tǒng)架構(gòu)文件目錄結(jié)構(gòu)文件目錄錄結(jié)構(gòu)文件目錄錄結(jié)構(gòu)文件目錄錄結(jié)構(gòu)開啟和關(guān)關(guān)閉OracleERP關(guān)閉OracleERP關(guān)閉APTier關(guān)閉ConcurrentServer關(guān)閉ReportsServer關(guān)閉iASServer關(guān)閉FormsServer關(guān)閉OracleERPForms服務(wù)器loginasapplprodChangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adfrmctl.shstop(FormServer)$adfmcctl.shstop(notrequired)(MetricsClient)$adfmsctl.shstop(notrequired)(MetricsServer)關(guān)閉OracleERP網(wǎng)頁服務(wù)務(wù)器loginasapplprodchangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adapcctl.shstop(ApacheServer)關(guān)閉OracleERP并行處理理服務(wù)器器loginasapplprodchangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adcmctl.shstopapps/apps(ConcurrentManager)關(guān)閉OracleERP整個(gè)AP層loginasapplprodchangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adstpall.shapps/apps關(guān)閉OracleERP關(guān)閉DB層關(guān)閉數(shù)據(jù)庫監(jiān)監(jiān)聽器關(guān)閉數(shù)據(jù)庫關(guān)閉OracleERPloginasoraprodchangedirtoDatabasestartup/shutdownscriptslocation$ORACLE_HOME/appsutil/scripts/PROD_mcerpdb1$addlnctl.shstopPROD(Listener)$addbctl.shstopimmediate(DB)開啟OracleERP開啟DB層開啟數(shù)據(jù)庫開啟監(jiān)聽器開啟OracleERPloginasoraprodchangedirtoDatabasestartup/shutdownscriptslocation$ORACLE_HOME/appsutil/scripts/PROD_mcerpdb1$addbctl.shstart(DB)$addlnctl.shstartPROD(Listener)開啟OracleERP開啟APTier開啟iAS服務(wù)器開啟Concurrent服務(wù)器開啟Forms服務(wù)器開啟Reports服務(wù)器開啟OracleERPForms服務(wù)器loginasapplprodchangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adfmsctl.shstart(notrequired)(MetricsServer)$adfmcctl.shstart(notrequired)(MetricsClient)$adfrmctl.shstart(FormServer)開啟OracleERP網(wǎng)頁服務(wù)器loginasapplprodChangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adapcctl.shstart(ApacheServer)$adtcfctl.shstart(notrequired)(TCFSocketServer)開啟OracleERP并行處理服務(wù)務(wù)器loginasapplprodchangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adcmctl.shstartapps/apps(ConcurrentManager)開啟OracleERP所有AP層loginasapplprodchangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adstrtal.shapps/appsERP安全性管理職責(zé)Responsibility菜單&子菜單&程序子菜單程序菜單NavigateWindows請求組&請求&請求集請求組請求集請求SRSform程序&子程序SubFunctionOracleERP安全性概論使用者職責(zé)職責(zé)職責(zé)菜單請求組數(shù)據(jù)組報(bào)表請求集程式子菜單子菜單程式子程式OracleERP系統(tǒng)的權(quán)限管管控職責(zé)2職責(zé)1使用者程式1程式2報(bào)表2報(bào)表3程式1程式3報(bào)表3報(bào)表4菜單:可以執(zhí)行哪個(gè)個(gè)表單請求:可以執(zhí)行哪個(gè)個(gè)報(bào)表數(shù)據(jù)組:如何連接數(shù)據(jù)據(jù)庫職責(zé)關(guān)系圖職責(zé)數(shù)據(jù)組菜單請求組菜單菜單子菜單程序程序程序˙˙˙子菜單子菜單程序程序程序職責(zé)(A)將設(shè)定好的Menu指派給Responsibility....請求組職責(zé)(A)職責(zé)(B)職責(zé)(C)....報(bào)表報(bào)表數(shù)據(jù)組Oracle數(shù)據(jù)庫Groupname:StandardOracleID:APPS職責(zé)職責(zé)職責(zé)職責(zé)職責(zé)職責(zé)定義ERP使用者使用者UserName名稱Password密碼PasswordExpiration密碼到期日EffectiveDates有效日日職責(zé)職責(zé)EffectiveDates有效日日定義新新的使使用者者定義新新的職職責(zé)定義菜菜單如何定定義報(bào)報(bào)表定義執(zhí)執(zhí)行檔檔定義值值集定義程程序設(shè)定請請求設(shè)定職職責(zé)-請求群群組定義執(zhí)執(zhí)行檔檔定義值值集定義值集定義程程式定義程程式設(shè)定職職責(zé)-請求群群組系統(tǒng)參參數(shù)系統(tǒng)參參數(shù)(ProfileOption)主要在在設(shè)定定OracleERP系統(tǒng)或或各模模塊相相關(guān)的的重要要參數(shù)數(shù)。系統(tǒng)參參數(shù)的的設(shè)定定層級級有：：SiteApplicationResponsibilityUserSite、Application及Responsibility層級須須由系系統(tǒng)管管理員員設(shè)定定，一一般使使用者者可設(shè)設(shè)定UserLevel。設(shè)定層影響范范圍DEMOOMPOMRPOMSuperUserOMAdministratorOMVisionOperations(USA)Roger地點(diǎn)應(yīng)用模模組職責(zé)使用者者Kevin個(gè)人設(shè)設(shè)定層選項(xiàng)系統(tǒng)設(shè)設(shè)定層選項(xiàng)ICX設(shè)定ICX:SessionTimeout連接Timeout時(shí)間間，以分鐘鐘計(jì)，，若idle時(shí)時(shí)間超超過限限制，，系統(tǒng)統(tǒng)會要要求重重新登登錄，，0或或空白白代表表沒有有連接接時(shí)間間限制制ICX:LimittimeSession可以在在系統(tǒng)統(tǒng)停留留的最長時(shí)時(shí)間(包括active&inactive)ICX:LimitconnectICX:Dateformatmask日期格格式(eg.12-31-1999)系統(tǒng)管管理設(shè)設(shè)定Concurrent:ReportAccessLevelUserResponsibilityConcurrent:ActiveRequest一個(gè)user能同時(shí)時(shí)Running的RequestConcurrent:ShowRequestsSummaryAfterEachRequestSubmissionYes/No是否在在Submit後,自動(dòng)進(jìn)進(jìn)入RequestSummary的畫面面Sign-onNotificationYes/No在Login成功后，提提醒是是否有有人試試圖用用你的的賬號號Login而而未成成功Sign-OnPasswordLength密碼長長度不不得小小于設(shè)設(shè)定數(shù)數(shù)Viewer:TextViewReportOutputorLog時(shí)時(shí),所使用用的Viewer系統(tǒng)管管理設(shè)設(shè)定PrinterDefaultPrinter,通常設(shè)為noprintSiteNameSiteName,會會Show在Windows的Title,通常在在做完完Clone后后,需手動(dòng)修改與正式式環(huán)境境區(qū)分分JavaColorSchemeForm的顏色并行請請求的的四階階段InactivePendingRunningCompletedInactive階段Nomanagerisdefinedtoruntherequest.Checkwithyoursystemadministrator.NoManagerPendingrequestisplacedonhold,byselectingHoldingtheStatusfieldoftheRequestDetailszone.OnHoldProgramtorunrequestisnotenabled.Contactyoursystemadministrator.DisabledInactiveDescriptionStatusPhasePending階段AchildrequestiswaitingforitsParentrequesttomarkitreadytorun.Forexample,areportinareportsetthatrunssequentiallymustwaitforapriorreporttocomplete.WaitingRequestisscheduledtostartatafuturetimeordate.ScheduledProgramtorunrequestisincompatiblewithotherprogram(s)currentlyrunning.StandbyRequestiswaitingforthenextavailablemanager.NormalPendingDescriptionStatusPhaseRunning階段Runningrequestisterminated,byselectingTerminateinthestatusfieldofRequestDetailZoneTerminatingAllrequestssubmittedbythesameparentrequesthavecompletedrunning.TheParentrequestiswaitingtoberestarted.ResumingParentrequestpausesforallitschildrequeststocomplete.Forexample,areportsetpausesforallreportsinthesettocomplete.PausedRequestisrunningnormally.NormalRunningDescriptionStatusPhaseRunningrequestisterminated,byselectingTerminateintheStatusfieldoftheRequestDetailszone.TerminatedPendingorInactiverequestiscancelled,byselectingCancelintheStatusfieldoftheRequestDetailszone.CancelledRequestcompleteswithwarnings.Forexample,areportisgeneratedsuccessfullybutfailstoprint.WarningRequestfailedtocompletesuccessfullyErrorRequestcompletesnormally.NormalCompletedDescriptionStatusPhaseCompleted階段管理并并行請請求監(jiān)控并并行管管理器器定義工工作班班次定義并并行管管理器器概論監(jiān)控并并行管管理器器定義工工作班班次定義并并行管管理器器將工作作班次次分配