Oracle ERP系统管理 Date:2022/9/26 1.Oracle ERP 架构2.启动和关闭 Oracle ERP3.ERP安全性管理4.设定档5.并行管理6.并行管理程序7.使用者监控8.维护 Oracle ERP内容 Oracle ERP 结构客户端应用层网页服务器Forms 服务器Oracle 数据库Report 服务器并行处理服务器TCF Server(Thin Client Framework)数据库层Oracle 数据库Oracle 数据库档案互联网架构 系统架构文件目录结构文件目录结构文件目录结构文件目录结构 开启和关闭 Oracle ERP关闭 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.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/scripts/$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 scripts 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 start(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.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并行处理服务器login 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安全性管理职责Responsibility菜单&子菜单&程序子菜单子菜单程序程序菜单菜单NavigateWindows请求组&请求&请求集请求组请求组请求集请求集请求请求SRS form程序&子程序Sub FunctionOracle ERP 安全性概论使用者使用者职责职责职责职责职责职责菜单菜单请求组请求组数据组数据组报表报表请求集请求集程式程式子菜单子菜单子菜单子菜单程式程式子程式子程式Oracle ERP 系统的权限管控职责职责 2职责职责 1使用者使用者程式程式 1程式程式 2报表报表 2报表报表 3程式程式 1程式程式 3报表报表 3报表报表 4菜单:可以执行哪个表单请求:可以执行哪个报表数据组:如何连接数据库职责关系图数据组数据组菜单菜单请求组请求组菜单菜单菜单子菜单子菜单程序程序程序程序程序程序子菜单子菜单子菜单子菜单程序程序程序程序程序程序职责职责(A)将设定好的Menu指派给Responsibility.请求组职责职责(A)职责职责(B)职责职责(C).报表报表报表报表数据组Oracle数据库职责职责职责职责职责职责职责职责职责职责职责职责定义ERP 使用者使用者User Name名称Password 密码Password Expiration 密码到期日Effective Dates 有效日职责职责Effective Dates 有效日定义新的使用者定义新的职责定义菜单如何定义报表定义执行档定义值集定义程序设定请求设定职责-请求群组定义执行档定义值集定义值集定义程式定义程式设定职责-请求群组系统参数系统参数(Profile Option)主要在设定Oracle ERP系统或各模块相关的重要参数。
系统参数的设定层级有：SiteApplicationResponsibilityUserSite、Application及Responsibility 层级须由系统管理员设定，一般使用者可设定User Level设定层影响范围地点地点应用模组应用模组职责职责使用者使用者个人设定层选项系统设定层选项ICX 设定ICX:Session Timeout连接Timeout时间，以分钟计，若idle时间超过限制，系统会要求重新登录，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 Request 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 后,需手动修改与正式环境区分Java Color Scheme Form 的颜色并行请求的四阶段Inactive 阶段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 is 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 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 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 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.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 阶段管理并行请求监控并行管理器定义工作班次定义并行管理器概论监控并行管理器定义工作班次定义并行管理器将工作班次分配给管理器启动并行管理器并行管理器规则概论监控使用者的活动(Sign-on Audit)设定 Sign-On Audit Sign-On:Audit Level NONEUSERRESPONSIBILITYFORM监控使用者Sign-On Audit 报告 Audit 报告Signon Audit UsersSignon Audit Unsuccessful LoginsSignon Audit ResponsibilitiesSignon Audit FormsSignon Audit Concurrent RequestsSignon Audit User(报告)Signon Audit Unsuccessful LoginsSignon Audit Responsibilities Signon Audit FormsSignon Audit Concurrent Requests 维护 Oracle ERP概论AD ToolsDB ToolsOS ToolsOAM(Oracle Application Manager)參閱 Oracle Applications Maintenance Procedures and Maintenance UtilitiesAD toolsAD ToolsadadminadpatchadctrlDB toolsDB ToolssqlpluslsnrctltnspingOS ToolsOAMOAM演讲完毕，谢谢观看！。