Oracle中间件WebLogic 12c维护保养手册

1ORACLE数据库日常维护手册前言 (2)2 ORACLE数据库每天应检查的项目 (2)2.1 2.1.1 2.1.2 2.1.3 2.1.4 2.2 2.2.1 2.2.2 2.3 2.3.1 2.3.2 2.3.3 2.3.4 2.3.5 2.4 2.4.1 2.4.2 2.4.3 2.4.4 2.4.5 2.4.6 2.5 2.6 2.7 2.7.1 2.7.2 2.7.3 2.8 2.8.1 2.8.2 2.9 2.9.1 2.9.2 2.9.3 2.9.4数据库基本状况检查 (2)检查Oracle的进程 (2)检查Oracle监听进程 (3)检查Oracle实例状态 (4)检查归档情况 (4)数据库日志文件检查 (4)检查Oracle日志文件 (4)检查Oracle核心转储目录 (5)数据库对象状态检查 (5)检查Oracle控制文件状态 (5)检查Oracle在线日志状态 (6)检查Oracle表空间的状态 (6)检查Oracle所有数据文件状态 (6)检查Oracle所有表、索引、存储过程、触发器、包等对象的状态 (7)数据库资源使用情况检查 (7)检查Oracle初始化文件中相关的参数值 (7)检查Oracle各个表空间的增长情况 (8)检查一些扩展异常的对象 (9)检查system 表空间内的内容 (9)检查对象的下一扩展与表空间的最大扩展值 (9)数据库表空间使用情况监控 (10)检查数据库定时作业的完成情况 (11)数据库坏块的处理 (11)数据库备份情况检查 (12)检查备份软件的日志 (12)检查数据库归档日志 (12)控制文件的备份 (12)数据库连接情况检查 (12)检查数据库连接 (12)检查数据库会话 (12)操作系统相关检查 (13)检查空间使用情况 (13)检查网络状况 (13)检查内存使用情况 (13)检查磁盘I/O 瓶颈 (14)3 ORACLE数据库每周应检查的项目 (14)3.1 3.2查看是否有危害到安全策略的问题 (14)查看的网络日志 (14)3.3 3.4将所有的警告日志存档 (14)查看ORACLE相关的网站，获取最新信息 (14)4 ORACLE数据库每月应检查的项目 (15)4.1 4.2 4.3查看对数据库会产生危害的增长速度 (15)查看数据库调整产生的影响 (15)查看I/O 的屏颈问题 (15)5附： (17)5.1 5.2 5.3 5.4启动数据库 (17)关闭数据库 (17)启动监听 (18)关闭监听 (19)1 前言数据库系统往往是企业或组织信息系统中最重要的基础架构，一旦数据库系统不能正常运行，那基于数据库的整个信息架构都会随之瘫痪，因此我们必须保证数据库系统持续的健康的运行。

Oracle中间件WebLogic12c维护保养手册Oracle 中间件WebLogic 12c 维护保养手册目录1日常监控及JVM查看工具 (3)1.1安装 (3)2VNC的安装及使用 (3)2.1安装 (3)2.2启动vnc (3)2.3运行VNC Viewer客户端 (3)2.4查询vnc服务 (4)2.5停止vnc服务 (5)2.6增加vnc服务终端 (5)3服务器相关参数配置 (5)3.1文件句柄数：根据实际服务器情况配置。

(5)4常见问题及处理办法 (5)4.1修改系统字符编码 (5)4.2手工删除DOMIAN的方法 (6)4.3域服务器启动端口冲突 (6)4.4启动后可刷新页面，查看服务状态 (6)4.5不重启服务情况下，替换静态文件 (6)4.6weblogic改为开发模式 (7)4.7版本管理 (7)4.8使用部署的目标定义的默认值的情况下，清理缓存文件路径 (7) 4.9启动server，server**.out日志文件中包含乱码 (7)4.10weblogic.xml文件说明 (7)4.11weblogic控制台密码修改 (8)4.12节点管理器配置文件说明 (9)4.13设置GC日志的打印参数 (9)4.14部署模式设置 (9)1日常监控及JVM查看工具1.1安装2VNC的安装及使用2.1安装Linux系统默认已安装vnc服务器端。

2.2启动vnc若未用vncpasswd设置密码，则第一次运行vncserver时，会提示设置密码，再次确定密码,并分配终端编号。

输入命令：vncserverYou will require a password to access your desktops.Password:输入连接密码Verify:再次输入密码xauth: creating new authority file /webapp/.XauthorityNew 'gd-webapps01:1 (webapp)' desktop is gd-webapps01:1 分配终端编号Creating default startup script /webapp/.vnc/xstartupStarting applications specified in /webapp/.vnc/xstartupLog file is /webapp/.vnc/gd-webapps01:1.log2.3运行VNC Viewer客户端在Microsoft Windows上运行VNC Viewer“vncviewer.exe”,系统会出现”Connection details”对话框在“Connection details”对话框中的“VNC server”文本框中输入VNC Server的IP地址：终端编号，单击“连接”按钮，再输入密码后，进入vnc操作界面。

ORACLE日常维护步骤1 数据库启动单实例：以oracle用户登录服务器，依次执行以下命令sqlplus “/as sysdba”startupexitRAC环境：以root用户登录数据库，依次执行以下命令进入到CRS主目录bin下：./crsctl check crs./crs_stat –t./crsctl start crs./crsctl check crs./crs_stat –tsrvctl start database -d db_name2 启动监听单实例：以oracle用户登录服务器，执行以下命令lsnrctl startRAC环境：以root用户登录服务器，执行以下命令进入到CRS主目录bin下：srvctl start listener -n instance1srvctl start listener -n instance23 检查数据库状态单实例：以oracle用户登录服务器，执行以下命令检查服务进程：ps -ef|grep "ora_"|grep -v grep结果中同一个实例至少包含ora_dbw0*、ora_lgwr*、ora_smon*、ora_pmon*、ora_ckpt*等5个进程。

检查监听状态：lsnrctl status检查实例状态：sqlplus “/as sysdba”sql>select instance_name,status,database_status from v$instance;RAC环境：检查方式与单实例基本一致，但多出检查crs状态Crs –t –v4 检查数据库告警日志以oracle用户登录，执行以下命令cd $ORACLE_BASE/oracle_sid/bdump/grep ORA- alert_sid.log|more如存在相关ORA-报错，请联系DBA进行检查处理。

5 数据库关闭单实例：以oracle用户登录，执行以下命令；Sqlplus “/as sysdba”Shutdown immediate;Exit停掉监听：lsnrctl stopRAC环境：以root用户登录服务器，进入crs安装主目录bin下停实例srvctl stop database -d db_name停CRS服务./crsctl stop crs停监听srvctl stop listener -n instance1srvctl stop listener -n instance26启停企业管理器（EM）以oracle用户登录服务器启动EM：Emctl start dbconsole关闭EM：Emctl stop dbconsole检查EM状态：Emctl status dbconsoleWeblogic 日常维护步骤1 Weblogic启动AdminServerWindows平台：进入应用域目录，双击startWebLogic.cmdLinux或Unix平台：进入应用域目录，./startWebLogic.sh2 Weblogic关闭Windows平台：进入应用域目录，双击stopWebLogic.cmd或直接点击关闭桌面上的命令行窗口；Linux或Unix平台：进入应用域目录，./stopWebLogic.sh或ps –ef |grep –i weblogic 查出进程号（pid），然后用kill -9 pid3 Server状态查询通过IE访问weblogic console，左侧目录结构树，点击环境（environment）----服务器（server）：查看server状态，确保部署应用的server处于running状态。

Oracle GoldenGate 12c for Oracle Database 12cJagdev DhillonVice PresidentNick WagnerProduct ManagerSafe Harbor StatementThe following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.Program Agenda1 2 3 4 Oracle GoldenGate 12.1.2 Review Oracle GoldenGate 12.1.2.1 New Features Streams to GoldenGate ConversionsQ&AOracle GoldenGate 12c Generic Enhancements•DDL Trigger is no longer needed–Works with Oracle 11.2.0.4 and up and requires Integrated Extract–Works with Oracle Standard Edition as well as Enterprise Edition•DISCARDFILE now has defaults, and no longer needs to be specified for each Replicat •Improved Schema Wildcard resolution within the parameter files–Only captures first TABLE parameter for SCOTT.EMP DMLTABLE SCOTT.EMP, COLMAP(…);TABLE *.EMP;•Oracle 12c Expanded Data Type Support–Support for VARCHAR2 / NVARCHAR2 / RAW MAX options (32k length)Integrated Replicat•Integrated Replicat for Oracle target databases only–11.2.0.4 and 12c (12.1.+)•Leverages database parallel apply servers for automatic dependency aware parallel apply•Minimal changes to replicat configuration–Single replicat parameter file for all tables–No split transaction semanticsIntegrated ReplicatInbound Server (Database Apply Process) Delivery Lightweight Streaming API Receiver Preparer Coordinator Inbound Server Applier NApplier 2 Applier 1 Oracle DatabaseDelivery Delivery Delivery Delivery Customer defined splitSQL SQLSQL SQLTargetOracle and Non-Oracle DatabasesMAP sales.acct1, TARGET sales.acct1; MAP sales.acct2, TARGET sales.acct2; MAP sales.acct3, TARGET sales.acct3;Trail Files Thread Customer defined split SQL SQLSQLSQL Single replicationprocess forcustomerGoldenGatecoordinatesthread for barrieroperations TargetOracle and Non-Oracle DatabasesMAP sales.acct1, TARGET sales.acct1, THREAD (2); MAP sales.acct2, TARGET sales.acct2, THREAD (3); MAP sales.acct,3 TARGET sales.acct3, THREADANGE (4-9);Credential Store/Oracle Wallet•Oracle Wallet and Credential Store functionality now built into the Oracle GoldenGate Installation•Credential Store for storing usernames and passwords•Once a credential has been added to the wallet–Remove USERID, MININGDBUSERID, etc–Replace with USERIDALIAS, MININGDBUSERIDALIAS, etcHA Features for GoldenGate in 12.1.2•Oracle Active Data Guard and Oracle GoldenGate High-Availability Best Practices [CON7715]–Tuesday, Sep 30, 10:45 AM - 11:30 AM- Moscone South – 308•Full Integration with ASYNC FSFO–GoldenGate can now safely follow bounded data-loss failovers–Support enabled in Integrated Extract with the addition of the following parameter:TRANLOGOPTIONS HANDLEDLFAILOVER•Works for Oracle DB 11g and 12c•Full integration with Oracle’s XAG–XAG allows you to register a GoldenGate instance to improve HA–XAG provides increased availability in the face a loss of an instance or Primary databaseProgram Agenda1 2 3 4 Oracle GoldenGate 12.1.2 Review Oracle GoldenGate 12.1.2.1 New Features Streams to GoldenGate ConversionsQ&A12.1.2.1 Major Enhancements•Capture Enhancements–Integrated Extract Enhancements–Certification for Oracle 12.1.0.2 and In-Memory Database (IMDB) –Support for Capturing from ADG Standby database •Integrated Delivery Enhancements–Dependency Aware Batching–DDL and DML Handlers–Error Queue Support•Support for multiple Editions (Edition Based Redefinition) •Column Level Character Set Support•SOCKS 5 SupportIntegrated Extract Specific Enhancements•Continues to support Oracle SE and EE databases•Improved Startup Performance and Scalability (shared mining dictionary) •Tagged transaction can be excluded for Active-Active replication–EXCLUDETAG•Create Table As Select… can be applied as DDL + DML rather than DDL –TRANLOGOPTIONS GETCTASDML•Added redo log capture for ANYDATA and UDTs–TRANLOGOPTIONS USENATIVEOBJSUPPORT•Support for Edition Based Redefinition and multiple editionsClassic Extract can now capture from an ADG Standby database •Extract can be configured to run on the Standby Database•Configuration on the Primary database–Setup DDL capture (optional)–Configure Supplemental log data•Configuration on the Standby database–USERID Parameter points to the Primary database (USERID username@primary ) –Set TRANLOGOPTIONS MINEFROMACTIVEDGShared Logminer Dictionary•REGISTER EXTRACT ecap DATABASE•REGISTER EXTRACT ename DATABASE SHARE ecap–Ename is created as a “clone” of ecap–2nd extract (ename) uses same internal dictionary as ecap•Fast start of 2nd extract (no dictionary processing required)•Single extract does dictionary maintenance•REGISTER EXTRACT eother DATABASE SCN startatscn SHARE ecap –SCN parameter meaning is different when combined with SHAREEXCLUDETAG Functionality•TRANLOGOPTIONS EXCLUDETAG takes a single string value, but allows multiple lines to specify multiple tags•Extend EXCLUDETAG to exclude any tagged operation–EXCLUDETAG +–Similar to Streams is_null_tag setting.•Filtering of tagged transactions can be done in the Extract pump and REPLICAT12.1.2.1 Integrated Delivery Enhancements Dependency-Aware Batching for Integrated Replicat•Through the use of INTEGRATEDPARAMS BATCHSQL_MODE–Controls the ordering of transactions in BATCHSQL mode–Options:•SEQUENTIAL – transaction batched in sequential order•DEPENDENT – Dependency grouping, schedule when no active dependencies•DEPENDENT_EAGER – dependency grouping but allow scheduling when there are active dependencies–Default is DEPENDENT for Oracle 12.1.0.2–Requires new OGG/RDBMS bundled patch (bp2) but not available for 11.2.0.4.•Without patch, default is SEQUENTIAL•COMMIT_SERIALIZATION=FULL sets BATCHSQL_MODE=SEQUENTIALIntegrated Replicat Apply Handler Configuration•Uses the same package calls to set up as Streams does–DBMS_APPLY_ADM package•DML: Set_dml_handler or Add_stmt_handler•DDL: Alter_apply–The scope of handler is dependent on the configuration•Per Table , Per Operation (Ins/Upd/Del)•It is associated with the Inbound Server (Integrated Replicat process inside thedatabase)•Operations processed by the DML/DDL handler will not be applied by the Replicat •Integrated Replicat needs to be stopped and restarted when adding or removing handlers.PL/SQL Update Handler on DEMO.ORDERS table BEGINDBMS_APPLY_ADM.SET_DML_HANDLER(object_name => '"DEMO"."ORDERS"',object_type => 'TABLE',operation_name => 'UPDATE',error_handler => FALSE, ## if FALSE, then the handler replaces normal apply processing, ## if TRUE, then the handler is only executed on error.user_procedure => 'DEMO.ORDERS_DML_HANDLER',apply_database_link => NULL,apply_name => NULL); ## If NULL, then handler is used for ALL apply & inbound servers END;/12.1.2.1 Integrated Delivery Enhancements Statement DML Handlers•Statement DML handlers are up to 4x faster than procedural DML handlers –Statement DML handlers should be used to replace SQLEXEC in the Replicat when possible •Easy to Use–SQL statements, rather than PL/SQL procedures–DBMS_APPLY_ADM.ADD_STMT_HANDLER•Creates handler with SQL statement AND•Registers to Apply process–DBMS_STREAMS_HANDLER_ADM package procedures•Create or Drop handler•Add or Remove statements to/from handler•Register with apply12.1.2.1 Integrated Delivery EnhancementsEnable Error Queue Handling•In older versions of OGG, if an error occurs it falls back and lets the Replicat retry the operation. If the OGG retry fails it abends•Allow DBMS_Apply_Adm.Execute_Error capability for Integrated Replicat to retry operations in the error queue. Handles whether is message is added to the error queue.–DBOPTIONS _NO_DISABLE_ON_RETRY_ERROR•Allow OGG to retry, but if OGG fails, continue processing. If OGG successfully applies transaction, OGG deletes error from queue. Default behavior.–DBOPTIONS _NO_DISABLE_OR_RETRY_ERROR•Disable OGG retry and continue processing, recommended with COMMIT_SERIALIZATION=FULLManaging Apply Errors12.1.2.1 Integrated Delivery EnhancementsEdition Based Redefinition•DDL Replication now supports CREATE/DROP EDITION–Replicat will grant the user permission to use if it exists on target•Extract will capture the EDITION NAME owner•Replicat will switch session to the EDITION owner before applying DDL •DDL operations on editions can be filtered as well–DDL INCLUDE ALL, EXCLUDE OBJTYPE EDITION•Support for Column Level Character Sets–For cases where a table has column(s) with a character set that is different from the database character set.–Use SOURCECHARSET to enable this functionality•In MAP / TABLE statements use CHARSET to use your own settings•In DEFGEN use COLCHARSET to use your own settings•Enhanced Cloud support–SOCKS v5 Support•SOCKet Secure is a protocol that supports routing between client and server •Allows authentication•SOCKS can encrypt all traffic between client and server•Alternative to VPN for cloud to on-premise or vice-versa–New parameter SOCKSPROXY•SOCKSPROXY host:port, [PROXYCSALIAS <alias> [, PROXYCSDOMAIN domain]]•Enhanced Cloud support–Example for sending trail data from on-premise to cloud.•GoldenGate installed on with manager port 9000•Firewall only allows incoming connections on SSH port.–Use SSH as SOCKS proxy server on-premise•ssh –i ssh-key –N –f –D 1080 ******************************.com•Port 1080 is the client port that will route to an OGG installation on –Extract Parameter file:•RMTHOST , MGRPORT 9000, SOCKSPROXY localhost:1080Program Agenda1 2 3 4 Oracle GoldenGate 12.1.2 Review Oracle GoldenGate 12.1.2.1 New Features Streams to GoldenGate ConversionsQ&AMOS 1912338.1 Oracle Streams to Oracle GoldenGate Conversion •Streams is now deprecated (as of Oracle 12c)•Designed to help existing Streams users convert their replication into Oracle GoldenGate replication.–The streams2ogg tool will generate the appropriate GoldenGate 12c configuration files allowing for an easier way to migrate the Streams implementation into a GoldenGate implementation.•This tool will help–Eliminate manual conversion errors–Minimize the GoldenGate learning curve for Streams customers–Implement GoldenGate best practicesMOS 1912338.1 Oracle Streams to Oracle GoldenGate Conversion•The streams2ogg migration tool is run at the database level–connecting to the Streams Administrator schema–Load and execute the streams2ogg package–Oracle GoldenGate Parameter files are produced•OGG configuration files can be generated to run on a different database or machine to allowing for testing and platform migrations.NOTE:This tool does not provide the environment or process for switching from Streams over to your GoldenGate implementation. And does not support complete conversion of the CDC (Change Data Capture) feature of Oracle DB. Ideally suited for environments where the source and target object structure is the same.Streams2oggMOS 1912338.1 Oracle Streams to Oracle GoldenGate Conversion •Database package streams2ogg–Download from MOS Doc ID 1912338.1•Load package as Streams Administrator and answer 2 questions –@streams2ogg–Name of Oracle GoldenGate administrator schema–Name of staging directory for storing the generated files•Run procedure from Streams Administrator schema using either: –exec streams2ogg.main–exec streams2ogg.customize (if performing customizations)•All generated files will be in the staging directory.Streams2ogg Files GeneratedFile Name Descriptione capname.prm Extract file name based on capture namep capname.prm Pump file name based on capture name/propagation namer appname.prm Replicat file name based on apply namemgr.prm Manager file name - contains PORT number,other OGG mgr Best Practiceparameters (These are not based on Streams configuration) handlers.sql Sql script to configure Streams handlers after replicat process isregistered (does not include handler code)streams2ogg.trc Debug/Trace file – always generatedstreams2ogg.rpt Report file – always generatedFile Name Descriptionggconfig.oby GGSCI obey file to create extract, pump, replicat processes ggconfig2.oby GGSCI obey file to create additional extract processes based on firstextract SCNggconfig_trandata.oby GGSCI obey file to configure database supplemental logging create_subdirectories.sh Shell script to generate directory structure under the trail file storagedirectoryreg_extract.sh Helper shell script for ggconfig2.oby OGG 12.1.2.0 Register extract….SCN optionwatch.sh, watch.sql watch_status.sql Helper shell and sql script for ggconfig2.oby for OGG 12.1.2.1 Register extract….SHARE optionwatch_status.sql can be used to get status of capture initializationogg_name_map.csv Comma-separated name/value pairs for customizing streams2ogg filegenerationStreams2ogg Files Generated (continued)Streams2ogg Post Execution StepsMOS 1912338.1 Oracle Streams to Oracle GoldenGate Conversion •Parameter files and obey files need to be edited–Choose method to login: dblogin or dbloginalias–For dblogin, set password•Pump parameter file also needs to identify the host name for the RMTHOST command–If PORT number is changed in mgr.port, modify port number in pump file, too. •wait.sh script needs sqlplus login passwordProgram Agenda1 2 3 4 Oracle GoldenGate 12.1.2 Review Oracle GoldenGate 12.1.2.1 New Features Streams to GoldenGate ConversionsQ&A。

Oracle白皮书2013 年 7 月Oracle WebLogic Server 12c 简介第 12.1.2 版跨传统环境与云环境的头号应用服务器执行概要 (4)云部署的灵活性 (6)为下一代应用程序提供任务关键的云平台 (7)使用优化的 Oracle WebLogic Server 和 Oracle 数据库集成实现高 RASP、多租户 .. 8使用动态集群实现云的灵活性 (12)使用 Oracle Exalogic 中间件云服务器优化实现高达 3 倍的性能提升 (13)使用自有云管理简化运营 (14)使用统一安装和修补框架提高效率 (14)一致的 Oracle Coherence 管理 (14)Java 消息服务 (JMS) 的灵活伸缩 (15)Oracle Enterprise Manager 12c 提供的额外的云管理功能 (16)使用现代开发平台缩短上市时间 (18)使用简化的 Maven 集成实现快速开发 (18)使用移动开发框架支持智能电话和平板电脑 (19)使用 WebSocket 和 Toplink 数据服务开发创新型移动应用程序 (19)使用适用于 HTML5 的 JSON-REST 服务释放数据 (20)Oracle WebLogic Server：市场领先的应用服务器 (21)结论 (23)免责声明以下内容旨在概述产品的总体发展方向。

该内容仅供参考，不可纳入任何合同。

其内容不构成提供任何材料、代码或功能的承诺，并且不应该作为制定购买决策的依据。

所描述的有关 Oracle 产品的任何特性或功能的开发、发布和时间安排均由 Oracle 自行决定。

执行概要如今的企业领导对IT 提出了挑战性的需求。

根据最近的一项IDC 调查，CIO 们将降低成本、快速推出新的和改进的产品以及提高生产效率列为首要任务。

1 许多组织都在努力满足这些迫切需要。

原因何在？竞争激烈的市场、业务模式、消费者喜好都在快速变化，要跟上变化的步伐，必须更改现有软件或编写全新的应用程序。

（Oracle管理）Oracle数据库维护手册数据库维护手册目录2.1数据库启动42.2数据库停止52.3监听器的启停52.4用户管理62.5数据库参数文件62.6数据库概况的查询72.7常用对象的创建和使用82.8失效数据库对象的检测和编译92.9数据备份的技巧102.10数据库命中率的监测112.11最消耗资源进程的检测112.12锁的监测及处理122.13SQL语句执行技巧132.14表空间的管理142.15数据文件I/O的统计优化152.16错误号的跟踪出理153.1ORACLE数据库日常检查163.2会话连接日志的清理163.3数据库hang住时的停止和方法16 3.4扩表空间方法173.5死锁会话的杀死173.6未决两阶段事务的回滚184.1EM工具181前言本文主要是简单介绍和总结日常Oracle数据在运行维护方面的一些方法和技巧。

通过该手册以便于相关技术人员的日常运维工作。

2ORACLEDB维护方法2.1数据库启动1、以oracle用户用户登录，sqlplus‘/assysdba’sqlplus>startup2、以oracle用户或ora816用户登录sqlplus‘/assysdba’sqlplus>startupnomuntsqlplus>alterdatabasemount；sqlplus>alterdatabaseopen；3、第一种启动方式是最常用的手工启动方式，第二种启动方式是数据库有故障时常用的逐步启动方式，可以观察故障点。

因为startupnomount语句只读取spfile（serverparameterfile数据库参数文件），启动instance，启动SGA和后台进程；alterdatabasemount语句打开控制文件，确认数据文件和联机日志文件的位置，但此时不对数据文件和日志文件进行校验检查；alterdatabaseopen 打开包括Redolog文件在内的所有数据库文件，这种方式下可访问数据库中的数据。

中间件日常维护手册(weblogic部分)（v 120925）目录1. 每天要维护的文档 (2)1.1 启动服务相关的几个文件 (2)1.1.1 startWebLogic.cmd/startWebLogic.sh (2)1.1.2 startManagedWebLogic.cmd/startManagedWebLogic.sh (2)1.1.3 setDomainEnv.cmd/setDomainEnv.sh (3)1.1.4 stopWebLogic.cmd/stopWebLogic.sh (3)1.1.5 stopManagedWebLogic.cmd/stopManagedWebLogic.sh (3)1.1.6 thread的监控 (3)1.1.7 JDBC监控 (4)1.1.8 检查是否生成javacore和heapdump文件 (4)1.2．weblogic配置文件config.xml (4)1.2.1 关于WebLogic 管理和config.xml 文件概述 (4)1.2.2 何时去编辑config.xml (4)1.2.3 config.xml 文件里的内容 (5)1.3 每天要维护的日志文件 (5)1.3.1 域日志(domain.log) (5)1.3.2 server.log (5)1.3.3 access.log (6)1.4 系统文件 (6)1.4.1硬盘分区使用情况 (6)1.4.2 CPU 负载情况 (6)1.4.3 内存MEMORY和SWAP使用率 (6)2.每周要维护的文档 (7)2.1 应用属性文件weblogic.xml (7)2.1.1 说明 (7)2.1.2 可配置的属性详解 (7)2.2属性文件web.xml (8)2.2.1 说明 (8)2.2.2 文件说明 (8)3.每月要维护的文件 (8)3.1 weblogic 系统文件备份 (8)3.2 定期日志删除 (8)3.3 补丁的更新 (8)1. 每天要维护的文档1.1 启动服务相关的几个文件WebLoigc 的启动是通过启动文件来完成的，包括启动管理服务器(startWebLogic)、启动被管服务器(startManagedWebLogic)、设置域环境(setDomainEnv)、关闭管理服务器(stopWebLogic)、关闭被管服务器(stopManagedWebLogic)等。

软件室 Weblogic12 C安装配置手册-初级版本 <1.0>修订历史记录目录1.简介 (4)1.1目的 (4)1.2范围 (4)1.3定义、首字母缩写词和缩略语 (4)1.4参考资料 (4)1.5概述 (4)2.部署前准备工作 (4)2.1JDK环境安装(使用ROOT用户) (4)2.2H OSTS文件配置和多台WEBLOGIC集群说明(使用ROOT用户) (5)2.3创建WEBLOGIC用户和用户组(使用ROOT用户) (6)3.WEBLOGIC12C的安装（在桌面模式下进行安装，非命令行模式） (6)3.1运行安装程序 (6)3.2安装步骤图片展示 (7)4.创建WEBLOGIC域(DOMAIN) (15)4.1运行配置向导 (15)4.2选择D OMAIN S OURCE (19)4.3输入管理员用户名称和密码 (21)4.4选择WEBLOGIC启动模式和JDK (21)4.5选择定制配置和集群服务器配置选择说明 (23)4.6配置管理节点 (23)4.7W EB容器服务配置 (25)4.8集群配置 (26)4.9其他配置图解 (29)5.WEBLOGIC 启动和JVM内存设置 (33)5.1节点配置 (33)5.2W EBLOGIC手动启动(使用WEBLOGIC用户) (33)5.2.1启动管理服务（使用weblogic用户） (33)5.2.2启动web容器节点（使用weblogic用户） (34)5.2.3访问地址 (34)5.3生产模式免密码和后台启动（使用WEBLOGIC用户操作命令） (34)5.4开机自启动服务配置和设置（使用ROOT用户） (35)5.5关闭WEBLOGIC (39)5.6调整WEBLGOC的运行JVM内存 (39)Weblogic12c安装配置手册-初级1.简介本文档是对以前的weblogic12c安装配置手册的整理和总结，包括在日常维护过程中常出现的问题及解决方法。

ORACLE数据库⽇常维护⼿册（最全+最实⽤）最近针对ORACLE数据库⽇常维护中最实⽤的⽅法全部整理成册,⽅便⼤家参考！！2021-07-11查看数据库版本SELECT*FROM V$VERSION;查看数据库语⾔环境SELECT USERENV('LANGUAGE') FROM DUAL;查看ORACLE实例状态SELECT INSTANCE_NAME,HOST_NAME,STARTUP_TIME,STATUS,DATABASE_STATUS FROM V$INSTANCE;查看ORACLE监听状态lsnrctl status查看数据库归档模式SELECT NAME,LOG_MODE,OPEN_MODE FROM V$DATABASE;查看回收站中对象SELECT OBJECT_NAME,ORIGINAL_NAME,TYPE FROM RECYCLEBIN;清空回收站中对象PURGE RECYCLEBIN;还原回收站中的对象FLASHBACK TABLE "BIN$GOZUQZ6GS222JZDCCTFLHQ==$0" TO BEFORE DROP RENAME TO TEST;闪回误删除的表FLASHBACK TABLE AAA TO BEFORE DROP;闪回表中记录到某⼀时间点ALTER TABLE TEST ENABLE ROW MOVEMENT;FLASHBACK TABLE TEST TO TIMESTAMPTO_TIMESTAMP('2009-10-15 21:17:47','YYYY-MM-DD HH24:MI:SS');查看当前会话SELECT SID,SERIAL#,USERNAME,PROGRAM,MACHINE,STATUS FROM V$SESSION;查看DDL锁SELECT*FROM DBA_DDL_LOCKS WHERE OWNER ='FWYANG';检查等待事件SELECT SID, ERNAME, EVENT, WAIT_CLASS, T1.SQL_TEXT FROM V$SESSION A, V$SQLAREA T1 WHERE WAIT_CLASS 'Idle'AND A.SQL_ID = T1.SQL_ID; SELECT SID, ERNAME, EVENT, WAIT_CLASS, T1.SQL_TEXT FROM V$SESSION A, V$SQLAREA T1 WHERE WAIT_CLASS 'Idle' AND A.SQL_ID = T1.SQL_ID;检查数据⽂件状态SELECT FILE_NAME,STATUS FROM DBA_DATA_FILES;检查表空间使⽤情况SELECT UPPER(F.TABLESPACE_NAME) "表空间名",D.TOT_GROOTTE_MB "表空间⼤⼩(M)",D.TOT_GROOTTE_MB - F.TOTAL_BYTES "已使⽤空间(M)",TO_CHAR(ROUND((D.TOT_GROOTTE_MB - F.TOTAL_BYTES) / D.TOT_GROOTTE_MB *100,2),'990.99') "使⽤⽐",F.TOTAL_BYTES "空闲空间(M)",F.MAX_BYTES "最⼤块(M)" FROM (SELECT TABLESPACE_NAME, ROUND(SUM(BYTES) / (1024*1024), 2) TOTAL_BYTES, ROUND(MAX(BYTES) / (1024*1024), 2) MAX_BYTES FROM SYS.DBA_FREE_SPACE GROUP 收缩表空间ALTER TABLESPCE TS_AJ_DATA COALESCE;增加表空间⼤⼩SELECT T.TABLESPACE_NAME, T.FILE_NAME, T.BYTES /1024/1024/1024FROM DBA_DATA_FILES T WHERE T.TABLESPACE_NAME ='TS_AJ_DATA';ALTER TABLESPACE TS_AJ_DATA ADD DATAFILE '/DATA/TS_AJ_DATA05_10G.DBF' SIZE 10000MAUTOEXTEND OFF;检查不起作⽤的约束SELECT OWNER, CONSTRAINT_NAME, TABLE_NAME, CONSTRAINT_TYPE, STATUS FROM DBA_CONSTRAINTS WHERE STATUS ='DISABLE';检查发⽣坏块的数据库对象SELECT TABLESPACE_NAME, SEGMENT_TYPE, OWNER, SEGMENT_NAMEFROM DBA_EXTENTSWHERE FILE_ID=AND BETWEEN BLOCK_ID AND BLOCK_ID BLOCKS -1;检查⽆效的数据库对象SELECT OWNER,OBJECT_NAME,OBJECT_TYPEFROM DBA_OBJECT/doc/dba9a779825b68483416ac96SWHERE STATUS ='INVALID';查看语句执⾏进度SELECT SE.SID,OPNAME,TRUNC(SOFAR / TOTALWORK *100, 2) ||'%'AS PCT_WORK,ELAPSED_SECONDS ELAPSED,ROUND(ELAPSED_SECONDS * (TOTALWORK - SOFAR) / SOFAR) REMAIN_TIME, SQL_TEXT FROM V$SESSION_LONGOPS SL, V$SQLAREA SA, V$SESSION SEWHERE SL.SQL_HASH_VALUE = SA.HASH_VALUE AND SL.SID = SE.SID AND SOFAR != TOTALWORKORDER BY START_TIME;检查碎⽚程度⾼的表SELECT SEGMENT_NAME TABLE_NAME, COUNT(*) EXTENTSFROM DBA_SEGMENTSWHERE OWNER NOT IN ('SYS', 'SYSTEM')GROUP BY SEGMENT_NAMEHAVING COUNT(*) = (SELECT MAX(COUNT(*)) FROM DBA_SEGMENTS GROUP BY SEGMENT_NAME);检查表空间的 I/O ⽐例SELECT DF.TABLESPACE_NAME NAME, DF.FILE_NAME "FILE", F.PHYRDS PYR,F.PHYBLKRD /doc/dba9a779825b68483416ac96PBR,F.PHYWRTS PYW,F.PHYBLKWRT PBW FROM V$FILESTAT F, DBA_DATA_FILES DFWHERE F.FILE# = DF.FILE_IDORDER BY DF.TABLESPACE_NAME;检查⽂件系统的 I/O ⽐例SELECT SUBSTR(A.FILE#, 1, 2) "#",SUBSTR(, 1, 30) "NAME",A.STATUS,A.BYTES,B.PHYRDS,B.PHYWRTSFROM V$DATAFILE A, V$FILESTAT BWHERE A.FILE# = B.FILE#;检查消耗CPU最⾼的进程SELECT P.PID PID,S.SID SID,P.SPID SPID,ERNAME USERNAME,S.OSUSER OSNAME,P.SERIAL# S_#,P.TERMINAL,P.PROGRAM PR ,P.BACKGROUND,S.STATUS,RTRIM(SUBSTR(A.SQL_TEXT, 1, 80)) SQLFROMFROM V$PROCESS P, V$SESSION S, V$SQLAREA AWHERE P.ADDR = S.PADDRAND S.SQL_ADDRESS = A.ADDRESSAND P.SERIAL#= '1';检查运⾏很久的SQLSELECT USERNAME,SID,OPNAME,ROUND(SOFAR *100/ TOTALWORK, 0) ||'%'AS PROGRESS, TIME_REMAINING, SQL_TEXTFROM V$SESSION_LONGOPS, V$SQLWHERE TIME_REMAINING =0AND SQL_ADDRESS = ADDRESSAND SQL_HASH_VALUE = HASH_VALUE;等待时间最多的5个系统等待事件的获取SELECT*FROM(SELECT*FROM V$SYSTEM_EVENT WHERE EVENT NOT LIKE'SQL%'ORDER BY TOTAL_WAITS DESC)WHERE ROWNUM =1查找前⼗条性能差的SQLSELECT*FROM (SELECT PARSING_USER_ID EXECUTIONS,SORTS,COMMAND_TYPE,DISK_READS,SQL_TEXTFROM V$SQLAREAORDER BY DISK_READS DESC)WHERE ROWNUM =1检查死锁SELECT ername "Blocking User", ername "DB User",ername "Waiting User", bs.SID "SID", ws.SID "WSID",bs.serial# "Serial#", bs.sql_address "address",bs.sql_hash_value "Sql hash", bs.program "Blocking App",ws.program "Waiting App", bs.machine "Blocking Machine",ws.machine "Waiting Machine", bs.osuser "Blocking OS User",ws.osuser "Waiting OS User", bs.serial# "Serial#",ws.serial# "WSerial#", DECODE (wk.TYPE,'MR', 'Media Recovery','RT', 'Redo Thread','UN', 'USER Name','TX', 'Transaction','TM', 'DML','UL', 'PL/SQL USER LOCK','DX', 'Distributed Xaction','CF', 'Control FILE','IS', 'Instance State','FS', 'FILE SET','IR', 'Instance Recovery','ST', 'Disk SPACE Transaction','TS', 'Temp Segment','IV', 'Library Cache Invalidation','LS', 'LOG START OR Switch','RW', 'ROW Wait','SQ', 'Sequence Number','TE', 'Extend TABLE','TT', 'Temp TABLE',wk.TYPE) lock_type,DECODE (hk.lmode,0, 'None',1, 'NULL',2, 'ROW-S (SS)',3, 'ROW-X (SX)',4, 'SHARE',5, 'S/ROW-X (SSX)',6, 'EXCLUSIVE',TO_CHAR (hk.lmode)) mode_held,DECODE (wk.request,0, 'None',1, 'NULL',2, 'ROW-S (SS)',3, 'ROW-X (SX)',4, 'SHARE',5, 'S/ROW-X (SSX)',6, 'EXCLUSIVE',TO_CHAR (wk.request)) mode_requested,TO_CHAR (hk.id1) lock_id1, TO_CHAR (hk.id2) lock_id2, DECODE(hk.BLOCK, 'NOT Blocking', /**//* Not blocking any other processes */1, 'Blocking', /**//* This lock blocks other processes */2, 'Global', /**//* This lock is global, so we can't tell */TO_CHAR (hk.BLOCK)) blocking_othersFROM v$lock hk, v$session bs, v$lock wk, v$session ws WHERE hk.BLOCK =1 AND hk.lmode !=0AND hk.lmode !=1AND wk.request !=0AND wk.TYPE = hk.TYPEAND wk.id1 = hk.id1AND wk.id2 = hk.id2AND hk.SID = bs.SIDAND wk.SID = ws.SIDAND (ername IS NOT NULL)AND (ername ='SYSTEM')AND (ername ='SYS')ORDER BY1;查看正在运⾏的JOBSELECT*FROM DBA_JOBS_RUNNING;检查数据库JOB的完成情况SELECT JOB, LOG_USER, LAST_DATE, NEXT_DATE, WHAT, FAILURES FROM DBA_JOBS;查看正在运⾏的JOB对应的SID、SERIAL#、SPIDSELECT A.JOB, B.SID, B.SERIAL#, C.SPIDFROM DBA_JOBS_RUNNING A, V$SESSION B, V$PROCESS C WHERE A.SID = B.SIDAND B.PADDR = C.ADDRAND JOB ='21';通过SID查询SERIAL#、SPIDSELECT B.SID, B.SERIAL#, C.SPID FROM V$SESSION B, V$PROCESS C WHERE B.SID ='554' AND B.PADDR = C.ADDR;停⽌会话--SID:554 SERIAL#:1134 SPID:23242 ORACLE级别ALTER SYSTEM KILL SESSION '554,1134'; 操作系统级别kill-923242。

WebLogic 12c 安装部署手册012012年目录1WebLogic 12c介绍 (4)1.1概要 (4)1.2缩略语和术语 (4)1.3要求 (4)1.4升级或迁移注意事项 (4)1.5下载 (5)2WebLogic 12c安装 (5)2.1JDK软件安装 (5)2.2WEBLOGIC软件安装 (6)2.3域创建及配置 (13)2.3.1域创建 (13)2.3.2启动/停止管理控制台 (19)2.4受管服务器的创建及配置 (20)2.5计算机的创建及配置 (22)2.6配置运行服务器的计算机 (23)2.7节点服务器的运行 (26)2.7.1节点管理器介绍 (26)2.7.2节点管理器启动 (26)2.8数据源的配置..................................................... 错误！未定义书签。

2.8.1一般数据源的配置............................................. 错误！未定义书签。

2.8.2多数据源的配置................................................. 错误！未定义书签。

2.8.3GridLink数据源的配置..................................... 错误！未定义书签。

2.9WEBAPPS应用的部署 ..................................... 错误！未定义书签。

2.9.1应用部署配置..................................................... 错误！未定义书签。

2.9.2应用包相关配置................................................. 错误！未定义书签。

2.9.3启动应用............................................................. 错误！未定义书签。

Oracle数据库维护和管理手册1Oracle 数据库维护和管理手册作者孙德金审核分类数据库子类Oracle更新时间 -11-24关键字Oracle 维护和管理摘要Oracle 运行维护、管理、日常巡检主要适linux用环境文档控制2文档修订记录版本号变化状态变更内容修改日期变更人0.01 C .11.24 孙德金*变化状态:C――创立,A——增加,M——修改,D——删除文档审批信息版本号审核人审核日期批准人批准日期备注目录1 概述................................................................................................... 错误!未定义书签。

1.1 目的 ....................................................................................... 错误!未定义书签。

1.2 范围 ................................................................................. 错误!未定义书签。

31.3 预期读者 ......................................................................... 错误!未定义书签。

1.4 术语定义 ......................................................................... 错误!未定义书签。

1.5 参考资料 ......................................................................... 错误!未定义书签。

2 CRS的管理 ...................................................................................... 错误!未定义书签。

中间件日常维护手册(weblogic部分)（v 120925）作者吴占喜审核分类其他子类Weblogic更新时间2012/9/25关键字weblogic摘要Weblogic日常维护手册主要适维护工程师及当地现场工程师参考和使用用环境目录1. 每天要维护的文档 (3)1.1 启动服务相关的几个文件 (3)1.1.1 startWebLogic.cmd/startWebLogic.sh (3)1.1.2 startManagedWebLogic.cmd/startManagedWebLogic.sh (3)1.1.3 setDomainEnv.cmd/setDomainEnv.sh (3)1.1.4 stopWebLogic.cmd/stopWebLogic.sh (4)1.1.5 stopManagedWebLogic.cmd/stopManagedWebLogic.sh (4)1.1.6 thread的监控 (4)1.1.7 JDBC监控 (5)1.1.8 检查是否生成javacore和heapdump文件 (5)1.2．weblogic配置文件config.xml (5)1.2.1 关于WebLogic 管理和config.xml 文件概述 (6)1.2.2 何时去编辑config.xml (6)1.2.3 config.xml 文件里的内容 (6)1.3 每天要维护的日志文件 (7)1.3.1 域日志(domain.log) (7)1.3.2 server.log (7)1.3.3 access.log (7)1.4 系统文件 (8)1.4.1硬盘分区使用情况 (8)1.4.2 CPU 负载情况 (8)1.4.3 内存MEMORY和SWAP使用率 (8)2.每周要维护的文档 (9)2.1 应用属性文件weblogic.xml (9)2.1.1 说明 (9)2.1.2 可配置的属性详解 (9)2.2属性文件web.xml (10)2.2.1 说明 (10)2.2.2 文件说明 (10)3.每月要维护的文件 (11)3.1 weblogic 系统文件备份 (11)3.2 定期日志删除 (11)3.3 补丁的更新 (11)1. 每天要维护的文档1.1 启动服务相关的几个文件WebLoigc 的启动是通过启动文件来完成的，包括启动管理服务器(startWebLogic)、启动被管服务器(startManagedWebLogic)、设置域环境(setDomainEnv)、关闭管理服务器(stopWebLogic)、关闭被管服务器(stopManagedWebLogic)等。

ORACLE FEATURE OVERVIEWORACLE DATABASE LOCATOR FEATURE LOCATION CAPABILITIES IN ORACLE DATABASE 12C KEY CAPABILITIES • SDO_GEOMETRY PackageOTHER ORACLE DATABSELOCATOR CAPABILITIES• Spatial geometry object data type• Fast spatial R-tree indexing• Spatial relationship operators:distance, area, and lengthfunctions+-• Open, standard SQL access tospatial operations• Whole Earth geometry model –comprehensive treatment ofgeodetic data• Function-based spatial indexes• Long transactions• Integration with Oracle FusionMiddleware MapViewer 11g mapvisualization tool• Coordinate system support basedon the European Petroleum SurveyGroup (EPSG) data model• Explicit coordinate transformationsInformation about the Oracle Spatialand Graph option can be found in aseparate data sheet at/goto/spatialA detailed listing of Oracle DatabaseLocator feature and Oracle Spatialand Graph option is in the OracleSpatial and Graph Developer’sGuide, 12c Release 1.Every Oracle database includes built-in location features that enable any business application – from department to enterprise – to directly incorporate location information and realize competitive advantages. Oracle’s open, native spatial support eliminates the cost of separate, proprietary systems, and is supported by all leading geospatial tool vendors. Only Oracle delivers industry-leading security, performance, scalability, and manageability for mission critical spatial assets stored in Oracle’s native type. This feature overview highlights capabilities of the Oracle Locator feature of Oracle Database 12c – the industry’s leading spatial database management platform. Easily Location-Enable All Your Applications Most business information has a location component, such as customer addresses, sales territories, and physical assets. Businesses can take advantage of their geographic information by incorporating location analysis into their information systems. This allows organizations to make better decisions and respond to customers more effectively. Oracle Database 12c provides the foundation for deploying enterprise-wide spatial information systems and location-enabled e-Business applications. Oracle Database Locator , a feature of Oracle Database (Express Edition, Standard Edition, Standard Edition One, and Enterprise Edition), provides core location functionality needed by most customer applications and partner solutions. Developers can easily incorporate location information directly in their applications and services using Locator. This is possible because location data is fully integrated in the Oracle server itself. Geographic and location data are manipulated using the same semantics applied to the CHAR, DATE or INTEGER types that are familiar to all users of SQL. Oracle Database Locator feature is not a solution for more complex geospatial applications. Oracle Spatial and Graph , an option to Oracle Database Enterprise Edition, extends the Locator feature, and provides an even more robust foundation for geospatial and business applications that require advanced spatial analysis and processing in Oracle Database. It includes support for all geospatial data types and models, including vector and raster data, and topology and network models; as well as routing and geocoding engines. Oracle Database Locator Feature Highlights The SDO_GEOMETRY package is now part of Oracle Database Locator feature. This means that many of the commonly used spatial functions and operators, such as intersection, difference, distance, and within distance are2Resources:/goto/spatial•White papers •Customer videos, profiles•News and eventsOracle Technology Network:/technetwork/database/options/spatialandgraph/spatial•Documentation and white papers •Software, sample code •Customer profiles •Technical forum • Training (Oracle University classschedules, online training, freetutorials)• PartnersRelated products • Oracle Database 12c • Oracle Fusion MiddlewareMapVieweravailable. However, to take advantage of the dramatic performance improvements for these spatial functions and operators (Vector Performance Acceleration feature), the Oracle Spatial and Graph option is required. This gives users about 50X faster spatial joins, touch, contains, overlaps, and complex masks. Manage Critical Spatial Data Assets with Enterprise-Class Security, Scalability, Performance For your mission-critical spatial data assets, only Oracle can provide the security, scalability, and performance of the industry’s leading database, to manage multi-terabyte datasets and serve communities ranging from tens to tens of thousands of users. Only by using Oracle’s native spatial data type (versus Long Raw or BLOB) can you take advantage of the features below: • Oracle Exadata Database Machine • Partitioning support for spatial indexes •Parallel index builds for spatial R-tree indexes •Parallel spatial queries •Replication (some features available with Enterprise Edition only) • Spatially-driven multi-level securitySupported By All Leading Geospatial Tools and ApplicationsOracle Database Locator feature is directly integrated with the leading geospatial, mapping and location services technology vendors. Since Oracle’s spatial data type is compliant with open standards, Oracle can serve as an interoperable, central geospatial data repository for providingdata to any partner application.A list of partners is available at:/technetwork/database/options/spatialandgraph/spatial.With Oracle Database Locator feature, Oracle brings the power and valueof location analysis to all your business applications. Only Oracle providesworld-class performance, scalability, security, and manageability to yourspatial data assets, while reducing costs, with support from every leadinggeospatial vendor.Copyright © 2013, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.。

Oracle® Enterprise Manager Ops CenterCertified Systems Matrix12c Release 4 (12.4.0.0.0)F17673-01April 2019Certified Systems MatrixThis guide lists the certified systems for Oracle Enterprise Manager Ops Center.The following topics are covered in this document:•Base Operating Systems•Base Browsers•Base Databases•Base Oracle Clusterware for High Availability•Target Operating Systems•Target Servers•Target Non-Server Hardware•Target VirtualizationBase Operating SystemsThis section describes the supported operating systems for the Enterprise Controllerand Proxy Controller.Enterprise Controller Operating SystemsThis table lists the supported operating systems for the Enterprise Controller.Table 1-1 Enterprise Controller Operating SystemsCertificationPlatformVersion Minimum Update Level and CommentsOracle SolarisOracle Solaris SPARC 10Embedded Database: 1/13Customer-Managed Database: 1/13Table 1-1 (Cont.) Enterprise Controller Operating Systems CertificationPlatformVersion Minimum Update Level and CommentsOracle Solaris SPARC 11Embedded Database: 11.3 and 11.4Customer-Managed Database: 11.3 and 11.4Oracle Solaris SPARC Local Zone 10Embedded Database: 1/13Customer-Managed Database: 1/13Oracle Solaris SPARC Local Zone 11Embedded Database: 11.3 and 11.4Customer-Managed Database: 11.3 and 11.4Oracle Solaris SPARC Kernel Zone 11Embedded Database: 11.3 and 11.4Customer-Managed Database: 11.3 and 11.4Oracle VM Server for SPARC 10Embedded Database: 1/13Customer-Managed Database: 1/13Oracle VM Server for SPARC 11Embedded Database: 11.3 and 11.4Customer-Managed Database: 11.3 and 11.4Oracle Solaris x8610Embedded Database: 1/13Customer-Managed Database: 1/13Oracle Solaris x8611Embedded Database: 11.3 and 11.4Customer-Managed Database: 11.3 and 11.4Oracle Solaris x86 Local Zone 10Embedded Database: 1/13Customer-Managed Database: 1/13Oracle Solaris x86 Local Zone 11Embedded Database: 11.3 and 11.4Customer-Managed Database: 11.3 and 11.4Oracle Solaris x86 Kernel Zone 11Embedded Database: 11.3 and 11.4Customer-Managed Database: 11.3 and 11.4LinuxOracle Linux77.0 - 7.3Proxy Controller Operating SystemsThis table lists the supported operating systems for Proxy Controllers. Table 1-2 Proxy Controller Operating SystemsCertification Platform Version Minimum Update Level and Comments Oracle SolarisOracle Solaris SPARC101/13Oracle Solaris SPARC1111.3 and 11.4Oracle Solaris SPARC LocalZone1111.3 and 11.4Table 1-2 (Cont.) Proxy Controller Operating SystemsCertification Platform Version Minimum Update Level and Comments Oracle Solaris SPARCKernel Zone1111.3 and 11.4Oracle VM Server forSPARC101/13Oracle VM Server forSPARC1111.3 and 11.4Oracle Solaris x86101/13Oracle Solaris x861111.3 and 11.4Oracle Solaris x86 LocalZone1111.3 and 11.4Oracle Solaris x86 KernelZone1111.3 and 11.4LinuxOracle Linux77.0 - 7.3Base BrowsersThis table lists the supported browsers for accessing the user interface. Table 1-3 Base BrowsersCertification Platform VersionFirefox64 or laterInternet Explorer11Chrome71 or laterBase DatabasesThis table lists the supported product databases.Table 1-4 Base DatabasesCertification Platform Version Supported Update Level CommentsOracle Database -Customer-Managed 12c12.1.0.2 container and non-containerAll platforms the databasesupports are allowed.Oracle Real ApplicationClusters are supported. 11g11.2.0.3.0 and 11.2.0.4.0Table 1-4 (Cont.) Base DatabasesCertification Platform Version Supported Update Level CommentsOracle Database -Embedded 12c12.1.0.2Oracle Database 12.1.0.2 isused in Oracle EnterpriseManager Ops Center 12.4.Base Oracle Clusterware for High AvailabilityThis table lists the supported Oracle Clusterware versions for Enterprise Controller High Availability.Table 1-5 Base Oracle ClusterwareCertification Platform Version Update LevelOracle Clusterware11gR211.2.0.1 or 11.2.0.3 Target Operating SystemsThis table lists the supported target operating systems.Table 1-6 Target Operating SystemsCertificationPlatformVersion Minimum Update Level and Comments Oracle Solaris SPARCOracle SolarisSPARC101/13Oracle Solaris SPARC 1111.3 and 11.4The Enterprise Controller and Proxy Controller mustbe on Oracle Solaris 11 to update, provision, andagent-manage Oracle Solaris 11 assets.For Oracle Solaris 11.3 and 11.4, support is limited tothe same feature set as Oracle Solaris 11.1, as wellas limited support for Kernel zones. Other featuresintroduced in Oracle Solaris 11.3 and 11.4 are not yetsupported.Oracle SolarisSPARC LocalZone101/13Table 1-6 (Cont.) Target Operating SystemsCertificationPlatformVersion Minimum Update Level and CommentsOracle Solaris SPARC Local Zone 1111.3 and 11.4The Enterprise Controller and Proxy Controller mustbe on Oracle Solaris 11 to update, provision, andagent-manage Oracle Solaris 11 assets.For Oracle Solaris 11.3 and 11.4, support is limited tothe same feature set as Oracle Solaris 11.1, as wellas limited support for Kernel zones. Other featuresintroduced in Oracle Solaris 11.3 and 11.4 are not yetsupported.Oracle Solaris SPARC Kernel Zone 1111.3 and 11.4The Enterprise Controller and Proxy Controller mustbe on Oracle Solaris 11 to update, provision, andagent-manage Oracle Solaris 11 assets.For Oracle Solaris 11.3 and 11.4, support is limited tothe same feature set as Oracle Solaris 11.1, as wellas limited support for Kernel zones. Other featuresintroduced in Oracle Solaris 11.3 and 11.4 are not yetsupported.Oracle VMServer forSPARC101/13Oracle VM Server for SPARC 1111.3 and 11.4The Enterprise Controller and Proxy Controller mustbe on Oracle Solaris 11 to update, provision, andagent-manage Oracle Solaris 11 assets.For Oracle Solaris 11.3 and 11.4, support is limited tothe same feature set as Oracle Solaris 11.1, as wellas limited support for Kernel zones. Other featuresintroduced in Oracle Solaris 11.3 and 11.4 are not yetsupported.Oracle Solaris x86Oracle Solarisx86101/13Oracle Solaris x861111.3 and 11.4The Enterprise Controller and Proxy Controller mustbe on Oracle Solaris 11 to update, provision, andagent-manage Oracle Solaris 11 assets.For Oracle Solaris 11.3 and 11.4, support is limited tothe same feature set as Oracle Solaris 11.1, as wellas limited support for Kernel zones. Other featuresintroduced in Oracle Solaris 11.3 and 11.4 are not yetsupported.Oracle Solarisx86 Local Zone101/13Table 1-6 (Cont.) Target Operating SystemsCertificationPlatformVersion Minimum Update Level and CommentsOracle Solaris x86 Local Zone 1111.3 and 11.4The Enterprise Controller and Proxy Controller mustbe on Oracle Solaris 11 to update, provision, andagent-manage Oracle Solaris 11 assets.For Oracle Solaris 11.3 and 11.4, support is limited tothe same feature set as Oracle Solaris 11.1, as wellas limited support for Kernel zones. Other featuresintroduced in Oracle Solaris 11.3 and 11.4 are not yetsupported.Oracle Solaris x86 Kernel Zone 1111.3 and 11.4The Enterprise Controller and Proxy Controller mustbe on Oracle Solaris 11 to update, provision, andagent-manage Oracle Solaris 11 assets.For Oracle Solaris 11.3 and 11.4, support is limited tothe same feature set as Oracle Solaris 11.1, as wellas limited support for Kernel zones. Other featuresintroduced in Oracle Solaris 11.3 and 11.4 are not yetsupported.LinuxOracle Linux77.0 - 7.3OS Updates are not supported.Target ServersThis section shows the supported target servers.Oracle Enterprise Manager Ops Center can perform server management tasks on many platforms. All Oracle/Sun servers with ILOM enabled service processors are supported. These servers represent the bulk of server equipment (V series servers, X series servers, T series servers, and M series servers) available from Oracle. Exceptions are called out in the documentation for specific features if any exist. The recommended firmware is the most recently tested version.Starting with Oracle Enterprise Manager Ops Center 12c Release 3 (12.3.2.0.0), Oracle Server X6–2, Oracle Server X6–2L, SPARC S7-2, and SPARC S7-2L systems are supported.SPARC M5-32, SPARC M6-32, SPARC M7-8, SPARC M7-16, SPARC M8-8 Single Domain, and SPARC M8-8 Multi Domain servers are supported, but some features have additional limitations:•When performing firmware provisioning on SPARC M5-32 and SPARC M6-32 servers, do not select the "Requires Host Power Off" option.•Certain hardware faults on SPARC M5-32 and SPARC M6-32 servers are mapped to the wrapping components, rather than to the correct components.•When performing OS Provisioning on SPARC M5-32, SPARC M6-32, SPARC M7-8, SPARC M7-16, SPARC M8-8 Single Domain, and SPARC M8-8 MultiDomain server domains, if you plan to use the network interfaces on the PCI cards that are available only through OBP, specify the MAC address of the networkinterface instead of the IP address when you deploy the OS Provisioning plan. Oracle Server X7 series systems are supported, but they do not support Oracle Solaris 10. You cannot configure RAID on Oracle Server X7 series systems.Oracle Server X6 series systems are supported, but they do not support Oracle Solaris 10. You cannot configure RAID on Oracle Server X6 series systems.Oracle Server X5 series systems are supported, but they do not support Oracle Solaris 10. You cannot configure RAID on Oracle Server X5 series systems.Ensure that you maintain your system firmware. The following are some of the reasons to update the firmware on your system:•Support for new versions of hardware (or peripherals)•Expanded compatibility and enhancements•Better reliability and system availability•Better system performance•Additional system features•Security fixes•Other bug fixesSee the Related Articles and Resources section for more information about updating firmware.For the Auto Service Request (ASR) feature, Oracle Enterprise Manager Ops Center supports the ILOM and FMA telemetry sources as well as HALRT faults from Exadata systems. Any hardware supported by Oracle Enterprise Manager Ops Center that is listed as supported in the ASR documentation is supported for ASR through Oracle Enterprise Manager Ops Center using these telemetry sources. See the Related Articles and Resources section for more information about the ASR documentation. Target Non-Server HardwareThis table lists the supported target non-server hardware.For the Auto Service Request (ASR) feature, Oracle Enterprise Manager Ops Center supports the ILOM and FMA telemetry sources as well as HALRT faults from Exadata systems. Any hardware supported by Oracle Enterprise Manager Ops Center that is listed as supported in the ASR documentation is supported for ASR through Oracle Enterprise Manager Ops Center using these telemetry sources. See the Related Articles and Resources section for more information about the ASR documentation.Table 1-7 Target Non-Server HardwareCertificationPlatformVersion Minimum Update LevelOpen StorageOracle ZFSStorageZS3-2NAOracle ZFSStorageZS3-4NAOracle ZFSStorageZS4-4NAOracle ZFSStorageZS5-2NATarget VirtualizationThis table lists the supported target virtualization technologies for control domains. See the Related Articles and Resources section for more information about virtualization requirements.Table 1-8 Target VirtualizationCertification Platform Version Minimum Update Level and Comments Oracle VM Server for SPARC 3.2Oracle Solaris 10 1/13Oracle VM Server for SPARC 3.3Oracle Solaris 11.3Oracle VM Server for SPARC 3.4Oracle Solaris 11.3Oracle VM Server for SPARC 3.5Oracle Solaris 11.3Oracle VM Server for SPARC 3.6Oracle Solaris 11.4Oracle Solaris Zones Oracle Solaris10Oracle Solaris 10 1/13Oracle Solaris Zones Oracle Solaris11Oracle Solaris 11.3 and 11.4Oracle VM Server for SPARC Supported Guest Operating Systems NA For information about Guest support, see/technetwork/documentation/vm-sparc-194287.html.Related Articles and ResourcesSee the Oracle Enterprise Manager Ops Center Installation for Oracle Solaris Operating System and Oracle Enterprise Manager Ops Center Installation for Linux Operating Systems for information about installing Oracle Enterprise Manager OpsCenter. These documents are available in the Oracle Enterprise Manager Ops Center Documentation Library at /cd/E59957_01/index.htm.For more information about firmware:•See Firmware Resources at /technetwork/systems/ patches/firmware/firmware-resources-1429462.html for a high level overview of firmware update recommendations.•See the Oracle hardware documentation and Product Notes for minimum firmware and OS requirements for your servers.•See the Oracle Enterprise Manager Ops Center Operations Guide for information about downloading and updating the required firmware version.See the ASR documentation at /technetwork/systems/asr/ documentation/index.html for more information about ASR support.For current discussions, see the product blog at https:/// opscenter.See the release-specific Oracle VM Server for SPARC Release Notes for the system requirements, including supported platforms, required and recommended operating system versions, and required and recommended firmware versions. The Oracle VM Server for SPARC documentation is located at /technetwork/ documentation/vm-sparc-194287.htmlOracle® Enterprise Manager Ops Center Certified Systems Matrix, 12c Release 4 (12.4.0.0.0)F17673-01Copyright © 2007, 2019, Oracle and/or its affiliates. All rights reserved.This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.。