EBSR12系统管理培训稿

1、Oracle ERP系统管理 Date: 7/14/2022 11. Oracle ERP 架构2. 启动和关闭 Oracle ERP3. ERP平安性管理4. 设定档5. 并行管理6. 并行管理程序7. 使用者监控8. 维护 Oracle ERP内容2 Oracle ERP 结构3客户端4应用层网页效劳器Forms 效劳器Oracle 数据库Report 效劳器并行处理效劳器TCF Server (Thin Client Framework)Forms ServerReports ServerAS 10g (web server)Oracle DatabaseTCF ServerConcur

2、rent Processing ServerApplication5数据库层Oracle 数据库Oracle 数据库档案Oracle Database11gData FileDatabase6互联网架构 客户端 应用层 数据库层Forms ServerReports ServerAS 10g(web server)Concurrent Processing ServerBrowserOracle Database11g R1PCOracle DatabaseData FileTCF ServerJava Console7系统架构89文件目录结构10文件目录结构11文件目录结构12文件目录结构1

3、3 开启和关闭 Oracle ERP14关闭 Oracle ERP关闭 AP Tier关闭Concurrent Server关闭 Reports Server关闭 iAS Server关闭 Forms Server15关闭 Oracle ERPForms 效劳器login as applprodChange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/ $ adfrmctl.sh stop (Form Server)$ adfmcctl.sh stop (not required) (Metri

4、cs Client) $ adfmsctl.sh stop (not required) (Metrics Server)16关闭 Oracle ERP网页效劳器login as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/ $ adapcctl.sh stop (Apache Server)17关闭 Oracle ERP并行处理效劳器login as applprodchange dir to Applications start/stop scripts loc

5、ation $INST_TOP/admin/scripts/$ adcmctl.sh stop apps/apps (Concurrent Manager) 18关闭 Oracle ERP整个 AP 层login as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/ $ adstpall.sh apps/apps 19关闭 Oracle ERP关闭 DB 层关闭数据库监听器关闭数据库20关闭 Oracle ERPlogin as oraprodchange dir t

6、o Database startup/shutdown scripts location $ORACLE_HOME/appsutil/scripts/PROD_mcerpdb1 $ addlnctl.sh stop PROD (Listener)$ addbctl.sh stop immediate (DB)21开启 Oracle ERP开启 DB 层开启数据库开启监听器22开启 Oracle ERPlogin as oraprodchange dir to Database startup/shutdown scripts location $ORACLE_HOME/appsutil/scr

7、ipts/PROD_mcerpdb1 $ addbctl.sh start (DB)$ addlnctl.sh start PROD (Listener)23开启 Oracle ERP开启 AP Tier开启 iAS 效劳器开启 Concurrent 效劳器开启 Forms 效劳器开启 Reports 效劳器24开启 Oracle ERPForms 效劳器login as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/ $ adfmsctl.sh start (not

8、 required) (Metrics Server) $ adfmcctl.sh start (not required) (Metrics Client) $ adfrmctl.sh start (Form Server)25开启 Oracle ERP网页效劳器login as applprodChange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/$ adapcctl.sh start (Apache Server)$ adtcfctl.sh start (not required) (

9、TCF SocketServer) 26开启 Oracle ERP并行处理效劳器login as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/$ adcmctl.sh start apps/apps (Concurrent Manager)27开启 Oracle ERP所有AP 层login as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/script

10、s/$ adstrtal.sh apps/apps 28 ERP平安性管理29职责Responsibility30菜单 & 子菜单 & 程序子菜单程序菜单NavigateWindows31请求组 & 请求 & 请求集请求组请求集请求SRS form32程序 & 子程序Sub Function33Oracle ERP 平安性概论使用者职责职责职责菜单请求组数据组报表请求集程式子菜单子菜单程式子程式34Oracle ERP 系统的权限管控职责 2职责 1使用者程式 1程式 2报表 2报表 3程式 1程式 3报表 3报表 435菜单 : 可以执行哪个表单请求: 可以执行哪个报表数据组 : 如何连接数

11、据库职责关系图职责数据组菜单请求组36菜单菜单子菜单程序程序程序子菜单子菜单程序程序程序职责 (A)将设定好的Menu指派给Responsibility37.请求组职责 (A)职责 (B)职责 (C).报表报表38数据组Oracle数据库Group name : StandardOracle ID : APPS职责职责职责职责职责职责39定义ERP 使用者使用者User Name名称Password 密码Password Expiration 密码到期日Effective Dates 有效日职责职责Effective Dates 有效日40定义新的使用者41定义新的职责42定义菜单43如何定义

12、报表定义执行档定义值集定义程序设定请求设定职责-请求群组44定义执行档45定义值集46定义值集47定义程式48定义程式49设定职责-请求群组50系统参数系统参数 (Pro) 主要在设定Oracle ERP系统或各模块相关的重要参数。系统参数的设定层级有：SiteApplicationResponsibilityUserSite、Application及Responsibility 层级须由系统管理员设定,一般使用者可设定User Level。51设定层影响范围DEMOOMPOMRPOM Super UserOM AdministratorOM Vision Operations (USA)Ro

13、ger地点应用模组职责使用者Kevin52个人设定层选项53系统设定层选项54ICX 设定ICX:Session Timeout连接Timeout时间,以分钟计,假设idle时间超过限制,系统会要求重新登录,0或空白代表没有连接时间限制ICX: Limit timeSession 可以在系統停留的最长时间(包括active & inactive)ICX: Limit connectICX: Date format mask日期格式 (eg. 12-31-1999)55系统管理设定Concurrent:Report Access LevelUserResponsibilityConcurrent

14、:Active Request一個user能同時 Running的RequestConcurrent: Show Requests Summary After Each Request SubmissionYes/No 是否在Submit後,自動進入Request Summary的畫面Sign-on NotificationYes/No 在Login成功后,提醒是否有人试图用你的账号Login而未成功Sign-On Password Length密码长度不得小于设定数Viewer: Text View Report Output or Log 时,所使用的Viewer56系统管理设定Print

15、erDefault Printer,通常设为noprintSite NameSite Name, 会Show 在Windows 的Title,通常在做完Clone 后,需手动修改与正式环境区分Java Color Scheme Form 的颜色57并行请求的四阶段InactivePendingRunningCompleted58Inactive 阶段No manager is defined to run the request. Check with your system administrator.No ManagerPending request is placed on hold,

16、by selecting Holding the Status field of the Request Details zone.On HoldProgram to run request is not enabled. Contact your system administrator.DisabledInactiveDescriptionStatusPhase59Pending 阶段A child request is waiting for its Parent request to mark it ready to run. For example, a report in a re

17、port 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 manager.NormalPendingDescript

18、ionStatusPhase60Running 阶段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 pauses for all its child

19、 requests to complete. For example, a report set pauses for all reports in the set to complete.PausedRequest is running normally.NormalRunningDescriptionStatusPhase61Running request is terminated, by selecting Terminate in the Status field of the Request Details zone.TerminatedPending or Inactive re

20、quest 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 阶段62管理并行请求63监控并行管理器定义工作班次定义并行管理器概论64监控并行管理器65定义工作班次66定义并行管理器67将工作班次分配给管理器68启动并行管理器69并行管理器规则70