BPM11gFoundation-02-0-ProductOverview

oracle11g安装配置手册V1.0版目录1安装Oracle前的系统预备工作 (2)1.1检查需要的软件包 (2)1.2修改系统内核参数 (2)1.3创建oracle组和用户 (3)1.4创建oracle安装名目 (3)1.5设置oracle用户环境变量 (3)2安装Oracle (4)2.1解压缩安装文件 (4)2.2安装ORACLE (4)3创建数据库 (10)3.1配置监听 (10)3.2创建数据库实例 (14)3.3检查oracle实例是否安装成功 (21)3.4设置开机自启动数据库实例 (21)4数据库配置 (22)4.1数据库差不多信息 (22)4.2修改ORACLE核心参数 (22)4.3建数据库表空间 (23)4.4建数据库用户 (23)4.5导入数据 (23)4.6用PLSQL Developer工具编译失效对象 (23)4.7修改用户密码 (24)5系统故障处理 (24)5.1数据库文件损坏 (24)5.2Oracle逻辑结构故障的处理方法： (32)5.3数据库服务器硬件故障 (34)1安装Oracle前的系统预备工作1.1检查需要的软件包以root用户登录系统，使用rpm -q 软件包关键词命令进行检测1.2修改系统内核参数在/etc/sysctl.conf中添加以下行：vi /etc/sysctl.conf运行下面的命令应用以上OS参数：/sbin/sysctl –p添加以下行到/etc/security/limits.conf文件中：假如/etc/pam.d/login文件中没有以下行，那么添加以下内容：修改/etc/selinux/config文件来关闭linux防火墙，确保SELINUX设置如下：1.3创建oracle组和用户1.4创建oracle安装名目1.5设置oracle用户环境变量以oracle用户登陆系统，在.bash_profile文件尾添加以下行：2安装Oracle2.1 解压缩安装文件$ mkdir /oracle/soft通过FTP上传安装包到/oracle/soft/名目下使用命令unzip 文件名解压安装包unzip p1*******_112030_Linux-x86-64_1of7.zipunzip p1*******_112030_Linux-x86-64_2of7.zip设置oracle帐户能够操作安装文件所在的名目chown -R oracle:oinstall /oracle/softchmod -R 755 /oracle/soft2.2 安装ORACLE用oracle帐户进入安装文件所在名目，执行如下命令即可看到安装界面$ ./runInstaller假如无法看到安装界面，请使用root帐户执行如下命令后再运行安装程序：# export DISPLAY=:0.0或者ip:0.0# xhost +$ ./runInstaller 或 ./runInstaller -ignoreSysPreReqs 〔跃过系统检查〕假如显现界面乱码现象，执行以下命令：export LANG=en显现安装界面后，依照界面提示进行相关的设置：安装完成的最后步骤，操作如下：$ su - root# /oracle/oralnventory/orainstRoot.sh #/oracle/product/11.2.0/dbhome_1/root.sh3创建数据库3.1 配置监听1、以oracle用户登录系统运行netca命令$ netca2、添加监听程序3、输入监听程序名4、使用默认端口15215、完成配置6、启动监听$ lsnrctl start3.2 创建数据库实例以oracle用户登录系统，运行dbca命令创建数据库实例$ dbca1、选择创建数据库2、选择创建数据库模板，选定制数据库3、输入数据库全局名及SID：amdb4、设定数据库账号密码5、设置闪回区大小，那个地点选择默认值大小6、设置数据库实例SGA、PGA大小，视操作系统内存大小，一样假如此系统只有ORACLE 应用，建议分配给ORACLE实例80%的大小，假如数据库为OLTP应用的，那么其应用一样差不多上小的短的进程，所需要的pga也相应较少，因此该值通常为总共分配给Oracle 实例的20%，另外的80%给SGA，假如是OLAP的应用，建议各占50%。

Oracle BPM Suite 11g – Complex Gateway ContentsOracle BPM Suite 11g – Complex Gateway (1)1Oracle BPM Suite 11g : Multi-Instance (1)1.1Concepts (1)1.2Sample Overview (1)1.2.1Scope (1)1.2.2What’s Included (1)1.3Understanding the Complex Gateway sample (1)1.3.1Context (1)1.3.2Overview (1)1.3.3Configuration of Complex Gateway (2)1.3.4Testing the process (2)1 Oracle BPM Suite 11g : Multi-Instance1.1 ConceptsA complex gateway is only a merging gateway and can be used to merge process branches created bysplitting parallel or inclusive gateway. A common use case of Complex Gateway is for aborting active paths in the Parallel or Inclusive Gateways if the condition associated with the Complex Gateway is satisfied. Thecomplex gateway is activated once the specified condition is true./docs/cd/E21764_01/doc.1111/e15176/model_bus_procs_bpmpd.htm#BPMPD15001.2 Sample Overview1.2.1 ScopeThis sample covers Complex Gateway for aborting active paths in the Parallel or Inclusive Gateways.1.2.2 What’s IncludedThe sample Application has 1 project:1. Complex BPM Project that highlights using Complex Gateway.1.3 Understanding the Complex Gateway sample1.3.1 ContextThis is used as a Merge Gateway for Parallel and Inclusive Gateways to abort active incoming pathsbased on evaluation of a specific condition.1.3.2 OverviewThis is a very simple example where the passport is cleared after checking driver’s license, validatingcredit and criminal record. These 3 checks are conducted by different departments. The passport iscleared if 2 out of 3 checks have been completed and the outcome is “APPROVE. The incomingpayload is kept simple and is just a string – passport id. The Check Criminal Record, Check Creditand Check Driver’s License are User Tasks. There is no UI associated with any of these User Tasks.The active incoming path to the Complex Gateway is aborted if 2 out of 3 incoming flows have completed with outcome = “APPROVE”.1.3.3 Configuration of Complex GatewayThe Complex Gateway is associated with a conditional expression. . If the “Abort Pending Flows” flag shown in Error! Reference source not found. is checked, the outstanding incoming sequence flows are aborted and activities such as outstanding human tasks are aborted. A special data object –activationCount - is associatedwith a complex gateway and may be used in the condition along with other data objects. The activationCountindicates the number of incoming sequence flows that have been activated.The1.3.4 Testing the processGo to Oracle Enterprise Manager (Oracle EM) and use the Test Web Service option to supply inputvalues for triggering the process instance. Log in as “cdoyle” (Credit Agency) and select the Approveaction for the check credit step. Log in as “jcooper” (DMV) and select the action for check Driver’slicense step. You will notice that the check criminal record – task item is withdrawn and theGateway completes.。

ORACLE DATA SHEETORACLE DATA SHEETContact UsFor more information about Oracle Identity Management, visit or call +1.800.ORACLE1 to speak to an Oracle representative.Copyright © 2011, 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 subjectto 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 notbe 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.AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. 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. UNIX is a registered trademark licensed through X/Open Company, Ltd. 1010。

Oracle® Enterprise Performance Management SystemReadmeRelease 11.2.1.0.000F21647-04May 2020Oracle Enterprise Performance ManagementSystem 11.2.1.0.000 Installation andConfiguration ReadmeRelated Topics•Purpose•Scope of this Release•New Features in This Release•Upcoming Changes•Installation Information•Supported Platforms•Supported Languages•Supported Paths to this Release•Compatibility•Defects Fixed•Known Issues•Tips and Troubleshooting•Documentation UpdatesPurposeThis document includes important, late-breaking information about this release ofOracle Enterprise Performance Management System. Review this Readme thoroughlybefore installing EPM System.Scope of this ReleaseOracle Enterprise Performance Management System Release 11.2.x offers thesebenefits:•Delivers updated technology, including Fusion Middleware (FMW) 12g.•Includes updated platform certifications.•Streamlines and simplifies the architecture, updating the underlying technology stack.•Provides a simplified repository configuration to streamline infrastructure and architecture for the future.•Premier Support is provided through at least 2030.Release 11.2.x doesn't support the following features and products:•Vertical scaling. Vertical scaling is not supported in Release 11.2 except for when using the standard deployment process.•Oracle Hyperion EPM Architect isn't available in EPM System Release 11.2. If you're migrating to EPM System Release 11.2 and have Oracle Essbase, Oracle Hyperion Planning, Oracle Hyperion Profitability and Cost Management, or Oracle Hyperion Financial Management metadata in Performance Management Architect Release 11.1.2.4, you can migrate the metadata out of Performance Management Architect Release 11.1.2.4 into Oracle Data Relationship Management Release11.2. See Oracle Data Relationship Management Integrating Oracle DataRelationship Management Suite with Enterprise Performance Management.•Simplified Interface•Smart Push isn't supported in this release. If you used Smart Push in Release11.1.2.4, when you upgrade to 11.2, you can no longer use Smart Push.•Oracle Hyperion Strategic Finance•Oracle Crystal Ball (replaced by Predictive Planning)•Oracle Enterprise Performance Management Mobile•Offline Planning•Oracle Hyperion Workforce Planning•Oracle Hyperion Capital Asset Planning•Oracle Project Financial Planning•Oracle Hyperion Public Sector Planning and Budgeting•Financial Management Analytics•Quantitative Management and Reporting for Solvency•Oracle Essbase Studio Console•Disclosure Management•Oracle Hyperion Performance Scorecard•Hyperion BI Plus. You can’t migrate Release 11.1.2.4 reports that used Essbase as a data source to Release 11.2. In Release 11.2, Oracle Hyperion Financial Reporting, which is now a component of Hyperion Financial Applications,continues to support connections to a Planning data source using an Essbase connection, as well as Profitability and Cost Management.•Oracle Hyperion Financial Close Management Release 11.2 doesn't support the following features.–The ability to configure a content management system for Financial Close Management–Financial Management integrations–Event monitoring, automated integrations, and end-user integrations requiring integrated parameters•Oracle Essbase Analytics Link. If you used Oracle Essbase Analytics Link11.1.2.2.500 with Oracle Hyperion Financial Management 11.1.2.4, you cancontinue to use it with Oracle Hyperion Financial Management 11.2.x and Oracle Hyperion Tax Provision 11.2.x. Log on to My Oracle Support, search for and read Knowledge Document 2562089.1.New Features in This ReleaseRelated Topics•About the New Features in this Release•New Features in Release 11.2.1.0.000About the New Features in this ReleaseThis section includes new features in Release 11.2.1. To review the list of new features from earlier releases, use the Cumulative Feature Overview tool. This tool enables you to identify the products you own and your current implementation release. With a single click, the tool quickly produces a customized report of new feature descriptions. This tool is available here:https:///pls/apex/f?p=20620:1:0New Features in Release 11.2.1.0.000•Oracle Enterprise Performance Management System Release 11.2.1.0.000 adds support for Google Chrome web browser, Microsoft Edge web browser, andWindows Server 2016. Check the Oracle Enterprise Performance Management System Certification Matrix for all platform requirements.•EPM System Installer has a new installation type—Apply Update. Use Apply Update to move from EPM System Release 11.2.0 to 11.2.1. See Applying an Update to EPM System Products.Note that files are listed on Oracle Software Delivery Cloud as 11.2.0.0.0 (for example Oracle Enterprise Performance Management System - Part 1 11.2.0.0.0) but the downloaded ZIP files contain Release 11.2.1 files.Upcoming ChangesInternet Explorer Browser SupportFor Internet Explorer Browser users, Microsoft recommends using the new Microsoft Edge as your default browser. With this guidance in mind, EPM System will no longer support Internet Explorer starting with release 11.2.2.0.000. If you have any questions regarding de-support, please create a Service Request. For additional guidance on Internet Explorer Lifecycle, contact Microsoft.Installation InformationLate-breaking information about the installation of EPM System products is provided in this readme. Review this information thoroughly before installing EPM System products.Complete instructions for installing this release are in the Oracle Enterprise Performance Management System Installation and Configuration Guide.Supported PlatformsRelated Topics•About Supported Platforms•Browser SupportAbout Supported PlatformsInformation about system requirements and supported platforms for Oracle Enterprise Performance Management System products is available in spreadsheet format in the Oracle Enterprise Performance Management System Certification Matrix. This matrix is posted on the Supported Platforms Matrices page on Oracle Technology Network (OTN):https:///middleware/technologies/bi-foundation/hyperion-supported-platforms.htmlBrowser SupportEPM System does not have a browser version dependency; however, it is possible that the products that EPM System works with do have dependencies.Check the Oracle Enterprise Performance Management System Certification Matrix and specific product readmes for any additional browser support requirements.The matrix is posted on the Supported Platforms Matrices page on OTN:https:///middleware/technologies/bi-foundation/hyperion-supported-platforms.htmlSupported LanguagesInformation about supported languages for Oracle Enterprise Performance Management System products is available in spreadsheet format on the Translation Support tab in the Oracle Enterprise Performance Management System Certification Matrix. This is posted on the Supported System Configurations page on OTN: https:///middleware/technologies/bi-foundation/hyperion-supported-platforms.htmlSupported Paths to this Release•Release 11.1.2.4. You can upgrade Oracle Enterprise Performance Management System Release 11.1.2.4 products to Release 11.2.x. To update your existing applications, you deploy EPM System Release 11.2.x software on a new machine and then migrate EPM System Release 11.1.2.4.xxx artifacts (such asapplications, metadata, and security) and data to the new deployment. SeeUpgrading EPM System in the Oracle® Enterprise Performance Management System Installation and Configuration Guide.•Release 11.2.0. To move from EPM System Release 11.2.0 to 11.2.1, use the Apply Update option in EPM System Installer. See Applying an Update to EPM System Products in the Oracle® Enterprise Performance Management System Installation and Configuration Guide.CompatibilityEPM System supports the Oracle Enterprise Performance Management System product versions listed in the Release Compatibility tab in the Oracle Enterprise Performance Management System Certification Matrix. This matrix is posted on the Supported Platforms Matrices page on OTN:https:///middleware/technologies/bi-foundation/hyperion-supported-platforms.htmlDefects FixedRelated Topics•Defects Fixed in Release 11.2.1.0.000•Defects Fixed in Release 11.2.0Defects Fixed in Release 11.2.1.0.000Release 11.2.1 fixes the following defect:30619061 - FDMEE deployment fails. When installing products with EPM System Installer, install all products at one time for each machine in the environment. You can't install one or more products first and then install another product later.Defects Fixed in Release 11.2.0Release 11.2.0 includes all defects fixed from any PSE or PSU released after Release 11.1.2.4. See those readmes for the list of defects fixed in each PSE or PSU. Known IssuesRelated Topics•About Known Issues•Known Issues in Release 11.2.1.0.000•Known Issues in Release 11.2.0About Known IssuesThe topics in this section contain the noteworthy known issues of this release. Known Issues in Release 11.2.1.0.000References to Unused Version of Struts 1.2.9 RemainIssue: Release 11.2.1 uses Struts 2.5.20. However:•After installing Oracle Enterprise Performance Management System Release11.2.1, or after upgrading to Release 11.2.1, references to unused Struts 1.2.9remain in the user interface.•After using the Apply Update installation option to update from EPM System Release 11.2.0 to 11.2.1, the Struts 1.2.9 Jar file and references to unused Struts1.2.9 remain in the deployment environment and in the user interface. Solution: EPM System Release 11.2.1 provides a script that deletes the unused Struts Jar file and removes the references to the unused version from the deployment environment and in the user interface.1.After installing and configuring EPM System Release 11.2.1, or after completingthe upgrade process, navigate to epm_oracle_home\common\config\11.1.2.0\fixreferences.bat.unch the following script, providing the appropriate parameters formiddleware_home and domain_home.Fixreferences.bat middleware_home domain_homeFor example:Fixreferences.bat C:\Oracle\Middleware\ C:\Oracle\Middleware\user_projects\domains\EPMsystemApply Update and Silent InstallationIssue: The Apply Update installation option in EPM System Installer does not work using silent installation.Additionally, see Known Issues in Release 11.2.0, which also applies to Release 11.2.1.0.000.Known Issues in Release 11.2.0Web Server Configuration Task for Oracle HTTP Server (OHS) FailsIssue:Installation of Oracle HTTP Server (OHS) fails without giving an error. Then, when configuring with EPM System Configurator, the Web Server configuration task for Oracle HTTP Server (OHS) fails.Solution:After downloading files from EDelivery, extract EPM files to a folder that is nested at least one level under another folder.•For example, configuration fails if files are extracted to \epm_install_files and OHS installation is performed from a Shared Drive mapped to this location.•Configuration succeeds if files are extracted to \epm_install_files \windows64 and OHS installation is performed from a Shared Drive mapped to \epm_install_files. During installation, open this shared drive, then open the folder windows64 and run installation.Changing Database DetailsIssue:You can't change database details for Oracle Enterprise Performance Management System and RCU databases after configuration.Using IIS as the Web ServerIssue:Using IIS as the Web Server does not work.Starting Administration Services ConsoleIssue:When you try to start Oracle Essbase Administration Services Console, you get an error message: “Windows cannot find \Java\jre6\bin\javaw.exe "Solution:Before starting Administration Services Console, edit admincon.bat and change the JAVA_HOME value to JDK 1.8. (The default location for JDK 1.8 installed with EPM System is C:\Oracle\Middleware\jdk1.8.0_181.)Tips and TroubleshootingTips and troubleshooting topics are listed in the Installation and Configuration Troubleshooting Guide.All Oracle Enterprise Performance Management System 11.2.0 guides are available in the library on the Oracle Help Center: https:///en/applications/?tab=8. Documentation UpdatesRelated Topics•Accessing EPM System Product DocumentationAccessing EPM System Product DocumentationFind the latest Oracle Enterprise Performance Management System product guides in the Oracle Help Center (https:///en/). To access documents to view or download, click the Applications icon. In the Applications Documentation window,select the Enterprise Performance Management tab, and then look for your release in the Enterprise Performance Management list.You can also find deployment-related documentation on the Oracle Technology Network (/technetwork/index.html) and on the Oracle Software Delivery Cloud website (/EPD/WelcomePage/get_form). Oracle® Enterprise Performance Management System ReadmeF21647-04Copyright © 2020, 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 embedded, installed or activated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government end users are "commercial computer software" or “commercial computer software documentation” pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in the applicable contract. The terms governing the U.S. Government’s use of Oracle cloud services are defined by the applicable contract for such services. 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 Inside 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, Epyc, and the AMD 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.For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at /pls/topic/lookup?ctx=acc&id=docacc.Access to Oracle SupportOracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit /pls/topic/ lookup?ctx=acc&id=info or visit /pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.Toprovidefeedbackonthisdocumentation,*******************************,or,inanOracleHelpCentertopic,clicktheFeedbackbuttonlocatedbeneaththeTableof Contents (you may need to scroll down to see the button).Follow EPM Information Development on these social media sites:LinkedIn - /groups?gid=3127051&goback=.gmp_3127051Twitter - /hyperionepminfoFacebook - /pages/Hyperion-EPM-Info/102682103112642YouTube - https:///oracleepminthecloud。

Version 11.0Repository Guide Oracle ATGOne Main StreetCambridge, MA 02142USARepository GuideProduct version: 11.0Release date: 01-10-14Document identifier: AtgRepositoryGuide1402071827Copyright © 1997, 2014 Oracle and/or its affiliates. All rights reserved.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.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, 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 on 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. 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.For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at /pls/ topic/lookup?ctx=acc&id=docacc.Access to Oracle Support: Oracle customers have access to electronic support through My Oracle Support. For information, visit http:// /pls/topic/lookup?ctx=acc&id=info or visit /pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.Table of Contents1. Introduction (1)2. Repository API (3)Repository Architecture (4)Repository Items (4)Item Descriptors (5)MutableRepository (6)Core Repository API Elements (6)atg.repository.Repository (7)atg.repository.RepositoryView (7)atg.repository.RepositoryItem (8)atg.repository.MutableRepository (8)atg.repository.PropertiesChangedEvent (10)Cloning Repository Items (11)3. Repository Queries (13)Repository Query API (13)atg.repository.QueryBuilder (13)atg.repository.QueryOptions (14)Repository Query Examples (15)Repository Queries in the ATG Control Center (17)Repository Query Language (18)RQL Overview (18)Comparison Queries (19)Text Comparison Queries (19)Date and Timestamp Queries (20)Property of Property Queries (20)Logical Operators (20)Multi-Valued Property Queries (20)INCLUDES ITEM (21)IS NULL (21)COUNT (21)ALL (22)PROPERTY HINT (22)Full Text Search Queries (22)ID-based Queries (22)ORDER BY (23)RANGE (23)Parameters in Queries (24)Parameterized Field Queries (24)RQL Examples (25)RQL Grammar (25)4. SQL Repository Overview (27)5. SQL Repository Architecture (29)Repositories and Transactions (29)Managing Transactions (30)Repository Definition Files (31)Default Values and XML File Combination (32)SQL Repository Items (32)SQL Repository Item Descriptors (33)6. SQL Repository Data Models (35)Primary and Auxiliary Tables (35)id Property (35)Repository Guide iiiCompound Repository IDs (36)IdSpaces and the id Property (37)Database Sequences and Repository IDs (38)Auxiliary Tables (38)References Constraints (39)Properties and Database Columns (39)One-to-Many Relationships: Multi-Valued Properties (40)Operating on Multi-Valued Properties (42)Many-to-Many Relationships (42)Default Item Descriptor (43)Cascading Data Relationships (43)Cascade Insert (43)Cascade Update (44)Cascade Delete (44)Cascade Example (45)Item Descriptor Inheritance (46)Benefits of Item Descriptor Inheritance (47)Queries and Item Descriptor Inheritance (49)Item Descriptor Inheritance with the copy-from Attribute (49)Limitations of SQL Repository Inheritance (49)Derived Properties (50)Derivation Syntax (50)Override Properties (52)Properties Derived from the Same Item (52)Complex Derivations (52)Derivation Methods (53)Repository Items and Session Backup (56)7. SQL Repository Item Properties (59)Enumerated Properties (59)enumerated (60)enumerated String (61)Required Properties (62)Unique Properties (63)Date and Timestamp Properties (63)Last-Modified Properties (63)Null Properties (64)Grouping and Sorting Properties (64)Property Validation with a Property Editor Class (65)Maintaining Item Concurrency with the Version Property (66)Repository Items as Properties (67)Multiple Item Properties (68)Adding an Item to a Multi-Item Property (69)Querying Subproperties (70)Transient Properties (70)Assigning FeatureDescriptorValues with the <attribute> Tag (70)Attributes Used in the ACC (71)Linking between Repositories (72)SQL Types and Repository Data Types (72)User-Defined Property Types (73)Identifying a User-Defined Property Type (74)Using the property-type Attribute (74)Implementing a User-Defined Property Type (74)Property Conversion Methods (76)iv Repository GuideNull Values in User-Defined Property Types (76)User-Defined Properties and the ACC (76)User-Defined Property Type Examples (77)Property Fetching (79)Handling Large Database Columns (80)8. SQL Repository Queries (81)Repository Filtering (81)<rql-filter> (82)filterQuery and rqlFilterString Properties (83)Overriding RQL-Generated SQL (83)Parameterized Queries (84)Parameterized Query API (84)Query Types that Support Parameters (85)QueryCache and Parameterized Queries (85)Parameterized Query Example (85)Named Queries (87)Named Queries in an SQL Repository Definition File (87)Java Code Access to Named Queries (90)Text Search Queries (92)Simulating Text Search Queries (94)Wildcards in Queries (94)Not Queries and Null Values (95)Outer Joins (95)Table Ownership Issues (96)Constraints (97)Setting Ownership at the Repository Level (97)Unsupported Queries in the SQL Repository (97)9. Localizing SQL Repository Definitions (99)Defining a Resource Bundle (99)Localizing Properties (100)Localizing Enumerated Properties (100)10. SQL Repository Caching (103)Item and Query Caches (103)Item Caches (104)Query Caches (104)Caching Modes (104)Setting Caching Mode (105)Disabling Caching (105)Inherited Caching Modes (106)Simple Caching (106)Locked Caching (106)Prerequisites (106)ClientLockManager Component (107)ServerLockManager Component (107)Processing Lock Requests (109)Isolation Levels (110)Locking Exceptions (111)Resolving Lock Contention (111)Monitoring Lock Managers (112)Locking Scenarios and Workflows (113)Distributed Caching Modes (114)Simple versus Distributed Caching (114)Distributed Caching Mode Options (114)Repository Guide vDistributed TCP Caching (115)Distributed TCP Caching Setup (116)Restoring Subscriber Data (117)Invalidating Cached Items (117)Disabling Automatic Updates to das_gsa_subscriber (117)Distributed JMS Caching (118)Distributed JMS Caching Setup (118)Distributed Hybrid Caching (119)Distributed Hybrid Caching Setup (120)Distributed Hybrid Caching Initialization (123)Optimizing Performance (123)Monitoring Cache Manager Activity (124)Distributed External Caching (124)Cache Configuration (124)Query Cache Tuning (126)Item Cache Tuning: ATG Commerce (126)Cache Timeout (126)Monitoring Cache Usage (127)Weak Cache Hashtable (128)Caching by Repository IDs (129)Restoring Item Caches (129)Preloading Caches (130)Enabling Lazy Loading (131)Lazy Loading Settings (132)Integration with Batch Loading (133)Using Preloading Hints in Lazy-Loaded Queries (133)Cache Flushing (134)Flushing All Repository Caches (134)Flushing Item Caches (135)Flushing Query Caches (136)Cache Invalidation Service (136)Enabling the Cache Invalidator (136)Invoke the Cache Invalidator Manually (136)Use the Cache Invalidator with Distributed JMS Caching (137)11. External SQL Repository Caching (139)Choosing Repository Items for External Caching (139)Configuring Repository Items for External Caching (139)Cache Locality (140)Cache Modes for External Caching (141)External Caching and Cache Invalidation (142)External Caching and Cache Warming (142)External Cache Naming (143)External Caching Statistics (144)Batch Mode for External Caching (145)Enabling Batch Mode for External Caching (145)Repository Configuration for Batch Mode (146)12. Developing and Testing an SQL Repository (147)Adding Items (147)Adding Items with Composite IDs (148)Adding Items without Specifying IDs (148)Adding Items to Multi-Item Properties (149)Updating Items (149)Removing Items (150)vi Repository GuideRemoving References to Items (150)Querying Items (151)Importing and Exporting Items and DDLs (151)startSQLRepository (151)Requirements (152)Syntax (152)Exporting Repository Data (155)Importing Repository Data (155)Importing to a Versioned Repository (156)SQL Repository Test Example (157)Using Operation Tags in the Repository Administration Interface (158)Debug Levels (159)Modifying a Repository Definition (159)13. SQL Repository Reference (161)SQL Repository Definition Tag Reference (161)<!DOCTYTPE> (162)<gsa-template> (162)<header> (162)<item-descriptor> (163)<property> (168)<derivation> (173)<option> (173)<attribute> (174)<table> (175)<expression> (176)<rql-filter> (176)<named-query> (177)<rql-query> (177)<rql> (177)<param> (177)<sql-query> (177)<sql> (177)<input-parameter-types> (178)<returns> (178)<dependencies> (178)<transaction> (178)<rollback-transaction> (179)<add-item> (179)<update-item> (180)<remove-item> (180)<remove-all-items> (181)<query-items> (181)<print-item> (182)<set-property> (183)<import-items> (183)<export-items> (184)<load-items> (184)<dump-caches> (185)<print-ddl> (186)DTD for SQL Repository Definition Files (186)Sample SQL Repository Definition Files (192)Simple One-to-One (193)One-to-One with Auxiliary Table (194)Repository Guide viiOne-to-Many with an Array (195)One-to-Many with a Set (196)One-to-Many with a Map (197)One-to-Many Mapping to Other Repository Items (198)Ordered One-to-Many (199)Many-to-Many (200)Multi-Column Repository IDs (201)Configuring the SQL Repository Component (203)Registering a Content Repository (203)SQL Repository Component Properties (204)14. SQL Content Repositories (213)Setting Up an SQL Content Repository (213)Creating an SQL Content Repository Definition (214)Folder and Content Item Descriptors (214)Path and Item ID Attributes (215)Defining Content Item Descriptors (217)Content Attributes and Properties (217)Storing Content on a File System (218)Content Repository Example (218)Book Item Type Properties (219)Locating the Content with Path and Folder Properties (219)Book Example Repository Definition File (220)Book Example SQL Table Creation Statements (220)Adding Content to the Content Repository (221)Accessing Items in the Content Repository (221)Configuring an SQL Content Repository (222)15. Repository Loader (223)Repository Loader Architecture (223)Repository Loader Components (224)FileSystemMonitorScheduler (225)FileSystemMonitorService (225)LoaderManager (227)TypeMapper and TypeMappings (229)ContentHandlers (232)Repository Loader Administration (233)RLClient (234)Supplemental RLClient Parameters (234)Repository Loader Manifest (235)Manifest File Tags and Attributes (236)Importing Versioned Repository Data (236)Configuring the VersionedLoaderEventListener (237)Importing Targeters that Reference rules Files (240)Configuring TypeMapping Components for the PublishingFileRepository (241)Repository Loader Example (241)User Item Type (242)Item Pathnames (243)Type Mappings and Content Handlers (244)TypeMapper (244)xml2repository Schemas (245)Running the Repository Loader Example (245)16. Purging Repository Items (247)Selecting Repository Items (248)Related Conditions and Actions (249)viii Repository GuidePurge Statistics (249)Scheduling a Purge Operation (251)Stopping a Purge Operation (252)Asset Purge Error Handling (252)Throttling and Performance (252)Configuring Throttle Settings for an Asset Purge Function (252)Configuring the Thread Count for an Asset Purge Function (253)Using the Profile Asset Purge Function (253)Creating and Configuring an Asset Purge Function (254)Asset Purge Process Overview (255)Configuring Asset Condition Components (256)Configuring Related Condition Components (257)Configuring Related Action Components (260)Configuring Basic Purging Components (264)Configuring Additional Processing Components (267)Configuring the Asset Purge Pipeline (267)Configuring the Asset Purge User Interface (270)17. Repository Web Services (271)GetRepositoryItem Web Service (271)PerformRQLQuery Web Service (274)PerformRQLCountQuery Web Service (275)Repository Web Service Security (277)18. Composite Repositories (279)Use Example (279)Primary and Contributing Item Descriptors (279)Item Inheritance and Composite Repositories (280)Transient Properties and Composite Repositories (280)Non-Serializable Items and Composite Repositories (280)Property Derivation (281)Configuring a Composite Repository (281)Property Mappings (281)Excluding Properties (282)Link Methods (282)Creating Composite and Contributing Items (283)Missing Contributing Items (283)Configuring the Composite Repository Component (284)Composite Repository Queries (284)Composite Repository Caching (285)Composite Repository Definition Tag Reference (285)<composite-repository-template> (285)<header> (composite repository) (285)<item-descriptor> composite repository (286)<primary-item-descriptor> (287)<contributing-item-descriptor> (288)<attribute> composite repository (288)<property> composite repository (289)<primary-item-descriptor-link> (290)<link-via-id> (291)<link-via-property> (292)DTD for Composite Repository Definition Files (292)Sample Composite Repository Definition File (294)19. Secured Repositories (299)Features and Architecture (299)Repository Guide ixCreating a Secured Repository (301)Modify the Underlying Repository (301)Configure the Secured Repository Adapter Component (302)Register the Secured Repository Adapter Component (303)Create the Secured Repository Definition File (304)Secured Repository Example (305)Modify the SQL for the Repository Data Store (305)Modify the XML definition file (306)Define the Secured Repository Adapter’s Definition File (307)Configure a Secured Repository Adapter Component (308)Register the Repositories (309)ACL Syntax (309)Standard Access Rights (310)ACL Examples (310)Secured Repository Definition File Tag Reference (311)<secured-repository-template> (311)<item-descriptor> secured repository (311)<property> secured repository (312)<default-acl> (312)<descriptor-acl> (312)<owner-property> (313)<acl-property> (313)<creation-base-acl> (313)<creation-owner-acl-template> (314)<creation-group-acl-template> (314)DTD for Secured Repository Definition File (315)Performance Considerations (317)Exceptions Thrown by the Secured Repository (318)20. LDAP Repositories (319)Overview: Setting Up an LDAP Repository (320)LDAP Directory Primer (320)Hierarchical Tree Structure (321)LDAP Data Representation (321)Hierarchical Entry Types (322)Directory Schema (322)LDAP and JNDI (324)LDAP Sources (324)LDAP Repository Architecture (324)LDAP Repository Items and Repository IDs (325)Item Descriptors and LDAP Object Classes (325)Item Descriptor Hierarchies and Inheritance (327)Id and ObjectClasses Properties (328)Additional Property Tag Attributes (329)New Item Creation (330)Repository Views in the LDAP Repository (331)Repository View Definition (331)LDAP Repository View Example (332)LDAP Repository Queries (333)ID Matching Queries (333)Unsupported Queries in the LDAP Repository (334)Configuring LDAP Repository Components (334)/atg/adapter/ldap/LDAPRepository (335)/atg/adapter/ldap/InitialContextPool (336)x Repository Guide/atg/adapter/ldap/InitialContextEnvironment (337)/atg/adapter/ldap/LDAPItemCache (339)/atg/adapter/ldap/LDAPItemCacheAdapter (339)/atg/adapter/ldap/LDAPQueryCache (339)/atg/adapter/ldap/LDAPQueryCacheAdapter (340)LDAP Password Encryption (340)LDAP Repository Definition Tag Reference (341)<!DOCTYPE>LDAP repository (341)<ldap-adapter-template> (342)<header>LDAP repository (342)<view> (342)<item-descriptor>LDAP repository (342)<id-property> (343)<object-classes-property> (344)<object-class> (345)<property>LDAP repository (345)<option>LDAP repository (347)<attribute>LDAP repository (347)<child-property> (348)<new-items> (349)<search-root> (350)Sample LDAP Repository Definition File (351)DTD for LDAP Repository Definition Files (352)Index (355)Repository Guide xixii Repository Guide1 Introduction 11IntroductionData access is a large part of most Internet applications. Oracle ATG Web Commerce Data Anywhere Architecture™ provides a unified view of content and data across a business for organizations and their customers. The core of the Oracle ATG Web Commerce Data Anywhere Architecture is the Repository API.Through the Repository API, you can employ a single approach to accessing disparate data types, including SQL databases, LDAP directories, content management systems, and file systems.With the Oracle ATG Web Commerce Data Anywhere, the application logic created by developers uses the same approach to interact with data regardless of the source of that data. One of the most powerful aspects of this architecture is that the source of the data is hidden behind the Oracle ATG Web Commerce Repository abstraction. It is easy to change from a relational data source to an LDAP directory as none of the application logic needs to change. After data is retrieved from a data source, it is transformed into an object-oriented representation. Manipulation of the data can be done using simple getPropertyValue and setPropertyValue methods. The Repository API ties in closely with Oracle ATG Web Commerce’s targeting APIs, so you can retrieve items from the repository based on a variety of targeting rules, as well as retrieving specific identified items.The figure below provides a high-level overview of the Oracle ATG Web Commerce Data Anywhere Architecture.Oracle ATG Web Commerce Data Anywhere Architecture offers several advantages over the standard data access methods such as Java Data Objects (JDO), Enterprise JavaBeans (EJB), and Java Database Connectivity (JDBC).Among the differences:Data source independenceOracle ATG Web Commerce Data Anywhere Architecture provides access to relational database managementsystems, LDAP directories, and file systems using the same interfaces. This insulates application developersfrom schema changes and also storage mechanism. Data can even move from a relational database to an LDAPdirectory without requiring recoding. Java Data Objects support data source independence, but it is up tovendors to provide an LDAP implementation.Fewer lines of Java codeLess code leads to faster time-to-market and reduced maintenance cost. Persistent data types created withOracle ATG Web Commerce Data Anywhere are described in an XML file, with no Java code required.Unified view of all customer interactionsA unified view of customer data (gathered by web applications, call center applications, and ERP systems) can beprovided without copying data into a central data source. This unified view of customer data leads to a coherentand consistent customer experience.Maximum performanceIntelligent caching of data objects ensures excellent performance and timely, accurate results. The JDO and EJBstandards rely on a vendor implementation of caching that might not be available.Simplified transactional controlThe key to overall system performance is minimizing the impact of transactions while maintaining the integrityof your data. In addition to full Java Transaction API (JTA) support, Oracle ATG Web Commerce Data Anywherelets both page developers and software engineers control the scope of transactions with the same transactionalmodes—required, supports, never—used by EJB deployment engineers.Fine-grained access controlYou can control who has access to which data at the data type, data object, even down to the individualproperty with Access Control Lists (ACLs).Integration with ATG product suitesOracle ATG Web Commerce personalization, scenarios, commerce, portal, and content administrationapplications all make use of repositories for data access. A development team is free to use EJBs along sideof Oracle ATG Web Commerce technology, but the easiest way to leverage investment in Oracle ATG WebCommerce technology is to follow the example set by the solution sets. The Oracle ATG Web Commerce solutionsets satisfy all their data access needs with repositories.2 1 Introduction2Repository APIThe Oracle ATG Web Commerce Repository API (atg.repository.*) is the foundation of persistent objectstorage, user profiling, and content targeting in Oracle ATG Web Commerce products. A repository is a dataaccess layer that defines a generic representation of a data store. Application developers use this genericrepresentation to access data by using only interfaces such as Repository and RepositoryItem. Repositoriesaccess the underlying data storage device through a connector, which translates the request into whatever callsare needed to access that particular data store. Connectors for relational databases and LDAP directories areprovided out-of-the-box. Connectors use an open, published interface, so additional custom connectors can beadded if necessary.Developers use repositories to create, query, modify, and remove repository items. A repository item is likea JavaBean, but its properties are determined dynamically at runtime. From the developer’s perspective, theavailable properties in a particular repository item depend on the type of item they are working with. One itemmight represent the user profile (name, address, phone number), while another might represent the meta-dataassociated with a news article (author, keywords, synopsis).The purpose of the Repository interface system is to provide a unified perspective for data access. For example,developers can use targeting rules with the same syntax to find people or content.Applications that use only the Repository interfaces to access data can interface to any number of back-end datastores solely through configuration. Developers do not need to write a single interface or Java class to add a newpersistent data type to an applicationEach repository connects to a single data store, but multiple repositories can coexist within Oracle ATG WebCommerce products, where various applications and subsystems use different repositories or share the samerepository. Applications that use only the Repository API to access data can interface to any number of back-end data stores solely through configuration. For example, the security system can be directed to maintainits list of usernames and passwords in an SQL database by pointing the security system at an SQL repository.Later, the security system can be changed to use an LDAP directory by reconfiguring it to point to an LDAPrepository. Which repositories you use depends on the data access needs of your application, including thepossible requirement to access data in a legacy data store.The Oracle ATG Web Commerce platform includes the following models for repositories:•SQL repositories use Oracle ATG Web Commerce’s Generic SQL Adapter (GSA) connector to map betweenOracle ATG Web Commerce and the data in an SQL database. You can use an SQL repository to access content,user profiles, application security information, and more.•SQL profile repository, included in the Oracle ATG Web Commerce Personalization module, uses the GenericSQL Adapter connector to map user data that is contained in an SQL database. See the PersonalizationProgramming Guide.•LDAP Repositories (page 319) use the Oracle ATG Web Commerce LDAP connector to access user data in anLDAP directory. See the LDAP Repositories (page 319) chapter.•Composite Repositories (page 279) let you use multiple data stores as sources for a single repository.2 Repository API3。

Oracle 11g 日常维护手册目录第1章文档说明 (5)第2章CRS的管理 (5)2.1 RAC状态检查 (5)检查守护进程状态 (5)检查资源状态 (5)2.2 手工启动与关闭RAC (6)2.3 OCR的管理 (6)2.4 VOTING DISK的管理 (8)2.5 CSS管理 (9)2.6 管理工具SRVCTL (9)管理实例 (9)管理监听程序 (9)管理ASM (10)管理service (10)2.7 修改RAC的IP及VIP (11)修改外网IP及心跳IP (11)修改VIP (11)查看与删除IP (12)第3章ASM的管理 (13)3.1 管理DG (13)建立与扩充disk group (13)mount与unmount的吩咐 (14)删除disk group (14)增加DISK的total_mb (14)DG的属性－AU大小 (14)DG的属性－离线删除时间 (15)DG的属性－兼容版本 (15)向ASM中添加disk的完整步骤 (16)3.2 ASMCMD (17)ASMCMD常用吩咐 (17)复制ASM文件 (18)吩咐lsdg (18)元数据备份与复原 (18)3.3 ASM磁盘头信息备份与复原 (19)3.4 ASM常用视图 (20)视图V$ASM_DISKGROUP (20)视图V$ASM_DISK (21)3.5 常用方法 (22)如何确定ASM实例的编号 (22)查询DG－RAW－磁盘的对应关系 (22)第4章数据库管理 (24)4.1 参数文件管理 (24)4.2 表空间管理 (25)表空间自动扩张 (25)表空间更名 (26)表空间的数据文件更名 (26)缺省表空间 (26)表空间删除 (27)UNDO表空间 (27)TEMP表空间 (27)4.3 重做日志文件管理 (27)增加REDO日志组 (27)删除日志组 (28)日志切换 (28)日志清理 (28)重做日志切换次数查询 (28)4.4 归档模式 (29)单实例数据库修改为归档模式的方法 (29)RAC数据库修改为归档模式的方法 (29)归档路径 (30)4.5 重建限制文件 (31)4.6 内存参数管理 (32)Oracle内存管理发展阶段 (32)自动内存管理AMM (32)自动共享内存管理ASMM (33)自动PGA管理 (33)4.7 其他管理内容 (33)数据库版本查看 (33)字符集 (34)创建密码文件 (34)关闭审计功能 (34)帐号管理 (34)profile管理 (35)第1章文档说明本文档描述了Oracle11g中常见的维护和管理方法，包括CRS、ASM、数据库等。

Oracle Database 11g EditionsThe World's #1 Database Tailored to Meet Your NeedsWhether you're a lone developer, a midsize business, or large corporate enterprise, there's anedition of the world's #1 database to meet your business and technical requirements:∙Oracle Database 11gEnterprise Edition provides industry-leading performance, scalability, security, and reliability on a choice of clustered or single-servers with a widerange of optionsto meet user needs.∙Oracle Database 11g Standard Editionis an affordable, full-featured database for servers with up to four sockets. It allows you to save money by buying only what you need today, andthen scale out with Oracle Real Application Clustersas demand grows.∙ Oracle Database 11gStandard Edition One allows you to get started with small, two socket implementations at only $180 per user (5 user minimum).∙ Oracle Database 10g Express Edition is an entry-level, small-footprint database that is free to develop, deploy, and distribute.All editions are built using the same common code base, which means your databaseapplications can easily scale from small, single-processor servers to clusters of multi-processor servers without changing a line of code. Compare features below.Key Feature SummaryExpress Edition 10gStandard Edition One Standard EditionEnterprise EditionMaximum 1 CPU 2 Sockets 4 Sockets No Limit RAM1GB OS Max OS Max OS Max Database Size 4GBNo LimitNo LimitNo LimitWindows Linux Unix64 Bit SupportHigh Availability Read MoreActive Data GuardEnhances disaster protection investments by offloading resource intensive operations to a single physical standby database, enhancing overall quality of service. ReadOptionMoreFail SafeConfigure, verify Windows clusters andautomatically fail over fast and accuratelythrough high availability software integratedwith Microsoft Cluster Server. Read MoreFlashback QueryRecover older versions of data without complex, time-consuming operations. Read MoreFlashback Table, Database and Transaction QueryDiagnose and undo errors to reduce recovery time. Read MoreOracle Secure BackupSecure, high performance tape backup management for the Oracle Database and heterogenous file systems reducing the cost and complexity of networked data protection. Read MoreOracle Secure Backup is its own product that workswith each database editionServer Managed Backup and RecoverySimplify, automate, and improve backup and recovery performance with Oracle Recovery Manager (RMAN). Read MoreScalability Read MoreReal Application ClustersRun any packaged or custom application unchanged across multiple connected, or "clustered," servers. Read MoreOptionReal Application Clusters One NodeOracle RAC One Node is the one-node version of Oracle RAC which enables customers to standardize on a single deployment model for all their database needs. Read MoreOptionIntegrated ClusterwareBuilt-in clustering services to protect anyOracle application or any other kind of application within a cluster.Automatic Workload ManagementRoute service connection requests to appropriate server with lowest load; on failure, automatically reallocate surviving servers to services.Java, PL/SQL Native CompilationWrite stored procedures deployed in the database in both Java and PL/SQL.PL/SQL onlyIn-Memory Database CacheIncreases responsiveness and throughput by caching frequently used data in memory. Read MoreOptionSecurity Read MoreOracle Database VaultRestricts super-user and privileged-user access across applications and data. Read MoreOptionOracle Audit VaultAutomates the collection and analysis of audit data from multiple systems, turning audit data into a key security resource. Read MoreOracle Audit Vault is its own product that works witheach database editionOracle Advanced SecurityAddress privacy and compliance requirements. Read MoreOptionOracle Label SecurityProvides out-of-the-box row-level security. Compare user security clearances with data classification labels attached to data rows. Read MoreOptionSecure Application RolesEnable roles only after a user passes any number of security checks. Read MoreVirtual Private DatabaseEnforce data security and privacy with customizable, policy-based access control down to the row level. Read MoreFine-Grained AuditingAllows highly focused auditing with almost no 'background noise'.Read MoreProxy AuthenticationDetects and authenticates users connectingthrough a middle-tier application.Data Encryption ToolkitProtect vital data by providing an extra layer of protection for data on storage media. Read MoreApplication Development ReadMoreOracle SQL DeveloperGraphical tool that enhances productivity and simplifies database development tasks. Read MoreApplication ExpressDevelop and deploy fast, secure applications with a rapid web application development tool. Read MoreJava SupportGrid-enable databases through Web Services. Read MoreComprehensive XML SupportStore and retrieve XML natively with support for the W3C XML data model; use standard access methods for navigating and querying XML. Read MorePL/SQL and Java Server PagesUtilize a server-side Java and stored procedural language; secure, portable and seamless with SQL. Read MorePL/SQL onlyComprehensive Microsoft .Net Support, OLE DB, ODBCSupport multiple Windows data access methods. Read MoreManageability Read MoreReal Application TestingOptionReduces risk and costs of adopting new technologies, whether it's operatingsystems, servers, or software.Read MoreEnterprise ManagerManage and monitor all applications and systems based on the Oracle stack via a single, integrated console. Read MoreAutomatic Memory ManagementAutomate management of shared memory used by an Oracle Database instance. Read MoreAutomatic Storage ManagementConsistent storage management interface across all server and storage platforms. Read MoreAutomatic Undo ManagementMonitor configuration of all Oracle systems for parameter settings, security set-up, storage and file space conditions.Data Warehousing Read MoreExadata Database MachineThe Oracle Exadata Database Machine is a complete system, including software, servers, networking and storage designed to run multi-terabyte data warehouses at least 10x faster than conventional data warehouse systems. Read MoreRequires OracleDatabase Enterprise EditionAdvanced CompressionCompresses all types of data, including structured and unstructured data, to help you use resources more efficiently and lower storage costs. Read MoreOptionOLAPUse built-in analytical workspaces for Online Analytical Processing (OLAP). Read MoreOptionPartitioningEnables large tables and indexes to be split into smaller, more manageableOptioncomponents, without requiring changes to underlying applications.Read MoreAdvanced AnalyticsOracle Data Mining and Oracle R Enterprisecomponents extend the database into acomprehensive advanced analytics platformfor big data analytics. Read MoreOptionTransportable Tablespaces, Including Cross-PlatformTransport a set of tablespaces from one database to another, or from one database to itself.Star Query OptimizationJoin a fact table and a number of dimension tables.PL/SQL only Information Lifecycle ManagementUnderstand how data evolves, determine how it grows, monitor how its usage changes and decide how long it should be kept. Read MoreSummary Management - Materialized View Query RewriteAutomatically recognizing materialized view usage to satisfy requests.IntegrationAdvanced QueuingAllow database queues to serve as durable message stores via queue-based publish-subscribe.Distributed Queries/TransactionsQuery or update data on two or more distinct nodes of a distributed database.Content Management Read MoreXML DBHigh-performance, native XML storage and retrieval technology. Read MoreMultimediaDevelop, deploy, and manage traditional, Web, and wireless applications that include rich media in the most-popular formats.TextBuild text query applications and document classification applications. Read MoreLocatorManage geospatial data to leverage the business value of location. Read MoreSpatialSupport for sophisticated GIS deployments. Read MoreOptionSecure Enterprise SearchInternet-like search experience to users searching secure content inside the enterprise while protecting sensitive data from unauthorized users. Read MoreOracle Secure Enterprise Search is its own productthat works with each database edition。

IBM SoftwareIBM Informix software product family: Version 11.7 Discover the next decade of IBM Informix2 IBM Informix software product family: Version 11.7IBM® Informix® database software has been voted number one in customer satisfaction for two consecutive years, 2008 and 2009.1 Clients choose Informix because it is reliable, low-cost and hassle-free. Solution providers choose Informix for its best-of-breed embeddability. And it’s available on Microsoft® Windows®, Linux®, UNIX® and Mac OS X rmix 11.7 ushers in the next decade for Informix. As the engine that powers online transaction processing (OL TP) and decision support applications for businesses and partners of all sizes, it will continue to be a force in helping them to deliver smarter solutions. T ake a look at Informix 11.7 and you’ll discover unprecedented advantages: advanced performance, availability and efficiency, minimal complexity and lower computing costs. With the introduction of Informix Flexible Grid, it’s easy to perform routine maintenance and upgrades at all your geographic locations from a single site—and you can do it with zero downtime.ReliableInformix offers one of the most comprehensive sets ofhigh-availability options available from databases that can run on low-cost hardware, and Informix 11.7 takes that to new heights. With Informix Flexible Grid, you can distribute workloads to maximize your hardware investments while keeping data synchronized at all times, whether the servers are in the same room or on the other side of the world. In the case of a system failure, another server automatically takes over with no impact to your business. Further, Informix Flexible Grid lets you keep data available during planned outages without the need for temporary hardware or for cloning databases or applications. You can also useheterogeneous hardware and operating systems within the same grid. With Informix Flexible Grid, you can scalecapacity when and where needed, bring data on- or off-line, and change your data schema throughout your grid—all from a single location, all on demand and all with no downtime.Highlights• Reliable: Provides one of the industry’s widest sets ofoptions for keeping data available at all times, including zero downtime for maintenance• Low-cost: Cuts development costs by nearly eliminating up-front licensing costs typically incurred during the development phase• Hassle-free: Runs almost unattended with self-configuring, self-managing and self-healing capabilities• Best-of-breed embeddability: Provides a provenembedded data management platform for ISVs and OEMs to deliver integrated, world-class solutions, enabling platform independenceSoftware 3 Low-costInformix offers unparalleled cost-saving benefits by reducingthe up-front licensing costs typically incurred during thedevelopment phase. Businesses also benefit from the ongoingsavings in operational expenses, since Informix autonomicfeatures help eliminate outages and require less performancetuning. The autonomic capabilities can handle many of themanual tasks normally performed by a hands-onadministrator with other relational database management systems (RDBMS).Informix also offers data compression technology that can produce up to 80 percent savings on disk space and I/O improvements of up to 20 percent.2 With less data volumeto process, businesses can achieve faster search times, more efficient use of their hardware resources, and reduced backup and recovery times.Hassle-freeInformix is designed from the ground up for easy, scalable administration and includes features that allow Informix to “disappear” within an application. Thanks to the manyself-monitoring and self-healing features built into Informix, such as automated storage and memory management, the database software can be customized to proactively track and react to business thresholds—and resolve them before they become an issue.Small companies love Informix because they don’t needa large technical staff to run their data processing environment. As companies grow, Informix has them covered: customers with large deployments are able to manage an average of 2,000 Informix databases with a single DBA.3 Informix enables growing businesses to scale and manage their databases no matter where they are, on demand and with no downtime.Best-of-breed embeddabilityMore than 2,500 loyal business partners have established millions of Informix deployments around the world, most of which are never seen by the actual customers. For example, Informix is in thousands of worldwide retailers, 20 of the top 25 U.S. supermarkets and 95 percent of telecom service delivery providers.3 Market innovators such as China Mobile, Verizon, Lazare Kaplan International, DHL Express andT rafficmaster rely on Informix to deliver seamless and superior service to their customers.Informix is available on multiple versions of Windows, Linux, UNIX and Mac operating systems, so OEMs, ISVs and VARs are not locked into a single platform and can pursue more market opportunities. Informix is standards-based and supports a wide variety of integrated development environments (IDEs) and application development languages. The same installer can be used on all platforms and can be easily customized and hidden within an embedded solution. The software’s small footprint and self-managing capabilities make it an ideal choice for embedded data management solutions. Plus, Informix can be up and running in minutes, not days, and requires virtually zero administration.Informix is also widely deployed in virtualized environments, with a profile and feature set that lends itself well to virtualization. Customers can reduce costs through server consolidation and can prepare for moving to a true cloud-computing environment, where additional economies of scale are available when supporting customers in a Service Oriented Architecture (SOA). Want to learn more about how companies of all sizes are taking advantage of Informix? Read these success stories: /software/success/cssdb.nsf/softwareL2VW? OpenView&Count=30&RestrictToCategory=dmmain_Informix DynamicServer4 IBM Informix software product family: Version 11.7Informix: A complete data management solutionWhile Informix is low-cost and hassle-free, it still offers a comprehensive range of data management capabilities. In addition to those already described, Informix offers many other capabilities, such as:• Warehouse and business analytics: Provides strong performance and value as a single platform to address both OL TP and analytical requirements; higher performance for all types of workloads means fewer servers—and less space, power and cooling• Application development options and tools: Enables developers to choose their favorite language or IDE; now available are new or updated drivers for PHP, Ruby and Microsoft .NET, plus other compatibility features that make it easy to port applications to Informix• OpenAdmin Tool: Provides a graphical administration tool to monitor and administer all of your Informix environments from a single console• Native support for advanced data types:Provides enhanced data process functionality, enabling businesses to create richer applications with spatial, time series and geodetic data, as well as other capabilitiesInformix EditionsInformix offers many editions, including no-cost editions and for-purchase editions, to meet a wide variety of enterprise, ISV, VAR and OEM needs.Free EditionsDeveloper Edition: This edition provides all features of Informix for individual application development, testing and proof-of-concepts. Available on a wide variety of platforms, Developer Edition has some processing and storage limitations. Community support is available.Innovator-C Edition: Designed for low-cost embeddedor workgroup computing, the Innovator-C Edition allows small-to-midsize businesses to develop and deploy widely used database functionality, including replication and some clustering capabilities. The Innovator-C Edition is available on a wide variety of platforms and is limited to four cores over a maximum of one socket and 2 GB of memory. Selective Support at Elite Level is available as an optional purchase.For-purchase EditionsChoice Edition for Windows: This edition gives businesses, ISVs and OEMs with Windows-based environments the ability to develop and deploy near enterprise-class functionality at low cost. The Choice Edition is limited to eight cores over a maximum of two sockets and 8 GB of memory.Choice Edition for Mac OS X: This edition has the same functionality as the Choice Edition for Windows, but is available on Mac OS X.Growth Edition: This edition provides powerful data management capabilities for departmental solutions or small-to-midsize businesses, including unlimited replication cluster nodes to send or receive data updates from other nodes in the cluster. This edition supports up to two high-availability cluster nodes of any type. It is limited to 16 cores over a maximum of four sockets and 16 GB of memory. Growth Edition is available on all supported platforms.Ultimate Edition: This edition includes all Informix features on all supported platforms for development, deployment and distribution with unlimited scalability. It includes full grid and replication capabilities. Storage compression is available as an optional feature.Informix supports a vast number of platforms and versionsof operating systems. A complete list can be found online at /support/docview.wss?rs=630&uid=swg27013343&S_CMP=rnavSoftware 5Developer Edition Linux/UNIX/ Windows/Mac Free for one developerlicense; no distributionCommunity Publicdownload• 1 GB memory• 1 CPU• 8 GB storage limitStorage Optimization Featurenot availableInnovator-C Edition Linux/UNIX/ Windows/Mac Free to develop anddeploy (distributionrequires commerciallicense)Optional: SelectedSupport chargedper install/yearPublicdownload• 2 GB memory• 1 socket, total4 coresFeatures unavailable: StorageOptimization Feature, SDS, parallelfeatures, partitioning, AdvancedAccess Control, Informix WarehouseFeature (SQL Warehousing T ool),multiple secondary serversPartially available: 2-node grid;1 primary, 1 secondary server (HDR),ER (2 root nodes)Choice Editionfor Windowsand Choice Edition for Mac OS X Licensing via LU Socket,AUIncludes Supportand Subscriptionin first yearPassportAdvantage• 8 GB memory• 2 sockets, total8 coresFeatures unavailable: StorageOptimization Feature, SDS, parallelfeatures, partitioning, AdvancedAccess Control, Informix WarehouseFeature (SQL Warehousing Tool),multiple secondary serversPartially available: 2-node grid;1 primary, 1 secondary server (HDR,RSS), ER (2 root nodes)Growth Edition Linux/UNIX/ Windows/Mac OS X Licensing via LU Socket,AU, CS, PVUIncludes Supportand Subscriptionin first yearPassportAdvantage• 16 GB memory• 4 sockets, total16 coresFeatures unavailable: StorageOptimization Feature, parallel features,partitioningPartially available: 3-node grid;1 primary, any2 secondary servers(HDR, RSS, SDS), unlimited ER rootand leaf nodesUltimate Edition Linux/UNIX/ Windows/Mac Licensing via AU, CS,PVUIncludes Supportand Subscriptionin first yearPassportAdvantage• Unlimited For-charge feature: StorageOptimization Feature; everythingelse includedNote: AU: Authorized User Single Install; CAF: Continuous Availability Feature; CS: Concurrent Session; ER: Enterprise Replication; HDR: high-availability data replication; LU: Limited Use; PVU: Processor Value Unit; SDS: Shared Disk SecondaryInformix Editions summary table© Copyright IBM Corporation 2010IBM Corporation Software Group Route 100Somers, NY 10589 U.S.A.Produced in the United States of America October 2010All Rights ReservedIBM, the IBM logo, and Informix are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries or both. If these and other IBM trademarked terms are marked on their first occurrence in this information with a trademark symbol (® or ™), these symbols indicate U.S. registered or common law trademarks owned by IBM at the time this information was published.Such trademarks may also be registered or common law trademarks in other countries. A current list of IBM trademarks is available on the web at“Copyright and trademark information” at /legal/copytrade.shtml Linux is a registered trademark of Linus T orvalds in the United States, other countries or both.Microsoft, Windows, Windows NT and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries or both.UNIX is a registered trademark of The Open Group in the United States and other countries.Other company, product or service names may be trademarks or service marks of others.1 The VendorRate 2009 Y ear End Report. /discoverinformix2 “Deep Compression with IBM Informix” /ibmdl/pub/software/data/sw-library/demos/informix/CompressionDemo.swf3 E mbedding Informix: Real World Experiences. /software/data/informix/embed/experience.htmlPlease RecycleIMB14078-USEN-02For more informationT o learn more about Informix and its capabilities, pleasecontact your IBM representative or IBM Business Partner or visit the following website: /software/data/informix。

Oracle数据库11g版本介绍满足不同企业需求的世界一流的数据库Oracle数据库11g是业界第一个为网格计算而设计的数据库，且有多个版本可供选择：标准版和企业版。

所有这些版本都使用相同的通用代码库构建，这意味着企业的数据库管理软件可以轻松地从规模较小的单一处理器服务器扩展到多处理器服务器集群，而无需更改一行代码。

Oracle数据库11g企业版还有许多其他增强了性能、可伸缩性、可用性、安全性和可管理性的功能选项。

无论你是独立开发者、中小型企业还是大型企业，这些世界一流的数据库版本中总有一款可满足您的业务和技术需求。

下表全面总结了Oracle数据库11g的各个版本。

有关各版本之间相互对比的详细信息，请参阅Oracle数据库11g产品系列白皮书。

主要功能汇总标准版企业版CPU最大数量 4 无限制RAM 操作系统允许的最大容量操作系统允许的最大容量数据库规模无限制无限制WindowsLinuxUnix支持64位高可用性更多内容故障保护配置和验证Windows集群，并通过与微软集群服务器集成的高可用性软件快速、准确地自动恢复。

更多信息回闪查询无需复杂、耗时的操作即可恢复更早版本的数据。

更多信息回闪表、数据库和事务查询诊断和撤销错误操作以缩短恢复时间。

更多信息数据卫士创建、维护并监控一个或多个备用数据库，以保护企业数据不受故障、灾难、错误和损坏的影响。

更多信息Oracle安全备份针对Oracle数据库和异构文件系统的安全、高性能的磁带备份管理可降低网络数据保护的成本和复杂性。

更多信息服务器管理的备份和恢复借助Oracle恢复管理器（RMAN）简化、自动化并提高备份及恢复性能。

可扩展性更多内容真正应用集群跨多个相互连接或“集群可选的”服务器运行任意未做更改的打包或定制的管理软件。

更多信息集成的集群件利用一组通用、内置的集群服务创建和运行数据库集群。

自动工作负载管理将服务连接请求发送给拥有最低负载的适当服务器；一旦发生故障，自动将幸存的服务器重新分配以用于服务。

甲骨文推出Oracle业务流程管理（BPM）套件11g
佚名
【期刊名称】《中国信息化》
【年(卷),期】2010(000)016
【摘要】为了帮助客户降低成本，适应变化并简化业务流程管理，甲骨文公司近日宣布推出Oracle业务流程管理套件11g。

Oracle业务流程管理套件11g的统一流程基础简化了流程开发、部署、监控和执行。

新组件包括：统一流程引擎、Oracle通用内容管理、端到端管理等。

【总页数】1页(P77-77)
【正文语种】中文
【中图分类】TP31
【相关文献】
1.甲骨文推Oracle业务流程管理套件11g [J], 卢敏
2.甲骨文推出Oracle业务流程管理套件11g [J],
3.注重流程再造优化简化业务流程管理甲骨文推出Oracle业务流程管理套件11g强调融合性统一性 [J],
4.甲骨文推出Oracle SOA套件11g升级版 [J],
5.进一步提升Oracle数据集成产品线甲骨文推出Oracle数据集成器11g和Oracle GoldenGate 11g [J], 爱德曼
因版权原因，仅展示原文概要，查看原文内容请购买。

Board Assembly Part Number(s)Part Number Description159040B-01L or later NI PXIe-7846R159040B-02L or later NI PXIe-7847R159040B-03L or later NI PXIe-7856R159040B-04L or later NI PXIe-7857R159040B-05L or later NI PXIe-7858RManufacturer: National InstrumentsVolatile MemoryUser Accessible/ BatteryType Size System Accessible1Backup? Purpose Method of Clearing2(7846R/7847R/7856R/7857R)FPGA Block RAM 11,700 KB Yes/Yes No Data storage during Cycle PowerVI Execution(7858R)FPGA Block RAM 16,020 KB Yes/Yes No Data storage during Cycle PowerVI Execution (7847R/7857R/7858R)DRAM 512MB Yes/Yes No Onboard Memory Storage Cycle PowerNon-Volatile MemoryUser Accessible/ BatteryType Size System Accessible Backup? Purpose Method of Clearing(7846R/7847R/7856R/7857R)Flash 64 Mb No- Device information No/Yes Product Identification None available to user- Calibration data3No/Yes Calibration Information None available to user- Calibration metadata Yes/Yes User-defined See Clearing Notes- FPGA bitstream Yes/Yes User LV FPGA VI Bitstream See Clearing Notes(7858R)Flash 128 Mb- Device information No/Yes No Product Identification None available to user- Calibration data3No/Yes Calibration Information None available to user- Calibration metadata Yes/Yes User-defined See Clearing Notes- FPGA bitstream Yes/Yes User LV FPGA VI Bitstream See Clearing Notes1 Items are designated No for the following reason(s):a) Hardware changes or a unique software tool from National Instruments are required to modify contents of the memorylisted.b) Hardware-modifying software tools are not distributed to customers for any personal access or customization, also knownas non-normal use.2 The designation None Available to User indicates that the ability to clear this memory is not available to the user undernormal operation. The utilities required to clear the memory are not distributed by National Instruments to customers fornormal use.3 Calibration constants that are stored in device calibration memory include information for the device’s full operating range. Calibration constants do not maintain any unique data for specific configurations at which the device is used unlessotherwise specified.Media StorageUser Accessible/ BatteryType Size System Accessible Backup? Purpose Method of Clearing NONEClearing Notes:Calibration metadata: There are two items in the calibration metadata that need to be cleared:1.To clear the user-defined information, you can use the Calibration Utility to write a known value to the user stringfield.2.To clear the calibration password, you can use the Calibration Utility to change the password to a known value.FPGA bitstream: You can use the NI-RIO Device Setup utility to erase the FPGA bitstream data. For more details, visit /info and enter the infocode fpgaflashclr.Terms and DefinitionsUser Accessible Allows the user to directly write or modify the contents of the memory during normal instrument operation. System Accessible Does not allow the user to access or modify the memory during normal instrument operation. However, system accessible memory may be accessed or modified by background processes. This can be something that is not deliberate by the user and can be a background driver implementation, such as storing application information in RAM to increase speed of use.Cycle Power The process of completely removing power from the device and its components. This process includes a complete shutdown of the PC and/or chassis containing the device; a reboot is not sufficient for the completion of this process. Volatile Memory Requires power to maintain the stored information. When power is removed from this memory, its contents are lost.Non-Volatile Retains its contents when power is removed. This type of memory typically contains calibration or chip configuration information, such as power up states.。

BIEE11g入门培训教程编写：北京殷塞信息技术有限公司编写日期:2012/6/19版本：V1。

0目录BIEE11g入门培训教程 (1)1. ORACLE BIEE基础 (5)1.1. OBIEE 概述 (5)1。

1.1。

BIEE 历史 (5)1.1.2. 数据模型 (5)1。

2. BIEE 安装 (6)1.2.1. JDK要求 (6)1.2。

2. 下载BIEE (6)1。

2.3. 安装BIEE (7)1。

2。

4. Logs (9)1.3。

配置 (10)1.3.1. 安装后的目录 (10)1.3.2。

几个重要的配置文件 (10)1。

4。

预览Demo效果 (10)1。

4。

1。

启动BI服务和OC4J (10)1。

4。

2。

打开BIEE仪表盘 (11)2。

BIEE 开发步骤 (12)2.1。

数据库 (12)2。

1.1。

安装数据库 (12)2。

2。

创建资料库 (12)2.2.1。

资料库 (12)2。

3。

创建物理模型 (13)2.3。

1。

导入物理表 (13)2.3.2. 创建物理模型 (16)2.3.3。

新建主键和外键 (17)2.4。

创建逻辑模型 (20)2。

4.1. 创建逻辑层 (20)2。

4.2. 查看逻辑层 (21)2。

4.3. 修改逻辑层 (21)2。

5. 创建展现模型 (22)2.5.1。

创建展现层 (22)2。

6. 保存资料库 (22)2.6。

1。

保存资料库 (22)2。

6.2. 修改密码 (23)2。

7。

发布资料库 (23)2.7。

1. 修改NQSConfig。

INI (24)2。

7。

2。

重启Oracle BI Server (24)2.8. Answers –答复 (24)2.8.1. 登陆BI EE11g (24)2。

8.2。

选择主题 (25)2.8.4。

保存报表 (28)2。

9。

Dashboards –仪表盘 (29)2。

9.1。

创建仪表盘 (29)2。

9。

2。

编辑仪表盘 (29)2。

甲骨文推数据集成器11g和GoldenGate11g甲骨文公司日前推出构成Oracle数据集成产品线基础的Oracle GoldenGate和Oracle数据集成器企业版的最新版本Oracle GoldenGate 11g和Oracle数据集成器企业版11g，此举扩大了甲骨文在数据集成行业的领先地位。

萧百龄_大中华区产品战略部首席产品战略解决方案专家这两款新产品是Oracle融合中间件产品系列的组成部分，通过更紧密地与Oracle应用产品和技术产品相集成，实现了企业级实时数据集成，这些产品还支持更多的异构系统，并具有最佳性能。

Oracle GoldenGate 11g通过独特的低影响度和延迟都很小的数据采集、分配和交付功能，为关键任务系统提供了实时的数据集成和连续可用性。

Oracle数据集成器企业版11g通过高性能抽取、加载和转换(E-LT)技术，可及时地向数据仓库环境快速、高效地加载和转换数据。

为了进一步在各种复杂系统之间确保信息的准确性和一致性，甲骨文还推出了面向数据集成器11g的Oracle数据质量(Oracle Data Quality for Data Integrator 11g)和Oracle数据剖析11g(Oracle Data Profiling 11g)，这两款产品也是Oracle数据集成产品线的组成部分。

Oracle数据集成产品是业界最全面、最开放和集成度最高的企业级实时数据集成解决方案。

客户可以降低IT成本和风险，同时更快地实现运营和分析系统的价值。

更紧密的集成、增强的支持和更高的性能这两款新版软件与Oracle应用产品和Oracle技术产品的集成更加紧密：Oracle GoldenGate 11g已针对运行在Oracle电子商务套件、Oracle PeopleSoft、Oracle JD Edwards等Oracle应用产品上的运营报告解决方案进行了认证。

通过支持更新、更多的数据类型，Oracle GoldenGate 11g使客户能采用下一代Oracle应用产品。

P/N: 1802051110012 *1802051110012*MGate 5111 Series Quick Installation GuideVersion 1.2, January 2021Technical Support Contact Information/support2021 Moxa Inc. All rights reserved.OverviewThe MGate 5111 is an industrial Ethernet gateway for ModbusRTU/ASCII/TCP, PROFINET and EtherNet/IP to PROFIBUS slave network communications.Package ChecklistBefore installing the MGate 5111, verify that the package contains the following items:•MGate 5111 gateway•Quick installation guide (printed)•Warranty cardPlease notify your sales representative if any of the above items is missing or damaged.Optional Accessories (can be purchased separately)•Mini DB9F-to-TB: DB9-female-to-terminal-block connector•WK-51-01: Wall-mounting kit, 51 mm wideHardware IntroductionDimensionsUnit = mm (inch)LED IndicatorsLED Color DescriptionPWR 1, PWR 2 Green Power is on Off Power is offReady GreenSteady on: Power is on, and the unit is functioningnormallyBlinking: The unit is responding to the software’sLocate functionRedSteady on: Power is on, and the unit is booting upBlinking: Indicates an IP conflict, or the DHCP orBOOTP server is not responding properlyFlashing quickly: the microSD card failedLAN Green(Flashingonly)The Ethernet port is receiving or transmitting dataModbus TCP Client:Modbus communication in progressModbus TCP Server:Modbus communication in progressEtherNet/IP Adapter:EtherNet/IP communication is exchanging dataPROFINET IO Device:PROFINET communication is exchanging dataRed(Flashingonly)A communication error occurredModbus TCP Client:1.Received an exception code or framing error(parity error, checksum error)mand timeout (slave device is notresponding)3.TCP connection timeoutModbus TCP Server:1.Received an invalid function code or framing error(parity error, checksum error)2.Accessed invalid register address or coil addressEtherNet/IP Adapter:The connection was refused due to incorrectconfigurationOff No communicationMB* Green(Flashingonly)Modbus is receiving or transmitting dataRed(Flashingonly)A communication error occurredMaster Mode:1.Received an exception code or framing error(parity error, checksum error)mand timeout (the slave device is notresponding)Slave Mode:1.Received an invalid function code or framing error(parity error, checksum error)2.Accessed invalid register address or coil address Off No communicationLED Color DescriptionPBS Green(Flashingonly)PROFIBUS is receiving or transmitting dataRed(Steady)Error in the configuration or parameter data.Off PROFIBUS offline or Slave ID is wrong.Eth1, Eth2 Green Indicates an 100 Mbps Ethernet connection Amber Indicates a 10 Mbps Ethernet connection Off The Ethernet cable is disconnected*Only indicates serial communication status; for Modbus TCP status, please refer to LAN LED indicator.Reset ButtonRestore the MGate to factory default settings by using a pointed object (such as a straightened paper clip) to hold the reset button down until the Ready LED stops blinking (approximately five seconds).Pull-Up, Pull-Down, and Terminator for RS-485 (Modbus) On the MGate 5111’s left side panel, you will find DIPswitches to adjust each serial port’s pull-up resistor,pull-down resistor, and terminator.SWMODBUS1 2 3 Pull-upresistorPull-downresistorTerminatorON 1 KΩ 1 KΩ120 ΩOFF150 KΩ(default)150 KΩ(default)– (default) Rotary SwitchBefore communicating, you must assign a slave ID to thePROFIBUS slave, If you would like to assign an addressbetween 0 to 99, you need to change the rotary switch tothe desired address. If you would like to assign anaddress which is over 99, you must set it via webconsole.Hardware Installation Procedure1.Connect the power adapter. Connect the 12-48 VDC power line orDIN-rail power supply to the MGate 5111’s terminal block. Make sure the adapter is connected to an earthed socket.e a PROFIBUS cable to connect the MGate to a PROFIBUS PLC orother PROFIBUS master.e an Ethernet cable to connect the MGate to the Modbus TCP client,Modbus TCP server device, PROFINET IO controller, or EtherNet/IP scanner device.4.The MGate 5111 is designed to be attached to a DIN rail or mountedon a wall. For DIN-rail mounting, push down the spring and properly attach it to the DIN rail until it “snaps” into place. For wall mounting, install the wall-mount kit (optional) first and then screw the device onto the wall.Wall or Cabinet MountingTwo metal plates are provided for mounting theunit on a wall or inside a cabinet. Attach theplates to the unit’s rear panel with screws. Withthe plates attached, use screws to mount theunit on a wall. The heads of the screws should be5 to 7 mm in diameter, the shafts should be 3 to4 mm in diameter, and the length of the screwsshould be more than 10.5 mm.For each screw, the head should be 6 mm or less in diameter, and the shaft should be 3.5 mm or less in diameter.The following figure illustrates the two mounting options:Software Installation InformationPlease download the user's manual and DSU (Device Search Utility) from Moxa’s website: . Please refer to the User’s Manual for additional details on using the Device Search Utility.The MGate 5111 also supports login via a web browser.Default IP address: 192.168.127.254Default account: adminDefault password: moxaPin AssignmentsEthernet Port (RJ45)Pin Signal1 Tx+2 Tx-3 Rx+6 Rx-Modbus Serial Port (Male DB9) PinRS-232RS-422/ RS-485 (4W)RS-485 (2W) 1 DCD TxD-(A) – 2 RXD TxD+(B) –3 TXD RxD+(B) Data+(B)4 DTR RxD-(A) Data-(A) 5* GND GND GND 6 DSR – – 7 RTS – – 8 CTS – – 9 – ––*Signal groundPROFIBUS Serial Port (Female DB9) Pin Signal1- 2-3 PROFIBUS D+4 RTS5 Signal common6 5V7 -8 PROFIBUS D-9-Console Port (RS-232)The MGate 5111 Series can use an RJ45 serial port to connect to a PC to configure the device. PinSignal 1 DSR 2 RTS 3 GND 4 TXD 5 RXD 6 DCD 7 CTS 8DTRPower Input and Relay Output PinoutsV2+V2-V1+V1-ShieldedGroundDC Power Input 2 DCPowerInput 2 N.O.CommonN.C.DC Power Input 1 DC Power Input 1SpecificationsPower Input12 to 48 VDCPower Consumption (Input Rating)12 to 48 VDC, 416 mA (max.)Operating TemperatureStandard Models: 0 to 60°C (32 to 140°F) Wide Temp. Models: -40 to 75°C (-40 to 167°F)Storage Temperature-40 to 85°C (-40 to 185°F)ATEX and IECEx Information1. DEMKO Certificate number: 17 ATEX 1848XIECEx Certificate number: IECEx UL 17.0019X 2. Ambient Temperature Range:0°C to 60°C (for models without suffix –T) -40°C to 75°C (for models with suffix –T only) 3. Certification String: Ex nA nC IIC T4 Gc4. Standards Covered: EN 60079-0:2012+A11:2013/IEC 60079-0 6thEd. AND EN 60079-15:2010/IEC 60079-15 4th Ed.5. The conditions of safe use:a. Ethernet Communications Devices are intended for mounting in atool-accessible IP54 enclosure and use in an area of not more than pollution degree 2 as defined by IEC/EN 60664-1.b. Conductors suitable for use in an ambient temperature greaterthan 86°C must be used for the power supply terminal.c. A 4 mm 2 conductor must be used when a connection to theexternal grounding screw is utilized.d. Provisions shall be made, either in the equipment or external tothe equipment, to prevent the rated voltage from being exceededby the transient disturbances of more than 140% of the peak-rated voltage. When wiring the relay contact (R), digital input (DI), and power inputs (P1/P2), we suggest using AWG (American Wire Gauge) 16-24 as a cable and the corresponding pin-type cable terminals. The connector canwithstand a maximum torque of 5 pound-inches. The wire temperature rating should be at least 105°C.NOTE This equipment is suitable for use in Class 1, Division 2, Groups A, B, C, D or nonhazardous locations onlyMoxa Inc.No. 1111, Heping Rd., Bade Dist., Taoyuan City 334004, Taiwan。

Dell PowerEdge Systems Oracle 11g R2 Database on Enterprise Linux x86_64 Getting Started GuideNotes, Cautions, and WarningsNOTE: A NOTE indicates important information that helps you make better use of your computer.CAUTION: A CAUTION indicates potential damage to hardware or loss of data if instructions are not followed.WARNING: A WARNING indicates a potential for property damage, personalinjury, or death._______________Information in this publication is subject to change without notice.©2011Dell Inc.All rights reserved.Reproduction of these materials in any manner whatsoever without the written permission of Dell Inc. is strictly forbidden.Trademarks used in this text: Dell™, the DELL logo, PowerEdge™, are trademarks of Dell Inc. Red Hat® and Red Hat® Enterprise Linux® are registered trademarks of Red Hat, Inc. in the United States and/or other countries. Novell® is a registered trademark and SUSE ™ is a trademark of Novell Inc. in the United States and other countries. Oracle® is a registered trademark of Oracle Corporation and/or its affiliates.Other trademarks and trade names may be used in this publication to refer to either the entities claiming the marks and names or their products. Dell Inc. disclaims any proprietary interest in trademarks and trade names other than its own.2011 – 07 Rev. A00Contents1Overview (5)Before You Begin (5)Hardware Requirements (5)Network Requirements (6)Operating System Requirements (6)2Preparing Nodesfor Oracle Installation (7)Attaching to RHN/ULN Repository (7)Installing the Dell Validated RPM (9)Installing the Dell Oracle Utilities RPM (10)Oracle Software Binary Location (11)Setting up the Network (12)Public Network (12)Private Network (13)IP Address and Name ResolutionRequirements (16)Contents33Preparing Shared Storage for Oracle RAC Installation (19)Partitioning the Shared Disk (20)Adjusting the Stripe Element Sizeon a Primary Partition (23)Installing and Configuring ASMlib (25)Using ASMLib to Mark the Shared Disksas Candidate Disks (25)4Installing Oracle 11g R2Grid Infrastructure (29)Before You Begin (29)Configure the System Clock Settingsfor All Nodes (29)Configuring Node One (30)5Configuring Shared Oracle Homefor Database Binary Using ACFS (33)6Installing Oracle 11g R2 Database(RDBMS) Software (35)7Creating Diskgroup Using ASMConfiguration Assistant (ASMCA) (37)8Creating Database Using DBCA (39)4ContentsOverviewThis document applies to Oracle Database 11g R2 running on Red Hat Enterprise Linux 5.x AS x86_64 or Oracle Enterprise Linux 5.x AS x86_64.Before You BeginHardware Requirements•Oracle requires 1.5 gigabytes (GB) of physical memory.•Swap space must be equal to the amount of RAM allocated to the system.•Oracle's temporary space (/tmp) must be at least 1 GB in size.• A monitor that supports resolution of 1024 x 768 to correctly display the Oracle Universal Installer (OUI).•For Dell-supported hardware configurations, see the Software Deliverable List (SDL) for each Dell Validated Component at /oracle. Table1-1 describes the disk space required for an Oracle installation.Table 1-1.Minimum Disk Space RequirementsSoftware Installation Location Size RequiredGrid Infrastructure home 4.5 GB of spaceOracle Database home 4 GB of spaceShared storage disk space Sizes of database and FlashbackRecoveryOverview5Network Requirements•It is recommended that you ensure each node contains at least three network interface cards (NICs). One NIC for public network and twoNICs for private network to ensure high availability of the Oracle RealApplication Clusters (RAC).•Public and private interface names must be the same on all nodes.For example, if eth0 is used as the public interface on node one, all other nodes require eth0 as the public interface.•All public interfaces for each node should be able to communicate with all nodes within the cluster.•All private interfaces for each node should be able to communicate with all nodes within the cluster.•The hostname of each node must follow the RFC 952 standard (/rfc/rfc952.txt). Hostnames that include an underscore ("_") are not permitted.•Each node in the cluster requires the following IP address:•One public IP address•T wo private IP address•One virtual IP address•Three single client access name (SCAN) addresses for the clusterOperating System Requirements•Red Hat Enterprise Linux 5.x AS x86_64•Oracle Linux 5.x AS x86_646OverviewPreparing Nodes for Oracle InstallationAttaching to RHN/ULN RepositoryNOTE: The documentation provided below discusses how to set up a local yumrepository using your operating system installation media. If you would like toconnect to the Red Hat Network (RHN)/Unbreakable Linux Netwrok (ULN) channels, see the appropriate documentation. For Red Hat, see /red_hat_network.For information relating to ULN network, see .The recommended configuration is to serve the files over http using an Apache server (package name: httpd).This section discusses hosting the repository files from a local filesystem storage. While other options to host repository files exist, they are outside of the scope of this document. It is highly recommended to use local filesystem storage for speed and simplicity of maintenance.1Mount the DVD image by either using the physical media or by using the ISO image.•Using the physical media: Insert the DVD into the server and it should auto-mount into the /media directory.•Using the ISO image: Run the following command as root,substituting the path name of your ISO image for the field myISO.iso:mkdir /media/myISOmount -o loop myISO.iso /media/myISOPreparing Nodes for Oracle Installation72To install and configure the http daemon, configure the machine that will host the repository for all other machines to use the DVD image locally.Create the file /etc/yum.repos.d/local.repo and enter the following: [local]name=Local Repositorybaseurl=file:///media/myISO/Servergpgcheck=0enabled=03Install the Apache service daemon using the following command which temporarily enables the local repository for dependency resolution: yum -y install httpd --enablerepo=local After the Apache service daemon is installed, start the service and set it to start up for us next time we reboot. Run the following commands as root: •service httpd start•chkconfig httpd onTo use Apache to serve out the repository, copy the contents of the DVD into a published web directory. Run the following commands as root(make sure to switch myISO with the name of your ISO) command:•mkdir /var/www/html/myISO•cp -R /media/myISO/* /var/www/html/myISO NOTE: The command createrepo is used for creating customrepositories, but it is not required as the DVD already holds the repository information.•This step is only necessary if you are running SELinux on the server that hosts the repository. Run the following command as root torestore the appropriate SELinux context to the copied files:restorecon -Rvv /var/www/html/.•The final step is to gather the DNS name or IP of the server that is hosting the repository. The DNS name or IP of the hosting server willbe used to configure your yum repository repo file on the client server.8Preparing Nodes for Oracle InstallationPreparing Nodes for Oracle Installation 9The following is an example of the configuration using the RHEL 5.x Server media in the configuration file/etc/yum.repos.d/myRepo.repo[myRepo]name=RHEL5.5 DVDbaseurl=/RHEL5_5/Server enabled=1gpgcheck=0NOTE: Replace with your server's DNS name or IPaddress. NOTE: You can also place the configuration file on the server hosting therepository for all other servers such that it can also use the repository as amore permanent solution to what was done in step 2 .Installing the Dell Validated RPMOnce your nodes have attached to the appropriate yum repository, install the Dell Validated RPM package. The Dell Validated RPM package automates certain pieces of the installation process required for the installation of Oracle RAC.The process to install the Dell Validated RPM package is as follows:1Download the latest Dell Oracle Deployment tar file from /dell-groups/enterprise_solutions/m/oracle_db_gallery/default.aspxNOTE: The filename will follow the convention: Dell-Oracle-Deployment-OS version-year-month.tar, for example: Dell-Oracle-Deployment-Lin-2011-07.tar 2Copy the Dell Oracle Deployment tar file to a working directory of all your cluster nodes.3To go to your working directory, enter the following command:# cd </working/directory/path>4Untar the Dell-Oracle-Deployment release using the command: # tar -xvf Dell-Oracle-Deployment-o-y-m.tarNOTE: Where,o is the operating system version, y is the year, and m is themonth of the tar release.5Change directory to Dell-Oracle-Deployment-o-y-m6Install the Dell Validated RPM package on all your cluster nodes using the following command:# yum localinstall dell-validated* --nogpgcheck Installing the Dell Oracle Utilities RPMThe Dell Oracle utilities RPM is designed to do the following Dell and Oracle recommended settings:•Create Grid Infrastructure directories, set ownership, and permissions.•Create grid user.•Create Oracle Database (RDBMS) directories, set ownership, and permissions.•Create the Oracle base directories, set ownership, and permissions.•Set pam limits within (/etc/pam.d/login).•Setup /etc/profile.•Set SELinux to Disabled.•Install the Dell PowerEdge system component drivers if applicable.•Set kernel parameters.The process to install the Dell Oracle utilities RPM is as follows:1Download the latest Dell Oracle Deployment tar file from/dell-groups/enterprise_solutions/m/oracle_db_gallery/default.aspxNOTE: The filename will follow the convention: Dell-Oracle-Deployment-OSversion-year-month.tar, for example: Dell-Oracle-Deployment-Lin-2011-07.tar 2Copy the Dell Oracle Deployment tar file to a working directory of all your cluster nodes.10Preparing Nodes for Oracle InstallationPreparing Nodes for Oracle Installation 113To go to your working directory, type the following command:# cd </working/directory/path>4To Untar the Dell-Oracle-Deployment release type the following command:# tar -xvf Dell-Oracle-Deployment-o-y-m.tar NOTE:Where, o is the operating system version, y is the year, and m is the month of the tar release.5Change directory to Dell-Oracle-Deployment-o-y-m6To iInstall the Dell Oracle utilities RPM package on all your cluster nodes type the following command:# yum localinstall dell-oracle-utilities* --nogpgcheck 7Once the rpm is installed, run the dodeploy script to set up the environment as follows: # dodeploy -g -r 11gR2For more information about the Dell Oracle utilities RPM and its options, check the man pages using the command: # man 8 dodeployNOTE: The Dell-Oracle-Deplyoment tar contains the latest supported drivers provided from our Software Deliverable List (SDL). Consult the README file found within the Dell-Oracle-Deployment tar for installation instructions of the latest drivers.Oracle Software Binary LocationThe Oracle software binaries should be located on node one of your cluster. It is important to note that starting with Oracle 11g R2 (11.2.0.2), Oracle Database patch sets are full installation of the Oracle software. For more information on how this impacts future Oracle deployments, see My Oracle Support note: 1189783.1 Important Changes to Oracle Database Patch Sets Starting with 11.2.0.2.12Preparing Nodes for Oracle InstallationSetting up the NetworkPublic NetworkNOTE: Ensure that the public IP address is a valid and routable IP address.To configure the public network on each node:1Log in as root .2Edit the network device file /etc/sysconfig/network-scripts/ifcfg-eth# where # is the number of the network device:NOTE: Ensure that the Gateway address is configured for the public network interface. If the Gateway address is not configured, the Oracle Gridinstallation may fail.DEVICE=eth0ONBOOT=yesIPADDR=<Public IP Address>NETMASK=<Subnet mask>BOOTPROTO=staticHWADDR=<MAC Address>SLAVE=noGATEWAY=<Gateway Address>3Edit the /etc/sysconfig/network file, and, if necessary, replace localhost.localdomain with the qualified public node name. For example, the command for node 1 will be: hostname= 4T ype service network restart to restart the network service.5T ype ifconfig to verify that the IP addresses are set correctly.6To check your network configuration, ping each public IP address from a client on the LAN that is not a part of the cluster.7Connect to each node to verify that the public network is functioning. T ype ssh <public IP> to verify that the secure shell (ssh) command is working.Preparing Nodes for Oracle Installation 13Private NetworkNOTE: Each of the two NIC ports for the private network must be on separate PCI buses.The grid infrastructure of Oracle 11gR2 (11.2.0.2) supports IP failovernatively using a newly introduced feature known as Redundant Interconnect . Oracle uses its ora.cluster_interconnect.haip resource to communicate with Oracle RAC, Oracle ASM, and other related services. The Highly Available Internet Protocol (HAIP) has the ability to activate a maximum of four private interconnect connections. These private network adapters can be configured during the initial install process of Oracle Grid or after the installation process using the oifcfg utility.Oracle Grid currently creates an alias IP (as known as virtual private IP) on your private network adapters using the 169.254.*.* subnet for the HAIP . If the subnet range is already in use, Oracle Grid does not attempt to use it. The purpose of HAIP is to load balance across all active interconnect interfaces, and failover to other available interfaces if one of the existing private adapters becomes unresponsive.NOTE: When adding additional HAIP addresses (maximum of four) after theinstallation of Oracle Grid, restart your Oracle Grid environment to make these new HAIP addresses active.The example below provides step-by-step instructions on enabling redundant interconnect using HAIP on a fresh Oracle 11gR2 (11.2.0.2) GridInfrastructure installation.1Edit the file, /etc/sysconfig/network-scripts/ifcfg-ethX , where X is the number of the eth device, ifcfg-ethX configuration files of the network adapters to be used for your private interconnect. The following example shows eth1 and eth2 using a 192.168.0.* subnet.DEVICE=eth1BOOTPROTO=staticHWADDR=00:1E:C9:4B:72:22ONBOOT=yesIPADDR=192.168.0.140NETMASK=255.255.255.0DEVICE=eth2HWADDR=00:1E:C9:4B:71:24BOOTPROTO=staticONBOOT=yesIPADDR=192.168.0.141NETMASK=255.255.255.02Once you have saved both the configuration files, restart your network service using service network restart.The completion of the steps above have now prepared your system toenable HAIP using the Oracle Grid Infrastructure installer. When you have completed all the Oracle prerequisites and are ready to install Oracle, you will need to select eth1 and eth2 as 'private' interfaces at the 'NetworkInterface Usage' screen.This step enables redundant interconnectivity once your Oracle GridInfrastructure has successfully completed and is running.3To verify that your redundant interconnect using HAIP is running, you can test this feature using the ifconfig command. An example of the output is listed below.ifconfigeth1 Link encap:Ethernet HWaddr00:1E:C9:4B:72:22inet addr:192.168.0.140Bcast:192.168.0.255 Mask:255.255.255.128inet6 addr: fe80::216:3eff:fe11:1122/64 Scope:LinkUP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1RX packets:6369306 errors:0 dropped:0overruns:0 frame:014Preparing Nodes for Oracle InstallationTX packets:4270790 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000RX bytes:3037449975 (2.8 GiB) TX bytes:2705797005 (2.5 GiB)eth1:1 Link encap:Ethernet HWaddr00:1E:C9:4B:72:22inet addr:169.254.167.163Bcast:169.254.255.255 Mask:255.255.0.0UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1eth2 Link encap:Ethernet HWaddr00:1E:C9:4B:71:24inet addr:192.168.0.141Bcast:192.168.0.255 Mask:255.255.255.128inet6 addr: fe80::216:3eff:fe11:1122/64 Scope:LinkUP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1RX packets:6369306 errors:0 dropped:0 overruns:0 frame:0TX packets:4270790 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000RX bytes:3037449975 (2.8 GiB) TX bytes:2705797005 (2.5 GiB)Preparing Nodes for Oracle Installation1516Preparing Nodes for Oracle Installationeth2:1 Link encap:Ethernet HWaddr00:1E:C9:4B:71:24inet addr:169.254.167.164Bcast:169.254.255.255 Mask:255.255.0.0UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1For more information on Redundant Interconnect andora.cluster_interconnect.haip, see metalink note: 1210883.1 at .IP Address and Name Resolution RequirementsThe steps below show how to set up your cluster nodes for using Domain Name System (DNS). For information on how to set up cluster nodes using GNS, see the wiki article /dell-groups/enterprise_solutions/w/oracle_solutions/1416.aspx .For a Cluster Using DNSTo set up an Oracle 11g R2 RAC using Oracle DNS (without GNS):1Configure at least two interfaces on each node, one for the private IP address and one for the public IP address.2Configure the SCAN NAME on the DNS for Round Robin resolution to three addresses (recommended) or at least one address. The SCANaddresses must be on the same subnet as virtual IP addresses and public IPaddresses. NOTE: For high availability and scalability, it is recommended that youconfigure the SCAN to use Round Robin resolution to three IP addresses.The name for the SCAN cannot begin with a numeral. For installation tosucceed, the SCAN must resolve to at least one address.Table2-1 describes the different interfaces, IP address settings and the resolutions in a cluster.Configuring a DNS ServerTo configure changes on a DNS server for an Oracle 11g R2 cluster using a DNS (without GNS):1Configure SCAN NAME resolution on DNS server.A SCAN NAME configured on the DNS server using the Round Robinpolicy should resolve to three public IP addresses (recommended),however the minimum requirement is one public IP address.For example:scancluster IN A 192.0.2.1IN A 192.0.2.2IN A 192.0.2.3Where scancluster is the SCAN NAME provided during Oracle Gridinstallation.NOTE: The SCAN IP address must be routable and must be in public range. Table 2-1.Cluster Requirements for DNSInterface Type ResolutionPublic Static DNSPrivate Static Not requiredNode virtual IP Static DNSSCAN virtual IP Static DNSPreparing Nodes for Oracle Installation17Configuring a DNS ClientTo configure the changes required on the cluster nodes for name resolution: 1Configure the resolv.conf on all the nodes in the cluster to contain nameserver entries that are resolvable to the appropriate DNS server. Provide an entry similar to the following:/etc/resolv.conf:search nameserver 192.0.2.100Where, 192.0.2.100 is a valid DNS server address in your network and is the domain server in your network.2Verify the order configuration. /etc/nsswitch.conf controls the name service order. In some configurations, the NIS can cause issues with Oracle SCAN address resolution. It is recommended that you place the NIS entry at the end of the search list and place the dns entry first. For example,hosts: dns files nisOnce you have modified the /etc/nsswitch.conf, restart the nscd service by issuing the command:# /sbin/service nscd restart18Preparing Nodes for Oracle InstallationPreparing Shared Storage for Oracle RAC InstallationNOTE: In this section, the terms disk(s), volume(s), virtual disk(s), LUN(s) mean the same and are used interchangeably, unless specified otherwise. Similarly, theterms Stripe Element Size and Segment Size both can be used interchangeably. Oracle RAC requires shared LUNs for storing your Oracle Cluster Registry (OCR), voting disks, Oracle Home using ACFS, Oracle Database files, andFlash Recovery Area (FRA). To ensure high availability for Oracle RAC it is recommended that you have:•Three shared LUNs, each of 1 GB in size for normal redundancy or five LUNs for high redundancy for the Oracle clusterware.•At least two shared disks to store your database. Each shared disk should be the same disk speed and size.•At least two shared LUNs to store your Automatic Storage Management Cluster File System (ACFS). Each shared disk must be at least 10 GB,for a total size of 20 GB.•At least two shared LUNs or volumes to store your FRA. Ideally, the FRA space should be large enough to copy all of your Oracle datafiles andincremental backups. For more information on optimally sizing your FRA, see My Oracle Support ID 305648.1 section "What should be the size of Flash Recovery Area?"NOTE: It is recommended to use the device mapper multipath for optimalperformance and persistent name binding across nodes within the cluster.NOTE: For more information on attaching shared LUNs/volumes, see the Wikidocumentation found at: http:// /dell-groups/enterprise_solutions/w/oracle_solutions/3-storage.aspxPreparing Shared Storage1920Preparing Shared Storage Partitioning the Shared DiskThis section describes how to use Linux’s native partition utility fdisk to create and align a single partition on a volume/virtual disk that spans the entire disk.CAUTION: In a system running the Linux operating system, align the disk prior tobeing written to the Volume/Virtual Disk (VD). Failure to do so will cause all data on the disk to be destroyed.To use the fdisk utility to create a partition and set the alignment: 1At the command prompt, type one of the following:•#> fdisk –u /dev/<block_device> •fdisk –u /dev/mapper/<multipath_disk>Where, <block_device > is the name of the block device that you are creating and aligning a partition on.For example, if the block device is /dev/sdb , type: fdisk –u /dev/sdb If multiple paths to a shared disk are being used and device mapper is the multipath software.The system displays the following message:The number of cylinders for this disk is set to 8782.NOTE: The number of cylinder is larger than 1024, and could in certain setups cause problems with:•Software that runs at boot time (old versions of LILO)•Booting the Partitioning software from other operating systems (for example,DOS FDISK, OS/2 FDISK)NOTE: The value of the number of cylinders in your display message may be different depending on the size of your disk.aCommand (m for help): n # To create a new partition bCommand action extended primary partition (1-4):P # To create a primary partition c Partition number (1-4): 1Preparing Shared Storage 21d First sector (63-xxxxxx, default 63): <StripeElement Size or Segment Size in terms ofSectors>Where the Stripe Element Size (SES) or the Segment Size (SS) is theamount of disk space that is consumed on a single physical disk by a Stripe Element as part of Stripe.For example, a stripe that contains 256 KB of disk space and has 64 KB of data residing on each disk in the stripe. Here the stripe element size is 64 KB and the stripe size is 256 KB.Use the following formula to set the value above:Stripe Element Size in Sectors = Stripe Element Size in KB * 2 FirstSector = Stripe Element Size in Sectors NOTE: The above formula assumes that 1 Sector = 512 Bytes or 0.5 KB.Set the above value to the following, if the SES/SS was left at the Storage Controller’s default value:–For Dell PowerVault MD30xx/MD30xxi, set First sector to: 128 (default 64 KB * 2)–For Dell PowerVault MD32xx/MD32xxi, set First sector to: 256 (default 128 KB * 2)–For Dell EqualLogic PS-Series, set First sector to: 128 (default 64 KB * 2)If the SES/SS for the disk/Volume/VD is set to a non-default value of the storage array, for example 512KB in case of MD32xx, set the First sector value to 1024.Last sector or +size or +sizeM or +sizeK (1024-xxxxx, default xxxxxx): <Enter default value or return key> # Default Value so the singlepartition spans the entire diskCommand (m for help): wq # write and quit22Preparing Shared StorageThe system displays the following message:The partition table has been altered!Callingioctl() to re-read partition table.Syncing disks.If you get a warning message instead saying the kernel still reads the old partition table, then follow step 3 for the kernel to be able to re-read the new partition table.2Repeat step 1 for all the disks that need to be aligned.3T ype the following to re-read the partition table and to be able to see the newly created partition(s)#> partprobe Or#> service multipathd restart Or#> kpartx –a /dev/mapper/<multipath_disk>4Verify that the partition has been aligned by running the one of the following command:•#> fdisk –ul /dev/<block_device> •#> fdisk –ul /dev/mapper/<multipath_device> Where, <block_device > or <multipath_device > is the name of the disk whose partition was aligned.The following example is of a sample output of the above command on a block device that has been aligned. If your partition is properly aligned then you will see the desired starting sector that you set in step 1 under the Start column against your partition.Disk /dev/mapper/mpath70: 53.6 GB, 53697576960 bytes255 heads, 63 sectors/track, 6528 cylinders, total 104878080 sectorsUnits = sectors of 1 * 512 = 512 bytes5Reboot the system if your newly created and aligned partition is not displayed properly.DeviceBootStart End Bloc k s Id System /dev/mapper/mpath70p110241048723195243609683LinuxPreparing Shared Storage 23Adjusting the Stripe Element Size on a Primary Partition To use thefdisk utility to adjust a disk partition, perform the following steps:NOTE: This article assumes that the disk to be aligned already contains a singleprimary partition. If you want to the create primary partition, follow the steps in "Partitioning the Shared Disk" on page 20.CAUTION: In a system running the Linux operating system, align the partition table before the data is written to the Volume. Failure to follow the precaution could lead to all the data on the Volume to be destroyed.At the command prompt, type:1#> fdisk -u /dev/<block_device>where <block_device> is the name of the block device that you are adjusting. For example, if the block device is /dev/mapper/db , type: fdisk /dev/mapper/db.The system displays the following message:The number of cylinders for this disk is set to 8782. There is nothing wrong with that, but this is larger than 1024, and could in certain setups cause problems with:1)software that runs at boot time (e.g., old versions of LILO)2)booting and partitioning software from other OSs (e.g., DOS FDISK, OS/2 FDISK)a. Command (m for help): x # To enter the expert Modeb. Expert command (m for help): b # To move beginning of data in a partitionc. Partition number (1-4): 1 # The partition number to be alignedd. New beginning of data (128-xxxxx, default 128): 128NOTE: 1 block = 512 bytes; 128 blocks * 512 bytes = 64KB。

P111G可编程序控制器的扩展应用两例
白清
【期刊名称】《《电子制作》》
【年(卷),期】2004(000)012
【摘要】接通K1(启动按键)彩灯控制器开始工作。

【总页数】3页(P32-34)
【作者】白清
【作者单位】
【正文语种】中文
【中图分类】TN915.07
【相关文献】
1.P111G型可编程序控制器（三）——实际应用指南 [J], 白青
2.P111G型可编程序控制器（四）——在串行通讯方面的应用 [J], 白青
3.可编程序控制器中
定时器和计数器扩展的应用探索 [J], 高飞
4.高职留学生教学方法探讨与反思——以"可编程序控制器应用"课程为例 [J], 董微
5.不学单片机,上手就搞P111G自动控制(四)——P111G的通讯和扩展应用 [J], 刘颂
因版权原因，仅展示原文概要，查看原文内容请购买。