EBSR12系统管理培训稿

单击此处编辑母版标题样式,单击此处编辑母版文本样式,第二级,第三级,第四级,第五级,*,Oracle ERP系统管理,Date:,2024/8/25,1. Oracle ERP,架构,2.,启动和关闭,Oracle ERP,3. ERP,安全性管理,4.,设定档,5.,并行管理,6.,并行管理程序,7.,使用者监控,8.,维护,Oracle ERP,内容,Oracle ERP 结构,客户端,应用层,网页服务器,Forms,服务器,Oracle,数据库,Report,服务器,并行处理服务器,TCF Server,(Thin Client Framework),Forms Server,Reports Server,AS,10g,(web server),Oracle Database,TCF Server,Concurrent,Processing Server,Application,数据库层,Oracle,数据库,Oracle,数据库档案,Oracle Database,11g,Data File,Database,互联网架构,客户端 应用层 数据库层,Forms Server,Reports Server,AS 10g,(web server),Concurrent,Processing Server,Browser,Oracle Database,11g R1,PC,Oracle Database,Data File,TCF Server,Java Console,系统,架构,文件目录结构,文件目录结构,文件目录结构,文件目录结构,开启和关闭,Oracle ERP,关闭,Oracle ERP,关闭,AP Tier,关闭,Concurrent Server,关闭,Reports Server,关闭,iAS Server,关闭,Forms Server,关闭,Oracle ERP,Forms,服务器,login as,appl,prod,Change dir to Applications start/stop scripts location,$INST_TOP/admin/scripts/,$ adfrmctl.sh stop (,Form Server,),$ adfmcctl.sh stop (not required) (,Metrics Client),$ adfmsctl.sh stop (not required) (,Metrics Server,),关闭,Oracle ERP,网页服务器,login as,appl,prod,change dir to Applications start/stop scripts location,$INST_TOP/admin/scripts/,$ adapcctl.sh stop,(,Apache Server,),关闭,Oracle ERP,并行处理服务器,login as,appl,prod,change dir to Applications start/stop scripts location,$INST_TOP/admin/scripts/,$ adcmctl.sh stop apps/apps,(Concurrent Manager),关闭,Oracle ERP,整个,AP,层,login as,appl,prod,change dir to Applications start/stop scripts location,$INST_TOP/admin/scripts/,$ adstpall.sh apps/apps,关闭,Oracle ERP,关闭,DB,层,关闭数据库监听器,关闭数据库,关闭,Oracle ERP,login as oraprod,change dir to Database startup/shutdown scripts location,$ORACLE_HOME/appsutil/scripts/PROD_mcerpdb1,$ addlnctl.sh stop PROD (Listener),$ addbctl.sh stop immediate (DB),开启,Oracle ERP,开启,DB,层,开启数据库,开启监听器,开启,Oracle ERP,login as oraprod,change dir to Database startup/shutdown scripts location,$ORACLE_HOME/appsutil/scripts/PROD_mcerpdb1,$ addbctl.sh start (DB),$ addlnctl.sh start PROD (Listener),开启,Oracle ERP,开启,AP Tier,开启,iAS,服务器,开启,Concurrent,服务器,开启,Forms,服务器,开启,Reports,服务器,开启,Oracle ERP,Forms,服务器,login as,appl,prod,change dir to Applications start/stop scripts location,$INST_TOP/admin/scripts/,$ adfmsctl.sh start (not required) (,Metrics Server),$ adfmcctl.sh start (not required) (,Metrics Client),$ adfrmctl.sh start (,Form Server,),开启,Oracle ERP,网页服务器,login as,appl,prod,Change 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,并行处理服务器,login as,appl,prod,change dir to Applications start/stop scripts location,$INST_TOP/admin/scripts/,$ adcmctl.sh start apps/apps (Concurrent Manager),开启,Oracle ERP,所有,AP,层,login as,appl,prod,change dir to Applications start/stop scripts location,$INST_TOP/admin/scripts/,$ adstrtal.sh apps/apps,ERP,安全性管理,职责,Responsibility,菜单,&,子菜单,& 程序,子菜单,程序,菜单,Navigate,Windows,请求组,&,请求,&,请求集,请求组,请求集,请求,SRS form,程序,&,子,程序,Sub Function,Oracle ERP,安全性概论,使用者,职责,职责,职责,菜单,请求组,数据组,报表,请求集,程式,子菜单,子菜单,程式,子程式,Oracle ERP,系统的权限管控,职责,2,职责,1,使用者,程式,1,程式,2,报表,2,报表,3,程式,1,程式,3,报表,3,报表,4,菜单,:,可以执行哪个表单,请求,:,可以执行哪个报表,数据组,:,如何连接数据库,职责关系图,职责,数据组,菜单,请求组,菜单,菜单,子菜单,程序,程序,程序,子菜单,子菜单,程序,程序,程序,职责,(A),将设定好的,Menu,指派给,Responsibility,.,.,.,.,请求组,职责,(A),职责,(B),职责,(C),.,.,.,.,报表,报表,数据组,Oracle,数据库,Group name :,Standard,Oracle ID :,APPS,职责,职责,职责,职责,职责,职责,定义,ERP,使用者,使用者,User Name,名称,Password,密码,Password Expiration,密码到期日,Effective Dates,有效日,职责,职责,Effective Dates,有效日,定义新的使用者,定义新的职责,定义菜单,如何定义报表,定义执行档,定义值集,定义程序,设定请求,设定职责,-,请求群组,定义执行档,定义值集,定义,值集,定义程式,定义程式,设定职责,-,请求群组,系统参数,系统参数,(Profile Option),主要在设定,Oracle ERP,系统或各模块相关的重要参数。,系统参数的设定层级有：,Site,Application,Responsibility,User,Site,、,Application,及,Responsibility,层级须由系统管理员设定，一般使用者可设定,User Level,。,设定,层,影响范围,DEMO,OM,PO,MRP,OM Super User,OM Administrator,OM Vision Operations (USA),Roger,地点,应用模组,职责,使用者,Kevin,个人设定,层,选项,系统设定,层,选项,ICX,设定,ICX:Session Timeout,连接Timeout时间,，,以分钟计，若idle时间超过限制，系统会要求重新登录，0或空白代表没有连接时间限制,ICX: Limit time,Session,可以在系統停留的,最长时间(,包括,active & inactive),ICX: Limit connect,ICX: Date format mask,日期格式,(eg. 12-31-1999),系统管理设定,Concurrent:Report Access Level,User,Responsibility,Concurrent:Active Request,一個,user,能同時,Running,的,Request,Concurrent: Show Requests Summary After Each Request Submission,Yes/No,是否在,Submit,後,自動進入,Request Summary,的畫面,Sign-on Notification,Yes/No,在,Login,成功,后，提醒是否有人试图用你的账号Login而未成功,Sign-On Password Length,密码长度不得小于设定数,Viewer: Text,View Report Output or Log 时,所使用的,Viewer,系统管理设定,Printer,Default Printer,通常,设为noprint,Site Name,Site Name, 会Show,在,Windows,的,Title,通常在做完,Clone 后,需,手动,修改,与正式环境区分,Java Color Scheme,Form,的,颜色,并行请求的四阶段,Inactive,Pending,Running,Completed,Inactive,阶段,No manager is defined to run the request. Check with your system administrator.,No Manager,Pending request is placed on hold, by selecting Holding the Status field of the Request Details zone.,On Hold,Program to run request is not enabled. Contact your system administrator.,Disabled,Inactive,Description,Status,Phase,Pending,阶段,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 a,prior report to complete.,Waiting,Request is scheduled to start at a future time or date.,Scheduled,Program to run request is incompatible with other program(s) currently running.,Standby,Request is waiting for the next available manager.,Normal,Pending,Description,Status,Phase,Running,阶段,Running request is terminated, by selecting,Terminate,in the status field of Request Detail Zone,Terminating,All requests submitted by the same parent request have completed running. The Parent request is waiting to be restarted.,Resuming,Parent request pauses for all its child requests to complete. For example, a report set pauses for all reports in the set to complete.,Paused,Request is running normally.,Normal,Running,Description,Status,Phase,Running request is terminated, by selecting Terminate in the Status field of the Request Details zone.,Terminated,Pending or Inactive request is cancelled, by selecting Cancel in the Status field of the Request Details zone.,Cancelled,Request completes with warnings. For example, a report is generated successfully but fails to print.,Warning,Request failed to complete successfully,Error,Request completes normally.,Normal,Completed,Description,Status,Phase,Completed,阶段,管理并行请求,监控并行管理器,定义工作班次,定义并行管理器,概论,监控并行管理器,定义工作班次,定义并行管理器,将工作班次分配给管理器,启动并行管理器,并行管理器规则,概论,监控使用者的活动,(Sign-on Audit),设定,Sign-On Audit,Sign-On:Audit Level,NONE,USER,RESPONSIBILITY,FORM,监控使用者,Sign-On Audit,报告,Audit,报告,Signon Audit Users,Signon Audit Unsuccessful Logins,Signon Audit Responsibilities,Signon Audit Forms,Signon Audit Concurrent Requests,Signon Audit User (,报告,),Signon Audit Unsuccessful Logins,Signon Audit Responsibilities,Signon Audit Forms,Signon Audit Concurrent Requests,维护,Oracle ERP,概论,AD Tools,DB Tools,OS Tools,OAM (Oracle Application Manager),參閱,Oracle Applications Maintenance Procedures and Maintenance Utilities,AD tools,AD Tools,adadmin,adpatch,adctrl,DB tools,DB Tools,sqlplus,lsnrctl,tnsping,OS Tools,OS Tools,ps,ps ef | grep smon,netstat,OAM,OAM,