OracleER系统管理培训课件

OracleERP系统管理

Date:2023/1/18

1.OracleERP架构2.启动和关闭OracleERP3.ERP安全性管理4.设定档5.并行管理6.并行管理程序7.使用者监控8.维护OracleERP内容

OracleERP结构客户端应用层网页服务器Forms服务器Oracle数据库Report服务器并行处理服务器TCFServer(ThinClientFramework)FormsServerReportsServerAS10g

(webserver)OracleDatabaseTCFServerConcurrentProcessingServerApplication数据库层Oracle数据库Oracle数据库档案OracleDatabase11gDataFileDatabase互联网架构

客户端应用层数据库层FormsServerReportsServerAS10g(webserver)ConcurrentProcessingServerBrowserOracleDatabase11gR1PCOracleDatabaseDataFileTCFServerJavaConsole系统架构文件目录结构文件目录录结构文件目录录结构文件目录录结构开启和关关闭OracleERP关闭OracleERP关闭APTier关闭ConcurrentServer关闭ReportsServer关闭iASServer关闭FormsServer关闭OracleERPForms服务器loginasapplprodChangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adfrmctl.shstop(FormServer)$adfmcctl.shstop(notrequired)(MetricsClient)$adfmsctl.shstop(notrequired)(MetricsServer)关闭OracleERP网页服务务器loginasapplprodchangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adapcctl.shstop(ApacheServer)关闭OracleERP并行处理理服务器器loginasapplprodchangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adcmctl.shstopapps/apps(ConcurrentManager)关闭OracleERP整个AP层loginasapplprodchangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adstpall.shapps/apps关闭OracleERP关闭DB层关闭数据库监监听器关闭数据库关闭OracleERPloginasoraprodchangedirtoDatabasestartup/shutdownscriptslocation$ORACLE_HOME/appsutil/scripts/PROD_mcerpdb1$addlnctl.shstopPROD(Listener)$addbctl.shstopimmediate(DB)开启OracleERP开启DB层开启数据库开启监听器开启OracleERPloginasoraprodchangedirtoDatabasestartup/shutdownscriptslocation$ORACLE_HOME/appsutil/scripts/PROD_mcerpdb1$addbctl.shstart(DB)$addlnctl.shstartPROD(Listener)开启OracleERP开启APTier开启iAS服务器开启Concurrent服务器开启Forms服务器开启Reports服务器开启OracleERPForms服务器loginasapplprodchangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adfmsctl.shstart(notrequired)(MetricsServer)$adfmcctl.shstart(notrequired)(MetricsClient)$adfrmctl.shstart(FormServer)开启OracleERP网页服务器loginasapplprodChangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adapcctl.shstart(ApacheServer)$adtcfctl.shstart(notrequired)(TCFSocketServer)开启OracleERP并行处理服务务器loginasapplprodchangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adcmctl.shstartapps/apps(ConcurrentManager)开启OracleERP所有AP层loginasapplprodchangedirtoApplicationsstart/stopscriptslocation$INST_TOP/admin/scripts/$adstrtal.shapps/appsERP安全性管理职责Responsibility菜单&子菜单&程序子菜单程序菜单NavigateWindows请求组&请求&请求集请求组请求集请求SRSform程序&子程序SubFunctionOracleERP安全性概论使用者职责职责职责菜单请求组数据组报表请求集程式子菜单子菜单程式子程式OracleERP系统的权限管管控职责2职责1使用者程式1程式2报表2报表3程式1程式3报表3报表4菜单:可以执行哪个个表单请求:可以执行哪个个报表数据组:如何连接数据据库职责关系图职责数据组菜单请求组菜单菜单子菜单程序程序程序˙˙˙子菜单子菜单程序程序程序职责(A)将设定好的Menu指派给Responsibility....请求组职责(A)职责(B)职责(C)....报表报表数据组Oracle数据库Groupname:StandardOracleID:APPS职责职责职责职责职责职责定义ERP使用者使用者UserName名称Password密码PasswordExpiration密码到期日EffectiveDates有效日日职责职责EffectiveDates有效日日定义新新的使使用者者定义新新的职职责定义菜菜单如何定定义报报表定义执执行档档定义值值集定义程程序设定请请求设定职职责-请求群群组定义执执行档档定义值值集定义值集定义程程式定义程程式设定职职责-请求群群组系统参参数系统参参数(ProfileOption)主要在在设定定OracleERP系统或或各模模块相相关的的重要要参数数。系统参参数的的设定定层级级有：：SiteApplicationResponsibilityUserSite、Application及Responsibility层级须须由系系统管管理员员设定定，一一般使使用者者可设设定UserLevel。设定层影响范范围DEMOOMPOMRPOMSuperUserOMAdministratorOMVisionOperations(USA)Roger地点应用模模组职责使用者者Kevin个人设设定层选项系统设设定层选项ICX设定ICX:SessionTimeout连接Timeout时间间，以分钟钟计，，若idle时时间超超过限限制，，系统统会要要求重重新登登录，，0或或空白白代表表没有有连接接时间间限制制ICX:LimittimeSession可以在在系統統停留留的最长时时间(包括active&inactive)ICX:LimitconnectICX:Dateformatmask日期格格式(eg.12-31-1999)系统管管理设设定Concurrent:ReportAccessLevelUserResponsibilityConcurrent:ActiveRequest一個user能同時時Running的RequestConcurrent:ShowRequestsSummaryAfterEachRequestSubmissionYes/No是否在在Submit後,自動進進入RequestSummary的畫面面Sign-onNotificationYes/No在Login成功后，提提醒是是否有有人试试图用用你的的账号号Login而而未成成功Sign-OnPasswordLength密码长长度不不得小小于设设定数数Viewer:TextViewReportOutputorLog时时,所使用用的Viewer系统管管理设设定PrinterDefaultPrinter,通常设为noprintSiteNameSiteName,会会Show在Windows的Title,通常在在做完完Clone后后,需手动修改与正式式环境境区分分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阶段管理并并行请请求监控并并行管管理器器定义工工作班班次定义并并行管管理器器概论监控并并行管管理器器定义工工作班班次定义并并行管管理器器将工作作班次次分配