Base-Oracle-3

合集下载

Oracle Autonomous Database 数据库自动化解决方案说明书

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数据库的语句

连接oracle数据库的语句连接Oracle数据库是开发人员常常遇到的一个任务，下面我将列举一些连接Oracle数据库的语句，希望能够帮助你。

1. 使用SQL*Plus连接Oracle数据库：```sqlplus username/password@host:port/service_name```其中，`username`是Oracle数据库的用户名，`password`是密码，`host`是主机名，`port`是端口号，`service_name`是服务名。

2. 使用JDBC连接Oracle数据库：```import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class OracleJdbcExample {public static void main(String[] args) {String url = "jdbc:oracle:thin:@host:port:service_name";String username = "username";String password = "password";try {Connection connection = DriverManager.getConnection(url, username, password);System.out.println("Successfully connected to Oracle database!");// 执行其他操作...connection.close();} catch (SQLException e) {System.out.println("Failed to connect to Oracle database!");e.printStackTrace();}}}```其中，`url`是连接Oracle数据库的URL，`username`是用户名，`password`是密码，`host`是主机名，`port`是端口号，`service_name`是服务名。

Oracle Database Mobile Server 11g 用户手册说明书

ORACLE DATABASE MOBILE SERVER ® 11g Oracle Database Mobile Server 11g is the best way to securely connect embedded devices and mobile applications to Oracle Database. Any organization with a mobile workforce or network of remote devices can benefit from using Oracle Database Mobile Server to safely and reliably link them into their existing enterprise infrastructure. Oracle Database Mobile Server is designed to work with Berkeley DB, Oracle’s high performance mobile data store. It is also compatible with SQLite, the popular open source project. Oracle Database Mobile Server Overview Oracle Database Mobile Server 11g is a reliable, secure way to link mobile applications and embedded devices into existing enterprise infrastructure. It is well suited for mission critical applications or any application where high performance and reliability are required. It extends the application grid to mobile devices, allowing access to enterprise data and applications in the absence of a network connection. When a network connection is available, Oracle Database Mobile Server uses data synchronization to allow reliable and secure data exchange with a backend Oracle Database. The three main components of Oracle Database Mobile Server are: 1) Mobile Client, resides on mobile platform to facilitate sync and remote management 2) The Sync Server itself, coupled with the Mobile Manager console, provide scalable, secure management of data, applications and devices. 3) Mobile Development Kit (MDK), a suite of tools for packaging, publishing and testing applications. Multi-Platform Mobile Client Oracle Database Mobile Server supports many different client platforms, including Java, Android, Blackberry, Windows Desktop & Mobile, and Linux. The Mobile Client provides support for either a SQLite database or Oracle Berkeley DB. • Berkeley DB is a widely deployed, mature embedded database library that provides enterprise class features, including high throughput, low-latency reads, non-blocking writes, data scalability and in-memory caching in a small memory footprint. Berkeley DB offers a SQL API that is SQLite compatible. Berkeley DB offers features that allow it to scale well beyond the limitations of the SQLite native library, while retaining the ease-of-use of the SQLite API. • SQLite is a very popular open source embedded database library and is widely used in smart phones, including Android and Blackberry devices. It is a small footprint, transactional database library that is self-administering, requiring no external DBA. The Mobile Client supports both databases with a rich set of data synchronization features. Data synchronization can be enabled in a variety of ways – automatic background sync, manual sync using a GUI, command line app, or even from another application using API calls.A device agent on the Mobile client allows administrators to remotely manage the device by sending commands or querying the system. Application life-cycle management can be achieved by enabling remote application updates.Enterprise Ready Mobile ServerAt the core of the Oracle Database Mobile Server product is the server itself, which can be deployed on commodity server hardware running industry standard operating systems including Windows, Linux, Solaris, HP-UX and IBM AIX. The Mobile Server provides a reliable, bi-directional synchronization system and a powerful administration interface.Robust and Scalable Synchronization SystemBased on the publish/subscribe or “pub-sub” model, the Oracle Database Mobile Server synchronization system allows efficient asynchronous and synchronous incremental data synchronization between thousands of mobile users and the Oracle Database.Oracle Database Mobile Server features a robust and resilient synchronization process. In the event of a network failure, the client will resume the function from the last acknowledged checkpoint rather than restart the transmission. The result is that a successful synchronization can be achieved even over unreliable network connections.Oracle Database Mobile Server is capable of analyzing information contained in the mobile application to automatically create the application's server-side synchronization logic. It provides a flexible architecture that enables customization of the synchronization process at multiple levels. Callback support enables interleaving various application-specific tasks during the various synchronization phases. Developers can choose to optimize only the resource intensive Compose phase of synchronization by implementing java classes that leverage their insights into the data model. Alternatively, developers can provide full control of the synchronization system by independently managing the data queues that contain the uploaded data and the client updates to be downloaded.Conflicts can occur when the same data has been modified by the server and the client, or by multiple clients. Oracle Database Mobile Server automatically detects such conflicts and resolves them based on a highly customizable rule set.Comprehensive Management and AdministrationOracle Database Mobile Server employs a secure, centralized repository to support a unified interface for distributing and managing software and data on remote systems. Mobile Manager, a web-based administration interface for Mobile Server, enables 100% server-side management of all mobile applications, devices, users and mobile servers. The administrator can create users and groups, assign application access privileges, send device commands and retrieve device diagnostic information from a single interface. Integration with enterprise Oracle OID and LDAP directories further simplifies user management. In addition, the administrator can manage the synchronization process by setting its frequency, resolving errors, or analyzing and tuning its performance from the same interface. A scripting language is available that can be used to batch administration functions minimize administrator overhead.Rapid Application Development SupportThe Mobile Development Kit (MDK) is included with Oracle Database Mobile Server. It consists of a set of tools, APIs, tutorials and code samples that accelerate the development of mobile applications.The main component of the MDK is the Mobile Database Workbench (MDW), a visual development tool for designing synchronized databases. Wizards in the MDW accelerate creation of synchronized databases by allowing developers to quickly define and customize snapshots of enterprise data models for incorporation into these databases. The Packaging Wizard enables bundling all application components (executables, libraries, images, help files etc.) into a JAR file for simple upload to the Mobile Server from where it can be deployed to mobile, embedded or lightweight business environments easily.Developers can use Oracle JDeveloper with ADF Mobile to visually develop applications that enable access to critical business data. Oracle Database Mobile Server includes support for deploying and managing applications created using JDeveloper and ADF Mobile.Oracle Database Mobile Server also supports familiar data access interfaces and open standards such as ODBC, JDBC, and . Tutorials and samples included in the documentation and MDK install highlight how to leverage specific features or develop applications on a particular platform.Table 1 Supported client platformsHigh Performance and ScalabilityOracle Database Mobile Server delivers impressive out-of-the-box performance, enabling users to access information quickly and efficiently. Support for multiprocessor systems and dynamic cache sizing ensure top performance for larger databases and greater numbers of connected users. Oracle Database Mobile Server provides tools to tune the performance of data synchronization.Oracle Database Mobile Server integrates with Oracle WebLogic Server to enable scaling of Mobile Server deployments by taking advantage of the load balancing features.On the mobile device side, Berkeley DB’s small footprint, extreme scalability, and fine-grain locking make it suitable for almost any application. It supports a high degree of concurrency, including support for concurrent Vacuum and Backup commands.Unparalleled Device and Application SecurityOracle Database Mobile Server provides standard device commands as well as the infrastructure to implement customized commands to support enterprise business processes and security best practices. For example, you can issue commands to synchronize the database, perform diagnostics, or change application settings. In the event of a device loss, theft, or other security concern, you can delete applications and databases, uninstall the client or reset the password. SSL based encryption protects data integrity while data is in transit between the device and the enterprise database.JavaN/A Yes N/A AndroidN/A Yes N/A BlackberryN/A Yes N/A Windows Desktopand MobileYes Yes Yes Linux Yes Yes N/ATable 2 Key Oracle Database Mobile Server featuresConclusionOrganizations of all types can leverage Oracle Database Mobile Server 11g to increase employee productivity, reduce operation costs, and improve customer satisfaction. Oracle Database Mobile Server has delivered demonstrable impact in a wide variety of roles, including sales force automation, data collection, customer relationship management (CRM), and field service applications. It has an established presence in a range of industries including financial services, healthcare, transportation, logistics, government, retail, military, and law enforcement. It is also commonly used as a building block for custom solutions by ISVs and System Integrators (SIs).Contact UsFor more information about Oracle Database Mobile Server, please visit or call +1.800.ORACLE1 to speak to an Oracle representative.Oracle is committed to developing practices and products that help protect the environmentCopyright © 2011, Oracle and/or its affiliates. All rights reserved.This document is provided for information purposes only and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.• Footprint is 1 MB• Very broad platform support• High performance• Non-blocking writes• In-memory caching• Concurrent access bymultiple threads orprocesses• Full ACID transactions• Automatic recovery• Scales to TB of data ina single table• JDBC, ODBC, APIs• SQL API compatiblewith SQLite, SQL-92• 128-bit AES encryption • Fine-grain locking• Zero administration • Flexible & reliable bi- directional synchronization • Asynchronous architecture for high scalability • Multi-threaded architecture • Custom synchronization invocation • Automatic (background) Synchronization • Support for schema evolution • SSL encryption & data compression • Network failure recovery • Built-in and custom conflict detection / resolution • Ability to synchronize data and applications• EM compliant UI • Single Sign-On capability using Oracle Identity Management • Scripting language for batch administration • Extension APIs • User management • Application provisioning and deployment • Device management including remote diagnostics • Unified interface to monitor synchronization and resolve errors。

ORACLE_BASE、ORACLE_HOME有什么区别

ORACLE_BASE、ORACLE_HOME有什么区别比如oracle 有两款产品，数据库以及其他的。

在装的过程中都会装载ORACLE_BASE目录下。

ORACLE_HOME 目录就是数据库的家目录。

例如：如果装了2个版本的oracle，那么ORACLE_BASE可以是一个，但ORACLE_HOME是2个。

ORACLE_BASE下是admin和productORACLE_HOME下则是ORACLE的命令、连接库、安装助手、listener等等一系列的东东。

这只是ORACLE自己的定义习惯。

ORACLE_HOME比ORACLE_BASE目录要更深一些。

也就是说：ORACLE_HOME＝$ORACLE_BASE/product/versionORACLE_BASE是oracle的根目录，ORACLE_HOME是oracle产品的目录。

简单说，你如果装了2个版本的oracle，那么ORACLE_BASE可以是一个，但ORACLE_HOME是2个全局数据库名用于区别分布式数据库各个不同机器上的实例。

SID用于区别同一台机器上的不同实例，即一个用于外部区分。

一个用于内部区分。

关于数据库名(db_name)、实例名(instance_name)、ORACLE_SID--------------------------------------------------------------------------------发布日期：2004-9-16 浏览次数:作者：jrlee关于数据库名(db_name)、实例名(instance_name)、ORACLE_SID最近因看到论坛有人问起这方面的东西，将自己的理解加上查阅相关资料整理如下，如果不全或不当的地方，望指正并补全它。

数据库名(DB_NAME)、实例名(Instance_name)、以及操作系统环境变量(ORACLE_SID)在ORACLE7、8数据库中只有数据库名(db_name)和数据库实例名(instance_name)。

Oracle Database Appliance部署指南说明书

1Register with My Oracle SupportA Verify that your shipment contains the correct power cables for your location.B Obtain your hardware Support Identiﬁer (SI).C Add the hardware SI and new software licenses that you received with Oracle Database Appliance to your My Oracle Support proﬁle. Each SI registration may take up to 24 hours.Note: You must have registered hardware and software SIs to obtain software or support from Oracle.2Plan the Network ConﬁgurationCollect the following network information from your network administrator:A Generic network information• Domain name (for example, )• (Optional) DNS server addresses• (Optional) Network Time Protocol server addresses• (Optional) VLAN ID• (Optional) NTP server detailsB Select the network interface you want to use for your public network• Oracle Database Appliance provides 10GB/25GB SFP28 optionsC Public network details needed to connect to the system• Host name and IP address (for example, hrsys0 and 192.0.2.18)• Netmask for public network (for example, 255.255.252.0)• Gateway for public network (for example, 192.0.2.1)• (Optional) VLAN ID for public network (for example, 100)Deploying Your Oracle Database Appliance X7-2S/X7-2M3Plan for Oracle ILOM ConﬁgurationConﬁgure Oracle Integrated Lights Out Manager (Oracle ILOM) for managing Oracle Database Appliance independently of the operating system. Collect the following ILOM details from your network administrator:• Oracle ILOM Host Name and IP address (for example, hrsysilom1 and 10.0.0.3)• Netmask for the Oracle ILOM network (for example, 255.255.255.0)• Gateway for the Oracle ILOM network (for example, 10.0.0.1)4Plan the Software and Database Conﬁguration PropertiesIdentify the following conﬁguration properties:• User and group information• Host Name and master password• Region (for example, America)• Time Zone (for example, America/Los_Angeles)• Data Storage Percentage (for example 80)• Database Name (for example, hrdb)• Database Unique Name• Database Version (for example, 12.2.0.1.0)• Database Edition (SE or EE)• Database Shape (for example, odb1)• Database Class (for example, OLTP)• Database Language (for example, English)• Database Character Set (for example, AL32UTF8)• Database National Character Set (for example: AL16UTF16)• Disk group redundancy for systems with 5 or more NVMe disks (Normal or High)• Database Territory (for example, America)• Container Database (yes or no)• (Optional) PDB Name and Admin User. This is optional if you answer no to Container Database.• Storage Type (ACFS or ASM)• (Optional) Oracle Enterprise Manager Database Express (EM Express) Console for Oracle Database 12.2.0.1,12.1.0.2 or the Database Control Console for Oracle Database 11.2.0.4.5(Optional) Plan for Oracle Auto Service RequestDownload the Oracle Database Appliance Server Patch, GI Clone, and RDBMS DB Clone software to a local computer on the network. Follow the instructions in the Oracle Database Appliance X7-2 Deployment and User's Guide .Find the patch information in the Oracle Database Appliance Release Notes and follow the instructions in the Oracle Database Appliance X7-2 Deployment and User's Guide .Go to /goto/oda/docs and select the release.6Download the SoftwareA Conﬁgure Oracle Auto Service Request (ASR), provide the following:• Oracle ASR user name• Oracle online account password• SNMP version (version 2 is recommended)• (Optional) Proxy server name to use for your deployment• (Optional) Proxy server port• (Optional) Proxy user name• (Optional) Proxy passwordB Conﬁgure External ASR manager• ASR Manager IP , host name• ASR Manager port• Y our My Oracle Support account user name and password.For more information about ASR, see: /technetwork/systems/asr/overview/index.html7Review Oracle Database Appliance Information 1Rack, Cable and Connect the Network and Power• Ensure that the system hardware is set up and mounted properly. See the Oracle Database Appliance Owner’s Guide for more information: h ttp:///goto/oda/docs and select the release• Important: Follow the instructions on Page 7 to cable Oracle Database Appliance° Connect power to the power supply unit (PSU)° Plug in the network cable for ILOM network management2Start Up the SystemA Once the green SP OK LED (1) is steady ON, push the power button (2)B Wait for the green Power OK LED (3) to turn steady ON. The Power OK LED might blink for several minutes. Do not repeatedly push the power buttonCopyright © 2017, Oracle and/or its afﬁliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its afﬁliates. Other names may be trademarks of their respective owners. E88372-02; Mfg no 7357594321• Review the most recent version of this poster in the Oracle Database Appliance online documentation library: /goto/oda/docs and select the release• Review the Oracle Database Appliance Release Notes for the latest patch information, what's new, and issues • Review the Oracle Database Appliance X7-2 Deployment and User's Guide for how to deploy the appliance and manage the databases• Review the Oracle Database Appliance white papers on OracleTechnology Network: https:///technetwork/server-storage/engineered-systems/database-appliance/index.html • Review the latest information about Oracle software and hardware products: 3Plumb the Network4Update the Repository with the GI and RDBMS FilesA Download the Oracle Database Appliance GI patch and RDBMS Clone ﬁles to a local computer on the network.B Unzip the ﬁles. If a patch ﬁle is split into more than one zip ﬁle, concatenate the zip ﬁles.C Upload the ﬁles to the appliance, then unzip each patch.D Update the repository. Y ou must include the fully qualiﬁed directory.# odacli update-repository -f /u01/tmp/patch_ﬁle_name.zipIf you have more than one bundle, you can use a comma-separated list. Spaces are not allowed between the ﬁlenames.E Check the job status to conﬁrm that the status of the job is Success# odacli list-jobsSee the Oracle Database Appliance X7-2 Deployment and User's Guide for more information.A Use either the 10GBase-T or the 25GbE SFP28 network interface.B Connect to the ILOM remote console, then log in to the system as root.C Run the command conﬁgure-ﬁrstnet to conﬁgure the initial network for btbond1.# conﬁgure-ﬁrstnet Select the Interface to conﬁgure the network on (btbond1): btbond1 Conﬁgure DHCP on btbond1 (yes/no): no INFO: Y ou have chosen Static conﬁguration Enter the IP address to conﬁgure: 10.1.10.2 Enter the Netmask address to conﬁgure: 255.255.255.0 Enter the Gateway address to conﬁgure: 10.1.10.1 INFO: Plumbing the IPs now INFO: Restarting the network Shutting down interface btbond1: bonding: btbond1: Removing slave em2. bonding: btbond1: releasing active interface em2 bonding: btbond1: making interface em3 the new active one. bonding: btbond1: Removing slave em3. bonding: btbond1: releasing active interface em3 ::::::::::56Monitor Deployment ProgressDeploy the Oracle Database AppliancePerform the following steps to create Oracle Database ApplianceA In your browser type the following URL: https://<ODA-host-ip-address>:7093/mgmt/index.htmlB Enter the following credentials• Username: oda-admin• Password: password See the Oracle Database Appliance X7-2 Deployment and User’s Guide .C Click Create Appliance on the Appliance pageD Enter the conﬁguration information detailsE Review your conﬁgurationF Click Submit to start the deployment• M onitor the progress on the Activity tab.x C abling for Oracle Database Appliance X7-2MNote: You can conﬁgure the system to use either the 10 GbE RJ-45 network ports or the 10/25 GbE SFP+ ports.2113445521134455Copyright © 2017, Oracle and/or its afﬁliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its afﬁliates. Other names may be trademarks of their respective owners. E88372-02; Mfg no 7357594。

Oracle NoSQL Database Data Cartridge 在线自学指南说明书

Hi, and welcome to this online, self-paced tutorial about Oracle NoSQL Database.My name is Swarnapriya Shridhar. I will be your guide on behalf of the course author, Salome Clement. This short tutorial explains how to integrate oracle event processing with Oracle NoSQL Database.This tutorial describes the Oracle NoSQL Database Data Cartridge. You will first get an overview of event processing and then learn about the Oracle NoSQL Database Data Cartridge.In the overview section, you will learn about event processing, Oracle Event Processor and how event processing is related to Big Data. You will then understand the use of event processing in the big data world with the help of a use case.An event is anything that happens that is significant to an enterprise. Event processing is the capture, processing and consumption of events. Processing includes formatting, filtering, correlation, enrichment, aggregation, and pattern matching of the events.In an event driven architecture, there are three main components: an event source, an event processor, and an event consumer.In an enterprise network, events are produced when business processes start and complete or fail. Some events can be detected by sensors. By processing these events, the activity of the enterprise and its business can be monitored and changed. You can detect business situations and derive early and intelligent insight to assist you in making timely and effective business decisions.There are three approaches to event processing: event passing, event routing, and complex event processing.In this tutorial, we will be talking about complex event processing. Complex event processing, or CEP, is event processing that combines data from multiple sources to infer events or patterns that suggest more complicated circumstances. The goal of complex event processing is to identify meaningful events and respond to them as quickly as possible.Relational databases are best equipped to run queries over finite stored data sets. A stored data set is appropriate when significant portions of the data are queried repeatedly and updates are relatively infrequent. However, modern applications generate data streams as opposed to data sets, such as sensor data applications, financial tickers, network performance measuring tools, network monitoring and traffic management applications, and click stream analysis tools. These applications require long-running queries over continuous unbounded sets of data. In addition, data streams represent data that is changing constantly, often exclusively through insertions of new elements.For managing and processing data in such applications, a different data management and querying capability, such as an event processor, is required. To address this requirement, Oracle SOA Suite provides Oracle Event Processing (OEP), a data management infrastructure that supports the notion of streams of structured data records together with stored relations.You will learn more about OEP in the next slide.Oracle Event Processing is a component of SOA suite, and can also be downloaded separately. OEP is a complete solution for building applications to filter, correlate, and process events in real-time so that downstream applications, service oriented architectures, and event-driven architectures are driven by true, real-time intelligence. It is a light weight, java based application server, which connects to high volume data feeds and has a event processing engine to match events based on user defined rules.An OEP application consists of four components: adapters, streams, processors, and business logic. These components are connected to each other to form an Event Processing Network.Big Data has evolved with the expansion of internet and mobile network usage. Businesses want to acquire all the data generated around them and process and analyze that data to enhance their business further. A huge amount of data that is generated is semi-structured or structure less, which can not be stored in traditional relational databases due to their volume, velocity, variety, and value. Oracle NoSQL Database is a solution to acquire and store such Big Data.For real-time applications using event driven architectures and wanting to use this big data, there needs to be a mechanism to communicate with the Oracle NoSQL Database. Oracle NoSQL Database Data Cartridge for event processing is a solution to this requirement. Later in this tutorial, you will learn more about this data cartridge. Before that, this big data and event processing scenario is explained further using a use case. Click next to proceed.A study of the US heathcare industry shows that a handful of patients with chronic medical conditions like Diabetes, Heart disease, Pulmonary Disease, Cancer, and Obesity consume a large portion of our heathcare resources.Triggered by these unsustainable costs and with the support of changing science and evolving care delivery models, the heathcare industry is reviewing its procedures to find an alternative way to delivery medical care by implementing the Big Data solution. Let us implement this solution to a simple medical care situation.Mark, 69 year old, has been facing heart and blood pressure related heath problems for some time. Today he is feeling the symptoms of high blood pressure and decides to visit his local city hospital. The on-duty heart specialist reviews Marks condition using tools that show all of Marks heath history including all doctor notes, prescriptions, and lab reports. The specialist decides to monitor Marks heath more closely. Mark is given a Remote Patient Monitoring Device and instructed to perform routine heart and blood pressure tests and send the results to the heathcare facility. The test results will be received by the heathcare facility in real time and monitored by the specialist. Any anomalies in the results or even lack of results within a specified time interval will trigger an alert that is sent to the specialist and an immediate response will be given. Since the device is user-friendly and easy to operate, Mark is quickly trained on how to use it to monitor himself.What you saw here was a very simple use case scenario. But, you can see how the patient’s condition is monitored regularly to prevent anything serious from happening and also cutting down the in-patient expenses. Lot more exciting innovations can be expected in the heathcare industry because of Big Data.Now, let us look at the components involved in building this solution and where exactly the Oracle NoSQL Database data cartridge is used.[[When a user sends test results using the remote monitoring device, events are reported to OEP that consist of a DeviceID and the current test results of the patient. OEP then takes this data, performs required processing, and also determines if there is any anomaly. If an anomaly is noted, then an alert is created and sent to the concerned authorities. The alert contains all required details about the patient that is stored in Oracle RDBMS as well as the Oracle NoSQL Database. The DeviceID is used to query the databases. In order to query an Oracle NoSQL Database from an OEP application, you need to use the Oracle NoSQL Database data cartridge.In the previous section, you saw what is event processing, what is Oracle Event Processing, and how event processing is related to Big Data with the help of a use case.In the next section, you will learn to use the Oracle NoSQL Database Data Cartridge for Event Processing. You will learn how to configure your environment, how to integrate Oracle NoSQL Database with event processing network, and how to query the KVStore from an event processing network.If you want your OEP applications to fetch data from an Oracle NoSQL Database, you need to use an OEP NoSQL Database data cartridge. To use this data cartridge, you need to first integrate an Oracle NoSQL Database with an event processing network. You can then use CQL queries to retrieve values from the KVStore by specifying a key in the query and then referring to fields of the value associated with the key.Oracle CEP applications use CQL queries to retrieve data. You can retrieve the Oracle NoSQL Data from within the event processing network by writing CQL queries as shown in the slide.In this example, the event type instances representing data from the S1 channel and CustomerDescription NoSQL data source are both implemented as JavaBeans classes. The CustomerDescription in the FROM clause corresponds to the id attribute value in the store element. Because both event types are JavaBeans classes, the Oracle CQL query can access the customer description associated with a particular event by equating the event's user ID with that of the customer description in the WHERE clause, treating both as JavaBeans properties.Once an entry from the store has been selected, fields from the value retrieved from the store can be referred to in the SELECT portion of the query or in additional clauses inthe WHERE clause. The creditScore value specified in the SELECT clause will include the value of the creditScore field of the CustomerDescription object retrieved from the store in the query output. The reference to creditScore in the WHERE clause will also further restrict the query to events where the value of the CustomerDescription creditScore field is greater than 5.The WHERE clause requests that an entry be retrieved from the store that has the key specified by the value of the event's userId field. This field must be of type String. Only equality relations are supported for obtaining entries from the store. And the join condition can use a single key only.The key used to obtain entries from the store can be formatted in one of two ways: by beginning the value with a forward slash ('/') or by omitting a slash.If the value specified on the left hand side of the equality relation starts with a forward slash, then the key is treated as a full key path that specifies one or more major components, as well as minor components if desired.For example, if the userId field of a SalesEvent object has the value "/users/user42/-/custDesc", then that value will be treated as a full key path that specifies "users" as the first major component, the user ID "user42" as the second major component, and a minor component named "custDesc".As a convenience, if the value specified on the left hand side of the equality relation does not start with a forward slash, then it is treated as a single major component that comprises the entire key.Note that keys used to retrieve entries from the store must be specified in full by a single field accessed by the Oracle CQL query. In particular, if a key path with multiple components is required to access entries in the key-value store, then the full key path expression must be stored in a single field that is accessed by the query.In this tutorial, you learnt about the Oracle NoSQL Database Data Cartridge for Oracle Event Processing. You should now be able to describe event processing and Oracle NoSQL Database Data Cartridge for Event Processing. You should be able to explain how event processing fits in the Big Data world. You should also be able to describe how to use the Oracle NoSQL Database Data Cartridge.。

Oracle目录结构

Oracle10g的目录结构在安装ORACLE的时候，需要设置Oracle根目录(oracle base directory)，Oracle主目录(oracle home directory)和Oracle清单目录(oracle invertory directory)这三个目录，如下图所示，这里我们设置Oracle主目录为c:\oracle\product\10.1.0\Db_1。

如果一台计算机上首次安装Oracle 10g并使用默认设置时，根目录(ORACLE_BASE)的默认位置是c:\oracle\product\10.1.0。

Oracle主目录(ORACLE_HOME)指向根目录的下一级目录，即%ORACLE_BASE%\Db_1。

如果在同一台主机的同一个根目录下安装多个产品或安装了第2次，则Oracle_Home主目录会以db_n的形式出现,即Db_2、Db_3等。

由于安装设置(如安装类型)和安装环境(如是否有其他Oracle数据库)的不同，文件目录结构也可能不同。

我这里安装完成后，其目录结构为：Oracle根目录（Oracle Base Directory）是Oracle的顶级目录，第一次安装Oracle 时，Oracle Universival Installer会提示创建这个目录。

在“注册表”中查找“oracle_base”可以查看oracle的根目录。

Oracle主目录（Oracle Home Directory）是安装特定的oracle产品的目录，单独的oracle产品或者不同版本的oracle数据库，都必须指定一个单独的oracle home目录，oracle home directory必须为oracle base directory 的一个子目录。

Oracle Universival Installer 会提示你指定主目录的路径，默认为ORACLE_BASE/Db_1。

oracle数据库预编译参数

oracle数据库预编译参数详解Oracle数据库的预编译参数通常指的是与预编译器相关的参数，用于在编译过程中控制和配置预编译程序的行为。

预编译器用于将嵌入在源代码中的SQL 语句转换为对应的函数调用。

以下是一些Oracle 数据库中常见的预编译参数：1. _SQL_TRACE（下划线前缀）:-含义：用于启用或禁用SQL 跟踪功能。

-取值：1 表示启用，0 表示禁用。

2. _SQL_TRACE_EVENT（下划线前缀）:-含义：用于指定SQL 跟踪事件，进一步细化跟踪的内容。

-取值：不同取值表示不同的跟踪事件。

3. _CONNECT_BY_USE_HASH（下划线前缀）:-含义：控制CONNECT BY 子句中的哈希连接。

-取值：1 表示使用哈希连接，0 表示不使用。

4. _OPTIM_PEEK_USER_BINDS（下划线前缀）:-含义：用于启用或禁用优化过程中的用户绑定变量的查看。

-取值：1 表示启用，0 表示禁用。

5. _PARSE（下划线前缀）:-含义：控制是否对SQL 语句进行解析。

-取值：1 表示解析，0 表示不解析。

6. _FIX_CONTROL（下划线前缀）:-含义：用于指定是否启用修复控制。

-取值：不同取值表示不同的修复控制选项。

7. _ORACLE_TRACE_FACILITY（下划线前缀）:-含义：用于启用或禁用Oracle 跟踪工具。

-取值：包括SQL_TRACE、TIMED_STATISTICS、等。

8. _PXA_OPTIMIZATION_LEVEL（下划线前缀）:-含义：用于指定PXA（Parallel Execution Architecture）优化级别。

-取值：从0 到2 不同级别的优化。

请注意，使用下划线前缀的参数是Oracle 内部使用的参数，一般情况下不建议直接修改这些参数，因为它们可能会对系统的稳定性和性能产生不可预测的影响。

修改这些参数之前应该仔细了解其含义，并在必要时咨询Oracle 官方文档或支持。

Oracle Database Appliance 部署和用户指南说明书

A Plug in AC power to the two power supplies (1). For redundancy, each power supply should be connected to a separate AC power source.B Plug in a network cable to the Oracle Integrated Lights Out Manager (Oracle ILOM) network management port (2).C Plug in network cables for public network (3). (Port connections can vary depending on the option ordered).1Server Back Panel Components, Connectors, and Indicators13Deploy and Con�gure the ApplianceRefer to the Oracle Database Appliance Deployment and User’s Guide for information about con�guring and deploying the appliance.To get started with your appliance, refer to the Oracle Database Appliance Welcome Kit at: h�p:///goto/oda/docsCopyright © 2023, Oracle and/or its a�liates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its a�liates. Other names may be trademarks of their respective owners. F79893-01; Mfg no 82173292Start Up the SystemPower on the host.A Con�rm that the green SP OK LED (4) is steady ON and the green Power OK LED (5) �ashes slowly.This indicates that the server is in Standby power mode.B Push the power bu�on (6). This applies full power to the server.C Wait for the green Power OK LED (5) to turn steady ON. The Power OK LED may blink for several minutes. Do not repeatedly push the power bu�ons.1Power Supply (PS) 1 with fan module2Power Supply (PS) 1 status indicators: Service Required LED: amber, AC OK LED: green 3Power Supply (PS) 0 with fan module4Power Supply (PS) 0 status indicators: Service Required LED: amber, AC OK LED: green 5Not usedCallout Description11PCIe card slot 6: Oracle Retimer PCIe Card 12PCIe card slot 7: �ller panel13PCIe card slot 8: �ller panel, or 3rd optional Oracle Dual Port 25Gb Ethernet Adapter or Oracle Quad Port 10GBase-T Adapter14PCIe card slot 9:Oracle Database Appliance X10-S: �ller panel, or 2nd optional Oracle Dual Port 25Gb Ethernet Adapter or Oracle Quad Port 10GBase-T Adapter Oracle Database Appliance X10-L: �ller panel, or 3rd optional Oracle Flash Accelerator 680 PCIe Card PCIe card slot 4:Oracle Database Appliance X10-S: �ller panelOracle Database Appliance X10-L: �ller panel, or 2nd optional Oracle Dual Port 25Gb Ethernet Adapter or Oracle Quad Port 10GBase-T Adapter PCIe card slot 3:Oracle Database Appliance X10-S: �ller panelOracle Database Appliance X10-L: �ller panel, or 2nd optional Oracle Flash Accelerator 680 PCIe CardPCIe card slot 2:Oracle Database Appliance X10-S: �ller panelOracle Database Appliance X10-L: �ller panel, or 1st optional Oracle Flash Accelerator 680 PCIe Card PCIe card slot 1:Oracle Database Appliance X10-S: �ller panelOracle Database Appliance X10-L: �ller panel, or 4th optional Oracle Flash Accelerator 680 PCIe Card 18USB 3.1 connector19System status indicators: Service Required LED (amber), Power/OK LED (green)20SER MGT port: RJ-45 serial port used to connect to the Oracle ILOM service processor15Locate LED (white)16100/1000Base-T network interface port with RJ-45 connector: NET 0179NET MGT port: 10/100/1000Base-T network interface port with RJ-45 connector used to connect to the Oracle ILOM service processor 768For more information about Oracle Database Appliance, go to Oracle Technology Network:h�p:///technetwork/server-storage/engineered-systems/database-appliance/index.html For more information about deployment, go to: h�p:///goto/oda/docsYou can also scan the Quick Response Code with your mobile device to read the documentation.Database ApplianceSetup for Oracle Database Appliance X10-S/X10-L10PCIe card slot 5: 1st Oracle Dual Port 25Gb Ethernet Adapter or Oracle Quad Port 10GBase-T Adapter Connect Power and Network Cables5641323419151617181256789101113142012Node。

Oracle Database Administration 2019 认证说明书

Introduction ................................................................................................................................................2Certification Details ....................................................................................................................................2Certification Benefits . (3)What IT Certification Offers What Oracle Certification OffersOracle Certification Innovation with Digital BadgingExam Preparation .......................................................................................................................................5Exam Topics (6)Oracle Database Administration I | 1Z0-082Oracle Database Administration II | 1Z0-083Sample Questions (13)Oracle Database Administration I | 1Z0-082Oracle Database Administration II | 1Z0-083Exam Registration Process .........................................................................................................................18Exam Score ................................................................................................................................................18Oracle Certification Program Candidate Agreement ...................................................................................19Oracle Certification Program Guidelines .. (19)Oracle Database Administration I & Oracle Database Administration IICertification Overview and Sample QuestionsOracle DatabaseIntroductionPreparing to earn the Oracle Database Administration 2019 Certified Professional certification helps candidates gain the skills and knowledge to install, patch and upgrade Oracle Database and Oracle Grid Infrastructure for a standalone server, create and manage a backup and recovery strategy using Recovery Manager (RMAN), use RMAN for Database duplication and transportation, diagnose failures using RMAN, and manage all aspects of Multitenant container databases, pluggable databases and application containers including creation, cloning, security, transportation and backup and recovery. The Administration I exam and recommended training focus on fundamental Database Administration topics such as understanding the database architecture, managing database instances, managing users, roles and privileges, and managing storage that lay the foundation for a Database Administrator entry-level job role. Additionally, the Admin I exam assumes knowledge of SQL.The Administration II exam and associated recommended training presents advanced topics such as multi-tenancy, backup and recovery, deploying, patching, and upgrading.Certification BenefitsWhat Oracle Certification OffersBy becoming a certified Oracle Database Administrator Professional , you demonstrate the full skill set needed to perform day to day administration of the Oracle Database.Preparing to take the Oracle Database certification exam broadens your knowledge and skills by exposing you to a wide array of important database features, functions and tasks. Oracle Database certification preparation teaches you how to perform complex, hands-on activities through labs, study and practice.Additionally, Oracle certification exams validate your capabilities using real-world, scenario-based questions that assess and challenge your ability to think and perform.What IT Certification OffersRecognitionof having required skillsExperienced a Greater Demandfor Their SkillsReceived Positive Impact onProfessional Imagethrough new skillsOpportunitiesSaid Certification was a Key Factor in Recent Raiseby peers and managementConfidence and RespectJanuary 2018 issue of Certification Magazine’s annual salary survey The kind of longevity suggests that earning and maintaining a certification can keep you moving for-ward in your career, perhaps indefinitely.73%65%71%January 2019 issue of Certification Magazine’s annual salary survey January 2019 issue of Certification Magazine’s annual salary surveyCertification that Signifies Y our Readiness to Perform Earned badges represent recognized skills and capabilitiesDisplay Y our Oracle Certification BadgeY ou‘ve earned it. Get the recognition you deserve.Modern Representation of Skills Tied to Real Time Job Markets View from your profile and apply to jobs that are matched to your skills; based on location, title, employers or salary rangeDisplay Y our AchievementA secure way to display and share your certification achievement • Industry Recognized • Credible • Role Based• Product Focused Across Database, Applications, Cloud, Systems, Middleware and Java• Globally one of the top 10 certifica-tion programs availableOracle Certification Innovation with Digital Badging Use Your Badge to Apply for JobsBenefitsOracle Certification Signifies a Candidate’s Readiness to Perform2019 Oracle Certified Professional Oracle Database AdministratorBoost Y our Professional ImageLearn MoreExam PreparationBy passing these exams, a certified individual proves fluency in and solid understanding of the skills required to be an Oracle Database Administrator.Recommendations to successfully prepare for Oracle Database Administration I | 1Z0-082 and Oracle Database Administration II | 1Z0-083 exams are:Attend Recommended Oracle T rainingThe courses below are currently available and are terrific tools to help you prepare not only for your exams, but also for your job as an Oracle Database Administrator.The new Oracle Database Administration Learning Subscription also helps you prepare for these exams with 24/7 access to continually updated training and hands-on labs and integrated certification.Recommended for 1Z0-082• O racle Database: Administration Workshop • Oracle Database: Introduction to SQL Recommended for 1Z0-083• O racle Database: Deploy, Patch and Upgrade Workshop• O racle Database: Backup and Recovery Workshop • O racle Database: Managing Multitenant Architecture• Oracle Database Administration: Workshop • O racle Database 19c: New Features for Administrators• O racle Database 18c: New Features forAdministrators (for 10g and 11g OCAs and OCPs)• O racle Database 12c R2: New Features for 12c R1 Administrators (12c R1 OCAs and OCPs)• O racle Database 11g: New Features for Administrators (for 10g OCAs and OCPs)The following topics are covered in the Oracle Database: Administration Workshop course.The following topics are covered in theOracle Database: Introduction to SQL course.The following topics are covered in the Oracle Database: Managing Multitenant Architecture Ed 1 course.The following topics are covered in the Oracle Database: Backup and Recovery Workshop course.The following topics are covered in the Oracle Database: Deploy, Patch and Upgrade Workshop course.The following topics are covered in the Oracle Database 19c: New Features for Administrators course.The following topics are covered in the Oracle Database: Administration Workshop course1. Which two statements are true about the Oracle Database server architecture?A. An Oracle Database server process represents the state of a user’s login to an instance.B. An Oracle Database server process is always associated with a session.C. Each server process has its own User Global Area (UGA).D. A connection represents the state of a user’s login to an instance.E. The entire data dictionary is always cached in the large pool.2. W hich two statements are true about the Oracle Database server during and immediatelyafter SHUTDOWN IMMEDIATE?A. New connection requests made to the database instance are refused.B. Uncommitted transactions are rolled back automatically.C. All existing connections to the database instance remain connected until all transactions eitherroll back or commit.D. Uncommitted transactions are allowed to continue to the next COMMIT.E. All existing transactions are aborted immediately.3. Which three statements are true about Oracle database block space management?A. A row can be migrated to a block in a different extent than the extent containing the originalblock.B. An insert statement can result in a migrated row.C. An update statement cannot cause chained rows to occur.D. A row can be migrated to a block in the same extent as the extent containing the originalblock.E. An insert statement can result in a chained row.1 2. 3.4. A n Oracle Database server session has an uncommitted transaction in progress whichupdated 5000 rows in one table.In which two situations does the transaction complete, thereby committing the updates?A. When a DDL statement is executed successfully by same user in a different session.B. When a DDL statement is executed successfully by the user in the same session.C. When a DML statement is executed successfully by same user in a different session.D. When a DML statement is executed successfully by the user in the same session.E. When a DBA issues a successful SHUTDOWN NORMAL statement and the sessionterminates normally.5.Which two statements are true about indexes and their administration in an Oracle database?A. An index can be scanned to satisfy a query without the indexed table being accessed.B. A non-unique index can be converted to a unique index using a Data Definition Language(DDL) command.C. A descending index is a type of bitmapped index.D. An invisible index is maintained when a Data Manipulation Language (DML) command is per-formed on its underlying table.E. An index is always created by scanning the key columns from the underlying table.6. Which two statements are true about sequences in a single instance Oracle database?A. Sequences that start with 1 and increment by 1 can never have gaps.B. A sequence can issue the same number more than once.C. Sequence numbers that are allocated require a COMMIT statement to make the allocationpermanent.D. A sequence can provide numeric values for more than one column or table.E. The data dictionary is always updated each time a sequence number is allocated.4. 5. 6.7. E xamine the description of the SALES table:Name Null? Type---------------------------- -------- --------------PRODUCT_ID NOT NULL NUMBER(10)CUSTOMER_ID NOT NULL NUMBER(10)TIME_ID NOT NULL DATECHANNEL_ID NOT NULL NUMBER(5)PROMO_ID NOT NULL NUMBER(5)QUANTITY_SOLD NOT NULL NUMBER(10,2)PRICE NUMBER(10,2)AMOUNT_SOLD NOT NULL NUMBER(10,2)The SALES table has 55,000 rows.Examine this statement:CREATE TABLE mysales (prod_id, cust_id, quantity_sold, price)ASSELECT product_id, customer_id, quantity_sold, priceFROM salesWHERE 1 = 2;Which two statements are true?A. MYSALES is created with no rows.B. MYSALES will have no constraints defined regardless of which constraints might be de-fined on SALES.C. MYSALES has NOT NULL constraints on any selected columns which had that constraintin the SALES table.D. MYSALES is created with 2 rows.E. MYSALES is created with 1 row.71. Which three are true about an application container?A. It always contains multiple applications.B. Two or more application PDBs in the same application container can share access to tables.C. It can have new application PDBs created by copying PDB$SEED.D. T wo or more application PDBs in the same application container can be given exclusive accessto some tables.E. It always has a new application PDBs created by copying PDB$SEED.F. It always contains a single application.2. RMAN has just been connected to a target database and the recovery catalog database.In which two cases would an automatic partial resynchronization occur between this target database’s control file and the RMAN recovery catalog?A. When any control file metadata for data file backups or image copies is now older thanCONTROL_FILE_RECORD_KEEP_TIME.B. When a new data file is added to a tablespace in a registered target database.C. When a backup of the current SPFILE is created.D. When the target is first registered.E. When any control file metadata for archive log backups or image copies is now older thanCONTROL_FILE_RECORD_KEEP_TIME.3. Which two are true about Oracle Grid Infrastructure for a Standalone Server?A. Oracle Restart can be used without using ASM for databases.B. Oracle Restart can attempt to restart a failed ASM instance automatically.C. It must be installed before Oracle Database software is installed.D. It must be installed after Oracle Database software is installed.E. It allows ASM binaries to be installed without installing Oracle Restart.F. It allows Oracle Restart binaries to be installed without installing ASM.1 2. 3.4. W hich two are true about creating container databases (CDBs) and pluggable databases (PDBs) inOracle 19c and later releases?A. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode.B. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration requiredbefore starting the duplication.C. A PDB snapshot must be a full copy of a source PDB.D. A PDB snapshot can be a sparse copy of a source PDB.E. A CDB can be duplicated only by using the Database Configuration Assistant (DBCA).5. Which two are true about the Oracle Optimizer?A. It requires system statistics when generating SQL execution plans.B. It always generates an index access operation when a statement filters on an indexed columnwith an equality operator.C. It ignores stale object statistics in the Data Dictionary.D. It can automatically re-optimize execution plans that were detected to be sub-optimal whenexecuting.E. It can re-write a statement internally in order to generate a more optimal plan.4. 5.Exam Registration ProcessOracle exams are delivered through the independent company Pearson VUE. Create a Pearson VUE loginOracle Certification Program Candidate AgreementIn order to take your Oracle certification, you will need to agree to the Oracle Certification Program Candidate Agreement. Please review this document by going here.Oracle Certification Program GuidelinesLearn more about Oracle Certification policies here.This certification overview and sample questions were created in June 2019. The content is subject to change,please always check the web site for the most recent information regarding certifications and related exams: /certification。

oracle数据库入门教程

oracle数据库入门教程Oracle数据库是一种常用的关系型数据库管理系统。

它被广泛用于各种企业级应用程序和互联网应用程序的开发和部署。

本教程将带你入门Oracle数据库，让你了解基本的概念和操作。

1. 什么是Oracle数据库？Oracle数据库是由Oracle Corporation开发并维护的一种关系型数据库管理系统。

它提供了一个可扩展、高性能和安全的数据库解决方案。

2. 安装Oracle数据库首先，你需要从Oracle官方网站下载适合你操作系统的Oracle数据库安装程序。

然后，按照安装向导的指示步骤进行安装。

3. 连接到Oracle数据库安装完成后，你可以使用命令行工具或图形界面工具来连接到Oracle数据库。

命令行工具包括SQL*Plus和SQL Developer，图形界面工具包括Oracle Enterprise Manager和Toad等。

4. 创建数据库实例在连接到Oracle数据库之后，你可以使用CREATE DATABASE语句创建一个新的数据库实例。

你需要指定数据库的名称、文件路径和其他参数。

5. 创建和管理表表是Oracle数据库中存储数据的基本单位。

你可以使用CREATE TABLE语句创建表，并使用INSERT、SELECT、UPDATE和DELETE语句来插入、查询、更新和删除表中的数据。

6. 数据类型Oracle数据库支持多种数据类型，包括字符型、数值型、日期型和大型对象型等。

你需要根据数据的性质选择合适的数据类型。

7. 查询数据查询是Oracle数据库中最常用的操作之一。

你可以使用SELECT语句在表中查询数据。

SELECT语句可以使用条件、排序、分组和连接等特性。

8. 索引和约束索引和约束是用于提高数据库性能和保证数据完整性的重要工具。

你可以使用CREATE INDEX语句创建索引，并使用CREATE TABLE语句添加约束。

9. 数据库备份和恢复数据库备份是防止数据丢失的重要手段。

Oracle Essbase 11.1.2 系统管理员指南说明书

Oracle Essbase 11.1.2 for System Administrators Online Analytical Processing Overview∙Data Transformation∙Multidimensional View of Information∙Dimensional Modeling∙Data Cubes∙Dimension Hierarchies∙OLAP SolutionsEssbase architecture, components, and production cycle∙Aggregate Storage and Block Storage∙Outlines∙Load Rules∙Calculation Scripts∙Aggregations∙Reporting in Smart ViewBlock Storage Data Structure∙Data Blocks and the Index System∙Block Storage Database Statistics∙Data Block Creation∙Database Calculation ProcessAggregate Storage Data Structure∙Table space Overview∙Data Aggregation∙Aggregate Storage Database StatisticsConfiguring Essbase Servers∙Setting up runtime and connection options for Essbase∙Configuring block storage and aggregate storage disk allocation∙Identifying the primary information logs available to Essbase system administrators∙Maintaining the Essbase Server configuration fileEssbase Data Integrity∙Ensuring Essbase Data Integrity∙Transactions and Locks∙Isolation LevelsEssbase Security Overview∙Essbase Native Security∙Global Access Security Layer∙User and Group Security Layer∙Application Access Type Security∙The Essbase Security FileCreating Essbase Security Filters∙The Essbase Security Filter Layer∙Creating Security Filters∙Filter Behavior∙Resolving Security ConflictsSecuring the Essbase Environment in Shared Services ∙Shared Services Security∙Converting Essbase Users to Shared Services Security ∙Provisioning Users in Shared Services∙External Authentication and Single Sign-on Optimizing Block Storage Caches∙Optimizing the Database∙Optimizing Caches∙Setting RAM Caches∙Cache Hit RatiosOptimizing Aggregate Storage Cache∙Aggregate Storage Cache Optimization∙Managing Aggregate Storage Cache∙Viewing Aggregate Storage Cache Statistics Optimizing Buffers and Compression∙Setting Data Retrieval Buffers∙Data Compression Methods∙Setting the Optimal Compression Method Managing Fragmentation∙Measuring Database Fragmentation∙Preventing and Reducing Database Fragmentation∙Removing Security File FragmentationManaging Applications, Sessions, Usernames, and Passwords ∙About Application and Session Management∙Migrating Applications and Databases∙Enabling/Disabling Usernames in Administration Services Console Backing Up, Restoring, and Recovering Essbase Databases ∙About Backup, Restore, and Recovery∙Manual Backup and Restore∙Automated Backup and Restore∙Manual Recovery∙Automated Recovery∙Recovering from a Server Interruption∙Recovering Corrupted Essbase DatabasesTask Automation∙Automating Tasks Using MaxL∙The MaxL Command Shell∙MaxL Statements and Syntax∙MaxL Username and Password Encryption∙Debugging MaxL scripts。

Oracle Essbase Integration Services 11.1.1.3 发行版说明

Oracle® Essbase Integration ServicesRelease 11.1.1.3Readme[Skip Navigation Links]About This Service Fix (1)New Features (1)Defects Fixed (1)Known Issues in Release 11.1.1.3 (3)Documentation Updates (6)About This Service FixThis Readme file describes the defects fixed in Oracle® Essbase Integration Services Service Pack11.1.1.3 as well as the known issues in this release.Top of Document New FeaturesCertification MatrixInformation about system requirements for EPM System products is now available in a spreadsheet format in the Oracle Hyperion Enterprise Performance Management System Certification Matrix, posted at /technology/products/bi/hyperion-supported-platforms.html. Systemrequirements are no longer part of the Oracle Hyperion Enterprise Performance Management System Installation Start Here.Supported LanguagesThis release supports non-English languages. The list of supported languages for all EPM System products is included in the Oracle Hyperion Enterprise Performance Management System Certification Matrix, posted at /technology/products/bi/hyperion-supported-platforms.html.Top of Document Defects FixedDefects Fixed in Release 11.1.1.3•Member load. In the batch file created for EIS scheduling for member loads, the path was not updated to include the start command.(8439772)•Console. Creating the fact table by selecting the Menu > Tools option failed.(8403636)•Data load. Batch file executed during data loads falsely reported that load was terminated with errors despite data load being successful.(8412247, 8304235, 8269211)•Console. Integration Services Console was not granting re-access to users after they exited the application because user ID information was not being cached.(8412193, 7714801)•Data and member loads. Data and member loads failed when run from a .cbs script, but Integration Services status indicated the load was successful.(8412254, 8304252, 7721750)Defects Fixed in Release 11.1.1.2These defects are fixed in Integration Services release 11.1.1.2. The defect number follows thedescription of the defect.Drill-Through Template SQL. Incorrect table alias names were generated in the SQL query created by Integration Server.(6584510, 8-631137724)Drill-Through Template SQL. Integration Server terminated abnormally when verifying Drill-Through Template SQL.(6851055)Data Load. When the Default Miscellaneous Member option was enabled for the aggregate storage option, the default members were not added and the data load failed. The data load failure has been addressed; however, you may need to reload any rejected records.(7607685, 7268275)Defects Fixed in Release 11.1.1.1These defects are fixed in Integration Services release 11.1.1.1. The defect number follows thedescription of the defect.Console. When building a cube in Integration Services Release 9.3.1., using a metaoutline that been generated in Release 7.x, a false error condition sometimes prevented users from building the cube.(7138407)Console. When several batch jobs for data loads were run consecutively, and one or more scripts had empty parameters, Integration Services would sometimes shut down, forcing a manual restart.(7212289)Load. In data loads, the displayed total of records loaded and records rejected exceeded the number of records in the outline.(7310328, 7158311)Drill-Through. If users changed passwords, sometimes drill-through report operations would fail because of encryption errors.(7360009, 7393959)Top of DocumentKnown Issues in Release 11.1.1.3The following issues are the noteworthy known issues of this release.ODBC Notes•“Localhost” is not a valid server name. In the Login dialog box, you must specify a computer name or IP address in both the Integration Server frame and the Essbase Server frame.•For UNIX systems, Integration Services installation creates a template odbc.ini. To store information about how to connect to a relational data source, edit the file using your preferrededitor.•To configure a Teradata data source, the TDODBC environment variable must be set manually. Configuration File Entry for DB2 OS/390DB2 OS/390 is supported only as a data source and should not be used as an OLAP Metadata Catalog.If you use IBM DB2 OS/390 as a data source, you must add an entry to the ais.cfg file for each data source name you configured in your DataDirect Wire Protocol driver for DB2. Add an entry to the ais.cfg file in the following format: [DS:dsn:390]. For example, using the sample database, TBC, the following is the entry to the ais.cfg file:[DS:TBC:390]JISX0213 Japanese Character Set Not SupportedThe JISX0213 Japanese character set, which replaces the JISX0208 and JISX0212 Japanese character sets, is supported on Windows Vista.The Oracle Essbase family of products, including Integration Services, does not support the JISX0213 Japanese character set. (6576813, 8-563756229)Windows Server 2003 SP1 May Experience Abnormal ShutdownIf you are using Windows Server 2003 Service Pack 1 with Integration Services, your system may experience an abnormal shutdown. To prevent this, install the update from Microsoft by going to: /kb/923996/Column Names with 0x5C Double-byte Characters May Not DisplayIf column names contain 0x5C double-byte characters, the columns may not display in a table.(6551802, 2-HYPER00071286)MBCS Characters Should Not Be Used in Names of Some Entities Multibyte-character-set characters should not be used in the names of these entities:•OLAP models•Metaoutlines•Data sources•Owners(6550123; 2-HYPER00073848, 73905, 73906, 73910, and 74122)Oracle Database as Unicode Data SourceIf you run Integration Services on Windows and access an Oracle database as an MBCS or Unicode data source using the DataDirect Wire Protocol Driver, characters corresponding to 0x4E88 in UTF-8 encoding may not be processed properly.Time-based Incremental Load LimitationDue to database restrictions in some databases such as Oracle, if the IN clause has more than 1,000 outline members that require updating during time-based incremental loads, SQL statements may not execute. In such cases, we recommend full loads rather than time-based incremental loads.Unable to Validate @ISUDA FunctionsAlthough Oracle Essbase Administration Services validates recently added functions in formulas for the block storage option (BSO), Integration Services may not. We strongly recommend you use Oracle Essbase Administration Services to validate these functions.Japanese EncodingIf you use Japanese encoding, Oracle recommends you use MS932 encoding instead of Shift-JIS.Specifying Ancestors in Template SQL for Drill-Through Operations on Duplicate MembersIn general, Oracle does not recommend using Drill-Template SQL for OLAP metaoutlines that support duplicate member names.If you still choose to use Drill-Through Template SQL for OLAP metaoutlines that support duplicate member names, Oracle suggests you take the following actions in order for Drill-Through Template SQL to function correctly:•Associate database keys for the drill-through-enabled members.To do this, in the General tab of the Member Properties dialog box for each drill-through-enabled member, in the Member Key Column drop-down list, select the appropriate database key columns for the drill-through-enabled members.These actions are valid for drill-through reports defined on any member level, including level zero members.•For drill-through defined on level zero members (leaf nodes), you can also fully identify a duplicate member by specifying all the ancestors for that member in Template SQL.In the following example of Template SQL using the TBC sample, for a drill-through intersectiondefined on Product.SKU, a WHERE clause was added (see bolded text) for the ancestor of SKU in order to fully define the member:SELECT DISTINCT ac."SKU", ac."SKU_ALIAS", ac."CAFFEINATED", ac."OUNCES",ac."PKGTYPE", ac."INTRODATE", aa."SUPPLIERID", ad."SUPPLIER_ALIAS", ad."ADDRESS", ad."CITY", ad."STATE", ad."ZIP", ad."COUNTRY"FROM TBC.SALES aa, TBC.PRODUCTDIM ab, TBC.PRODUCT ac, TBC.SUPPLIER adWHERE aa."PRODUCTID" = ac."PRODUCTID"AND aa."SUPPLIERID" = ad."SUPPLIERID"AND ac."SKU" = ab."SKU"AND ((($$Year-COLUMN$$ IN ( $$Year-VALUE$$))))AND (ab."FAMILY" in ('100'))AND (((ab."FAMILY" in ('100','200','300','400','Diet')) AND ($$Product-COLUMN$$ IN ( $$Product-VALUE$$))))The caveat to the solution given in the above example is that the member is fully defined only for children of Product 100; it is not practical to define Template SQL for every possible ancestor value.(6807790, 1-156SS6)Runtime Filter Condition Limitation for Customized Drill-Through OperationsIf you customize drill-through reports at run time and add a user-defined filter, keep the length of the filter under 8KB; otherwise, some members may not be included in the drill-through report query.(1-147T5F)Users Without Create Access to Essbase Server Cannot Verify Member FormulasTo verify member formulas, users must have Create access to the Essbase Server.(1-82215061)Updating Drill-Through Reports Not Supported for Outlines Containing Duplicate Member NamesRelease 11.1.1 does not support updating drill-through information in an outline containing duplicate member names. For such outlines, you should perform a full member load.Drill-Through Operations Are Not Supported on Unicode Data in Release 11.1.1 Records Rejected During Data Load when Alternate Fact Table SelectedIf the Time dimension is built directly from the fact table, and you select an alternate fact table, the data load may reject those records for which time members are not found in Oracle Essbase. In such cases, be sure that the time dimension is built to span time periods of all fact tables.(1-194924642)SQL Server 2005 Requires Name of New Executable in Sample Creation Scripts to Create TBC Sample Tables and to Load Sample DataThe current batch files and scripts used to create the TBC sample tables and to load the sample data do not function with SQL Server 2005. These files require the executable named SQLCMD.EXE.WORKAROUND: Edit the batch file install_sqlsrv.bat located in the AIS\samples directory, and replace the name of the executable ISQL.EXE with the new executable name SQLCMD.EXE.(8-532792001)Application Naming RestrictionsWhen managing Oracle’s Hyperion Shared Services models and naming applications, you cannot use the forward slash (/), backslash (\), or double quotation (“) characters.(8-514151218)Read-only Permission to External Data Sources for Drill-Through ReportsOracle recommends that your users be granted read-only permission to external data sources for drill-through reports and custom data load SQL.Adding Alternate Hierarchy a Second Time Duplicates ValuesWhen building a shared hierarchy for a block storage database, adding a shared hierarchy a second time may duplicate the values stored on a single element, resulting in incorrect data. This problem occurs when shared members are from the same hierarchy, such as these two hierarchies from theTBC sample database: Diet > 100-20 and 100 > 100-20.WORKAROUND: Use user-defined SQL to edit data load commands.(6584211)Start and Stop Controls for Windows Service on Windows 2003 SP1On Windows 2003 SP1, after installing Integration Services, the EPM System Installer uses Windows services to start and stop the services for Integration Services. Sometimes after stopping the service using Windows Services console, the Integration Server process, olapisvr.exe, continues to run.WORKAROUND: Manually stop the “olapisvr.exe” and “olapisvc.exe” processes by using the Windows Task Manager.(7253757)Long Table and Column Names Truncated in the Drill-Through WizardWhen using the Drill-Through Wizard in Essbase Spreadsheet Add-in, users will only see the first 80 characters of the table or column name.(6536313)System Limitations•Integration Services supports full Unicode functionality only on Oracle relational database servers.•Oracle recommends you use the same language for your Data source names as you use for your applications. (English will work in all cases.)•When creating a drill-through report with an OLAP intersection level based on a user-defined dimension or column, neither of the variables of the form $$dimension-COLUMN$$ or $$dimension-VALUE$$ will be created.•To retain and upgrade Dynamic Time Series settings made in Integration Services prior to release6.5.4, open and save the metaoutline using release 11.1.1. For recursive and alternate hierarchies,we recommend that you verify your settings.•Integration Services does not support user-defined tables created in Sybase or Informix.Top of Document Documentation UpdatesAccessing Hyperion Product DocumentationThe most recent version of each Hyperion product guide is available for download from theDocumentation area of the Oracle Technology Network (OTN) Web site(/technology/index.html). Deployment-related documentation is also availablefrom the Oracle E-Delivery Web site (/EPD/WelcomePage/get_form).Individual product guides are available for download on the Oracle Technology Network (OTN) Web site only.Note: Not all of the documentation for this product has been updated from Release 11.1.1.1 or11.1.1.2. Similarly, the product UI may not have been updated from Release 11.1.1.1 or 11.1.1.2. Oracle Call Interface No Longer SupportedOracle® Essbase Integration Services no longer supports Oracle Call Interface (OCI). References in the documentation to OCI should be disregarded.Top of DocumentCopyright © 2009, Oracle and/or its affiliates. All rights reserved.。

Oracle错误代码大全

Oracle错误代码大全•Introduction•ORA-00001: Unique Constraint Violated•ORA-00904: Invalid Identifier•ORA-01017: Invalid Username/Password•ORA-12154: TNS:could not resolve the connect identifier specified•ConclusionIntroduction在使用 Oracle 数据库时，用户可能会遇到各种各样的错误代码。

错误代码是 Oracle 数据库用于通知用户发生了什么问题的一种标准化方式。

本文档旨在向用户提供一个 Oracle 错误代码的大全，以帮助用户更好地理解和解决这些错误。

ORA-00001: Unique Constraint ViolatedORA-00001 错误通常表示在插入或更新操作中违反了唯一约束。

这意味着在插入或更新数据时，新数据中的一个或多个列的值与已存在的数据中的某个列的值冲突。

要解决此错误，可以采取以下措施： - 检查数据库中是否存在重复的唯一约束。

- 检查插入或更新数据的值是否与表中现有数据的值冲突。

- 检查是否有其他进程正在访问或修改正在插入或更新的数据。

ORA-00904: Invalid IdentifierORA-00904 错误表示在 SQL 语句中使用了无效的标识符。

这可能是由于以下原因导致的： - SQL 语句中引用了不存在的列名。

- SQL 语句中引用了不存在的表名。

- SQL 语句中引用了不存在的别名。

- SQL 语句中引用了无效的变量名。

要解决此错误，可以采取以下措施： - 检查 SQL 语句中的所有列名、表名、别名和变量名的拼写是否正确。

-确保所引用的对象〔表、列等〕存在于数据库中。

- 使用适宜的引用标记，例如双引号或方括号，以确保正确解析标识符。

Oracle从入门到精通-经典资料

数据缓冲区
用于存储从磁盘数据文件中读入的数据，所有用户共享。服务器进程将读入的数据保存在数据缓冲区中，当后续的请求需要这些数
据时可以在内存中找到，不需要再从磁盘读取，提高了读取速度。数据缓冲区的大小对数据库的读取速度有直接的影响。
日志缓冲区
日志记录数据库的所有修改信息，日志信息首先产生于日志缓冲区。当日志缓冲区的日志数据达到一定数量时，由后台进程将日志数据写入日
5
Oracle 数据库简介 2-2
Oracle数据库基于客户端/服务器技术
网络
请求
服务器
响应
数据库服务器对数据库表进行最佳管理，处理多个客户端对客同户一端数应据用的程并序发通访过问向。服全务面器地请保求持并数接据收完信整息性的，方并式控与制数数据据
库进行交互库。访它问充权当限用等户安与全数性据需库求之间的接口
Oracle 客户端
Oracle 服务器
tnsnames.ora
25
listener.ora
Oracle 网络配置 2-2
服务器端监听器配置信息包括监听协议、地址及其他相关信息。配置信息保存在名为listener.ora 的文件中。在安装服务器软件时自动配置一个监听器
客户端的网络服务名配置信息包括服务器地址、监听端口号和数据库SID等，与服务器的监听器建立连接。配置信息保存在名为tnsnames.ora的文件中
目标
4
Oracle 数据库简介 2-1
对象关系型的数据库管理系统 (ORDBMS) 在管理信息系统、企业数据处理、因特网及电子
商务等领域使用非常广泛在数据安全性与数据完整性控制方面性能优越跨操作系统、跨硬件平台的数据互操作能力

oracle mac基本操作方式

一、Oracle Mac基本操作方式简介Oracle是一种功能强大的数据库管理系统，能够在Mac评台上进行操作。

在使用Oracle数据库时，我们需要掌握一些基本的操作方式，以便能够高效地管理数据库，并进行数据的存储、检索和处理。

本文将介绍Oracle在Mac上的基本操作方式，帮助读者更好地了解和使用这一数据库管理系统。

二、安装Oracle Database on Mac1. 下载Oracle Database安装包在Oracle冠方全球信息站上下载适用于Mac评台的Oracle Database安装包。

在下载页面上，我们需要选择适合自己系统版本的安装包进行下载，并确保安装包无损。

2. 安装Oracle Database打开下载好的安装包，按照安装向导逐步进行安装步骤。

安装过程中需要设置管理员账号和密码，以及选择数据库的安装路径和端口等信息。

3. 配置Oracle Database安装完成后，需要进行一些基本的数据库配置，如创建数据库和初始化参数等。

配置完成后，就可以上Oracle Database了。

三、启动和关闭Oracle Database1. 启动Oracle Database在Mac终端输入以下命令来启动Oracle Database： ```sqlplus / as sysdbastartup```2. 关闭Oracle Database同样，在终端输入以下命令来关闭Oracle Database： ```sqlplus / as sysdbashutdown```四、连接到Oracle Database1. 使用SQL*Plus连接在终端输入以下命令来连接到Oracle Database：```sqlplus username/passworddatabase```2. 使用SQL Developer连接在Mac上安装SQL Developer，并通过界面进行连接设置，以便连接到Oracle Database进行操作。

jdbc连接oracle的基本步骤

一、概述在Java编程中，JDBC（Java Database Connectivity）是一个重要的API，它允许开发者通过使用标准的SQL语句来访问数据库。

对于访问Oracle数据库，JDBC也是常用的技术之一。

本文将介绍JDBC 连接Oracle数据库的基本步骤，以帮助读者快速了解并使用JDBC来实现与Oracle数据库的连接。

二、JDBC连接Oracle的准备工作1. 确认Oracle数据库驱动在使用JDBC连接Oracle数据库之前，首先需要确认已经安装了适当版本的Oracle数据库驱动。

Oracle冠方提供了多个版本的JDBC驱动程序，开发人员应当选择合适的版本，并将其添加到项目的类路径中。

2. 确保已经拥有Oracle数据库的连接信息在进行连接之前，需要确保已经获得了Oracle数据库的连接信息，包括数据库的主机名、端口号、数据库实例名、用户名和密码等。

这些信息将在后续的程序中被用到。

三、创建JDBC连接Oracle的步骤1. 加载JDBC驱动程序连接Oracle数据库之前，首先需要加载JDBC驱动程序。

使用Class.forName()方法，并传入JDBC驱动程序的类名，来加载驱动程序。

例如：```javaClass.forName("oracle.jdbc.driver.OracleDriver");```加载驱动程序后，即可使用JDBC与Oracle数据库进行通信。

2. 建立数据库连接一旦加载了驱动程序，接下来就可以建立与Oracle数据库的连接。

使用DriverManager.getConnection()方法，并传入数据库的连接信息，来建立连接。

例如：```javaString url = "jdbc:oracle:thin:主机名:端口号:数据库实例名";String user = "用户名";String password = "密码";Connection connection = DriverManager.getConnection(url, user, password);```其中，url是Oracle数据库的连接URL，用户名和密码分别是数据库的登入名和密码。

oracle的power函数

oracle的power函数Oracle数据库中的POWER函数用于计算一个数的指定幂次。

它的一般语法如下：POWER(base, exponent)其中，base是所需计算的底数，而exponent则是底数的指数。

以下是POWER函数的详细解释和示例：1.POWER函数的参数类型：- base：可以是任何数字类型，如整数、小数或者实数。

- exponent：可以是任何整数类型，包括正数、负数或零。

2.返回值类型：- POWER函数的返回值类型与base的数据类型相同。

3.示例：a.使用整数作为底数和指数的示例：SELECT POWER(2, 3) AS Result FROM dual;--输出：82的3次方等于8b.使用小数作为底数和指数的示例：SELECT POWER(2.5, 2) AS Result FROM dual;--输出：6.252.5的2次方等于6.25c.使用负数作为指数的示例：SELECT POWER(4, -2) AS Result FROM dual;--输出：0.06254的-2次方等于1/16，即0.0625d.使用0作为底数的示例：SELECT POWER(0, 3) AS Result FROM dual;--输出：00的任何正指数次方都等于0。

e.使用0作为指数的示例：SELECT POWER(2, 0) AS Result FROM dual;--输出：1任何数的0次方都等于1f.使用POWER函数进行表达式计算的示例：SELECT POWER(2 + 3, 2 - 1) AS Result FROM dual; --输出：5(2+3)的(2-1)次方等于5需要注意的是，POWER函数的底数不能为负数，并且不能为0且指数不能为负数的情况下，否则会返回空。

在进行POWER函数计算时，应始终注意数值范围以避免溢出或得到不准确的结果。

除了POWER函数，Oracle还提供了其他一些数学函数，如SQRT（计算开方）、LOG（计算对数）、EXP（计算指数）、ABS（返回绝对值）等，以满足各种数学计算的需求。

Oracle数据库解除连接、连接和升级到新CDB19c F10901-02说明书

Oracle® DatabaseUnplugging, Plugging, and Upgrading a PDB to a New CDB19cF10901-02May 2019Oracle Database Unplugging, Plugging, and Upgrading a PDB to a New CDB, 19cF10901-02Copyright © 2018, 2019, Oracle and/or its affiliates. All rights reserved.Primary Authors: Sunil Surabhi, Nirmal KumarContributing Authors: Lance Ashdown, Padmaja Potineni, Rajesh Bhatiya, Prakash Jashnani, Douglas Williams, Mark BauerContributors: Roy Swonger, Byron Motta, Hector Vieyra Farfan, Carol Tagliaferri, Mike Dietrich, Marcus Doeringer, Umesh Aswathnarayana Rao, Rae Burns, Subrahmanyam Kodavaluru, Cindy Lim, Amar Mbaye, Akash Pathak, Thomas Zhang, Zhihai ZhangThis 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.ContentsPrefaceUse Case Scenario for this Document iv Documentation Accessibility iv1 Upgrading Multitenant Architecture Sequentially Using Unplug-PlugAbout Upgrading Pluggable Databases (PDBs) Sequentially1-12 Upgrading Pluggable Databases SequentiallyUnplugging the Earlier Release PDB from the Earlier Release CDB2-1 Plugging in the Earlier Release PDB to the Later Release CDB2-2 Upgrading the Earlier Release PDB to the Later Release2-3 Use Inclusion or Exclusion Lists for PDB Upgrades2-4PrefacePrefaceThis guide provides a compilation of topics from the Oracle Database user assistancedocumentation that are collected to help you complete a specific use case scenario.•Use Case Scenario for this Document•Documentation AccessibilityUse Case Scenario for this DocumentUse this scenario document to assist you to unplug earlier release PDBs, plug theminto a later release CDB, and then upgrade the PDBs.Prerequisites for this Scenario•You have installed the same release Oracle Database software on the destination server, and it is updated to the same release update and release update revision.•You have completed preparation of the new Oracle home.•You have run the Pre-Upgrade Information Tool on the PDB.•The endian format of the source CDB and the target CDB are identical.•The same set of options are installed on the source CDB and the target CDB.•The source CDB and the target CDB have compatible character sets and national character sets.The source CDB and the target CDB can be on the same or different server hardware.Outline for this Scenario1.Upgrading Multitenant Architecture Sequentially Using Unplug-Plug. Learnabout the unplug-plug method for carrying out PDB upgrades.2.Upgrading Pluggable Databases Sequentially. Use these procedures tocomplete your PDB upgrade:a.Unplug earlier release PDBs from the earlier release CDB.b.Plug in the earlier release PDB to the later release CDB.c.Upgrade the earlier release PDB to the later release CDB.e inclusion or exclusion lists for PDB upgrades.These steps correspond to the chapters in this document. Documentation AccessibilityPreface For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at /pls/topic/lookup?ctx=acc&id=docacc.Access to Oracle SupportOracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit /pls/topic/ lookup?ctx=acc&id=info or visit /pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.1Upgrading Multitenant Architecture Sequentially Using Unplug-PlugTo upgrade pluggable databases (PDBs) that are in an earlier release multitenantcontainer databases (CDBs), Oracle Database Release 12c (12.1.0.1) and later, youcan unplug the PDBs from the earlier release CDB, and plug the PDBs into the laterrelease CDB.•About Upgrading Pluggable Databases (PDBs) SequentiallyYou can upgrade PDBs by unplugging a PDB from an earlier release CDB,plugging it into a later release CDB, and then upgrading that PDB to the laterrelease.About Upgrading Pluggable Databases (PDBs) SequentiallyYou can upgrade PDBs by unplugging a PDB from an earlier release CDB, plugging itinto a later release CDB, and then upgrading that PDB to the later release.CDBs can contain zero, one, or more pluggable databases (PDBs). After you install anew Oracle Database release, or after you upgrade the CDB (CDB$ROOT), you canupgrade one or more PDB without upgrading all of the PDBs on the CDB.You can choose the upgrade plan that meets the needs for your service delivery. Forexample, you can use Oracle Database Upgrade Assistant (DBUA) to upgrade a set ofPDBs, or you can use a manual upgrade to upgrade PDBs individually, or withinclusion or exclusion lists. You can upgrade the CDB and all PDBs (an In Parallelmanual upgrade), or you can upgrade the CDB, and then upgrade PDBs sequentially,either individually, or in sets using inclusion or exclusion lists.The following is a high-level list of the steps required for sequential PDB upgrades:1.Unplug the earlier release PDB from the earlier release CDB.2.Drop the PDB from the CDB.3.Plug the earlier release PDB into the later release CDB.4.Upgrade the earlier release PDB to a later release.With Oracle Database 12c Release 2 (12.2) and later releases, you can provide lists tothe Parallel Upgrade Utility to upgrade PDBs:•Priority lists, to set the order in which PDBs are upgraded•Inclusion lists, which enable you to designate a set of PDBs to upgrade after the PDBs listed in the priority list are upgraded•Exclusion lists, which enable you to designate a set of PDBs that are not upgradedRelated Topics•Oracle Database Backup and Recovery User’s Guide •Oracle Database Administrator’s Guide Chapter 1About Upgrading Pluggable Databases (PDBs) Sequentially2Upgrading Pluggable Databases SequentiallyTo upgrade PDBs after upgrading the Container Database (CDB), use the unplug-plugtechnique.•Unplugging the Earlier Release PDB from the Earlier Release CDBTo prepare for upgrading the PDB, use this procedure to unplug the PDB from theearlier release CDB.•Plugging in the Earlier Release PDB to the Later Release CDBTo Plug the PDB from the earlier release CDB to the later release CDB, use theCREATE PLUGGABLE DATABASE command.•Upgrading the Earlier Release PDB to the Later ReleaseOpen PDBs in UPGRADE mode use the Parallel Upgrade Utility to carry out theupgrade of the earlier-release PDB to the release level of the CDB.•Use Inclusion or Exclusion Lists for PDB UpgradesIf you want to upgrade a subset of earlier release PDBs, then use inclusion orexclusion lists to avoid reupgrading the CDB or PDBs that are at the new releaselevel.Unplugging the Earlier Release PDB from the Earlier Release CDBTo prepare for upgrading the PDB, use this procedure to unplug the PDB from theearlier release CDB.1.Run the Pre-Upgrade Information Tool on the PDB.For example, where the PDB named salespdb is running in the CDBin $ORACLE_HOME_12.2:$ORACLE_HOME_12.2/jdk/bin/java -jar$ORACLE_HOME_19/rdbms/admin/preupgrade.jar dir /tmp -c salespdb2.Run preupgrade_fixups.sql on your source database.For example:CONNECT / AS SYSDBASQL> ALTER SESSION SET CONTAINER=salespdb;SQL> @/tmp/preupgrade_fixups_salespdb.sql3.Follow all recommendations listed in preupgrade.log.4.Close the PDB you want to unplug.Chapter 2Plugging in the Earlier Release PDB to the Later Release CDB For example, use the following command to close the PDB salespdb:SQL> ALTER PLUGGABLE DATABASE salespdb CLOSE;5.Log back in to CDB$ROOT:CONNECT / AS SYSDBASQL> ALTER SESSION SET CONTAINER=CDB$ROOT;6.Unplug the earlier release PDB using the following SQL command syntax, wherepdb is the name of the PDB, and path is the location of the PDB XML file:ALTER PLUGGABLE DATABASE pdb UNPLUG INTO 'path/pdb.xml';For example, where the pdb name is salespdb and path is /home/oracle/salespdb.xml:SQL> ALTER PLUGGABLE DATABASE salespdb UNPLUG INTO '/home/oracle/salespdb.xml';The following response displays when the command is completed:Pluggable database altered7.Drop the pluggable database salespdb, but keep data files.Oracle recommends that you drop salespdb after this procedure to clean upleftover information in the CDB views, and to help to avoid future issues. As a bestpractice guideline, back up your PDB in the destination CDB first, and then issuethe DROP command on the source.To drop the pluggable database, enter the following command:SQL> DROP PLUGGABLE DATABASE salespdb KEEP DATAFILES;8.Exit.Plugging in the Earlier Release PDB to the Later Release CDBTo Plug the PDB from the earlier release CDB to the later release CDB, use theCREATE PLUGGABLE DATABASE command.This procedure example shows how to plug in a PDB when you are using Oracle-Managed Files. Refer to Oracle Database Administrator’s Guide for additionalinformation about plugging in PDBs.1.Connect to the later release CDB.2.Plug in the earlier release PDB using the following SQL command, where pdb isthe name of the PDB, and path is the path where the PDB XML file is located:CREATE PLUGGABLE DATABASE pdb USING 'path /pdb .xml';For example:SQL> CREATE PLUGGABLE DATABASE salespdb USING '/home/oracle/salespdb.xml';The following response displays when the command is completed:Pluggable database created.Related Topics•Oracle Database Administrator’s GuideUpgrading the Earlier Release PDB to the Later ReleaseOpen PDBs in UPGRADE mode use the Parallel Upgrade Utility to carry out the upgradeof the earlier-release PDB to the release level of the CDB.1.If needed, switch to the PDB that you want to upgrade. For example, enter thefollowing command to switch to the PDB salespdb :SQL> ALTER SESSION SET CONTAINER=salespdb;2.Open the PDB in UPGRADE mode.SQL> ALTER PLUGGABLE DATABASE OPEN UPGRADE;3.Upgrade the PDB using the Parallel Upgrade Utility command (catctl.pl , or theshell utility dbupgrade ).When you upgrade a PDB, you use the commands you normally use with theParallel Upgrade Utility. However, you also add the option -c PDBname to specifyChapter 2Upgrading the Earlier Release PDB to the Later Releasewhich PDB you are upgrading. Capitalize the name of your PDB as shown in the following example using the PDB named salespdb :$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catctl.pl -d \$ORACLE_HOME/rdbms/admin -c 'salespdb' -l $ORACLE_BASE catupgrd.sql4.Review results.The default file path for the logs is in the path Oracle_base /cfgtoollogs/dbname /upgradedatetime , where Oracle_base is the Oracle base path,dbname is the database name, and upgradedatetime is the date and time for the upgrade. The date and time strings are in the character string formatYYYYMMDDHHMMSC , in which YYYY designates the year, MM designates the month, DD designates the day, HH designates the hour, MM designates theminute, and SC designates the second.For example:$ORACLE_BASE/cfgtoollogs/salespdb/upgrade20181015120001/upg_summary.log 5.Log in to SQL*Plus, and open the PDB to execute post-upgrade fixups, and torecompile the INVALID objects in the database:SQL> STARTUP;SQL> ALTER SESSION SET CONTAINER=salespdb;e the utility catcon.pl to run the script postupgrade_fixups.sql :$ORACLE_HOME/perl/bin/perl catcon.pl –c 'salespdb' -n 1 -e -bpostfixups -d '''.''' /tmp/cfgtoollogs/salespdb/preupgrade/postupgrade_fixups.sqle the utility catcon.pl to run utlrp.sql from the $ORACLE_HOME/rdbms/admin directory:$ORACLE_HOME/perl/bin/perl catcon.pl –c 'salespdb'-n 1 -e -b comp -d '''.''' utlrp.sqlThe script recompiles INVALID objects in the database, and places a log file in the current directory with the name comp0.log .Use Inclusion or Exclusion Lists for PDB UpgradesIf you want to upgrade a subset of earlier release PDBs, then use inclusion orexclusion lists to avoid reupgrading the CDB or PDBs that are at the new release level.Oracle recommends that you record the containers that you upgrade, and useinclusion or exclusion lists to exclude these containers from successive bulk upgrades.Excluding upgraded containers from successive bulk upgrades ensures that theupgrade only runs on PDBs that require the upgrade. Avoiding reupgrades minimizes the overall upgrade time, and avoids unnecessary unavailability.For example: If you have installed Oracle Database using a multitenant architecture deployment, then the containers CDB$ROOT , PDB$SEED , and any other PDBs createdChapter 2Use Inclusion or Exclusion Lists for PDB Upgrades2-4Chapter 2Use Inclusion or Exclusion Lists for PDB Upgrades when the CDB was created, are part of the new release multitenant architecture. If you upgraded a CDB, and at the same time upgraded a set of PDBs to the new release, then you do not need to upgrade either the CDB containers or the upgraded PDBs again.In either case, when you plug in earlier release PDBs and then upgrade them, upgrade the PDBs with either an exclusion list, or an inclusion list:•Use an inclusion list to specify only the set of PDBs that you want to upgrade.•Use an exclusion list to exclude the CDB and PDB containers that are already upgraded.If you do not use an inclusion list or an exclusion list to limit the upgrade scope, then the Parallel Upgrade Utility (catctl.pl) attempts to upgrade the entire CDB, not just the PDBs that require the upgrade. During that upgrade process, your system undergoes needless downtime. The inclusion list and the exclusion list options are mutually exclusive.2-5IndexEexclusion listsand PDB upgrades, 2-4OOracle Multitenant upgrades, 1-1PPDB upgrades after CDB upgrade, 2-4PDBsupgrading individually, 1-1TtroubleshootingPDB upgrades, 2-4Index-1。

Oracle Database Migration Assistant for Unicode 产品

database to maintain data compliance with the Unicode Standard. Even with a database that uses the Unicode character set, incorrectly configured applications may introduce invalid character codes into the database and cause data corruption. The DMU’s Validation Mode feature can help expose the source of the issues and detect data problems, including presence of Unicode replacement characters(U+FFFD), ill-formed Unicode byte sequences, non-shortest form UTF-8, irregular UTF-8 byte sequences (6-byte surrogate pairs), unpaired surrogates, and Unicode noncharacters, before these issues are even noted by end-users.Release History∙DMU 1.1 – October 28, 2011∙DMU 1.2 – February 20, 2013∙DMU 2.0 – March 18, 2014∙DMU 2.1 – May 26, 2015∙DMU 2.1.1 – June 14, 2016∙DMU 2.2 – November 9, 2017Contact UsFor more information about Oracle Database Migration Assistant for Unicode, please visit or call +1.800.ORACLE1 to speak to an Oracle representative.Copyright © 2009, Oracle and/or its affiliates. All rights reserved.This document is provided for information purposes only and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Unicode is a registered trademark of Unicode, Inc. in the United States and other countries. Other names may be trademarks of their respective owners. 0109。