T2S1-Oracle Cloud Strategy V11_cn
- 格式:ppt
- 大小:12.10 MB
- 文档页数:27
G o o dP i pe tti n g P ra c ti c ePart of the GPP -Tip loading and tip ejection Loading a tip on the end of a pipette and subsequently ejecting it at the end of the pipetting cycle are very closely linked and constitute some of the heaviest forces associated with pipetting. With most pipetting systems the design of the distal end of the pipette is conical in shape. The process of loading the tip on the pipette requires a certain amount of force to ensure an adequate seal of the system – too little force and there is a risk of leakage and volumetric error. User technique for tip loading can vary as there is no clear way to know when enough force had been used to seal the system. Typically a user will adopt a technique that provides reasonable assurance that the tip has sealed and will stay with that technique for most of their working life. Unfortunately, for traditional conical tip systems, there is a strong correlation between the amount of force needed to load the tip and the amount of force required to eject it, so for those who adopt a technique that uses high force to add the tip, a high force will be required to eject it (see Figure 1, red line).In the paper by Lichty et al,6 a number of different manufacturer’s pipettes are reviewed and force measurements compiled for plunger forces and tip ejection forces. It is clear that tip ejection forces are the most significant force associated with the many steps involved in pipetting, but there is great variation in tip ejection forces between pipettes (See Figure 2).Figure 1 The relationship between tip loading and ejection forces – a traditional conical tip compared with a Rainin LTS tip.2Tip Ejection Forces at Increasing Tip Loading Forces Brand X Traditional Tip vs. Rainin LTS Insertion Force (kg)E j e c t i o n F o r c e (k g ) 4.03.02.01.00.00.0 5.0 10.0 15.0Rainin LTS Tip, 250 µL Brand X Tip, 250 µLRainin solved this problem with LiteTouch System (LTS) of pipettes and tips (See Figure3). Here both the distal end of the pipette and the inside of the tip have a closely matchedcylindrical surface. LTS tips also have a sealing system close to the entry point and a hard stop end point inside the tip. The end stop prevents the shaft from being pushed further into the tip with increased force. This strictly limits the maximum sealing force, while still guaranteeing that there will be no leakage. A strict limit on sealing force ensures a minimal ejection force (See Figure 1). This unique yet simple design provides a tool that significantly reduces one of the major sources of muscle fatigue and causes of RSI for pipettors.Figure 2Comparison of tip ejection forces from four popular pipettes. The maximum recommendedthumb exertion force is 2.1 kgf for females and 3.0 kgf for males.2Figure 3Mechanics of Rainin LTS tip sealing system compared to traditionalconical tip sealing systemsTraditional Large seal Conical Friction fit LTSSmall sealCylindricalPositive Stop34Plunger forcesThe plunger system of manual pipettes constitutes the second area of ergonomic interest to the user where repetitive tasks can influence the outcome of RSI’s. After tip insertion, pressing the plunger down to the first stop against the stroke spring (See Figure 4) prepares the pipette/tip system for aspiration. A clear distinctive first stop is critical in that it defines the distance needed to move the plunger and aspirate the desired volume.Mechanically, this first stop is created by the plunger hitting a stiffer pre-loaded blowout spring that has greater resistance than the stroke spring. After the plunger is pressed down to the first stop, the tip is inserted into the solution and the plunger slowly released to aspirate. The stroke spring performs the aspiration by pushing the plunger back up to the home position. The sample is dispensed at the last step – pushing the plunger down against the force of the stroke spring, through the first stop position and then against the force of the blow-out spring to remove all of the liquid. With all liquid dispensed, the plunger is released and returns back to the home position.In the paper by Lichty,6 blow-out forces are the second largest force in the process of pipetting (after tip ejection forces) and stroke spring forces the smallest.Figure 4Pressing manual pipette plunger to show home position (start dispense), first stop (full dispense) and second stop (blowout)“Home“Position First Stop Second StopAn important aspect of the forces in this process is the internal piston seal system (Figure 5).The seal produces a partial vacuum that enables liquid to be drawn into the tip as the pistonmoves up the shaft. The seal system must be tight and strong enough to hold the vacuumrequired for the entire operating range of the pipette. If the seal is too tight the force requiredto push the plunger down and then return it to the home position will be excessive. If the sealis relatively loose, the forces required to move the plunger back and forth will be less, but thepotential for leakage increases.PistonPiston springSeal retainerSealO-ringFigure 5Sealing system in manual pipettesFor manufacturers of pipettes there is a balance between the seal design and the stroke springforces that must be considered in order to meet both the technical needs for accurate pipettingand the individual user’s need for an ergonomic solution. This challenge is met differently byvarious manufacturers, resulting in variable plunger forces (See Figure 6).Figure 6Comparison of plunger forces from four popular pipettes. The maximum recommended thumb exertion force is2.1 kgf for females and3.0 kgf for males2 *New Pipet-Lite XLS reduces plunger forces by up to 43%5Rainin developed high precision, low friction seals to help reduce stroke spring plunger forces.These seals require minimal force to move while maintaining a vacuum, which allows for alighter stroke spring. A lighter stroke spring allows for a lighter blow-out spring, because thedifference in spring forces defines the first stop. Thus blow-out forces are reduced as well.Ultimately, the best solution for avoiding plunger forces is to use an electronic pipette, where amicroprocessor-controlled motor moves the plunger, resulting in near zero plunger forces. Thiscan be particularly helpful with multichannel pipettes, which have the highest plunger forces,and when a researcher needs to perform intensive repetitive mixing of the liquid samples.Volume setting – changing the aspiration volumeChanging the volume of a manual pipette is often necessary to meet the requirements of theexperiment (e.g., changing the setting of a 200 µL pipette down to 50 µL for specific bufferaddition, and then back up to 200 µL for the next buffer). The process of changing the volumesetting screw – normally a small diameter button – requires several turns of the hand-fingers-thumb combination. Experienced pipettors may even do this with one hand, both holding andadjusting the pipette at the same time, while holding a liquid sample in the other hand.A study by Asundi et al5 indicates that volume adjustment is an activity that requires highmuscle activity. In the four different thumb-related muscles that were tested, volume changesgenerated significant muscular response, indicating a potential for fatigue. Different pipettedesigns can either reduce or increase the forces required for changing volume. A further studyby Lichty et al6 found a positive correlation between ease of volume adjustment and workerproductivity, probably because significant time is spent adjusting the volume setting duringroutine operation.Rainin reduced the forces associated with volume adjustment by providing a large easy-gripbutton and low-friction screw mechanism. An adjustable lock prevents the inadvertent changingof the volume setting between pipetting steps. With this combination an operator can easilyunlock, adjust and lock the volume setting mechanism with one hand and with minimal forcerequirements, (see Figure 7).Figure 7Setting the pipette volume with one hand6Pipetting once will not affect your hand, but pipetting hundreds of times over the course ofseveral hours certainly will. The chance of getting injured increases greatly with repetitive work.Fortunately there are several straight-forward solutions.The first kind of solution is to use products that do the work for you. Multichannel pipettes and96-well pipetting platforms reduce repetition by pipetting multiple samples at once. Electronicpipettes can semi-automate certain functions, such as dispensing multiple aliquots from asingle aspiration, automatically mixing, or automatically changing the programmed volumes ina pre-determined sequence.The second kind of solution is to modify pipetting habits to decrease the effects of repetitivework. Try to take regular breaks, switch hands, stretch your limbs and maintain good posture(minimize twisting of your shoulders, arms and wrists; manipulate objects at shoulder height orbelow).GripGrip comfort has been positively associated with reducing hand and arm discomfort6. Factorsimportant for grip comfort include the shape of the pipette body and fingerhook, and thedistance your thumb needs to reach to the top of the plunger. Try to grasp the pipette with aslittle force as necessary to maintain control.Conclusion and RecommendationsThe ergonomics of pipetting are generally well understood. Higher pipetting forces and longhours of pipetting are associated with developing RSIs. The following recommendations willassist researchers in minimizing their chance of developing RSIs.Look for lower plunger forcesCheck spring forces associated with the plunger.Compare new pipettes with old ones.Use electronic pipettes when possible.Service your pipettes regularly to maintain optimal mechanics.Keeping the piston and seals clean will both lower friction, thus reducing pipetting force,and maintain better accuracy and precision.Look for lower tip ejection forcesCompare the tip ejection forces of different pipettes. Consider that a pipette with a high tiploading force will probably have a high tip ejection force. Remember that multichannelpipettes have generally higher forces and can be particularly hard on the thumb.Other considerationsUse pipettes with a finger hook that fit comfortably in your hand without gripping tightly.Lower the forces associated with volume change by using a pipette with a volume lock,low-friction volume change mechanism and a large dial with good grip.Reduce repetitive pipetting by using electronic pipettes, multichannels and 96-wellpipetting platforms. Take breaks and, if possible, switch hands and stretch arms andhands.71 Björksten MG, Almby B, Jansson ES. Hand and shoulder ailments among laboratory technicians using modernplunger-operated pipettes. Appl Ergon. 1994 Apr;25(2):88-94.2 Kroemer KH. Cumulative trauma disorders: their recognition and ergonomics measures to avoid them. Appl Ergon.1989 Dec;20(4):274-80.3 McGlothlin JD, Hales TR. Health Hazard Evaluation Report at Scientific Application International Corporation,Frederick, Maryland. Cincinnati, OH: U.S. Department of Health and Human Services, Public Health Service, Centersfor Disease Control and Prevention, National Institute for Occupational Safety and Health. HETA Report No. 95-0294-2594. (August 1996.)4 Fredriksson K. Laboratory work with automatic pipettes: a study on how pipetting affects the thumb. Ergonomics.1995 May;38(5):1067-73.5 Asundi KR, Bach JM, Rempel DM. Thumb force and muscle loads are influenced by the design of a mechanicalpipette and by pipetting tasks. Hum Factors. 2005 Spring;47(1):67-76.6 Lichty MG, Janowitz IL, Rempel DM. Ergonomic evaluation of ten single-channel pipettes. Work. 2011;39(2):177-85.7 David G, Buckle P. A questionnaire survey of the ergonomic problems associated with pipettes and their usage withspecific reference to work-related upper limb disorders. Appl Ergon. 1997 Aug;28(4):257-62.Rainin Instrument, LLC7500 Edgewater Drive, Oakland, CA 94621 Phone +1 510 564 1600a METTLER TOLEDO CompanySubject to technical changes© 02/2012 Rainin Instrument, LLC Printed in USA WP-504 Rev A55% recycled fiber, 30% PCWFor more information /rainin。
安装部署CloudStack 4.0企业私有云平台Ubuntu安装方式参考资料CloudStack Installation_Guide/installation.htmlCloudStack Admin_guide/working-with-iso.htmlCloudStack Admin_guide/creating-vms.htmlCloudStack Admin_guide/create-templates-overview.html目录结构1. 什么是CloudStack2. 宿主机的系统需求3. 配置安装源4. 安装Management Server5. 安装配置KVM虚拟化Host主机6. 用户界面7. 配置Management Server8. 创建Instance类型9. 创建ISO安装源并创建Instance10. 创建并定制Template11. 通过定制的Template创建VM Instance12. 其它优化设置环境介绍OS: Ubuntu Server 12.04.1 64-bitServer:10.6.203.10 cloudstack-server-1- CloudStack Management Server- CloudStack Agent- NFS Server- MySQL Server注:CloudStack支持很好的分布式架构,上面- 代表的所有角色都可以部署在不同的机器上,但在测试环境中因为条件有限我全部都部署到了一台机器上。
1. 什么是CloudStackCloudStack是一个开源的具有高可用性及扩展性的云计算平台。
提到开源的云计算平台,相信大家首先想到的可能是OpenStack,目前国内的几家云计算平台如阿里云、盛大云以及新浪SAE貌似都基于OpenStack做了二次开发。
但使用过CloudStack之后,你会发现其实CloudStack更像是一个商业化过后的产品,有着非常好的用户界面,各个模块默认集成的很好,且安装与部署过程也相对容易一些。
Oracle虚拟化管理器安装升级指南手册Oracle Linux和虚拟化团队很高兴地宣布Oracle Linux虚拟化管理器4.4版本的发布。
Oracle Linux虚拟化管理器现在包含在Oracle Linux 8中,支持Oracle Linux 8基于内核的虚拟机(KVM)计算主机,并且基于开源oVirt项目的4.4版本。
可以轻松地部署此服务器虚拟化管理平台,以配置、监控和管理具有由Oracle提供的企业级性能和支持的Oracle Linux KVM环境。
收益除了操作数据中心所需的基本虚拟化管理功能外,Oracle Linux虚拟化管理器4.4版中添加的显著功能还包括:Oracle Linux 8上的引擎支持:此版本升级了引擎(管理器)主机,以在Oracle Linux 8上运行。
使用Oracle Linux 8运行引擎,最新的Oracle Linux版本支持更长的生命周期支持。
甲骨文Linux 8 KVM主机支持:甲骨文Linux虚拟化管理器用户现在可以将甲骨文Linux 8 KVM主机添加到他们的环境中。
除了运行最新版本的牢不可摧企业内核(UEK)外,更高级版本的KVM实用程序(QEMU,Linvix8 KVM还支持OracleLibvirt)。
更新到oVirt 4.4版本:最新的oVirt 4.4版本提供了对oVirt 4.3版本的许多增强和bug 修复。
Oracle Linux虚拟化管理器是一种优化和安全的服务器虚拟化技术,有助于加速数字转换。
它为混合云和多云部署提供了领先的性能和安全性。
支持的新功能Oracle Linux虚拟化管理器4.4是基于oVirt 4.4.8开源软件的。
这个升级版本有许多新功能,其中一些更值得注意的功能包括:Oracle Linux 8 KVM主机支持:OracleLinux7 KVM主机和Oracle Linux 8 KVM主机都可以在不同的集群中进行管理。
Oracle Retail Analytics and Planning Cloud ServiceNext Gen Cloud Update GuideMay 2023 | Release 23.1.201.0Copyright © 2023, Oracle and/or its affiliatesDisclaimerThis document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle software license and service agreement, which has been executed and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.This document is for informational purposes only and is intended solely to assist you in planning for the implementation and upgrade of the product features described. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.Due to the nature of the product architecture, it may not be possible to safely include all features described in this document without risking significant destabilization of the code.TABLE OF CONTENTSDisclaimer 1 Introduction 3 Document Summary 3 Overview of Next Generation SaaS Architecture 3 Assumptions 3 Getting Started 5 Customer Actions for Retail Planning Solutions 5 Updated Solution URLs 5 Authentication Changes 5 File Transfer Services 6 Retail Analytics and Planning Core Update 7 Retail Analytics and Planning Core Plus 8 Customer Actions for Retail Insights and AI Foundation Solutions 9 Updated Solution URLs 9 Authentication Changes 9 File Transfer Services 10 Customer Actions for POM 11 Update Service Endpoint URLs 11 Authentication Changes 11 References 12IntroductionDocument SummaryThis document provides general enablement for Oracle Retail customers moving to Oracle's Next Generation Retail Analytics and Planning SaaS architecture. These checklists and resources capture major customer activities and milestones. Retailers should use these checklists early in the Next Gen Cloud Update phase. The checklists allow retailers to ask key questions while working with technical staff and partners. In addition, the checklists provide considerations for implementation planning. Once completed, the checklists can be used to set expectations among all parties and saved for future reference. Overview of Next Generation SaaS ArchitectureAll of Oracle’s Planning, Retail Insights, and Retail AI Foundation Cloud Services are moving to Oracle’s Next Ge neration SaaS Architecture. This is a cloud-native architecture that provides a secure, highly scalable foundation with increased system availability. This new architecture yields the following benefits:▪Significantly reduced downtime.▪Full adoption of OAuth 2.0 for all REST services.▪Significant improvements in middle-tier and application-tier scalability.▪Improved, simplified intra-Oracle Retail integration.▪ A centralized Oracle Retail Business Intelligence instance for easier reporting administration.▪Retirement of SFTP in favor of a service-based approach. Refer to the "Managing File Transfers" section in the RAP Administration Guide.▪Version 19 should be read-only once the Next Gen production update is complete and and the environment is handed over to the customer.AssumptionsNote the following assumptions regarding the Next Gen Cloud Update:▪Update of a Non-production environment in the New Gen Cloud occurs first to enable the customer to perform their development activities and prepare before the Production update.▪All batch files in the Version 19 (or earlier) environment must be processed, and there should be no files remaining in the SFTP folder.▪Update activity will be performed after the Weekly or Nightly batch cycle in the version 19 environment is complete.No jobs should be pending.▪If all the Oracle Retail Cloud services are currently using the same IDCS or OCI IAM instance, then no changes should be made to the IDCS or OCI IAM. If you are using different IDCS or OCI IAM instances for different OracleRetail Cloud services, they will be merged into a single instance. There is then a customer action to reset thepasswords after the merge.Retail Analytics and Planning Solutions Next Gen Update ChoicesUpdating to the Next-Gen Architecture for these solutions is a complete update process and all features and functionality currently available are unchanged. This also covers any solution built on AIF:Inventory Optimization (IO)Promotion & Markdown Optimization (PMO)Offer Optimization (OO)Assortment & Space Optimization (ASO)There are two choices when updating Planning Solutions: Core Update and Core Plus Update. Refer to Planning Core Update vs Planning Core Plus Update for more information.Getting StartedTo get the process started, please reach out to your Customer Success Manager (CSM) to receive more information about Oracle’s next-generation architecture, discuss the steps laid out in this document, and identify target dates and timelines that you want to follow to complete the upgrade. You may also raise a Service Request in Oracle Support to obtain more information or to request that Oracle schedule the upgrade for you based on your business needs.Customer Actions for Retail Planning SolutionsDue to the technical changes in Oracle's Next Generation SaaS architecture, the actions below are to be performed by the customer. This section applies to any current customer of a Retail Planning or Supply Chain solution based on the Retail Predictive Application Server (RPAS) architecture.Oracle will provision next-gen Cloud Services environment and migrate your existing configurations and data before it is handed over to you for validation. For details, please refer to the following sections.Along with the steps mentioned below, please refer to Next Gen Update Video for detailed information.Updated Solution URLsAuthentication ChangesFile Transfer ServicesRetail Analytics and Planning Core UpdateRetail Analytics and Planning Core PlusAlong with Retail Analytics and Core Update, followingare the additional capabilities.Built on top of AI Foundation for Analytics, Reporting,Data Mining, Intelligence, and ForecastingPlans and Forecasts are sent/received to/from AIFoundation. Oracle Retail AI Foundation providesspecific insight and value to planning, buying, selling,and moving decisions through Customer Segmentation,Advanced Clustering, Demand Transference, AffinityAnalysis, and Size Profiling and can be expanded tosupport broader retail uses as required.Refer to the Oracle Retail Analytics and PlanningImplementation Guide for Planning integration with AIFoundation:Refer to the Retail AI Foundation Cloud Service guideshere for more information on AI Foundation:Customers choosing Core Plus are expected to use POMto schedule their batches.Customer Actions for Retail Insights and AI Foundation SolutionsDue to the technical changes in Oracle's Next Generation SaaS architecture, the actions below are performed by the customer. This section applies to any current customer of Retail Insights, AI Foundation, and all associated applications such as Offer Optimization and Inventory Optimization.Updated Solution URLsAuthentication ChangesFile Transfer ServicesCustomer Actions for POMPOM batch schedules will change in Next Gen SaaS Architecture. Please refer to the section “RPASCE Batch Schedule with POM” in the RPAS Administration Guide for information about setting up new schedules.Update Service Endpoint URLsAuthentication ChangesReferencesRefer to the Release 23.1.201.0 documentation at the following URL: https:///en/industries/retail/index.htmlCONNECT WITH USCall +1.800.Oracle1 or visit Outside North America, find your local office at /contact /oracle /oracleCopyright © 2023 Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only, and the contents hereof are subject to change withoutnotice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, withoutour prior written permission.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。
Oracle Cloud操作手册一、前言搭建和管理云评台是企业信息化建设中的重要环节,而Oracle Cloud作为全球领先的云服务提供商,其功能强大、安全可靠、性能出色的特点,备受企业青睐。
为了更好地使用Oracle Cloud,我们建立了本操作手册,帮助用户快速上手并熟练使用各项功能。
二、注册与登录1. 注册账号a) 打开Oracle Cloud官方全球信息湾,点击“免费注册”按钮进入注册页面;b) 填写相关信息,包括尊称、电流信箱、公司名称等,点击“注册”按钮完成注册。
2. 登录账号a) 返回Oracle Cloud官方全球信息湾,在首页顶部找到“登录”入口;b) 输入注册时使用的电流信箱和密码,点击“登录”按钮即可成功登录。
三、创建实例1. 选择实例类型a) 在控制台页面左侧导航栏中找到“实例”选项,并点击“创建实例”;b) 根据实际需求,选择适合的实例类型,如计算实例、数据库实例等。
2. 配置实例参数a) 在创建实例页面,填写实例名称、选择地域、配置资源大小等参数;b) 确认配置无误后,点击“创建”按钮,等待系统分配资源并启动实例。
四、存储管理1. 创建存储卷a) 在控制台页面左侧导航栏中找到“存储”选项,并点击“存储卷”;b) 点击“创建存储卷”按钮,填写相关信息并选择存储类型,最后点击“创建”按钮完成创建。
2. 挂载存储卷a) 进入实例详情页面,找到“存储”选项并点击“挂载存储卷”;b) 选择需要挂载的存储卷和挂载点,点击“确定”完成挂载。
五、网络配置1. 创建虚拟网络a) 在控制台页面左侧导航栏中找到“网络”选项,并点击“虚拟云网络”;b) 点击“创建虚拟云网络”按钮,填写名称、CIDR块等信息,最后点击“创建”按钮完成创建。
2. 子网管理a) 在虚拟云网络页面,找到已创建的虚拟网络,点击“管理子网”;b) 点击“创建子网”按钮,填写相关信息并选择可用域和路由表,点击“创建”按钮完成创建。
Oracle® CloudData Sync Getting StartedRelease 2.4DSGS-240February 2018Getting Started With Data SyncThis guide introduces Data Sync Version 2.4 and provides installation instructions.Data Sync loads and transforms data that you want to analyze into a target database,for example, Oracle Database Cloud Service or Essbase Cloud Service (Essbase).Topics:•Before You Start•Installing and Setting Up Data Sync•Connecting to Oracle Database Cloud Service Using SSH Tunneling•Connecting To Your Data Target and Data SourceBefore You StartTo install Data Sync, you must meet the requirements and prerequisites, download theapplication from Oracle Technology Network, then install and configure the software.PrerequisitesBefore installing, you must have Java V1.8.x (not V1.9.x) of Java Development Kit(JDK) and apply critical updates.Source Database SupportData Sync supports the following source database types:•Oracle•NetSuite•Microsoft SQL Server•DB2•Teradata•MySQL•Oracle TimesTen•Generic JDBC with prepackaged drivers for Greenplum, MongoDB, Salesforce, Redshift, Hive and PostgreSQL•Other sources that support JDBC•Oracle Transactional Business Intelligence:–Oracle Financials Cloud–Oracle HCM Cloud–Oracle Procurement Cloud–Oracle Project Management Cloud–Oracle Sales Cloud–Oracle Supply Chain Management Cloud•Oracle Service Cloud (RightNow)JDBC DriversData Sync is a Java application that uses Java Database Connectivity (JDBC). Data Sync is installed with Oracle JDBC Version 12.1.0.2.0. If you’re using a different database or version, then you must replace the installed Oracle JDBC version with the JDBC version that’s specific to your database. To replace the installed JDBC version, you copy the JDBC drivers from your Oracle database environment to the \lib directory on the machine where you installed Data Sync.Vendor JDBC Driver File nameOracle ojdbc7.jarMySQL Mysql-connector-java*.jarMicrosoft SQL Server sqljdbc.jarDB2db2java.zipTimesTen ttjdbc6.jar, orai18n.jar, timestenjmsxla.jar,jms.jar, javax.jms.jarTeradata terajdbc4.jar, log4j.jar, teradata.jar,tdgssjava.jar, tdgssconfig.jarSecurityOracle recommends that you only install Data Sync in protected environments because Data Sync stores connection information and passwords for your databases. Installing and Setting Up Data SyncTo install Data Sync, you download the software pack from Oracle Technology Network, install the software, then configure Data Sync.Download and Install Data Sync1.On the Data Sync Downloads site (/technetwork/middleware/bicloud/downloads/index.html), accept the OTN license agreement, and click the OAC Data Sync link to download the OACDataSync.zip file.2.Copy the OACSDataSync.zip file to an installation directory with no spaces in thefolder names (for example, c:\DataSync2_4), and extract the contents.Setting up the Java Home Environment VariableDepending on your operating system, edit the config.bat or config.sh file, and modify the line that sets the JAVA_HOME. Replace “@JAVA_HOME” with the directory where the JDK is installed. If your JDK directory name contains spaces, then put double-quotes around it.For example, on Windows:set JAVA_HOME=D:\JavaFor example, on UNIX:JAVA_HOME=usr/javaStarting Data SyncTo start Data Sync and its server, run datasync.bat (Windows) or datasync.sh (Linux/ UNIX) from the directory where you installed Data Sync. The Data Sync icon displays in your system icon tray to show that the server is running.•Select Start UI to open the Data Sync client. When you close the Data Sync client, the Data Sync server remains running.•Select Exit to stop the Data Sync server and close the Data Sync client if it is open.Alternatively, use these files:•datasyncClient.bat.sh opens the Data Sync tool (when the server is running).•stopserver.bat/sh stops the Data Sync server.Upgrading an Existing Data Sync InstallationIf your existing environment is using JDK V1.7, follow these steps to upgrade:1.Create a new Data Sync2.3 environment using JDK V1.8.2.From the old environment, export the metadata (from the Tools menu, thenExport, then and select all categories and projects).3.From the old environment,import the metadata (from the Tools menu, then Import, then and select allcategories and projects).e the new environment to upgrade to Data Sync V2.4.Running Data Sync for the First TimeThe first time you start the Data Sync client, the Configuration Setup wizard prompts you to enter the following information:•Logical Name. Specify a name for the repository to distinguish the repository in multi-repository environments. For example, you might name the instanceDevelopment Environment or Production Environment.•Password. Provide a password for accessing Data Sync. Optionally, use the Remember password option to specify whether Data Sync stores the password so that you don’t have to specify it each time you start Data Sync.Reconfiguring Data Sync With Its Default SettingsTo reset Data Sync with default settings and re-run the setup process, run datasync.bat (Windows) or datasync.sh (Linux/UNIX) in a command window with the -clean option.Uninstalling Data SyncTo uninstall Data Sync, delete the install directory.Connecting to Database As A Service Using SSH TunnelingBy default, Data Sync V2.4 communicates with Oracle Database Cloud Service using port 1521. Alternatively, you can configure Data Sync to communicate with DatabaseAs A Service using the Secure Shell (SSH) port 22 (this configuration is known as‘SSH Tunneling’).1.Close Data Sync and the Data Sync server.To stop the Data Sync server, click the Data Sync icon on the Windows tool bar and click Exit.2.Update your JDK/JRE with Java Cryptography Extension (JCE), which supportsUnlimited Strength.The default JDK doesn’t install the unlimited strength version of JCE (JavaCryptography Extension). You must install a version of JCE that's compatible with the Java version you're using for Data Sync. For example, you might download JCE V7 from /technetwork/java/javase/downloads/jce-7-download-432124.html, or JCE V8 from /technetwork/java/ javase/downloads/jce8-download-2133166.html.3.Unzip the contents of the downloaded JCE ZIP file and replace the local_policy.jarand US_export_policy.jar in $JAVA_HOME/jre/lib/security with the downloaded files.4.Start Data Sync.5.From the Views menu, click SSH Tunnels (Beta).6.Create a new entry to configure the port forwarding from the local machine to theremote host.Option What to specifyName A short descriptive name to identify this configuration inData Sync.Remote Host The IP address of the Database As A Service node.Remote SSH Port The SSH Port on the remote host, which is typically 22.User Name The user name for the remote server, which is typicallyopc.Private Key The SSH private key file that matches the public keyassociated with the deployment. When you create aDatabase As A Service instance, you create a public keyand a private key. The Public Key was used on instancecreation. The private key is used to connect to theinstance at the Operating System (OS) level. Downloadthis file and point the location of that key file.Passphrase The password that you specified when you created thedatabase deployment.Port Forward The database port on the remote host, which is typically1521.Local Port An unassigned port on the local machine that can be usedfor the tunnel. If you don’t know the port number to enter,click Find Available Port, and select a port.7.Save the details and test the connection.When you test a connection and it’s successful, Data Sync creates the SSHtunnel, and this SSH tunnel remains active as long as Data Sync is running.8.Configure the default TARGET connection or create a new database connection toyour Database As A Service instance by choosing Oracle (Thin) type connection.For the Host, use localhost, and for the Port, use the local port that you defined in Step 6.9.Create a project and load your data as normal.If for any reason the SSH tunnel closes (or is deactivated), then reported failures in the job will relate to IO Exceptions. From the Views menu, click SSH Tunnels (Beta), and correct any issues.Connecting to Your Data SourceIn Data Sync, navigate to the Connections tab and specify connection details for your target database and the data sources that you want to extract from.Connecting Data Sync to Your Data SourceOn the Connections tab, create a connection for each of your data sources. If you load data only from files, skip this task and access the Project-File Data dialog to specify the files and loading details. On the Connections tab, click New and specify the connection details of your data source.•In the User and Password fields, specify the user name and password for a user with sufficient reporting privileges for the data source.•In the URL field, specify the URL for your data source. For example, for Amazon Redshift you might enter: jdbc:redshift://bics-:1234/prod.•In the Connection Type field, select the appropriate data source type. For example, for Amazon Redshift, you select Generic JDBC.For additional information about specifying connections for JDBC, Oracle Service Cloud, or NetSuite, click Help.Connecting to a Oracle Database Cloud Service TargetIn Data Sync, navigate to the Connections tab and specify connection details for your target database and the data sources that you want to extract from.Connecting Data Sync To A Oracle Database Cloud Service Data TargetOn the Connections tab, edit the connection with the name TARGET, and specify the connection details of your database target.•In the Connection Type field, don’t change the connection type Oracle (BICS).•In the User and Password fields, specify the user name and password of a user appropriate Application Roles.The user must have BI Dataload Author to load data into a table, and DVContent Author to load data into a data set.•In the URL field, specify your Oracle Analytics Cloud URL. For example, https://. Do not use URL extensions. Connecting to an Essbase TargetIn Data Sync, navigate to the Connections tab and specify connection details for your target database and the data sources that you want to extract from.Connecting Data Sync To An Essbase TargetOn the Connections tab, edit the connection with the name TARGET, and specify the connection details of your database target.•In the Connection Type field, select Essbase.•In the User and Password fields, specify the user name and password of a user with the Application Role named BI Dataload Author.•In the URL field, specify your Essbase URL. For example, http://:9000/.Oracle® Cloud Data Sync Getting Started, Release 2.4DSGS-240Copyright © 2015, 2018, Oracle and/or its affiliates. All rights reserved.This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.This document introduces Oracle Business Intelligence Cloud Service Data Sync Version 2.2 and provides installation instructions.。
Upgrading to Oracle Solaris11.1 November2012This article details the steps required to upgrade your Oracle Solaris1111/11system to Oracle Solaris11.1 using the Image Packaging System(IPS),a feature of Oracle Solaris.Introduction to Upgrading a System to Oracle Solaris11.1 There are two main approaches for upgrading a system to Oracle Solaris11.1.■Using the Oracle Solaris support repository,for customers with an Oracle support agreement■Using the Oracle Solaris release repository,for customers without an Oracle support agreementUsing the Oracle Solaris Support RepositoryCustomers who have an Oracle support agreement can use the Oracle Solaris support repository as their configured package repository.If you are using the support repository,the package publisher definition should look like the following:%pkg publisherPUBLISHER TYPE STATUS URIsolaris origin online https:///solaris/supportThe release process for Oracle Solaris11was changed to accelerate the release of critical bug fixes.A consequence of this process is that the update might not contain some bug fixes released in a Support Repository Update(SRU)for the preceding release.For example,the most recent SRU for Oracle Solaris1111/11is SRU#12.4.Some packages in SRU#12.4have a version number that is higher than the version number in the Oracle Solaris11.1release.To preserve these bug fixes,the version difference will prevent the upgrade to the Oracle Solaris11.1release.If the upgrade process is not blocked because of the version numbers,some fixes that are part of the SRU will be removed if you upgrade to the Oracle Solaris11.1release.For convenience,these bug numbers are listed in“Bugs Fixed in Later SRUs”on page7.For instructions,see“Upgrading a System With a Support Agreement to Oracle Solaris11.1”on page3. Once an SRU for Oracle Solaris11.1is released,the process is simplified if you want to install the11.1release, as well as the latest SRU.For instructions,see“How to Upgrade a System to Oracle Solaris11.1With the Latest SRU”on page6.Using the Oracle Solaris Release RepositoryUsers who have installed Oracle Solaris11without an Oracle support agreement can use the Oracle Solaris release repository as their configured package repository.If you are using the release repository,the package publisher definition should look like the following:%pkg publisherPUBLISHER TYPE STATUS URIsolaris origin online /solaris/release/For instructions,see“How to Upgrade a System to Oracle Solaris11.1Using the Oracle Solaris Release Repository”on page7.Upgrading From Oracle Solaris10There are no upgrade methods or tools available to transition from Oracle Solaris10to Oracle Solaris11or 11.1.You must either do a fresh installation of Oracle Solaris11or migrate your Oracle Solaris10OS instances or zones to an Oracle Solaris11system.For more information,refer to Transitioning From Oracle Solaris10to Oracle Solaris11.Upgrading to Oracle Solaris11.1and ZonesAll of the zones on your system should automatically be upgraded when you upgrade the global zone.Make sure that you follow any specific instructions to deal with specific packages as noted in the following procedures.Upgrading to Oracle Solaris 11.1and Third-Party Packages In general,third-party packages are not touched during the upgrade process.Third-party services,and the software they deliver,will only be disturbed by the upgrade process when the service shares configuration files with the OS,or when the files are installed in directories that are written over by the upgrade process.Upgrading a System With a Support Agreement to Oracle Solaris 11.1The steps that are required might be different due to some systems running different SRU versions.First,follow the instructions in “How to Verify Which SRU a System Is Running”on page 3.Depending on the SRU that the system is running,perform one of the following procedures:■“How to Upgrade a System Running A SRU Before SRU#10.5”on page 4■“How to Upgrade a System Running SRU#10.5or SRU#11.4”on page 4■“How to Upgrade a System Running at Least SRU#12.4”on page 5Note –The amount of time each procedure takes is dependent on many factors,including system and network resources.▼How to Verify Which SRU a System Is Running Display the information about pkg:/entire .In this example,SRU#10.5is installed.%pkg info entire Name:entire Summary:entire incorporation including Support Repository Update (Oracle Solaris 1111/11SRU 10.5).Description:This package constrains system package versions to the same build.WARNING:Proper system update and correct package selection depend on the presence of this incorporation.Removing this package will result in an unsupported system.For more information see https:///CSP/main/article cmd=show&type=NOT&doctype=REFERENCE&id=1372094.1.Category:Meta Packages/Incorporations State:Installed Publisher:solaris Version:0.5.11(Oracle Solaris 11SRU 10.5)Build Release:5.11Branch:0.175.0.10.0.5.0Packaging Date:Fri Aug 0318:26:272012Size:5.45kB FMRI:pkg://solaris/**********.11,5.11-0.175.0.10.0.5.0:20120803T182627Z Package Information Displayed for Oracle Solaris 1111/11If your system has Oracle Solaris 1111/11installed,without any SRUs,the package information looks like:#pkg info entire Name:entire Summary:Incorporation to lock all system packages to the same build Description:This package constrains system package versions to the same build.WARNING:Proper system update and correct package selection depend on the presence of this incorporation.Removing this package will result in an unsupported system.Category:Meta Packages/Incorporations State:Installed Publisher:solaris Version:0.5.11Build Release:5.11Branch:0.175.0.0.0.2.0Packaging Date:October 20,201102:38:22PM●Example 1Size:5.45kB FMRI:pkg://solaris/**********.11,5.11-0.175.0.0.0.2.0:20111020T143822Z▼How to Upgrade a System Running A SRU Before SRU#10.5You can choose to update to SRU#10.5or to a later SRU release.Note that SRUs starting with SRU#12.4havecertain fixes that will not be present in Oracle Solaris 11.1until the first Oracle Solaris 11.1SRU is available.Verify which Solaris 11SRU you have installed.For instructions,see “How to Verify Which SRU a System IsRunning”on page 3.Become an administrator.For more information,see “How to Use Your Assigned Administrative Rights”in Oracle Solaris 11.1Administration:Security Services .Update the system.These commands create a new boot environment.■To update to SRU#10.5,use the following command:#pkg update --accept **********.11,5.11-0.175.0.10■To update to the latest SRU,use the following command:#pkg update --acceptReboot using the updated boot environment.#rebootFollow the instructions for upgrading the SRU that you installed in Step 2.■“How to Upgrade a System Running SRU#10.5or SRU#11.4”on page 4■“How to Upgrade a System Running at Least SRU#12.4”on page 5▼How to Upgrade a System Running SRU#10.5or SRU#11.4Verify that you have SRU#10.5or SRU#11.4installed.For instructions see “How to Verify Which SRU aSystem Is Running”on page 3.Become an administrator.For more information,see “How to Use Your Assigned Administrative Rights”in Oracle Solaris 11.1Administration:Security Services .SPARC only:For each zone,remove the ldomsmanager package.For any SPARC based system that has one or more zones installed,you must perform an additional step.Foreach zone installed on the system,remove the pkg:/system/ldoms/ldomsmanager package as follows:#for z in ‘zoneadm list‘;do zlogin $z pkg uninstall ldomsmanager;done Update the IPS package.#pkg update pkg:/package/pkgDue to earlier bugs in some packages,it was possible to incorrectly install those packages on a system.Thiscommand removes the following bad packages,if they are installed:■x86:pkg://solaris ldoms/ldoms-incorporation ■SPARC:pkg://solaris/consolidation/nvidia/nvidia-incorporationpkg://solaris/driver/network/ethernet/elxlBeforeYou Begin 1234BeforeYou Begin 123pkg://solaris/driver/network/ethernet/pcnpkg://solaris/driver/network/ethernet/dnetpkg://solaris/driver/network/ethernet/iprbUpdate the remaining system packages.#pkg update --be-name s11.1ga --acceptReboot using the updated boot environment.#reboot▼How to Upgrade a System Running at Least SRU#12.4If any of the following packages are installed,you must either remove them and add them back after theupdate to Oracle Solaris 11.1,or disassociate them from the constraints on the system (called unlocking ),asdescribed in this procedure:■pkg://solaris/network/dns/bind ■pkg://solaris/service/network/dns/bind ■pkg://solaris/mail/fetchmailFor SRU#13.4,the pkg://solaris/networkdhcp/isc-dhcp package must be removed or unlocked as well.Become an administrator.For more information,see “How to Use Your Assigned Administrative Rights”in Oracle Solaris 11.1Administration:Security Services .Adjust packaging for the DNS and fetchmail services.If you are not using these packages,you can remove them.If you have dependencies on these packages,youmust unlock them.Only follow this step if one or more of the three packages listed is installed on your server.■To remove the packages,run this command:#pkg uninstall pkg://solaris/network/dns/bind pkg://solaris/service/network/dns/bind\pkg://solaris/mail/fetchmailFor SRU#13.4,also remove pkg://solaris/network/dhcp/isc-dhcp .If you have any zones installed on your system,you must also uninstall these packages in each zone.Forexample:#for z in ‘zoneadm list‘;do zlogin $z pkg uninstall pkg://solaris/network/dns/bind;done■To unlock the packages,run this command:#pkg change-facet facet.version-lock.mail/fetchmail=false #pkg change-facet work/dns/bind=false #pkg change-facet work/dns/bind=falseFor SRU#13.4,also unlock pkg://solaris/network/dhcp/isc-dhcp .Note –To save time,it is possible to combine these commands into one command:#pkg change-facet facet.version-lock.mail/fetchmail=false \work/dns/bind=false \work/dns/bind=falseThe previous commands must be performed in each configured zone with the packages installed.Update the IPS package.#pkg update pkg:/package/pkg45123Update the rest of the packages.#pkg update --be-name s11.1ga --acceptReboot using the updated boot environment.#rebootReverse the changes to the DNS and fetchmail services.■If you removed the packages in Step 2,reinstall them.#pkg install pkg://solaris/service/network/dns/bind #pkg install pkg://solaris/mail/fetchmailNote –The first command installs pkg://solaris/network/dns/bind ,so it is not necessary to install that package.For SRU#13.4,also reinstall pkg://solaris/network/dhcp/isc-dhcp .■If you unlocked the packages in Step 2,when the first SRU is released for Oracle Solaris 11.1,lock thepackages.#pkg change-facet facet.version-lock.mail/fetchmail=true #pkg change-facet facet.version-lock.service/network/dns/bind=true #pkg change-facet work/dns/bind=trueRelocking the packages updates them as required.For SRU#13.4,also lock pkg://solaris/network/dhcp/isc-dhcp .Note –To save time,it is possible to combine these commands into one command:#pkg change-facet facet.version-lock.mail/fetchmil=true \work/dns/bind=true \work/dns/bind=true▼How to Upgrade a System to Oracle Solaris 11.1With the Latest SRUOnce the first SRU for Solaris 11.1is released,use the following procedure to upgrade to Oracle Solaris 11.1with the new SRU.Verify which Solaris 11SRU you have installed.For instructions,see “How to Verify Which SRU a System IsRunning”on page 3.Become an administrator.For more information,see “How to Use Your Assigned Administrative Rights”in Oracle Solaris 11.1Administration:Security Services .For early SRUs only:Upgrade to the latest Oracle Solaris 11SRU.Perform these steps only on systems running an SRU earlier than 10.5.a.Update the SRU.This command updates the OS to Oracle Solaris 11with the latest SRU.#pkg update --accept b.Reboot using the updated boot environment.#reboot456BeforeYou Begin 12For all SRUs:Update to Oracle Solaris 11.1with the latest SRU.#pkg update --accept --be-name s11.1sruReboot using the updated boot environment.#rebootBugs Fixed in Later SRUsThe following is a list of the bug fixes that have been addressed in SRU#12.4,but not in Oracle Solaris 11.1until SRU#1for 11.1is released.Kernel fixes:■7071362tcp_icmp_source_quench and other tunables may no longer be field modifiable ■7181137sol_umad should allow userland MAD operations in NGZs ■7196540After 7174929integration 0.9.0is shown for first disk in second RAID volumeOther software fixes:■7166132vim should be able to run its test suite ■7190213libibmad and associated files need to be delivered in an NGZ ■7191495mkisofs install is incomplete ■7195687Update fetchmail to version 6.3.2■7195704Problem with utility/fetchmail ■7196234Problem with network/dns ■7197223vim shows high CPU usage when editing dtrace script with syntax highlighting enabledThe following is a list of bugs that have been addressed in SRU#13.4,but not in Oracle Solaris 11.1untilSRU#1for 11.1is released.■15805793SUNBT7186501-11.2net-snmp crashes in net_cpu_arch_load ■15494128assertion failed:zvol_get_stats(os,nv)==0,when encounter i/o error ■15797349Problem with shell/korn93■15800889s11:zonestat core dumps when executed in non-global zone ■15816060update zoneinfo timezones to 2012f (Fiji)■15797515SUNBT7176189-12.0nfs4_write()can dirty too much pages during an unmount attemptUpgrading a System Without a Support Agreement toOracle Solaris 11.1Use the following procedure to upgrade a Oracle Solaris 1111/11system if you do not have a supportagreement,or have no SRUs installed.Note –The amount of time the procedure takes is dependent on many factors,including system and network resources.▼How to Upgrade a System to Oracle Solaris 11.1Using theOracle Solaris Release RepositoryUpgrading to Oracle Solaris 1111/11is a multistep process due to the requirement that certain systempackages must be updated first in order to achieve a successful update for the remaining system packages.34Become an administrator.For more information,see “How to Use Your Assigned Administrative Rights”in Oracle Solaris 11.1Administration:Security Services .Update the system packages.This command creates a new boot environment.#pkg update --acceptNote –For systems that cannot directly connect to Oracle's hosted package repositories,download the Oracle Solaris 11.1Pre-Upgrade Repository Image.This image contains packages that you must update prior toupdating to Oracle Solaris 11.1.See /technetwork/server-storage/solaris11/downloads/index.htm for more information.The ISO image contains a README file that describes thenecessary steps for constructing the repository and updating to Oracle Solaris 11.1.Reboot using the updated boot environment.#rebootSPARC only:For each zone,remove the ldomsmanager package.For any SPARC based system that has one or more zones installed,you must perform an additional step.Foreach zone installed on the system,remove the pkg:/system/ldoms/ldomsmanager package as follows:#for z in ‘zoneadm list‘;do zlogin $z pkg uninstall ldomsmanager;doneUpdate the IPS package.#pkg update pkg:/package/pkgUpdate the rest of the packages.#pkg update --be-name s11.1ga --acceptReboot using the updated boot environment.#reboot1234567Copyright©2012Oracle 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 ernment or anyone licensing it on behalf of the ernment,the following notice is applicable:ERNMENT END USERS.Oracle programs,including any operating system,integrated software,any programs installed on the hardware,and/or documentation,delivered to ernment 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 ernment.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.E38227-01Oracle Corporation500Oracle Parkway,Redwood City,CA94065U.S.A.。
Oracle uses AI, data, and the cloud to free enterprises to focus on businessPublication Date: 16 Nov 2018 | Product code: INT002-000188Tom PringleOvum viewSummaryOracle's annual global event, OpenWorld, brings high expectations of announcements about new capabilities to the vendor's infrastructure, platform, and applications solutions clients. This year, Oracle's overarching theme – the infusion of automation across its portfolio – did not break the cycle. Oracle announced the rollout of its Gen 2 cloud infrastructure, brought new focus to the Oracle Autonomous Database and analytics at the platform level, and is expanding the range of artificial intelligence (AI) capabilities baked into its applications, paired with expanded data-as-a-service options and conversational interfaces. Oracle's strategy is simple, albeit it based on complex technology: it is making its technology solutions smarter and easier to use to free enterprises' time and resources to focus on their own core businesses.Apps infused with AI alongside platform automation delivers cost saving efficiency while enabling revenue-adding effectivenessFollowing last year's announcement of the Oracle Autonomous Database, alongside the earlier launch of Oracle Adaptive Intelligent Apps and the more recent acquisition of , the growing wave of AI capabilities Oracle offers has made this white-hot technology a key feature for the vendor. The problem with white-hot technologies is that they tend to come with hyped-up, unrealistic expectations about what they can achieve. Oracle CEO Mark Hurd put forward his view that emerging technologies such as AI are "features, not solutions." This view is indicative of the approach taken by Oracle to offering AI – and other new technology such as blockchain – capabilities to its customers as integrated features available as part of broader solutions. The Oracle Autonomous Database (now for both transactional and data warehouse use cases) at the platform level and Adaptive Intelligent Apps at the applications level are perhaps the best examples of this, offering automation of work at a scale and speed beyond the capabilities of human users, helping reduce operating costs for enterprises while opening new opportunities to add business value.I have categorized this approach as offering efficiency benefits in the form of cost savings, while helping free time and resources to effectively grow the business. IT departments have long committed most of their resources to "keeping the lights on," managing a vast estate of, as Hurd put it, "Lego bricks" that represent the myriad IT capabilities on offer to enterprises. Using AI to automate large amounts of this humdrum, repetitive work that – while keeping the business running day to day – provides little additive business value is what delivers those efficiency benefits. Focusing on the Oracle Autonomous Database, its ability to self-manage, including updating and patching, frees database administrators from that manual labor to focus on making data available as a valuable enterprise resource. It also has benefits for the security of the enterprise by helping ensure that the latest versions of the software are in use – notably without necessitating planned downtime, a trickI've suggested is like trying to change the tires on a moving car.Oracle's Adaptive Intelligent Apps continues to expand its range of machine learning-powered capabilities for Oracle's applications portfolio. Starting its offer in the CX space, with solutions for common enterprise requirements such as next best offer and product recommendations, AdaptiveIntelligent Apps have now come to ERP and HCM. During OpenWorld, numerous senior Oracle executives discussed the use of AI in applications to augment users' experience with more insight and automate away tasks that are not value adding. This approach brings efficiency savings, but critically the injection of AI capabilities into enterprise applications' processes, which run quietly in the background, are where the value-adding effectiveness use cases – those that focus on adding revenue or enhancing profitability – are found.Buying AI as an embedded capability is not the only option Oracle offersThe Autonomous Database and Adaptive Intelligent Apps are firmly at the "buy" end of the build-versus-buy spectrum; this is not, however, the conclusion of Oracle's AI offering. Earlier this year, Oracle acquired , adding a solution designed to serve those enterprises interested in building their own AI capabilities. offers a platform that provides the much-feted data scientists with access to the open source tools and computing resources necessary to support their work, but in a more governed way that helps make IT's job of supporting them easier. Oracle's growing ability to address enterprises' requirements regardless of the type of AI they are interested in is an emerging advantage in the market.Making smarter applications easier to use with Digital AssistantThe Oracle Digital Assistant was unveiled at OpenWorld and is representative of a trend that continues to make steady progress in the world of enterprise IT: consumerization. This trend started with the revolution that was user-selected smart devices in the enterprise and their integration with corporate standards via BYOD policies. It has more recently surfaced with advances in self-service analytics that brought more "human" UIs and a visually driven approach to working data. Breaking into core enterprise applications like ERP, however, has – so far – made little progress. Oracle Digital Assistant is a conversational digital assistant that aims to change that. There is no reason to suggest that "talking" to ERP is impossible; in fact, dealing with common processes via a conversational interface is a long-overdue advancement in the way users work with applications.The Oracle Digital Assistant will allow users to interact with ERP, SCM, CRM, and HCM in this way, providing a platform and the tools required to build AI-powered assistants that can interact directly with those applications. Importantly, Digital Assistant supports popular conversational interfaces in the workplace such as Slack and WeChat, along with more consumer-focused products such as Amazon Echo and Google Home. In Ovum's view, as bots and digital assistants continue to gain traction in our work and home lives, open integration between them will be essential – the user may only deal with one interface, but behind the scenes multiple interactions will be required to deliver information and take action.Data makes automation workDuring OpenWorld, Oracle announced its acquisition of DataFox, a cloud-based AI data engine business that delivers B2B data to inform enterprise decision-making. Oracle has made substantial headway in the data-as-a-service business with its Data Cloud portfolio, backed by the acquisitions of BlueKai, Datalogix, and Moat, and the delivery of data to customers is a business in its own right. However, where DaaS gets even more interesting is when that data is used to enrich enterprises' own first-party data in, for example, CRM applications; this is a fundamental differentiator for Oracle AI Apps. Machine learning, which powers the overwhelming majority of realistic enterprise AI use cases,lives and dies by the data it runs on. Limited data? Limited results. For machine learning, more is more (assuming it is of sufficient quality). Augmenting enterprises' own data with curated, web-scale data sets substantially improves business outcomes by expanding the breadth and depth of the data sources available to machine learning. The acquisition's rationale is further expanded as the Data Cloud has primarily been focused on B2C data sources. While that team has been developing greater B2B capabilities, DataFox brings an AI-curated set of B2B sources into the fold and, in particular, adds insights into private companies whose activities are harder to uncover.In the immediate term, we expect the DataFox acquisition to be used primarily for enriching customers' own CRM data, surfacing relevant signals such as changes in intent that influence buying decisions or reveal new prospects. In the future, its additive potential as the DataFox AI engine and data is combined with other Oracle AI and data assets is exponential.Dig deeper into data by simplifying, connecting, and scaling analyticsNot all data analysis can be entirely automated, and analytics solutions still have a substantial role to play in allowing users to work with data outside of embedded capabilities found in other enterprise applications. Oracle Analytics Cloud was discussed under the labels of simplify, connect, and scale – three of the key challenges any veteran of analytics and business intelligence will be familiar with. They are the obstacles that need to be overcome to start leveraging data across the enterprise, particularly serving a much broader consumer base who are not technical experts and require point-and-click and natural language access to data and analytics capabilities.The theme of embedding AI and automation across Oracle's portfolio is a major component of how these challenges are being overcome. For example, simplifying the process by which enterprise users get from raw data to discovering useful and preferably actionable information is achieved by embedding machine learning into the Analytics Cloud to auto-create recommendations and visualizations. Driving easier data connections with machine learning-augmented data profiling, transformations, and automated suggestions improves the data used by analytics. Or using the cloud as a vehicle allows deployments of analytics at scale to much larger audiences, switching users on and embedding it in their go-to apps, rather than provisioning traditional services.Oracle categorized its approach in these solution areas as augmented analytics, a natural complement to the requirements it is aiming to serve – a larger, less technical user audience that requires a guided analytical experience that delivers useful intelligence from data using the latest techniques while shielding those users from its complexity.AppendixAuthorTom M. Pringle, Head of Technology Research, Ovum********************Ovum ConsultingWe hope that this analysis will help you make informed and imaginative business decisions. If you have further requirements, Ovum’s consulting team may be able to help you. For more information about Ovum’s consulting capabilities, please contact us directly at *******************. Copyright notice and disclaimerThe contents of this product are protected by international copyright laws, database rights and other intellectual property rights. The owner of these rights is Informa Telecoms and Media Limited, our affiliates or other third party licensors. All product and company names and logos contained within or appearing on this product are the trademarks, service marks or trading names of their respective owners, including Informa Telecoms and Media Limited. This product may not be copied, reproduced, distributed or transmitted in any form or by any means without the prior permission of Informa Telecoms and Media Limited.Whilst reasonable efforts have been made to ensure that the information and content of this product was correct as at the date of first publication, neither Informa Telecoms and Media Limited nor any person engaged or employed by Informa Telecoms and Media Limited accepts any liability for any errors, omissions or other inaccuracies. Readers should independently verify any facts and figures as no liability can be accepted in this regard – readers assume full responsibility and risk accordingly for their use of such information and content.Any views and/or opinions expressed in this product by individual authors or contributors are their personal views and/or opinions and do not necessarily reflect the views and/or opinions of Informa Telecoms and Media Limited.CONTACT US*********************INTERNATIONAL OFFICES BeijingDubaiHong KongHyderabadJohannesburgLondonMelbourneNew YorkSan FranciscoSao PauloTokyo。