ila's EVE Database V0.05

Cloud EssentialsRun Critical Databasesin the CloudOracle has the most complete data management portfolio for any enterprise workload.Cloud computing is transforming business practices and simplifying data center operations. However, when it comes to moving critical database assets to the cloud, many IT leaders are cautious—and rightly so. They have seen the limitations of popular commodity cloud solutions, which mostly consist of fragmented hardware and software offerings that must be manually configured. IT pros must build their own platforms on top of the service provider’s commodity infrastructure, migrate their data, and then figure out how to keep everything in sync with the apps and data still maintained on premise.Oracle Autonomous Database provides enterprise-level scalability, security, performance, and automation—at a level that often exceeds what you can achieve in your own data center. You can subscribe to complete database platforms with a few clicks, eliminating the need to provision, build, and manage in-house databases and storage systems. With pay-as-you-grow configurations—all managed by Oracle experts—your organization will obtain operational flexibility with zero up-front capital expenses. It’s a great way to lower operational costs becauseyou pay only for what you use.Read on to discover what a powerful cloud database can do foryour business.1C arl W. Olofson and David Schubmehl, “Oracle’s Autonomous Database: AI-Based Automation for Database Management and Operations,” IDC report, February 18, 2018, /us/products/database/idc-oracles-autonomous-database-4497146.pdf.Migrating to a Cloud Computing ModelModern businesses depend on their data more than ever before. That data is coming at an alarming rate, placing crushing demands on data marts, enterprise data warehouses, and analytics systems.Some businesses look to the cloud to help solve these scalability issues. However, most cloudproviders simply move familiar data management problems to a new infrastructure, and it’s up to you to keep the entire platform running efficiently. Industry research firm IDC found that as much as 75 percent of the total cost of database management can be attributed to labor.1Developing new applications using a cloud model can boost efficiency and reduce costs, but how do you achieve results that completely transform your business? The key to achieving this type of IT transformation is to move both existing and new applications to the cloud. To that end, Oracle’s complete cloud offering delivers a comprehensive data ecosystem in which a broad set of relatedcloud services work together automatically— and in many cases, autonomously.Oracle Cloud and Oracle Autonomous Database run on Oracle Cloud Infrastructure, a second-generation cloud offering that runs enterprise applications and databases with exceptional performance, scalability and security. For example, Oracle Cloud Infrastructure allows customers to independently scale compute and storage resources without restarts, instantly meeting the needs of any size business.All Oracle Cloud database offerings are 100 percent compatible with Oracle Database instances that have been deployed on premise, ensuring asmooth transition to the cloud and a flexible hybrid management strategy. You can migrate yourdatabases to Oracle Cloud with a single click, then monitor the environment in the same way that you monitor your on-premise databases—all from a single console. You can do it yourself or you can let Oracle handle everything for you, including backups, software patches, and upgrades.The World’s First and Only Autonomous DatabaseOracle Autonomous Database represents four decades of innovation with machine learning (ML) technology. This revolutionary database management system is available in two unique offerings.• O racle Autonomous Data Warehouse allows you to deploy new data marts, data lakes, and data warehouses to the cloud—or move existing ones from your datacenter to the cloud.• O racle Autonomous Transaction Processing is designed for high-performance, mission-criticaldatabases, mixed workloads and OLTP workloads.Both offerings are powered by Oracle Exadata, a high-performance database platform engineered for exceptional scalability, availability, and performance. Oracle automates patching, upgrades, and tuning—including performing all routine maintenance tasks while the database management system is running, without human intervention. Manually managed databases simply can’t compete. Oracle Autonomous Database leads the industry in price, performance, availability, and security.Self-driving.Oracle Autonomous Database eliminates human error whenprovisioning, securing, monitoring, backing up, recovering,troubleshooting, and tuning your database. In addition toreducing the need for manual input, it cuts costs and allowsyour IT staff to concentrate on higher-value tasks. And withadaptive machine-learning algorithms, the database canautomatically tune itself—allowing you to submit queries,visualize data, and share results without getting boggeddown by mundane data management tasks.Self-securing.Devastating security lapses can occur if patches are notapplied in a timely manner. Oracle Autonomous Databasepatches itself to avoid human errors or omissions. Itautomatically applies the latest security patches, reducingvulnerability and minimizing application downtime.Always-on encryption lets you control your own keysto further enhance security. Oracle Data Safe, now includedwith Autonomous Database, mitigates risk from risky users,sensitive data and misconfigurations.Self-repairing.Oracle Autonomous Database automatically recoversfrom any physical failures—at both the server and datacenter levels. In addition, by applying software updatesacross multiple nodes within a cluster, it ensures yourapplications remain online. With Artificial Intelligencediagnostics, Oracle Autonomous Database detectserrors by continually gathering statistics, analyzing theroot cause of problems, and resolving them quickly. Ituses AI to deliver unprecedented reliability, performance,and elasticity for deployments.For most businesses, success depends on maintaining system uptime. This requires a cloud architecture that can handle every threat that arises, from software and hardware failures to natural disasters and cyber attacks. However, despite the capabilities and convenience of cloud computing, these online systems have expanded the potential attack surface and introduced new risks, a situation that is exacerbated by today’s highly mobile workforce.As cyberthreats become more frequent and sophisticated, it is critical for businesses to ensure the resilience of their data and systems. Yet due to a significant shortage of cybersecurity expertise, it’s difficult to find enough security operations professionals to protect these systems. It’s an expensive problem: According to Security Today, the average cost of a data breach in 2018 wasUS$3.86 million, up 6.4 percent from the previous year, and the average cost of each stolen record containing sensitive and confidential information was US$148—a 4.8 percent increase from the previous year.2Autonomous technologies allow you to discover data breaches more quickly and often avert thementirely, reducing risks by using machines to fightmachines. Oracle Autonomous Database uses AIand machine learning technology to automate yourcyberdefenses. In addition, Oracle automaticallyapplies patches across the entire stack of softwarethat supports your applications, even whilethose apps are running—increasing uptime andminimizing the risk of human error.All Oracle Database access is monitored, recorded,and can be audited at any time. The data isencrypted—both in transit and while at rest. Oraclealso makes it easy to redact sensitive application-layer data, restrict privileged-user capabilities, maskdata in nonproduction environments, and monitorall user activities. Administrative access to yourOracle Database environment includes multiplesecurity zones to restrict access on a need-to-knowbasis for all IT staff. Oracle Data Safe adds securityand compliance solutions to mitigate risks thathave traditionally been considered the customers’responsibility, including risky users, sensitivedata and misconfigurations. Data Safe providessecurity risk assessments, user risk assessments,database activity auditing, sensitive data discoveryand data masking all in a simple, unified securitycontrol center.Did you know?Through 2022, Gartner projects that the cloudservices industry will grow nearly three times asfast as the IT services industry as a whole.32S 3“Cloud security for the entire lifecycle of data.• Data is encrypted by default in the cloud (in transit and at rest)• Data is classified for risk• Data is masked for DevTest activitiesIntelligent Business Analytics Require AutomationTraditionally, database administrators viewed each database deployment as unique. They were responsible for building, securing, repairing, tuning, and maintaining database assets. These endless cycles of maintenance required lots of skilled personnel, raising overall costs. Oracle Autonomous Database automates this lifecycle so you can innovate more, spend less, and keep your data secure.For example, Oracle Autonomous Data Warehouse gives you an easier way to store, access, and manage your analytics data. The self-tuning capabilities are preconfigured for automated patches and upgrades, helping you eliminate manual, error-prone management processes. The database detects available patches and automatically applies them, without human intervention. You can deploy a data warehouse in the cloud in 15 minutes, then expand or shrink computing and storage resources independently, with no downtime. You can also access cloud-based business intelligence and data integration services. Provisioning, patching, software updates, performance tuning, backups, and securitypatches are performed automatically.Automated Database ProvisioningRapid Provisioning ProcessesProvisioning an on-premise database is often a lengthy process, including finding space in the data center, procuring hardware resources, setting up storage volumes, allocating memory, configuring database instances, and much more. Oracle simplifies the provisioning process via a cloud portal interface and APIs that integrate with any management or orchestration tool. You can have a fully configured OracleAutonomous Database instance up and running in less than five minutes. After that, new database instances can be provisioned in minutes. This highly efficient model avoids the burden of having to maintain extra capacity.1Choose Autonomous Data Warehouse or Autonomous Transaction Processing.2Specify the name of the database.3Select how many CPU cores you need for your service.6Specify whether you want to use existing licenses or subscribe to new database licenses.A six-step process.Did you know?A full 71 percent of AI leader organizations have experienced revenue growth of more than 10 percent in the past two years, versus only 33 percent of AI laggards.44H arvard Business Review, “The Rise of Intelligent Automation: Turning Complexity into Profit,” HBR Pulse Survey, /a/ocom/docs/artificial-intelligence/hbr-pulse-survey.pdf.4Select thestorage capacity.5Set up administrator credentials.Autonomous Database Use CasesYou can migrate any OLTP or data warehouse workload to Oracle Autonomous Database and scale it as needed. There are several popular use cases.Application development and testing.DevTest is one of the leading use cases for the public cloud. Many companies form DevOps teams in which developers collaborate with operations personnel to create, test, troubleshoot, and improve applications as part of a continuous flow.These no-cost tools enable you to develop applications on top of Oracle Autonomous Database:• O racle Application Express (APEX) enables fast, low-code application development• O racle REST Data Services provides a seamless interface between Oracle Autonomous Database and anytechnology that can interact with RESTful services• O racle SQL Developer Web is available directly from the Oracle Autonomous Database service console• O racle Developer Cloud Service enables agile development methodologies and DevOps automation Sandbox environments.Some Oracle Database customers use Oracle Autonomous Database as a staging ground to practice upgrade procedures or try out new database features, such as transportable table spaces and pluggable databases. If you make a mistake, you can easily delete the database instance and start over.Data warehouses.Oracle Autonomous Database is ideal for data warehouse workloads, especially when a diverse or geographically dispersed workgroup needs to access analytics services.It reduces the cost and complexity of managing the infrastructure, allowing analysts to focus on extracting valuefrom their data. Once your data warehouse is in the cloud, people can access it from anywhere, allowing your entire team to utilize data warehouse assets and data to flow easily to key destination points—including to Oracle’s cloud-based business intelligence engine.Migrating Existing Workloads to the CloudDiscovering New Monetization OpportunitiesHigh-Performance Data ManagementFor high-performance data warehouses and OLTP applications, consider Oracle Autonomous Transaction Processing. Designed for high-performance, mission-critical databases and mixed workloads, this OLTP service delivers extreme performance for instant analytics. Backup and disaster recovery services.Oracle Database Backup Cloud includes enterprise-grade data encryption, compression, and protection for automated backup of your cloud data. You can also use Oracle Cloud to establish an offsite disaster recovery service, complete with Oracle Data Guard and Oracle Active Data Guard. Many customers use their backups as standby databases for reporting and analytics.Enterprise data warehousing Sandbox Environment Line-of-business data martsBackup and disaster Recovery to the CloudMigrate existing applications to Autonomous DatabaseData warehousing and cloud compute analytics High-performance data management Expansion of data warehouse to Oracle Big Data CloudYour Automated FutureAI technology is fundamentally altering enterprise computing by changing how organizations receive, manage, and secure business data. By 2025, Oracle predicts that 90 percent of all applications and services will incorporate AI at some level—and more than halfof all enterprise data will be managed autonomously. Oracle Autonomous Database represents an entirely new category of software based on machine learning that allows you to focus on your core business, worry less about day-to-day operations, and create opportunities for innovation. Oracle Cloud puts these emerging technologies to work by enabling customers to establish new IT capabilities quickly, affordably, and securely.Intelligence at every layer.Oracle’s complete, integrated cloud platform includes intelligent solutions that span the SaaS, PaaS, and IaaS layers. For example, Oracle embeds AI across its business applications to enable new, intelligent experiences. Oracle also extends ML into Oracle Autonomous Database—the world’s first and only self-driving database. It’s all deployed on a next-generation cloud infrastructure that provides the foundation for intelligent cloud services. Oracle is the only company delivering a complete and integrated set of cloud services, and the only company building intelligent solutions at every layer.sets Oracle apart from other DBaaS providers.registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.VDL51082 191022。

Oracle数据库教程—— Oracl e Database常用补丁集Patch号及各版本PSU Oracle Database常用补丁集Patch号及各版本PSUPatchset/PSU Patch Number Description11.2.0.4.0 13390677 11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER 11.2.0.3.8 16902043DATABASE PATCH SET UPDATE 11.2.0.3.8 (INCLUDES CPUOCT2013)11.2.0.3.7 16619892 DATABASE PATCH SET UPDATE 11.2.0.3.7 (INCLUDES CPUJUL2013)11.2.0.3.6 16056266 DATABASE PATCH SET UPDATE 11.2.0.3.6 (INCLUDES CPUAPR2013)11.2.0.3.5 14727310 DATABASE PATCH SET UPDATE 11.2.0.3.5 (INCLUDES CPUJAN2013):11.2.0.3.4 14275605 DATABASE PATCH SET UPDATE 11.2.0.3.4 (INCLUDES CPUOCT2012)11.2.0.3.3 13923374 DATABASE PATCH SET UPDATE 11.2.0.3.3 (INCLUDES CPU JUL2012):11.2.0.3.2 13696216 DATABASE PATCH SET UPDATE 11.2.0.3.2 (INCLUDES CPU APR2012)11.2.0.3.1 13343438 DATABASE PATCH SET UPDATE 11.2.0.3.1 (INCLUDES CPU JAN2012)11.2.0.3 10404530 11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER 11.2.0.2.11 16619893 DATABASE PATCH SET UPDATE 11.2.0.2.11 (INCLUDES CPUJUL2013)11.2.0.2.10 16056267 DATABASE PATCH SET UPDATE 11.2.0.2.10 (INCLUDES CPUAPR2013)11.2.0.2.9 14727315 DATABASE PATCH SET UPDATE 11.2.0.2.9 (INCLUDES CPUJAN2013):11.2.0.2.8 14275621 DATABASE PATCH SET UPDATE 11.2.0.2.8 (INCLUDES CPUOCT2012)11.2.0.2.7 13923804 DATABASE PATCH SET UPDATE 11.2.0.2.7 (INCLUDES CPU JUL2012)11.2.0.2.6 13696224 DATABASE PATCH SET UPDATE 11.2.0.2.6 (INCLUDES CPU APR2012)11.2.0.2.5 13343424 DATABASE PATCH SET UPDATE 11.2.0.2.5 (INCLUDES CPU JAN2012)11.2.0.2.4 12827726 DATABASE PSU 11.2.0.2.4 (INCLUDES CPUOCT2011)11.2.0.2.3 12419331 DATABASE PSU 11.2.0.2.3 (INCLUDES CPUJUL2011)11.2.0.2.2 11724916 DATABASE PSU 11.2.0.2.2 (INCLUDES CPUAPR2011)11.2.0.2.1 10248523 DATABASE PSU 11.2.0.2.111.2.0.2 10098816 11.2.0.2.0 PATCH SET FOR ORACLE DATABASE SERVER 11.2.0.1.6 12419378 DATABASE PSU 11.2.0.1.6 (INCLUDES CPUJUL2011)11.2.0.1.5 11724930 DATABASE PSU 11.2.0.1.5 (INCLUDES CPUAPR2011)11.2.0.1.4 10248516 DATABASE PSU 11.2.0.1.4 (INCLUDES CPUJAN2011)11.2.0.1.3 9952216 DATABASE PSU 11.2.0.1.3 (INCLUDES CPUOCT2010)11.2.0.1.2 9654983 DATABASE PSU 11.2.0.1.2 (INCLUDES CPUJUL2010)11.2.0.1.1 9352237 DATABASE PSU 11.2.0.1.111.1.0.7.17 17082366 [*]11.1.0.7.16 16619896 [*] DATABASE PATCH SET UPDATE 11.1.0.7.16 (INCLUDES CPUJUL2013)11.1.0.7.15 16056268 [*] DATABASE PATCH SET UPDATE 11.1.0.7.15 (INCLUDES CPUAPR2013)11.1.0.7.14 14739378 [*] DATABASE PATCH SET UPDATE 11.1.0.7.14 (INCLUDES CPUJAN2013)11.1.0.7.13 14275623 [*] DATABASE PATCH SET UPDATE 11.1.0.7.13 (INCLUDES CPUOCT2012)11.1.0.7.12 13923474 DATABASE PATCH SET UPDATE 11.1.0.7.12 (INCLUDES CPU JUL2012)11.1.0.7.11 13621679 DATABASE PATCH SET UPDATE 11.1.0.7.11 (INCLUDES CPU APR2012)11.1.0.7.10 13343461 DATABASE PATCH SET UPDATE 11.1.0.7.10 (INCLUDES CPU JAN2012)11.1.0.7.9 12827740 DATABASE PSU 11.1.0.7.9 (INCLUDES CPUOCT2011)11.1.0.7.8 12419384 DATABASE PSU 11.1.0.7.8 (INCLUDES CPUJUL2011)11.1.0.7.7 11724936 DATABASE PSU 11.1.0.7.7 (INCLUDES CPUAPR2011)11.1.0.7.6 10248531 DATABASE PSU 11.1.0.7.6 (INCLUDES CPUJAN2011)11.1.0.7.5 9952228 DATABASE PSU 11.1.0.7.5 (INCLUDES CPUOCT2010)11.1.0.7.4 9654987 DATABASE PSU 11.1.0.7.4 (INCLUDES CPUJUL2010)11.1.0.7.3 9352179 DATABASE PSU 11.1.0.7.3 (INCLUDES CPUAPR2010)11.1.0.7.2 9209238 DATABASE PSU 11.1.0.7.2 (INCLUDES CPUJAN2010)11.1.0.7.1 8833297 DATABASE PSU 11.1.0.7.1 (INCLUDES CPUOCT2009)11.1.0.7 6890831 11.1.0.7.0 PATCH SET FOR ORACLE DATABASE SERVER 10.2.0.5.12 16619894 [*] DATABASE PATCH SET UPDATE 10.2.0.5.12 (INCLUDES CPUJUL2013):10.2.0.5.11 16056270 [*] DATABASE PATCH SET UPDATE 10.2.0.5.11(INCLUDES CPUAPR2013)10.2.0.5.10 14727319 [*] DATABASE PATCH SET UPDATE 10.2.0.5.10 (INCLUDES CPUJAN2013):10.2.0.5.9 14275629 [*] DATABASE PATCH SET UPDATE 10.2.0.5.9 (INCLUDES CPUOCT2012)10.2.0.5.8 13923855 [*] DATABASE PATCH SET UPDATE 10.2.0.5.8 (INCLUDES CPU JUL2012)10.2.0.5.7 13632743 [*] DATABASE PATCH SET UPDATE 10.2.0.5.7 (INCLUDES CPU APR2012)10.2.0.5.6 13343471 [*] DATABASE PATCH SET UPDATE 10.2.0.5.6 (INCLUDES CPU JAN2012)10.2.0.5.5 12827745 [*] DATABASE PSU 10.2.0.5.5 (INCLUDES CPUOCT2011) 10.2.0.5.4 12419392 DATABASE PSU 10.2.0.5.4 (INCLUDES CPUJUL2011)10.2.0.5.3 11724962 DATABASE PSU 10.2.0.5.3 (INCLUDES CPUAPR2011)10.2.0.5.2 10248542 DATABASE PSU 10.2.0.5.2 (INCLUDES CPUJAN2011)10.2.0.5.1 9952230 DATABASE PSU 10.2.0.5.1 (INCLUDES CPUOCT2010)10.2.0.5 8202632 10.2.0.5.0 PATCH SET FOR ORACLE DATABASE SERVER 10.2.0.4.17 16619897 [*] DATABASE PSU 10.2.0.4.17 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUJUL2013):10.2.0.4.16 16056269 [*] DATABASE PSU 10.2.0.4.16 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUAPR2013)10.2.0.4.15 14736542 [*] DATABASE PSU 10.2.0.4.15 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUJAN2013):10.2.0.4.14 14275630 [**] DATABASE PSU 10.2.0.4.14 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUOCT2012)0.2.0.4.13 13923851 [*] DATABASE PSU 10.2.0.4.13 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUJUL2012)10.2.0.4.12 12879933 [*]DATABASE PSU 10.2.0.4.12 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUAPR2012)10.2.0.4.11 12879929 [*] DATABASE PATCH SET UPDATE 10.2.0.4.11 (PRE-REQ 10.2.0.4.4 | INCLUDES CPUJAN2012)10.2.0.4.10 12827778 DATABASE PSU 10.2.0.4.10 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUOCT2011)10.2.0.4.9 12419397 DATABASE PSU 10.2.0.4.9 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUJUL2011)10.2.0.4.8 11724977 DATABASE PSU 10.2.0.4.8 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUAPR2011)10.2.0.4.7 10248636 DATABASE PSU 10.2.0.4.7 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUJAN2011)10.2.0.4.6 9952234 DATABASE PSU 10.2.0.4.6 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUOCT2010)10.2.0.4.5 9654991 DATABASE PSU 10.2.0.4.5 (REQUIRES PRE-REQUISITE10.2.0.4.4 | INCLUDES CPUJUL2010) [overlay PSU]10.2.0.4.4 9352164 DATABASE PSU 10.2.0.4.4 (INCLUDES CPUAPR2010)10.2.0.4.3 9119284 DATABASE PSU 10.2.0.4.3 (INCLUDES CPUJAN2010)10.2.0.4.2 8833280 DATABASE PSU 10.2.0.4.2 (INCLUDES CPUOCT2009)10.2.0.4.1 8576156 DATABASE PSU 10.2.0.4.1 (INCLUDES CPUJUL2009)10.2.0.4 6810189 10.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER 10.2.0.3 5337014 10.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER10.2.0.2 4547817 10.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER10.1.0.5 4505133 10.1.0.5 PATCH SET FOR ORACLE DATABASE SERVER10.1.0.4 4163362 10.1.0.4 PATCH SET FOR ORACLE DATABASE SERVER10.1.0.3 3761843 10.1.0.3 PATCH SET FOR ORACLE DATABASE SERVER9.2.0.8 4547809 9.2.0.8 PATCH SET FOR ORACLE DATABASE SERVER9.2.0.7 4163445 9.2.0.7 PATCH SET FOR ORACLE DATABASE SERVER9.2.0.6 3948480 9.2.0.6 PATCH SET FOR ORACLE DATABASE SERVER9.2.0.5 3501955 ORACLE 9I DATABASE SERVER RELEASE 2 - PATCH SET 4 VERSION 9.2.0.5.09.2.0.4 3095277 9.2.0.4 PATCH SET FOR ORACLE DATABASE SERVER9.2.0.3 2761332 9.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER9.2.0.2 2632931 9.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER9.0.1.5 3301544 9.0.1.5 PATCHSET9.0.1.4 2517300 9.0.1.4 PATCH SET FOR ORACLE DATABASE SERVER9.0.1.3 2271678 9.0.1.3. PATCH SET FOR ORACLE DATA SERVER8.1.7.4 2376472 8.1.7.4 PATCH SET FOR ORACLE DATA SERVER8.1.7.3 2189751 8.1.7.3 PATCH SET FOR ORACLE DATA SERVER8.1.7.2 1909158 8.1.7.2.1 PATCH SET FOR ORACLE DATA SERVER更多文章可见：我们其中一位工程师的博客：/。

系统安装：光盘内文件说明：ilasdoc_help 目录：存放系统文档，简要的系统功能说明ilasII 目录：客户端程序ABC 目录：串文件ilasII_GB_SCO.tar 文件：服务器端的打包文件或ilasII_GB_SUN.tar 文件：服务器端的打包文件服务器端安装：准备工作：将服务器安装好，设定当前日期；客户端安装Windows98第二版或Windows 2000。

1、将ILASII V2.0 Server端IlasII2.0_sco.tar文件ftp上传到服务器(以二进制方式)，解包（当前路径为/u/ilasII）。

a).利用ftp将光盘下的ilasII_GB_sco.tar文件拷贝到服务器的根目录下，具体操作指令如下：c:\> ftp 202.117.112.97 (登录到服务器上)输入服务器的帐号和口令录到服务器:root******ftp>cd /u （到服务器上的根目录上）ftp>lcd D:\（到客户机的当前光驱所在的根目录下）ftp>bin （设置传送数据模式为二进制）ftp>prompt （取消系统提示）ftp>mput * （将本机当前目录下的所有文件传到服务器的/u路径下）b).用root登录到主服务器上# umask 0000# cd /u# tar xvf ilasII_GB_SCO.tar2、建立/ilas目录，拷入ilasII.ini文件。

(系统运行环境)# cd /# mkdir ilas# cd ilas# cp /u/ilasII/ilasII.ini /ilas编辑ilasII.ini符合如下形式：IP=202.117.112.97（服务器IP地址）PORT=27088 (使用的端口号)IlasPath=/u/ilasII（数据库服务器路径）LocalPath=/u/ilasII（系统服务器路径）3、建立开机和关机文件，将S99ilas拷入/etc/rc2.d，K03ilas拷入/etc/rc0.d。

Oracle 通用补丁安装操作手册1.概述近几年，随着我们用户ORACLE数据库的应用越来越深入，环境越来越复杂，一些ORACLE常见的BUG也会偶尔的被触发.因此，我们对技术人员要求不能再像以前一样只要求会安装数据库，还应该要求其掌握在遇到数据库BUG的时候,能够熟练的找到并安装对应的修复补丁才行。

因此该文档用于指导技术人员，能够查看和检查数据库环境的补丁安装情况，并对提供的ORACLE补丁文件进行安装操作。

2. ORACLE补丁体系ORACLE数据库同其他企业软件一样，正式版的发布和运维都要经过一个漫长的周期，当正式版发布后，在其生命周期内会oracle公司会在官网上定期发布更新补丁程序,根据发布周期和集合程度不同,它们分别是维护版本（Version）、补丁集（Patch Set)、关键补丁更新（Critical Patch Update）、补丁集更新(Patch SetUpdate）和小补丁（One—off patch）几类，下面简单的介绍下它们的区别.Ø Version/维护版本针对前一个维护版本的所有补丁进行整理，增加新的功能或对软件有较大的改动,进行整体测试，得到一个软件版本”包”，称为版本Version.比如 11.2Ø Patch Set/补丁集在两次产品版本之间发布的一组经过全面测试的累计整体修复程序（一般每年发布一两次)，如11.2。

0。

211.2。

0.3。

Ø Critical Patch Update(CPU)/关键补丁更新指每季度提供一次的一组高优先级修复程序（往往针对安全性问题)。

对于以前的安全性修复程序而言，这些CPU是累积的，只需要安装最近最后一个就可以，它就包含了之前的所有CPU补丁,但也可包含其他修复程序,目的是解决与非安全性补丁之间的补丁冲突问题（即降低合并请求的必要性）.目前已经更名为Security Patch Update (SPU）。

如何在AIX上运行PRM For Oracle Database?由于ParnassusData Recovery Manager PRM for Oracle Database 是基于JAVA语言编写的绿色工具软件，所以可以跨所有具有JVM的操作系统平台，其中包括:AIX、Solaris、HPUX、Linux 和Windows 。

在AIX上运行PRM的简单前提是：1、AIX已经安装JDK 1.6或以上版本2、如果数据库中存在中文或其他非英文字符，则需要在AIX安装对应的中文语言包，否则PRM将无法正常显示中文。

可以通过lslpp命令已经安装的JAVA包，lslpp –l|grep Java 注意这里Java的J大写！bash-4.2# lslpp -l | grep JavaJava5.sdk 5.0.0.430 COMMITTED Java SDK 32-bitJava5_64.sdk 5.0.0.430 COMMITTED Java SDK 64-bitJava6.sdk 6.0.0.280 COMMITTED Java SDK 32-bitJava6_64.sdk 6.0.0.385 COMMITTED Java SDK 64-bitJava5.sdk 5.0.0.430 COMMITTED Java SDK 32-bitJava5_64.sdk 5.0.0.430 COMMITTED Java SDK 64-bitJava6.sdk 6.0.0.280 COMMITTED Java SDK 32-bitJava6_64.sdk 6.0.0.385 COMMITTED Java SDK 64-bit注意如果上面没有出现Java6的包信息，则说明没有安装Java6。

可以下载Java6_64.sdk 下载地址：/s/1mg7ejxu下载完成后将tar解压，并smitty installp来安装该java.sdk包如果你不知道java可执行文件，可以通过如下的命令获得bash-4.2$ lslpp -f Java6.sdk|grep /bin/java/usr/java6/bin/java -> /usr/java6/jre/bin/java/usr/java6/jre/bin/javaw/usr/java6/jre/bin/java/usr/java6/jre/bin/javaws/usr/java6/jre/javaws/javaws -> /usr/java6/jre/bin/javaws/usr/java6/bin/javadoc/usr/java6/bin/javac/usr/java6/bin/javah/usr/java6/bin/javap/usr/java6/bin/javaw -> /usr/java6/jre/bin/javaw/usr/java6/bin/java-rmi.cgi/usr/java6/jre/bin/java_vm/usr/java6/bin/javaws -> /usr/java6/jre/bin/javawsbash-4.2$ /usr/java6/bin/java -versionjava version "1.6.0"Java(TM) SE Runtime Environment (build pap3260sr9fp2-20110627_03(SR9 FP2))IBM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 AIX ppc-32 jvmap3260sr9-20110624_85526 (JIT enabled, AOT enabled)J9VM - 20110624_085526JIT - r9_20101028_17488ifx17GC - 20101027_AA)JCL - 20110530_01将java bin目录加入到PATH中export PATH= /usr/java6/bin:$PATHbash-4.2$ cd /orahome/ParnassusData_PRMForOracle_3002chmod 700 prm.sh直接运行./prm.sh如果报错而未正确进入图形化界面，如下图：则可以运行：java –jar prm.jar安装AIX 6.1上的中文语言包可以见如下教程：AIX 6.1 有2张系统安装碟，安装中文字符集UTF、GB***需要2张系统碟交替安装进行。

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.。

Package‘GCD’October12,2022Type PackageTitle Global Charcoal DatabaseVersion4.0.7Date2020-10-26Author Global Paleofire Working Group<************************>Maintainer Olivier Blarquez<******************>Description Contains the Global Charcoal database data.Data include charcoalseries(age,depth,charcoal quantity,associated units and methods)andinformation on sedimentary sites(localisation,depositional environment,biome,etc.)as well as publications informations.Since4.0.0the GCD mirrors the on-line SQL database at<>.URL License GPL(>=2)Depends R(>=3.5.0)Suggests paleofireImports rasterLazyLoad yesEncoding UTF-8RoxygenNote7.1.1NeedsCompilation noRepository CRANDate/Publication2020-10-2619:30:07UTCR topics documented:GCD-package (2)basin_size (3)charcoal_methods (4)charcoal_units (4)date (5)12GCD-package date_type (6)depo_context (6)GCD-internal (7)lands_desc (7)mat_dated (7)paleofiredata (8)paleofiresites (8)pub (10)site_type (11)Index12 GCD-package GCD:Global Charcoal Database dataDescriptionThe GCD package provides Global Charcoal Database data updated at regular intervals to be used in cunjuction with the paleofire package.DetailsPackage:GCDType:PackageVersion: 4.0.0Date:2018-03-01License:GPL(>=2)Author(s)Global Paleofire Working Group<paleofire >ReferencesPower,M.,J.Marlon,P.Bartlein,and S.Harrison.2010.Fire history and the Global Charcoal Database:a new tool for hypothesis testing and data exploration.Palaeogeography,Palaeoclima-tology,Palaeoecology291:52-59.See AlsoExamplesbasin_size3 rm(list=ls())library(GCD)##Charcoal data:data(paleofiredata)head(paleofiredata)##Associated sites informations:data(paleofiresites)head(paleofiresites)basin_size Basin sizeDescriptionBasin sizeFormatA data frame with7observations on the following5variables.ID_BASIN_SIZE a numeric vectorBASIN_SIZE_CODE a character vectorBASIN_SIZE_DESC a character vectorBASIN_SIZE_RANGE_MIN a character vectorBASIN_SIZE_RANGE_MAX a character vectorExamplesdata(basin_size)##maybe str(basin_size);plot(basin_size)...4charcoal_units charcoal_methods Extraction methodsDescriptionCharcoal extractions methods present in the databaseFormatA data frame with13observations on the following3variables.ID_METHOD a factor with levels ACID CPRO GRAV HNPK HVLQ IMAG NOTK OPPF OTHE POLS SIEV SIPO THSLMETHOD a factor with levels Acidification of sample using gas chromatography to measure elemental carbon(Verardo etal1990)charcoal part Ided as opaque phytoclasts/pyrofusinite in palynofacies anlaysis Charcoal part.Identified in thin slides(soil micromorphology)Charcoal particles identified by imaging software Charcoal separated by heavy liquidpreparation Cumulative probability(95%confidence interval)alluvial soil charcoalGRAVIMETRIC chemical assay(Winkler method)Hand picked charcoal from soil samplesNot known Other Pollen slide Sieved Sieved+PollslideMETH_CODE a numeric vectorExamplesdata(charcoal_methods)##maybe str(charcoal_methods);plot(charcoal_methods)...charcoal_units Charcoal unitsDescriptionCharcoal units used in GCDFormatA data frame with169observations on the following4variables.unit a factor with levels%125%DWT%TOF%WTO100P10121220142214243869501550756914 751077387PRA8POS ABSC ARCC AREA ARPG BCCT C004C010C01K C040C100C120C125C140C150C180C250C65X CARE CCMY CG2M CHCO CHRX CM10CMGR CMML COML CP20CPARCPRA DC13FRAG G05I G10I G250GCHG GCMY GRG1GRGR GRPC GT05GT10GT12GT15GT18GT1M GT24GT25GT2X GT30GT38GT50GT53GT5C LT12LT13LT18LT1M LT25LT40M2GRM2ML MCM3MM2C MM2G MMDW MMML MT10MULT NOTK ORDI OTHE PCM1PCMY PHYT PP25PP51date5 PP52PPML PPOL PRAB PROB PTC0PTC2PTC3PTCT PX25SQC0SQCU SQCY SQG1SQG5SQL5 TOCA TOM1TOM2TOM3TOM4TOM5TOM6TOM7TOM8TOM9TOMX TOTA UCMY V025V100V125 V255V501X01K X105X106X120X125X150X15G X160X180X18C X20P X250X25P X310 X37P X459X500X50U X512X515X520X53C X550X55P X55U XA1K XARE XARP XARS XC25 XCM3XCOP XFML XFRG XFRP XFRS XIMG XPEA XPEE XPIX XRIFqtype a factor with levels C0P0CONC INFL NOTK OTHE SOILtype a character vectorcode a numeric vectorExamplesdata(charcoal_methods)##maybe str(charcoal_methods);plot(charcoal_methods)...date Date tableDescriptionTable with the dating information contained in GCDFormatA data frame with4872observations on the following8variables.ID_SITE a numeric vectorDATE_LAB_NUMBER a factor with many levelsDEPTH a numeric vectorTICKNESS a numeric vectorAGE a numeric vectorERROR a numeric vectorID_DATE_TYPE a numeric vectorID_MAT_DATED a factor with levelsobtained~~Examplesdata(date)##maybe str(date);plot(date)...6depo_context date_type Type of dates in date.rdaDescriptionType of dates in date.rdaFormatA data frame with31observations on the following4variables.ID_DATE_TYPE a numeric vectorDATE_TYPE_CODE a character vectorDATE_TYPE_NAME a character vectorDATE_TYPE_NUMBER a numeric vectorobtained~~Examplesdata(date_type)##maybe str(date_type);plot(date_type)...depo_context Depositional contextsDescriptionDepositional contextsFormatA data frame with17observations on the following4variables.ID_DEPO_CONTEXT a numeric vectorDEPO_CONTEXT_CODE a character vectorDEPO_CONTEXT_NAME a character vectorDEPO_CONTEXT_NUMBER a numeric vectorExamplesdata(depo_context)##maybe str(depo_context);plot(depo_context)...GCD-internal7 GCD-internal Internal GCD DataDescriptionInternal GCD Datalands_desc Landscape description elementsDescriptionLandscape description elementsFormatA data frame with20observations on the following3variables.ID_LANDS_DESC a numeric vectorLANDS_DESC_CODE a character vectorLANDS_DESC_NAME a character vectorExamplesdata(lands_desc)##maybe str(lands_desc);plot(lands_desc)...mat_dated Material DatedDescriptionMaterial DatedFormatA data frame with23observations on the following4variables.ID_MAT_DATED a numeric vectorMAT_DATED_STANDARD_LEVEL a character vectorMAT_DATED_TYPE a character vectorMAT_DATED_HIGH_LEVEL a character vectorobtained~~Examplesdata(mat_dated)##maybe str(mat_dated);plot(mat_dated)...paleofiredata GCD Charcoal dataDescriptionCharcoal series from the Global Charcoal DatabaseFormatA data frame with134269observations on the following4variables.ID_SITE a numeric vectorDEPTH a numeric vectorEST_AGE a numeric vectorQUANTITY a numeric vectorMETHOD a factor with levels ACID CPRO GRAV HNPK HVLQ IMAG NOTK OREC OTHE POLS SIEV UNIT a factor see paleofiresites for detailsTYPE a factor with levels C0P0CONC INFL NOTK OTHE SOILExamplesdata(paleofiredata)##maybe str(paleofiredata);plot(paleofiredata)...paleofiresites GCD sites informationDescriptionSites description and featuresFormatA data frame with881observations on the following17variables.id_site sites primary key from GCD v4.x.xid_site_old sites primary key from GCD v3.x.x,deprecatedpref_units a factor,see help("charcoal_units")and data("charcoal_units")for detailssite_name a character vectorlat a numeric vectorlong a numeric vectorelevation a numeric vector of elevationscountry a character vectorcontinent a factor with levels Africa Antarctica Asia Australia Europe North America South AmericaISO3ISO3code by countrynum_dating a numeric vectormin_est_age a numeric vectormax_est_age a numeric vectornum_samp a numeric vectorhas_depth factor indicating presence of depths associated to agesdate_int a numeric vector,interval in years between two datesqtype a factor,see help("charcoal_units")and data("charcoal_units")for detailswater_depth a numeric vectordepo_context a character vector,see help("depo_contex")and data("depo_contex")for details id_site_type a character vector,see help("site_type")and data("site_type")for detailsid_basin_size a character vector,see help("basin_size")and data("basin_size")for detailsid_lands_desc a character vector,see help("lands_desc")and data("lands_desc")for details l12a numeric vector,Levavasseur et al.2012rf99a numeric vector,Ramankutty et al.1999gcd_version main GCD releasesnum_version a numeric vector:version number401meaning4.0.1update_date date of data update in the GCDDetailsl12levels0=Water1=Boreal forest2=Desert vegetation3=Grassland and dry shrubland4=Savannas abd dry woodlands10pub 5=Temperate forest6=Tropical forest7=Tundra8=Warm temperate9=Warm desert10=Cold desertrf99levels0=Water1=Tropical Evergreen Forest/Woodland2=Tropical Deciduous Forest/Woodland3=Temperate Broadleaf Evergreen Forest/Woodland4=Temperate Needleleaf Evergreen Forest/Woodland5=Temperate Deciduous Forest/Woodland6=Boreal Evergreen Forest/Woodland7=Boreal Deciduous Forest/Woodland8=Evergreen/Deciduous Mixed Forest/Woodland9=Savanna10=Grassland/Steppe11=Dense Shrubland12=Open Shrubland13=Tundra14=Desert15=Polar Desert/Rock/IceReferencesRamankutty,N.,and J.A.Foley(1999).Estimating historical changes in global land cover:crop-lands from1700to1992,Global Biogeochemical Cycles13(4),997-1027.Levavasseur,G.,M.Vrac,D.M.Roche,and D.Paillard.2012.Statistical modelling of a new global potential vegetation distribution.Environmental Research Letters7:044019.Examplesdata(paleofiresites)##maybe str(paleofiresites);plot(paleofiresites)...pub Publication ListDescriptionList of GCD publications with DOI and link.site_type11Usagedata("pub")FormatA data frame with664observations on the following4variables.id_pub a numeric vectorcitation a character vectorlink web adressesDOI DOIExamplesdata(pub)##maybe str(pub);plot(pub)...site_type Type of sitesDescriptionType of sitesFormatA data frame with53observations on the following4variables.ID_SITE_TYPE a numeric vectorSITE_TYPE_LEVEL a character vectorSITE_TYPE_DESC a character vectorSITE_TYPE_HIGH_LEVEL a character vectorExamplesdata(site_type)##maybe str(site_type);plot(site_type)...Index∗charcoalGCD-package,2∗datasetsbasin_size,3charcoal_methods,4charcoal_units,4date,5date_type,6depo_context,6lands_desc,7mat_dated,7paleofiredata,8paleofiresites,8pub,10site_type,11∗fireGCD-package,2∗globalGCD-package,2∗paleoGCD-package,2∗sedimentsGCD-package,2basin_size,3charcoal_methods,4 charcoal_units,4date,5date_type,6depo_context,6GCD(GCD-package),2GCD-internal,7GCD-package,2Internal(GCD-internal),7 lands_desc,7mat_dated,7paleofiredata,8paleofiresites,8,8PNV_L12(GCD-internal),7PNV_RF99(GCD-internal),7pub,10pub_key(GCD-internal),7release(GCD-internal),7site_type,1112。

Oracle Database 12c RAC for AIX 7.1一、安装说明服务器：IBM Power 750（两台）共享存储：华为DS6800OS：AIX 7.1.3ORACLE：12.1.0.1.0网络（hosts文件解析）：二、环境检查查看内存：# lsattr-E -l sys0 -a realmem系统架构：# getconf HARDWARE_BITMODE（或# bootinfo -K或# getconf KERNAL_BITMODE//输出64才可以查看Swap空间：# lsps -a，使用chps -s增加目录大小：# df -g（默认的不太大，最好扩展一下smitty chfs）检查软件包：# lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstatbos.perf.perfstat bos.perf.proctools rsct.basic.rte pat.clients.rte xlC.aix61.rte.11.1.0.4 xlC.rte.11.1.0.4（最后两个有版本要求）相关补丁：# instfix -i -k "IV16737IV21116 IV21235 IV28925 IV34869 IV35057 IV39136 IV41415 IV45072 IV45073"由于系统版本7.1.3，安装系统时已包括相关补丁集，安装过程中会有相关WARNING，忽略即可安装12c必须的其它软件包：ssh——建立信任关系、安装过程scp都需要的sshbash——如没有此包，安装GRID时会报INS-06001 Failed toperform operation due to internal driver errorunzip——AIX默认不支持.zip解压1.安装ssh相关包，一般系统盘中就有，smitty installp或mkdir dvdmount -v cdrfs -o ro /dev/cd0 /mnt/dvdcd /mnt/dvd/usr/sys/inst.immagesinstallp -ac -Y -d . openssh.base openssl.base openssl.man.en_US openssh..man.en_US①在/etc/security/login.cfg文件中，将usw下auth_type的默认值std_auth改为pam_auth②/etc/pam.conf中添加sshd auth required pam_aixsshd account required pam_aixsshd password required pam_aixsshd session required pam_aix③将/etc/ssh/sshd_config中#LoginGraceTime 2m改为 LoginGraceTime 0④重启sshstopsrc -s sshdstartsrc-s sshd2.bash需要网上下载（ftp:///gnu/bash/ 据说版本没有限制）后，上传到服务器，使用root用户执行：# rpm -ivh bash-4.2-1.aix6.ppc.rpm在/etc/security/login.cfg的usw:下添加/usr/bin/bash（此操作不知道是不是有效）3. 同样下载unzip_aix.Z文件，上传到服务器，解压uncompress unzip_aix（这里使用刻盘上传时会把.Z改为.z，解压前要改回来，否则报错）chmod 751 unzip将文件cp到/usr/bin# cp -v /u01/unzip_aix /usr/bin/unzip三、系统参数查看异步io：# ioo-a |grep aio_maxreqs（此版本为131070，不用修改）虚拟内存参数：# vmo –aF 与下面值不一致时，修改为下面值（调整后重启生效）：vmo -p -o minperm%=3vmo -p -o maxperm%=90vmo -p -omaxclient%=90vmo -p -olru_file_repage=0vmo -p -ostrict_maxclient=1vmo -p -o strict_maxperm=0系统分配的块大小（建议值128-1024）：chdev-l sys0 -a ncargs=1024用户允许的最大进程数：chdev–l sys0 –a maxuproc=16384网络参数：no -a | more查看兼容性：lsattr –E –l sys0 –a pre520tune1.如返回结果是pre520tuneenable Pre-520 tuning compatibity mode True，在/etc/添加如下：if [ -f /usr/sbin/no ] ; then/usr/sbin/no -o udp_sendspace=65536/usr/sbin/no -o udp_recvspace=655360/usr/sbin/no -o tcp_sendspace=65536/usr/sbin/no -o tcp_recvspace=65536/usr/sbin/no -o rfc1323=1/usr/sbin/no -o sb_max=4194304/usr/sbin/no -o ipqmaxlen=512fi2.如返回结果是pre520tunedisable Pre-520 tuning compatibity mode True，执行下面命令no -r -o ipqmaxlen=512 //此参数要求重启系统生效no -p -o rfc1323=1no -p -o sb_max=4194304no -p -o tcp_recvspace=65536no -p -o tcp_sendspace=65536no -p -o udp_recvspace=655360no -p -o udp_sendspace=65536其它网络参数：no -p -o tcp_ephemeral_low=9000-o tcp_ephemeral_high=65535no -p -o udp_ephemeral_low=9000-o udp_ephemeral_high=65535关闭NTPmv -v /etc/ntp.conf /etc/ntp.conf.bakstopsrc -s xntpd修改用户限制，将/etc/security/limits文件中部分内容如下：default:fsize = -1core = -1cpu = -1data = -1rss = -1stack = -1nofiles = -1四、添加IP解析、创建用户等信息在/etc/hosts添加解析地址（使用hosts解析IP）192.168.10.1 nc180p001192.168.10.2 nc180p002192.168.10.3 nc180p001-vip192.168.10.4 nc180p002-vip10.10.10.1 nc180p001-pri10.10.10.2 nc180p002-pri192.168.10.5 racscan创建组mkgroup -'A' id='1000' adms='root' oinstallmkgroup -'A' id=' 1001' adms='root' dbamkgroup -'A' id='1002' adms='root' opermkgroup -'A' id='1003' adms='root' asmadminmkgroup -'A' id='1004' adms='root' asmopermkgroup -'A' id='1005' adms='root' asmdba创建用户mkuser id='1000' pgrp='oinstall'groups='dba,asmdba,oper,asmadmin,asmdba’home='/home/grid' –s /usr/bin/bash gridmkuser id='1001' pgrp='oinstall'groups='dba,oper,asmadmin,asmdba,asmoper' home='/home/oracle' –s /usr/bin/bash oracle修改密码echo oracle | passwd --stdin oracleecho oracle | passwd --stdin grid添加用户能力lsuser -a capabilities gridchusercapabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE grid lsuser -a capabilities oraclechusercapabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle信任关系（可选）1.生成密钥对（两个节点，两个用户oracle,grid）ssh-keygen -t rsassh-keygen -t dsa2.配置信任关系（一个节点）cat .ssh/id_rsa.pub>>.ssh/authorized_keyscat .ssh/id_dsa.pub>>.ssh/authorized_keysssh nc180p002 cat .ssh/id_rsa.pub>>.ssh/authorized_keysssh nc180p002 cat .ssh/id_dsa.pub>>.ssh/authorized_keysscp .ssh/authorized_keysnc180p002:~/.ssh3.验证信任关系（两个节点，两个用户）ssh nc180p002 datessh nc180p002-pri datessh nc180p001 datessh nc180p001-pri date创建目录设置权限mkdir -p /u01/app/11.2.0/gridmkdir -p /u01/app/oraclechown -R grid:oinstall /u01chown oracle:oinstall /u01/app/oraclechmod -R 775 /u01/共享存储生成PV：chdev -l hdiskn -a pv=yes设置共享文件系统的权限供grid和oracle用户使用1.改变用于数据库存储的PV的属主chown grid:asmadmin /dev/rhdisk[2-12]2.改变用于数据库存储的PV的权限chmod 660 /dev/rhdisk[2-12]3.检测和设置保持策略lsattr -E -l hdisk[2-12] | grep reserve_设置保持策略:chdev -l hdisk[2-12] -areserve_policy=no_reserve (如果是reserve_policy)chdev -l hdisk[2-12] -areserve_lock=no (如果是reserve_lock)添加环境变量节点1上Oracle用户，在~/.bash_profile文件umask 022export EDITOR=viexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export ORACLE_SID=ora11g1exportPATH=.:${PATH}:$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:${LD_LIBRARY_PATH}export NLS_LANG=AMERICAN_AMERICA.UTF8 #此变量最好安装完再加上节点2上Oracle用户，在~/. bash_profile文件添加：umask 022export EDITOR=viexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export ORACLE_SID=ora11g2export PATH=.:${PATH}:$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:${LD_LIBRARY_PATH}export NLS_LANG=AMERICAN_AMERICA.UTF8#此变量最好安装完再加上节点1上Grid用户，在~/. bash_profile文件添加：umask 022export EDITOR=viexport ORACLE_BASE=/u01/app/gridexport GRID_HOME=/u01/app/11.2.0/gridexport ORACLE_SID=+ASM1exportPATH=.:${PATH}:$ORACLE_HOME/bin:/usr/bin:/bin::/usr/local/binexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:${LD_LIBRARY_PATH}节点2上Grid用户，在~/. bash_profile文件添加umask 022export EDITOR=viexport ORACLE_BASE=/u01/app/gridexport GRID_HOME=/u01/app/11.2.0/gridexport ORACLE_SID=+ASM2export PATH=.:${PATH}:$ORACLE_HOME/bin:/usr/bin:/bin:/usr/local/binexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:${LD_LIBRARY_PATH}五、安装GI1.解压grid两个安装包cd /u01unzip aix.ppc64_12c_grid_1of2.zipunzip aix.ppc64_12c_grid_2of2.zip2.解压目录属主改为grid用户cd /u01chmod -R grid:oinstsall grid/3.进入解压目录执行使用root用户rootpre.sh，将此文件传到第二个节点同样使用root 执行cd /u01/grid./rootpre.sh4.grid用户进入解压目录验证su - gridcd /u01/grid./runcluvfy.shstage -pre crsinst -n nc180p001,nc180p002 -fixup -verbose5.开始安装：$ ./runInstaller输入Y，回车继续进入图形界面。

ORACLE 9I FOR AIX 5L 的安装文档ORACLE 9I FOR AIX 5L 的安装文档作者：safe第一节：安装注意：因为ORACLE 9I为64位，所以安装的AIX平台也必须是64位。

如果不是必须要重新安装或使用连接库函数将其改为64位To change to 64 bit multi-processor mode:# ln -sf /usr/lib/boot/unix_64 /unix# ln -sf /usr/lib/boot/unix_64 /usr/lib/boot/unix# bosboot -ad /dev/ipldevice# shutdown -r一、确认系统环境1、主机环境机型：IBM P630 υCPU ：1000MHz υMEM ：1G （MIN υ 512M）$ /usr/sbin/lsattr -E -l sys0 -a realmemrealmem 12582912 Amount of usable physical memory in Kbytes False/tmp：1000M （MIN 500M） υ$df -k /tmpFilesystem 1024-blocks Free %Used Iused %Iused Mounted on/dev/hd3 655360 603088 8% 69 1% /tmpSWAP：6G υ（一般是2倍于MEM，但因为我们的内存已经很大了，所以没有按一般规则）$ /usr/sbin/lsps -aPage Space Physical V olume VolumeGroup Size %Used Active Auto Typehd6 hdisk0 rootvg 6144MB 1 yes yeslv/oracle：38G （MIN υ 3.5G，本目录用于安装软件、存放source以及oracle9用户的根目录所在）$ df -k /oracleFilesystem 1024-blocks Free %Used Iused %Iused Mounted on/dev/oracle 38010880 28495268 26% 64272 1% /oracle2、操作系统环境OS情况：AIX 5L 64bit and υ 64-bit kernel mode，主机名ERP01$ uname -aAIX hawk3 1 5 000BD81A4C00hawk3:/#bootinfo -y64hawk3:/#bootinfo -K64OS υ PATCH：Oracle要求PA TCH：IY22854,IY26778,IY28766,IY28949,IY29965,IY30150等俱全可以使用下面的命令来检查所需PA TCH，如：#/usr/sbin/instfix -a -ivk IY22854有X-window，单独安装的32bit JA V A υ Version1.3.1，你可以从这里download：/developerworks/java/jdk/aix/index.html3、Oracle版本1。