OracleERP系统管理培训课件

1、Oracle ERP系统管理 Date: 2022/10/12 1.OracleERP架构2.启动和关关闭OracleERP3.ERP安全性管管理4.设定档5.并行管理理6.并行管理理程序7.使用者监监控8.维护OracleERP内容OracleERP 结构构客户端应用层网页服务务器Forms服务器Oracle数据库Report服务器并行处理理服务器器TCFServer(ThinClientFramework)FormsServerReports ServerAS10g(web server)OracleDatabaseTCFServerConcurrentProcessing ServerA

2、pplication数据库层层Oracle数据库Oracle数据库档档案OracleDatabase11gData FileDatabase互联网架架构客户端应应用层数数据据库层FormsServerReports ServerAS10g(web server)ConcurrentProcessing ServerBrowserOracleDatabase11gR1PCOracleDatabaseData FileTCFServerJava Console系统架构文件目录录结构文件目录录结构文件目录录结构文件目录录结构开启和关关闭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、网页服务务器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层关闭数据据库监听听器关闭数据据库关闭OracleERPloginasoraprodchangedir to Database startup/shutdownscriptslocation$ORACLE_HOME/appsutil/scripts/PROD_mcerpdb1$ addlnctl.sh stopPROD(Listener)$ ad

6、dbctl.shstopimmediate(DB)开启OracleERP开启DB层开启数据据库开启监听听器开启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网页服务务器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安全性概概论使用者职责职责职责菜单请求组数据组报表请求集程式子菜单子菜单程式子程式OracleERP系统的权权限管控控职责2职责1使用者程式1程式2报表2报表3

10、程式1程式3报表3报表4菜单:可以执行行哪个表表单请求:可以执行行哪个报报表数据组:如何连接接数据库库职责关系系图职责数据组菜单请求组菜单菜单子菜单程序程序程序子菜单子菜单程序程序程序职责(A)将设定好好的Menu指派给Responsibility.请求组职责(A)职责(B)职责(C).报表报表数据组Oracle数据库Groupname :StandardOracleID:APPS职责职责职责职责职责职责定义ERP使用者使用者User Name名称Password密码PasswordExpiration密码到期期日EffectiveDates有效日职责职责EffectiveDates有效日定义

11、新的的使用者者定义新的的职责定义菜单单如何定义义报表定义执行行档定义值集集定义程序序设定请求求设定职责责-请求群组组定义执行行档定义值集集定义值集定义程式式定义程式式设定职责责-请求群组组系统参数数系统参数数(ProfileOption)主要在设设定OracleERP系统或各各模块相相关的重重要参数数。系统参数数的设定定层级有有：SiteApplicationResponsibilityUserSite、Application及Responsibility层级须由由系统管管理员设设定，一一般使用用者可设设定User Level。设定层影响范围围DEMOOMPOMRPOMSuperUserOMA

12、dministratorOMVisionOperations(USA)Roger地点应用模组组职责使用者Kevin个人设定定层选项系统设定定层选项ICX设定ICX:SessionTimeout连接Timeout时时间，以分钟计计，若idle时间超超过限制制，系统统会要求求重新登登录，0或空白白代表没没有连接接时间限限制ICX: Limit timeSession可以在系系統停留留的最长时间间(包括active&inactive)ICX: Limit connectICX: Dateformat mask日期格式式(eg. 12-31-1999)系统管理理设定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密码长度度不得小小于设定定数Viewer: TextView ReportOu

14、tputorLog时时,所使用的的Viewer系统管理理设定PrinterDefault Printer,通常设为noprintSite NameSite Name, 会Show在Windows的Title,通常在做做完Clone后后,需手动修改与正式环环境区分分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阶段管理并行行请求监控并行行管理器器定义工作作班次定义并行行管理器器概论监控并行行管理器器定