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)頁(yè)服務(wù)器Forms服務(wù)器Oracle數(shù)據(jù)庫(kù)Report服務(wù)器并行處理服務(wù)器TCFServer(ThinClientFramework)FormsServerReportsServerAS10g

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

客戶端應(yīng)用層數(shù)據(jù)庫(kù)層FormsServerReportsServerAS10g(webserver)ConcurrentProcessingServerBrowserOracleDatabase11gR1PCOracleDatabaseDataFileTCFServerJavaConsole系統(tǒng)架構(gòu)文件目錄結(jié)構(gòu)文件目錄錄結(jié)構(gòu)文件目錄錄結(jié)構(gòu)文件目錄錄結(jié)構(gòu)開(kāi)啟和關(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)頁(yè)服務(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ù)庫(kù)監(jiān)監(jiān)聽(tīng)器關(guān)閉數(shù)據(jù)庫(kù)關(guān)閉OracleERPloginasoraprodchangedirtoDatabasestartup/shutdownscriptslocation$ORACLE_HOME/appsutil/scripts/PROD_mcerpdb1$addlnctl.shstopPROD(Listener)$addbctl.shstopimmediate(DB)開(kāi)啟OracleERP開(kāi)啟DB層開(kāi)啟數(shù)據(jù)庫(kù)開(kāi)啟監(jiān)聽(tīng)器開(kāi)啟OracleERPloginasoraprodchangedirtoDatabasestartup/shutdownscriptslocation$ORACLE_HOME/appsutil/scripts/PROD_mcerpdb1$addbctl.shstart(DB)$addlnctl.shstartPROD(Listener)開(kāi)啟OracleERP開(kāi)啟APTier開(kāi)啟iAS服務(wù)器開(kāi)啟Concurrent服務(wù)器開(kāi)啟Forms服務(wù)器開(kāi)啟Reports服務(wù)器開(kāi)啟OracleERPForms服務(wù)器loginasapplprodchangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adfmsctl.shstart(notrequired)(MetricsServer)$adfmcctl.shstart(notrequired)(MetricsClient)$adfrmctl.shstart(FormServer)開(kāi)啟OracleERP網(wǎng)頁(yè)服務(wù)器loginasapplprodChangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adapcctl.shstart(ApacheServer)$adtcfctl.shstart(notrequired)(TCFSocketServer)開(kāi)啟OracleERP并行處理服務(wù)務(wù)器loginasapplprodchangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adcmctl.shstartapps/apps(ConcurrentManager)開(kāi)啟OracleERP所有AP層loginasapplprodchangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adstrtal.shapps/appsERP安全性管理職責(zé)Responsibility菜單&子菜單&程序子菜單程序菜單NavigateWindows請(qǐng)求組&請(qǐng)求&請(qǐng)求集請(qǐng)求組請(qǐng)求集請(qǐng)求SRSform程序&子程序SubFunctionOracleERP安全性概論使用者職責(zé)職責(zé)職責(zé)菜單請(qǐng)求組數(shù)據(jù)組報(bào)表請(qǐng)求集程式子菜單子菜單程式子程式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è)表單請(qǐng)求:可以執(zhí)行哪個(gè)個(gè)報(bào)表數(shù)據(jù)組:如何連接數(shù)據(jù)據(jù)庫(kù)職責(zé)關(guān)系圖職責(zé)數(shù)據(jù)組菜單請(qǐng)求組菜單菜單子菜單程序程序程序˙˙˙子菜單子菜單程序程序程序職責(zé)(A)將設(shè)定好的Menu指派給Responsibility....請(qǐng)求組職責(zé)(A)職責(zé)(B)職責(zé)(C)....報(bào)表報(bào)表數(shù)據(jù)組Oracle數(shù)據(jù)庫(kù)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è)定請(qǐng)請(qǐng)求設(shè)定職職責(zé)-請(qǐng)求群群組定義執(zhí)執(zhí)行檔檔定義值值集定義值集定義程程式定義程程式設(shè)定職職責(zé)-請(qǐng)求群群組系統(tǒng)參參數(shù)系統(tǒng)參參數(shù)(ProfileOption)主要在在設(shè)定定OracleERP系統(tǒng)或或各模模塊相相關(guān)的的重要要參數(shù)數(shù)。系統(tǒng)參參數(shù)的的設(shè)定定層級(jí)級(jí)有：：SiteApplicationResponsibilityUserSite、Application及Responsibility層級(jí)須須由系系統(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í)間超超過(guò)限限制，，系統(tǒng)統(tǒng)會(huì)要要求重重新登登錄，，0或或空白白代表表沒(méi)有有連接接時(shí)間間限制制ICX:LimittimeSession可以在在系統(tǒng)統(tǒng)停留留的最長(zhǎ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的畫(huà)面面Sign-onNotificationYes/No在Login成功后，提提醒是是否有有人試試圖用用你的的賬號(hào)號(hào)Login而而未成成功Sign-OnPasswordLength密碼長(zhǎng)長(zhǎng)度不不得小小于設(shè)設(shè)定數(shù)數(shù)Viewer:TextViewReportOutputorLog時(shí)時(shí),所使用用的Viewer系統(tǒng)管管理設(shè)設(shè)定PrinterDefaultPrinter,通常設(shè)為noprintSiteNameSiteName,會(huì)會(huì)Show在Windows的Title,通常在在做完完Clone后后,需手動(dòng)修改與正式式環(huán)境境區(qū)分分JavaColorSchemeForm的顏色并行請(qǐng)請(qǐng)求的的四階階段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階段管理并并行請(qǐng)請(qǐng)求監(jiān)控并并行管管理器器定義工工作班班次定義并并行管管理器器概論監(jiān)控并并行管管理器器定義工工作班班次定義并并行管管理器器將工作作班次次分配