EBSR12系统管理培训稿

OracleERP系统管理Date:2019/9/151.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.•NoManager•Pendingrequestisplacedonhold,byselectingHoldingtheStatusfieldoftheRequestDetailszone.•OnHold•Programtorunrequestisnotenabled.Contactyoursystemadministrator.•Disabled•Inactive•Description•Status•PhasePending阶段•AchildrequestiswaitingforitsParentrequesttomarkitreadytorun.Forexample,areportinareportsetthatrunssequentiallymustwaitfora•priorreporttocomplete.•Waiting•Requestisscheduledtostartatafuturetimeordate.•Scheduled•Programtorunrequestisincompatiblewithotherprogram(s)currentlyrunning.•Standby•Requestiswaitingforthenextavailablemanager.•Normal•Pending•Description•Status•PhaseRunning阶段•Runningrequestisterminated,byselectingTerminateinthestatusfieldofRequestDetailZone•Terminating•Allrequestssubmittedbythesameparentrequesthavecompletedrunning.TheParentrequestiswaitingtoberestarted.•Resuming•Parentrequestpausesforallitschildrequeststocomplete.Forexample,areportsetpausesforallreportsinthesettocomplete.•Paused•Requestisrunningnormally.•Normal•Running•Description•Status•Phase•Runningrequestisterminated,byselectingTerminateint