EBSR12系统管理培训稿ppt课件

1、Oracle ERP系统管理 Date: 2022/4/19 1. Oracle ERP 架构2. 启动和封锁 Oracle ERP3. ERP平安性管理4. 设定档5. 并行管理6. 并行管理程序7. 运用者监控8. 维护 Oracle ERP内容 Oracle ERP 构造客户端运用层网页效力器Forms 效力器Oracle 数据库Report 效力器并行处置效力器TCF Server (Thin Client Framework)Forms ServerReports ServerAS 10g (web server)Oracle DatabaseTCF ServerConcurrent

2、 Processing ServerApplication数据库层Oracle 数据库Oracle 数据库档案Oracle Database11gData FileDatabase互联网架构 客户端 运用层 数据库层Forms ServerReports ServerAS 10g(web server)Concurrent Processing ServerBrowserOracle Database11g R1PCOracle DatabaseData FileTCF ServerJava Console系统架构文件目录构造文件目录构造文件目录构造文件目录构造 开启和封锁 Oracle ER

3、P封锁 Oracle ERP封锁 AP Tier封锁Concurrent Server封锁 Reports Server封锁 iAS Server封锁 Forms Server封锁 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) (Metrics Client) $ adfmsctl

4、.sh stop (not required) (Metrics Server)封锁 Oracle ERP网页效力器login as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/ $ adapcctl.sh stop (Apache Server)封锁 Oracle ERP并行处置效力器login as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/scr

5、ipts/$ adcmctl.sh stop apps/apps (Concurrent Manager) 封锁 Oracle ERP整个 AP 层login as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/ $ adstpall.sh apps/apps 封锁 Oracle ERP封锁 DB 层封锁数据库监听器封锁数据库封锁 Oracle ERPlogin as oraprodchange dir to Database startup/shutdown scr

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

7、rt (DB)$ addlnctl.sh start PROD (Listener)开启 Oracle ERP开启 AP Tier开启 iAS 效力器开启 Concurrent 效力器开启 Forms 效力器开启 Reports 效力器开启 Oracle ERPForms 效力器login as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/ $ adfmsctl.sh start (not required) (Metrics Server) $ adfmcctl.

8、sh start (not required) (Metrics Client) $ adfrmctl.sh start (Form Server)开启 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) (TCF SocketServer) 开启 Oracle ERP并行处置效力器log

9、in as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/$ adcmctl.sh start apps/apps (Concurrent Manager)开启 Oracle ERP一切AP 层login as applprodchange dir to Applications start/stop scripts location $INST_TOP/admin/scripts/$ adstrtal.sh apps/apps ERP平安性管理职责Responsib

10、ility菜单 & 子菜单 & 程序子菜单程序菜单NavigateWindows恳求组 & 恳求 & 恳求集恳求组恳求集恳求SRS form程序 & 子程序Sub FunctionOracle ERP 平安性概论运用者职责职责职责菜单恳求组数据组报表恳求集程式子菜单子菜单程式子程式Oracle ERP 系统的权限管控职责 2职责 1运用者程式 1程式 2报表 2报表 3程式 1程式 3报表 3报表 4菜单 : 可以执行哪个表单恳求: 可以执行哪个报表数据组 : 如何衔接数据库职责关系图职责数据组菜单恳求组菜单菜单子菜单程序程序程序子菜单子菜单程序程序程序职责 (A)将设定好的Menu指派给Re

11、sponsibility.恳求组职责 (A)职责 (B)职责 (C).报表报表数据组Oracle数据库Group name : StandardOracle ID : APPS职责职责职责职责职责职责定义ERP 运用者运用者User Name称号Password 密码Password Expiration 密码到期日Effective Dates 有效日职责职责Effective Dates 有效日定义新的运用者定义新的职责定义菜单如何定义报表定义执行档定义值集定义程序设定恳求设定职责-恳求群组定义执行档定义值集定义值集定义程式定义程式设定职责-恳求群组系统参数系统参数 (Profile Op

12、tion) 主要在设定Oracle ERP系统或各模块相关的重要参数。系统参数的设定层级有：SiteApplicationResponsibilityUserSite、Application及Responsibility 层级须由系统管理员设定，普通运用者可设定User Level。设定层影响范围DEMOOMPOMRPOM Super UserOM AdministratorOM Vision Operations (USA)Roger地点运用模组职责运用者Kevin个人设定层选项系统设定层选项ICX 设定ICX:Session Timeout衔接Timeout时间，以分钟计，假设idle时间

13、超越限制，系统会要求重新登录，0或空白代表没有衔接时间限制ICX: Limit timeSession 可以在系統停留的最长时间(包括active & inactive)ICX: Limit connectICX: Date format mask日期格式 (eg. 12-31-1999)系统管理设定Concurrent:Report Access LevelUserResponsibilityConcurrent:Active Request一個user能同時 Running的RequestConcurrent: Show Requests Summary After Each Reques

14、t SubmissionYes/No 能否在Submit後,自動進入Request Summary的畫面Sign-on NotificationYes/No 在Login胜利后，提示能否有人试图用他的账号Login而未胜利Sign-On Password Length密码长度不得小于设定数Viewer: Text View Report Output or Log 时,所运用的Viewer系统管理设定PrinterDefault Printer,通常设为noprintSite NameSite Name, 会Show 在Windows 的Title,通常在做完Clone 后,需手动修正与正式环

15、境区分Java Color Scheme Form 的颜色并行恳求的四阶段InactivePendingRunningCompletedInactive 阶段No manager is defined to run the request. Check with your system administrator.No ManagerPending request is placed on hold, by selecting Holding the Status field of the Request Details zone.On HoldProgram to run request i

16、s not enabled. Contact your system administrator.DisabledInactiveDescriptionStatusPhasePending 阶段A child request is waiting for its Parent request to mark it ready to run. For example, a report in a report set that runs sequentially must wait for aprior report to complete.WaitingRequest is scheduled

17、 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.NormalPendingDescriptionStatusPhaseRunning 阶段Running request is terminated, by selecting Terminate in the status field o

18、f 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 requests to complete. For example, a report set pauses for all reports in the set to complete.Paused

19、Request is running normally.NormalRunningDescriptionStatusPhaseRunning request is terminated, by selecting Terminate in the Status field of the Request Details zone.TerminatedPending 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 阶段管理并行恳求监控并行管理器定义任务班次定义并行管理器概论监控并行管理器定义任务班次定义并行管理器将任务班次分配给管