oracle11g使用手册
Oracle11g简单安装和使用教程
Oracle11g简单安装和使⽤教程⼀、Oracle11g的安装过程（Windows版本）很简单，步骤为：1. ⾸先从Oracle官⽅⽹站上下载Oracle11g数据库，⼤约为1.7G。
解压后，setup.ext就可以开始安装2. 在安装开始的时候，会要求填写⼀些信息。
需要注意两项：1）SID。
这应该是安装的数据库的ServiceID，在数据库安装成功后，在Window的服务中会多⼀项OracleServiceSID的服务,这⾥的SID就是在安装时填写的字符串。
因此在连接数据库的时候都需要有SID信息，⽐如使⽤JDBC连接的时候。
2）密码。
这⾥的密码是系统管理员的密码(sys,sysdba)。
3. 接下来就可以按照界⾯提⽰安装了，安装过程中会检查电脑配置，如果符合要求就可以继续安装。
4. 安装结束后，会⽣成⼀个database config的界⾯，上⾯有安装的数据库的sid, port等信息。
（可以把这个界⾯保存起来，防⽌以后忘记相关信息）⼆、Oracle的连接安装完成后，就可以连接数据库了，连接Oracle可以通过PLSql,SQLDeveloper，建议可以使⽤SQLDeveloper，因为它界⾯不错。
在程序->Oracle11g->应⽤开发程序下⾯有SQLDeveloper，第⼀次启动时，需要设置java.exe的路径（SQLDeveloper应该是JAVA开发的），之后就可以看到连接界⾯了。
接下来需要填写连接信息，第⼀次连接时，必须先通过sysdba进⾏连接，所以要使⽤安装时设置的密码，其它信息如下：1）需要选择登录⾝份为系统管理员2)sid安装时设置的sid值3)端⼝号⼀般默认是1521注意在连接的时候，需要确保在服务中的OracleServiceSID和OracleOraDb11g_home1TNSListener是打开的填好上⾯的信息就可以登录了。
如果要创建⾃⼰的数据库，需要下⾯⼏个过程:1.创建表空间，语句如下：select file_Name from dba_data_files (查询表空间)create tablespace RDHISV151008datafile '/app/ADMINISTRATOR/oradata/orcl/RDHISV151008.dbf' size 400m;2.创建⼀个⽤户，并默认为SampleTableSpace表空间create user RDHISV151008 identified by eplugger;(创建⽤户设置密码)alter user RDHISV151008 default tablespace RDHISV151008;(绑定表空间到⽤户)3.为⽤户授权:grant dba to RDHISV151008;(赋权限)注意，接下来的操作必须在SampleUser的连接中进⾏，步骤如下:1.在SQLDeveloper中新建⼀个连接，并使⽤刚才创建的SampleUser信息进⾏登录2.接下来在SampleUser的连接中就可以使⽤sql进⾏各种操作，这些操作都会在SampleTableSpace中进⾏。
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数据库存储管理员指南11g Release 2 (11.2) E10500-01说明书
Oracle® Database Storage Administrator's Guide 11g Release 2 (11.2)E10500-01August 2009Oracle Database Storage Administrator's Guide, 11g Release 2 (11.2)E10500-01Copyright © 2007, 2009, Oracle and/or its affiliates. All rights reserved.Contributing Authors: Jerry Abraham, Prasad Bagal, Mark Bauer, Eric Belden, Bill Bridge, Chan Chan, Xiaobin Chen, Hanlin Chien, Jonathan Creighton, Steve Fogel, Dave Friedman, Barb Glover, Fred Glover, Shie-rei Huang, Diane Lebel, Rich Long, Colin McGregor, Gregory Mengel, Valarie Moore, Darshan Nagarajappa, Harish Nandyala, Bob Nelson, Satish Panchumarthy, Kathy Rich, Francisco Sanchez, Santhosh Selvaraj, Ara Shakian, Duane Smith, Joshua Smith, Malai Stalin, Amar Subba, Yaser Suleiman, Michael Timpanaro-Perrotta, Nitin Vengurlekar, Anton Verhulst, Radek Vingralek, Ron Weiss, Rajiv Wickremesinghe, Jim A. Williams, Sivakumar Yarlagadda, Song Ye, Krishnan Yegnashankaran, Hector Yuen This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.This software 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 which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications.Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.This software and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.ContentsPreface (xxi)Audience (xxi)Documentation Accessibility (xxi)Related Documents (xxii)Conventions (xxii)What's New in Oracle Database Storage? (xxiii)New Storage Features for Oracle Database 11g Release 2 (11.2) (xxiii)New Storage Features for Oracle Database 11g Release 1 (11.1) (xxvi)1 Introduction to Oracle Automatic Storage ManagementOverview of Oracle Automatic Storage Management...................................................................... 1-1 Understanding Oracle ASM Concepts................................................................................................. 1-2 About Oracle ASM Instances........................................................................................................... 1-2 About Oracle ASM Disk Groups..................................................................................................... 1-6 About Mirroring and Failure Groups............................................................................................. 1-6 About Oracle ASM Disks.................................................................................................................. 1-7 Allocation Units ......................................................................................................................... 1-7 About Oracle ASM Files.................................................................................................................... 1-7 Extents.......................................................................................................................................... 1-8Oracle ASM Striping................................................................................................................... 1-9File Templates.............................................................................................................................. 1-9 Understanding Oracle ASM Disk Group Administration............................................................... 1-9 About Discovering Disks...............................................................................................................1-10 About Mounting Disk Groups......................................................................................................1-10 About Adding and Dropping Disks.............................................................................................1-10 About Online Storage Reconfigurations and Dynamic Rebalancing......................................1-10 2 Considerations for Oracle ASM StorageStorage Resources for Disk Groups...................................................................................................... 2-1 Oracle ASM and Multipathing.............................................................................................................. 2-3 Recommendations for Storage Preparation........................................................................................ 2-4iii3 Administering Oracle ASM InstancesOperating With Different Releases of Oracle ASM and Database Instances Simultaneously3-1 Configuring Initialization Parameters for an Oracle ASM Instance............................................. 3-2 Initialization Parameter Files for an Oracle ASM Instance.......................................................... 3-3 Backing Up, Copying, and Moving an Oracle ASM Initialization Parameter File................... 3-4 Setting Oracle ASM Initialization Parameters............................................................................... 3-5 Automatic Memory Management for Oracle ASM............................................................... 3-5 Oracle ASM Parameter Setting Recommendations....................................................................... 3-6 ASM_DISKGROUPS................................................................................................................... 3-7ASM_DISKSTRING.................................................................................................................... 3-7ASM_POWER_LIMIT................................................................................................................ 3-8ASM_PREFERRED_READ_FAILURE_GROUPS.................................................................. 3-8DB_CACHE_SIZE....................................................................................................................... 3-9DIAGNOSTIC_DEST.................................................................................................................. 3-9INSTANCE_TYPE....................................................................................................................... 3-9LARGE_POOL_SIZE...............................................................................................................3-10PROCESSES..............................................................................................................................3-10REMOTE_LOGIN_PASSWORDFILE...................................................................................3-10SHARED_POOL_SIZE............................................................................................................3-10 Setting Database Initialization Parameters for Use with Oracle ASM....................................3-11 Managing Oracle ASM Instances.......................................................................................................3-12 Administering Oracle ASM Instances with Server Control Utility.........................................3-12 Using Oracle Restart.......................................................................................................................3-12 Starting Up an Oracle ASM Instance............................................................................................3-13 About Mounting Disk Groups at Startup.............................................................................3-15About Restricted Mode...........................................................................................................3-15 Shutting Down an Oracle ASM Instance.....................................................................................3-16 Upgrading an Oracle ASM Instance With Oracle Universal Installer.....................................3-17 Downgrading an Oracle ASM Instance.......................................................................................3-19 Active Session History Sampling for Oracle ASM.....................................................................3-21 Using Oracle ASM Rolling Upgrade.................................................................................................3-21 Patching Oracle ASM Instances.........................................................................................................3-22 Authentication for Accessing Oracle ASM Instances....................................................................3-22 About Privileges for Oracle ASM.................................................................................................3-23 Using One Operating System Group for Oracle ASM Users............................................3-23Using Separate Operating System Groups for Oracle ASM Users...................................3-24The SYSASM Privilege for Administering Oracle ASM....................................................3-25The SYSDBA Privilege for Managing Oracle ASM Components.....................................3-26 Creating Users with the SYSASM Privilege................................................................................3-26 Operating System Authentication for Oracle ASM ...................................................................3-26 Password File Authentication for Oracle ASM ..........................................................................3-27 Migrating a Database to Use Oracle ASM........................................................................................3-27 Using Oracle Enterprise Manager to Migrate Databases to Oracle ASM...............................3-28 Using Oracle Recovery Manager to Migrate Databases to Oracle ASM.................................3-28 Best Practices White Papers on Migrating to Oracle ASM........................................................3-28 iv4 Administering Oracle ASM Disk GroupsDisk Group Attributes............................................................................................................................ 4-2 Creating Disk Groups............................................................................................................................. 4-3 Using the CREATE DISKGROUP SQL Statement........................................................................ 4-3 Example: Creating a Disk Group..................................................................................................... 4-5 Creating Disk Groups for a New Oracle Installation.................................................................... 4-6 Specifying the Allocation Unit Size................................................................................................. 4-7 Specifying the Sector Size for Drives............................................................................................... 4-8 Oracle Cluster Registry and Voting Files in Oracle ASM Disk Groups..................................4-10 Altering Disk Groups...........................................................................................................................4-11 Adding Disks to a Disk Group......................................................................................................4-12 Example: Adding Disks to a Disk Group.............................................................................4-12 Adding Volumes to Disk Groups.................................................................................................4-13 Dropping Disks from Disk Groups..............................................................................................4-14 Example: Dropping Disks from Disk Groups......................................................................4-15 Intelligent Data Placement.............................................................................................................4-15 Resizing Disks in Disk Groups......................................................................................................4-16 Example: Resizing Disks in Disk Groups.............................................................................4-16 Undropping Disks in Disk Groups...............................................................................................4-17 Example: Undropping Disks in Disk Groups......................................................................4-17 Manually Rebalancing Disk Groups............................................................................................4-17 Example: Manually Rebalancing a Disk Group..................................................................4-18 Tuning Rebalance Operations.......................................................................................................4-18 Oracle ASM Disk Discovery ..............................................................................................................4-18 How A Disk is Discovered.............................................................................................................4-19 Disk Discovery Rules......................................................................................................................4-20 Improving Disk Discovery Time...................................................................................................4-20 Managing Capacity in Disk Groups..................................................................................................4-21 Negative Values of USABLE_FILE_MB.......................................................................................4-23 Oracle ASM Mirroring and Disk Group Redundancy..................................................................4-23 Oracle ASM Mirroring and Failure Groups................................................................................4-23 Oracle ASM Failure Groups...................................................................................................4-24How Oracle ASM Manages Disk Failures............................................................................4-25Guidelines for Using Failure Groups....................................................................................4-25Failure Group Frequently Asked Questions........................................................................4-25 Oracle ASM Recovery from Read and Write I/O Errors..........................................................4-26 Oracle ASM Fast Mirror Resync...................................................................................................4-27 Preferred Read Failure Groups.....................................................................................................4-29 Configuring and Administering Preferred Read Failure Groups....................................4-29 Performance and Scalability Considerations for Disk Groups....................................................4-30 Determining the Number of Disk Groups...................................................................................4-31 Performance Characteristics When Grouping Disks.................................................................4-31 Oracle ASM Storage Limits...........................................................................................................4-31 Disk Group Compatibility..................................................................................................................4-31 Overview of Disk Group Compatibility......................................................................................4-32 Disk Group Compatibility Attributes..........................................................................................4-33 COMPATIBLE.ASM................................................................................................................4-33vCOMPATIBLE.RDBMS...........................................................................................................4-33COMPATIBLE.ADVM............................................................................................................4-33 Setting Disk Group Compatibility Attributes.............................................................................4-34 Valid Combinations of Compatibility Attribute Settings..................................................4-34Using CREATE DISKGROUP with Compatibility Attributes..........................................4-35Using ALTER DISKGROUP with Compatibility Attributes.............................................4-35Viewing Compatibility Attribute Settings...........................................................................4-36Features Enabled By Disk Group Compatibility Attribute Settings................................4-36Reverting Disk Group Compatibility....................................................................................4-37 Considerations When Setting Disk Group Compatibility in Replicated Environments......4-38 Managing Oracle ASM File Access Control for Disk Groups......................................................4-38 About Oracle ASM File Access Control.......................................................................................4-39 Using SQL Statements to Set Disk Group Attributes for Oracle ASM File Access Control.4-40 Using SQL Statements to Manage Oracle ASM File Access Control.......................................4-41 Mounting and Dismounting Disk Groups......................................................................................4-42 Mounting Disk Groups Using the FORCE Option.....................................................................4-43 Checking the Internal Consistency of Disk Group Metadata......................................................4-44 Dropping Disk Groups........................................................................................................................4-44 Renaming Disks Groups......................................................................................................................4-45 5Introduction to Oracle ACFSOverview of Oracle ACFS...................................................................................................................... 5-1 Understanding Oracle ACFS Concepts................................................................................................ 5-3 About Oracle ACFS............................................................................................................................ 5-4 About Oracle ACFS and Oracle Database Homes........................................................................ 5-4 About Oracle ASM Dynamic Volume Manager............................................................................ 5-5 About the Oracle ACFS Driver Model............................................................................................ 5-6 About the Oracle ACFS Mount Model and Namespace.............................................................. 5-6 About the Oracle ACFS Mount Registry........................................................................................ 5-6 About Oracle ACFS Snapshots......................................................................................................... 5-6 About Oracle ACFS and Backup and Restore................................................................................ 5-7 About Oracle ACFS Integration with Oracle ASM....................................................................... 5-7 Understanding Oracle ACFS Administration.................................................................................... 5-8 Oracle ACFS and File Access and Administration Security........................................................ 5-8 Oracle ACFS and Grid Infrastructure Installation........................................................................ 5-8 Oracle ACFS and Grid Infrastructure Configuration................................................................... 5-8 Clusterware Resources and Oracle ACFS Administration.......................................................... 5-9 Oracle ACFS and Dismount or Shutdown Operations.............................................................5-10 Overview of Oracle ASM Dynamic Volume Manager..................................................................5-10 6Using Views to Display InformationViews Containing Oracle ASM Disk Group Information............................................................... 6-1 Viewing Oracle ASM File Access Control Information................................................................ 6-4 Viewing Disk Region Information................................................................................................... 6-5 Views Containing Oracle ACFS Information..................................................................................... 6-6 vi7 Administering Oracle ASM Files, Directories, and TemplatesWhat Types of Files Does Oracle ASM Support?.............................................................................. 7-1 About Oracle ASM Filenames............................................................................................................... 7-2 Single File Creation Form................................................................................................................. 7-3 Multiple File Creation Form............................................................................................................. 7-4 Fully qualified File Name Form....................................................................................................... 7-4 Alias Oracle ASM Filename Forms................................................................................................. 7-5 Creating a Tablespace in Oracle ASM: Using a Data File with an Alias Name................. 7-6 Alias Oracle ASM Filename with Template Form........................................................................ 7-6 Incomplete Oracle ASM Filename Form........................................................................................ 7-7 Incomplete Oracle ASM Filename with Template Form.............................................................. 7-7 Creating and Referencing Oracle ASM Files in the Database........................................................ 7-7 Creating Oracle ASM Files Using a Default File Location for Disk Group Specification....... 7-8 Using Oracle ASM Filenames in SQL Statements......................................................................... 7-9 Managing Alias Names for Oracle ASM Filenames......................................................................... 7-9 Adding an Alias Name for an Oracle ASM Filename...............................................................7-10 Renaming an Alias Name for an Oracle ASM Filename...........................................................7-10 Dropping an Alias Name for an Oracle ASM Filename............................................................7-10 Dropping Files and Associated Aliases from a Disk Group.....................................................7-10 Managing Disk Group Directories....................................................................................................7-11 Creating a New Directory..............................................................................................................7-11 Renaming a Directory.....................................................................................................................7-12 Dropping a Directory.....................................................................................................................7-12 Accessing Oracle ASM Files with the XML DB Virtual Folder...................................................7-12 Inside /sys/asm..............................................................................................................................7-13 Using DBMS_FILE Transfer Utility for Oracle ASM.....................................................................7-14 Managing Disk Group Templates......................................................................................................7-15 Template Attributes........................................................................................................................7-15 Adding Templates to a Disk Group.............................................................................................7-17 Modifying a Disk Group Template..............................................................................................7-18 Dropping Templates from a Disk Group....................................................................................7-18 Creating Tablespaces in Oracle ASM: Specifying Attributes with Templates.......................7-18 8 Performing Oracle ASM Data Migration With RMANOverview of Oracle ASM Data Migration.......................................................................................... 8-1 Purpose of Oracle ASM Data Migration......................................................................................... 8-1 Basic Concepts of Oracle ASM Data Migration............................................................................. 8-2 Basics Steps of Data Migration to Oracle ASM Using RMAN.................................................... 8-2 Preparing to Migrate the Database to Oracle ASM Using RMAN................................................. 8-3 Migrating the Database to Oracle ASM Using RMAN.................................................................... 8-5 Migrating a Database from Oracle ASM to Alternative Storage.................................................... 8-9 Moving Data Files Between Oracle ASM Disk Groups Using RMAN......................................... 8-9 9 Administering Oracle ASM with Oracle Enterprise ManagerOracle Automatic Storage Management Home Page........................................................................ 9-1 Accessing the Oracle ASM Home Page in Single-Instance Oracle Databases ......................... 9-2vii。
Oracle HTTP Server 11g R1 配置手册说明书
Oracle HTTP Server 11g R1 Configuration for FLEXCUBEOracle FLEXCUBERelease 12.4.0.0.0[May] [2017]Table of Contents1.PURPOSE (3)2.INTRODUCTION TO ORACLE HTTP SERVER (OHS) (3)2.1HTTP L ISTENER (3)2.2M ODULES (MODS) (3)3.INSTALLATION OF OHS 11G (4)4.CONFIGURE ORACLE HTTP SERVER INFRONT OF WEBLOGIC SERVER (11)4.1F OR W EB L OGIC IN SINGLE INSTANCE (11)4.2F OR W EBLOGIC INSTANCES IN CLUSTER (12)5.ENABLE “WEBLOGIC PLU G-IN ENABLED” FLAG I N WEBLOGIC (13)PRESSION RULE SETTING (13)6.1L OADING MOD_DEFLATE (13)6.2C ONFIGURING FILE TYPES (14)6.3HTTPD.CONF FILE CHANGES (14)7.CONFIGURING SSL FOR ORACLE HTTP SERVER (16)7.1SSL CONFIGURATION FOR I NBOUND R EQUEST TO O RACLE HTTP S ERVER (16)7.1.1Create a new Wallet and import Certificate (16)7.1.2Configuring Wallet in ssl.conf file (20)7.2C ONFIGURING SSL BETWEEN O RACLE HTTP S ERVER AND O RACLE W EBLOGIC S ERVER (21)7.2.1Turn off KeepAliveEnabled (21)7.2.2To enable one-way SSL (21)7.2.3To enable two-way SSL (22)8.SAMPLE CONFIGURATION FILES (23)9.STARTING, STOPPING, AND RESTARTING ORACLE HTTP SERVER (23)9.1S TART (23)9.2S TOP (23)9.3R ESTART (23)10.TEST THE APPLICATION (24)11.SERVER LOGS LOCATION (24)12.REFERENCES (24)1. PurposeThe objective of this document is to explain the installation and configuration of Oracle HTTP Server 11g R1(11.1.1.6.0). This includes setting up of server details, configuration of compression rules and enabling SSL.2. Introduction to Oracle HTTP Server (OHS)Oracle HTTP Server is the Web server component for Oracle Fusion Middleware. It is based on Apache web server, and includes all base Apache modules and modules developed specifically by Oracle. It provides a HTTP listener for Oracle WebLogic Server and the framework for hosting static pages, dynamic pages, and applications over the Web. Key aspects of Oracle HTTP Server are its technology, its serving of both static and dynamic content and its integration with both Oracle and non-Oracle products.Oracle HTTP Server consists of several components that run within the same process. These components provide the extensive list of features that Oracle HTTP Server offers when handling client requests.Following are the major components:2.1 HTTP ListenerOracle HTTP Server is based on an Apache HTTP listener to serve client requests. An HTTP server listener handles incoming requests and routes them to the appropriate processing utility.2.2 Modules (mods)Modules extend the basic functionality of Oracle HTTP Server, and support integration between Oracle HTTP Server and other Oracle Fusion Middleware components. There are modules developed specifically by Oracle for Oracle HTTP Server. Ex: mod_wl_ohs, mod_plsqlOracle HTTP Server also includes the base Apache and third-party modules out-of-the-box.These modules are not developed by Oracle. Ex: mod_proxy, mod_perl3. Installation of OHS 11gInvoke the setup exe to start the installationSelect Skip Software UpdatesSelect Install and ConfigureSelect only Oracle HTTP ServerEnter the required OHS instance and component namesThis completes the installation of Oracle HTTP Server with <Instance> and <component>. Example: Instance is instance1 and component is ohs1.If you would like to change the port after the installation(OHS Listen Port) edit$ORACLE_INSTANCE/config/OHS/<component_name>/httpd.conf and change the listen port.NOTE: This port is for http protocol and not for https.4. Configure Oracle HTTP Server infront of Weblogic ServerIn Oracle HTTP Server requests from Oracle HTTP Server to Weblogic server are proxied usingmod_wl_ohs module. This configuration file needs to be modified to include the Weblogic server and port details.mod_wl_ohs.conf file is located at${ORACLE_INSTANCE}/config/OHS/{COMPONENT_NAME}/mod_wl_ohs.confAdd the below directives to mod_wl_ohs.conf file.4.1 For WebLogic in single instance<Location /<<context/url>> >SetHandler weblogic-handlerWebLogicHost <<server name>>WeblogicPort <<port>></Location>Example:<Location /FCJNeoWeb>SetHandler weblogic-handlerWebLogicHost wlserver1WeblogicPort 7707</Location>This will forward /FCJNeoWeb from HTTP server to /FCJNeoWeb on WebLogic Server wlserver1: 77074.2 For Weblogic instances in cluster<Location /<<context/url>> >SetHandler weblogic-handlerWebLogicCluster <server1>:<port1>,<server2>:<port2></Location>Example<Location / FCJNeoWeb >SetHandler weblogic-handlerWebLogicCluster wlserver1:7010, wlserver2:7010</Location>This will forward /FCJNeoWeb from HTTP server to /FCJNeoWeb on WebLogic Cluster wlserver1:7010 and wlserver2:70105.Enable “WebLogic Plug-In Enabled” flag in weblogicThis flag needs to be enabled in weblogic if it is accessed through proxy plugins. When the WebLogic plugin is enabled, a call to getRemoteAddr will return the address of the browser client from the proprietary WL-Proxy-Client-IP header instead of the web server.a. Plugin flag at managed server leveli. Click on ‘Environment’- > 'Servers' -> '<ManagedServer>' -> 'General' -> 'Advanced'ii. Check the 'WebLogic Plug-In Enabled' box.iii. Click 'Save'iv. Restart the Server.b. Plugin flag at domain levelv. Click on <Domain> -> 'Web Applications'vi. Check the 'WebLogic Plug-In Enabled' box.vii. Click 'Save'viii. Restart the server.6. Compression rule settingContent compression in Oracle HTTP Server is done using mod_deflate. This can compress HTML, text or XML files to approx. 20 - 30% of their original sizes, thus saving on server traffic. However, compressing files causes a slightly higher load on the server, but clients' connection times to server is reduced.6.1 Loading mod_deflatemod_deflate is used for compression in OHS and this is installed in Oracle HTTP Server under location "${ORACLE_HOME}/OHS/modules/mod_deflate.so"But it might not be loaded.To load the file add the below directive in mod_wl_ohs.conf fileLoadModule deflate_module "${ORACLE_HOME}/OHS/modules/mod_deflate.so"6.2 Configuring file typesmod_deflate also requires to specify which type files are going to be compressed.In the LOCATION section of mod_wl_ohs.conf file add the below entries.AddOutputFilterByType DEFLATE text/plainAddOutputFilterByType DEFLATE text/xmlAddOutputFilterByType DEFLATE application/xhtml+xmlAddOutputFilterByType DEFLATE text/cssAddOutputFilterByType DEFLATE application/xmlAddOutputFilterByType DEFLATE application/x-javascriptAddOutputFilterByType DEFLATE text/htmlSetOutputFilter DEFLATEImages are supposed to be in a compressed format, and therefore are bypassed by mod_deflate.6.3 httpd.conf file changesThis is a server configuration file which typically contains directives that affect how the server runs, such as user and group IDs it should use, and location of other files. Cross check the existence of mod_wl_ohs.conf include in httpd.conf file.httpd.conf file is present under location“${ORACLE_INSTANCE}/config/OHS/{COMPONENT_NAME}/httpd.conf”In this file cross check for the below entryinclude "${ORACLE_INSTANCE}/config/OHS/${COMPONENT_NAME}/mod_wl_ohs.conf"If above include entry is not present, then add the above include section.7. Configuring SSL for Oracle HTTP ServerSecure Sockets Layer (SSL) is required to run any Web site securely. Secure Sockets Layer (SSL) is an encrypted communication protocol that is designed to securely send messages across the Internet.Reading of “SSL_Configuration on Weblogic” document provide d as part of FCUBS installation isrecommended before proceeding with further setup.In Oracle HTTP server, SSL configuration can be done between1. Browser to Oracle HTTP Server(Mandatory)2. Oracle HTTP Server to Oracle Weblogic Server(If required)7.1 SSL configuration for Inbound Request to Oracle HTTP ServerPerform these tasks to enable and configure SSL between browser and Oracle HTTP Server.1. Obtain a certificate from CA or create a self signed certificate.2. Create an Oracle Wallet which contains the above SSL Certificate. The default wallet that isautomatically installed with Oracle HTTP Server is for testing purposes only. The default wallet is located in "${ORACLE_INSTANCE}/config/OHS/${COMPONENT_NAME}/keystores/default"3. Configuring Wallet in ssl.conf file7.1.1 Create a new Wallet and import Certificate1. Go to the \Oracle_WT1\bin\launch.exe, this will launch your wallet manager2. Click on Create new and then click no option.3. Enter the wallet password and click on OK, this will create a new wallet.4. Not it will ask for certificate request creation, Click on NO to proceed5. Right click on trusted certificates and then import trusted certificate.6. Browse to the folder where certificate is stored and click on Open7. Click on Save Wallet button on the left side navigation and save the wallet either to defaultlocation("${ORACLE_INSTANCE}/config/OHS/${COMPONENT_NAME}/keystores/default") or folder of your choice.8. Click on Wallet tab and enable Auto Login7.1.2 Configuring Wallet in ssl.conf fileIn ssl.conf file the newly created wallet need to updated. This file is located under folder"${ORACLE_INSTANCE}/config/OHS/${COMPONENT_NAME}/1. Change the SSLWallet directive to point to the location of new wallet created.SSLWallet "${ORACLE_INSTANCE}/config/${COMPONENT_TYPE}/${COMPONENT_NAME}/keystores/"2. Change the Listen port number in ssl.conf file to the SSL enabled port, by default the value is 44437.2 Configuring SSL between Oracle HTTP Server and Oracle Weblogic ServerSSL for outbound requests from Oracle HTTP Server are configured in mod_wl_ohs.Refer to “SSL_Configura tion on Weblogic” document for weblogic server setting mentioned in below section.7.2.1 Turn off KeepAliveEnabledThe below parameter in mod_wl_ohs should be turned off, by default it is on. Add the below directive under LOCATION section of mod_wl_ohs fileKeepAliveEnabled OFF7.2.2 To enable one-way SSL1. Generate a custom keystore identity.jks for Weblogic Server containing a certificate.2. At Identity section in Keystores tab in weblogic Admin Console for server seta. The custom trust store with the identity.jks file locationb. The keystore type as JKSc. The passphrase used to created the keystore3. Copy the certificate to Oracle HTTP Server and import the new certificate into OHS wallet as a trustedcertificate.4. Add following new directive in mod_wl_ohs.conf to point to the wallet locationWlSSLWallet "${ORACLE_INSTANCE}/config/OHS/{COMPONENT_NAME}/keystores/default"5. Change the port in mod_wl_ohs file to point to SSL port of Weblogic server.6. Restart both Weblogic Server and Oracle HTTP Server7.2.3 To enable two-way SSL1. Perform one-way SSL configuration steps2. Generate a new trust store, trust.jks for Weblogic server3. Keystore created for one-way SSL could be used, but it is recommended to create a separate truststore4. Export the user certificate from Oracle HTTP Server wallet, and import it into truststore created above5. At Trust section in Keystores tab in Weblogic Admin Console for the server seta. The custom trust store with the trust.jks file locationb. The keystore type as JKSc. The passphrase used to created the keystore6. Under the SSL tabEnsure trusted CA is set as from Custom Trust Keystore.7. Restart Weblogic Server8. Sample Configuration Fileshttpd.conf mod_wl_ohs.conf ssl.conf9. Starting, Stopping, and Restarting Oracle HTTP ServerNavigate to the below location in command prompt ${ORACLE_INSTANCE}/bin/ and run below commands 9.1 Startopmnctl startproc ias-component={COMPONENT_NAME}Example: opmnctl startproc ias-component=ohs19.2 Stopopmnctl stopproc ias-component={COMPONENT_NAME}Example: opmnctl stopproc ias-component=ohs19.3 Restartopmnctl restartproc ias-component={COMPONENT_NAME}Example: opmnctl restartproc ias-component=ohs110. Test the applicationTest the application deployed on Weblogic using Oracle HTTP Server after restarting both the oracle http server and weblogic serverhttps://ohs_servername:ohs_https_port/<<context/url>>http://ohs_servername:ohs_http_port/<<context/url>>ohs_servername: server on which OHS is deployedohs_https_port: port number mentioned against LISTEN directive in SSL.conf fileohs_http_port: port number mentioned against LISTEN directive in httpd.conf fileExample:https://localhost:4443/FCJNeoWeb/welcome.jspOrhttp://localhost:7777/FCJNeoWeb/welcome.jsp11. Server Logs LocationOracle HTTP Server Logs are generated under folder${ORACLE_INSTANCE}/diagnostics/logs/OHS/{COMPONENT_NAME}/12. ReferencesSSL_Configuration.doc for Weblogic provided as part of FCUBS installation./cd/E16764_01/web.1111/e10144/under_mods.htm/cd/E25054_01/core.1111/e10105/sslconfig.htmOracle_HTTP_Server_Configuration[May] [2017]Version 12.4.0.0.0Oracle Financial Services Software LimitedOracle ParkOff Western Express HighwayGoregaon (East)Mumbai, Maharashtra 400 063IndiaWorldwide Inquiries:Phone: +91 22 6718 3000Fax:+91 22 6718 3001/financialservices/Copyright © 2007, 2017, Oracle and/or its affiliates. All rights reserved.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. 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 failsafe, 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.This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.This software or hardware and documentation may provide access to or information on content, products and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.。
Oracle Identity Manager 11g 用户手册说明书
ORACLE DATA SHEETORACLE DATA SHEETContact UsFor more information about Oracle Identity Management, visit or call +1.800.ORACLE1 to speak to an Oracle representative.Copyright © 2011, Oracle and/or its affiliates. All rights reserved.This document is provided for information purposes only and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subjectto any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose.We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document. This document may notbe reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. UNIX is a registered trademark licensed through X/Open Company, Ltd. 1010。
Oracl-11G安装手册
Oracl 11G 64位安装手册1、解压两个压缩包到同一目录，即"database"，然后单击解压目录下的"setup.exe"文件，如下图所示：2、.执行安装程序后会出现如下的命令提示行。
3、等待片刻之后就会出现启动画（加载应用程序）4、稍微等待一会，就会出现如下图所示的安装画面，选择第二项：仅安装数据库软件，然后单击"下一步"继续，同时在出现的信息提示框单击"是"继续。
5、之后会出现安装类型对话框，选择：单实例数据库安装6、选择你运行产品使用需要的语言7、选择数据库版本（这里选择企业版）8、选择Oracl的安装路径9、Oracl自动检测本机环境是否符合要求10、检测完成之后，点击完成即可11、Oracl正在安装产品12、1为Sage X3创建用户，赋予权限接下来我们要做的是为windows操作系统创建一个名叫“adonix”的登陆用户，并为用户“adonix”和用户“administrator”赋予权限。
其中，“administrator”是windows操作系统自动创建的用户。
点击“系统工具”>>“本地用户和组”>>“用户”。
密码设置为1位或1位以上，X3才可以正常设置console中的server；如果windows提示密码需满足“8位以上，字母数字并用”等条件，你可以照做，或在“开始”>>“所有程序”>>“管理工具”>>“本地安全策略”>>“账户策略”>>“密码策略”中禁用“密码必须符合复杂性要求”。
现在已经成功地将adonix添加到了ora_dba组中，按相同的方法把adonix也添加进Administrators组中。
给用户adonix赋予权限，点击“开始”>>“所有程序”>>“管理工具”>>“本地安全策略”。
Oracle_11g_for_AIX_6_安装手册
Oracle 11g 安装手册（For AIX 6.1）安装描述：基于AIX 6.1操作系统安装Oracle 11.2单节点数据库。
一．安装前工作1. 硬件需求（1）内存>=1GB命令：prtconf | more（2）paging space物理内存在2-16GB之间，交换空间与物理内存大小相同物理内存大于16GB，交换空间设为物理内存的0.75倍命令：lsps –a（3）检查是否为64位命令：/usr/bin/getconf HARDW ARE_BITMODEbootinfo -k（4）磁盘空间temp空间>=1GBoracle软件安装目录>=8GB（5）操作系统run level为2命令：who –r2. 软件需求（1）操作系统版本AIX 6.1 TL 02 SP1 ("6100-02-01), 64-bit kernel及以上版本命令：oslevel –sgetconf KERNEL_BITMODE（2）操作系统文件集bos.adt.basebos.adt.libbos.adt.libmbos.perf.libperfstat 6.1.2.1 or laterbos.perf.perfstatbos.perf.proctoolsxlC.aix61.rte:10.1.0.0 or lateroracle 安装指导文档中没有包括以下文件集，但实际安装检查提示需要rsct.basic.rtepat.clients.rte命令：lslpp -l bos.adt.base（3）编译器IBM XL C/C++ Enterprise Edition for AIX, V9.0 April 2008 PTF命令：lslpp -l|grep vac（4）操作系统补丁需求如果操作系统TL level>TL 02（oracle 11.2所需的最小TL level），检查以下补丁：IZ41855IZ51456IZ52319以上补丁已经包含在以下TL level中：AIX 6.1 TL-02 SP-04 and laterAIX 6.1 TL-03 SP-02 and laterAIX 6.1 TL-04如果操作系统是其它TL level，咨询IBM确认是否需要打以上所列补丁。
(完整版)oracle11g dataguard 完全手册
oracle11g dataguard 完全手册一、前言：网络上关于dataguard的配置文章很多，但是很多打着oracle11g的文章实际都是只能在9 10 上运行，比如FAL_CLIENT在11g中已经废弃，但是现在网络上的文章都是没有标注这一点。
而且对于具体含义语焉不详对于新手只能知其然而不知其所以然。
这篇文章我就想让像我这样的人对于dataguard配置不仅仅知道怎么配置，还要知道为什么需要这样配置，这样的效果才是最好的。
这篇文章不仅仅是记录如何配置，还介绍了为什么是这样，以及注意要点，我希望这个文章可以作为进行dataguard配置的一个参考手册。
二、前提1.主库是归档模式：如果我们不清楚为什么是归档模式，那我们就应该也不会清楚dataguard是用来做什么的。
透过很多修饰的官方语言，我们需要明确DG（dataguard简称，后同）实际上的作用就是用来高可用。
而实现原理就是从主库获取数据到从库，在主库发生异常的时候，从库接管主库，完成身份的变化。
可以一个主库，最多9个从库。
同时分为逻辑standby和物理standby这里我们讨论的是物理standby.一旦创建并配置成standby 后，dg 负责传输primary数据库redo data 到standby 数据库，standby 数据库通过应用接收到的redo data 保持与primary 数据库的事务一致。
这下清楚了吧，需要保证主从库一致，需要传输archive log和redo log到从库，如果不是归档模式无法保证主从库的数据一致。
2.从库只需要安装数据库软件，数据从主库传输后完成。
3.很多人说11g有了active dataguard(ADG)，逻辑standby 实际上已经没什么用处了。
4.主从库硬件最好一致。
oracle数据库版本需要一致。
(1)内存检查项：# grep MemTotal /proc/meminfo交换分区检查项：如果内存在1-2G,swap是1.5倍；2-16G,1倍；超过16G，设置为16G即可。
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
1、首先安装Oracle11g，如下图所示：Oralce不支持中文路径及空格。
切忌。
记录好相关信息
2、导出数据备份：
Expdp 用户名/密码@连接串dumpfile=ora11g.dmp directory=服务器路径schemas=nc56
并将dmp文件从服务器上取到本机
3、使用PL/SQL软件，使用system用户登录，使用如下语句，创建nc56用户
-- Create the user
create user NC56
identified by "nc56"
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT
password expire;
-- Grant/Revoke role privileges
grant dba to NC56;
-- Grant/Revoke system privileges
grant unlimited tablespace to NC56 with admin option;
--创建表空间：
执行脚本前先建立db 文件夹否则报错
CREATE TABLESPACE "NNC_DATA03" LOGGING DATAFILE
'd:\db\nc3.ora'SIZE500M ;
CREATE TABLESPACE "NNC_DATA02" LOGGING DATAFILE
'd:\db\nc2.ora'SIZE500M ;
CREATE TABLESPACE "NNC_DATA01" LOGGING DATAFILE
'd:\db\nc1.ora'SIZE500M ;
CREATE TABLESPACE "NNC_INDEX01" LOGGING DATAFILE
'd:\db\I1.ora'SIZE500M ;
CREATE TABLESPACE "NNC_INDEX02" LOGGING DATAFILE
'd:\db\I2.ora'SIZE500M ;
CREATE TABLESPACE "NNC_INDEX03" LOGGING DATAFILE
'd:\db\I3.ora'SIZE500M ;
alter database datafile'D:\db\I1.ora'autoextend on; alter database datafile'D:\db\I2.ora'autoextend on; alter database datafile'D:\db\I3.ora'autoextend on;
alter database datafile'D:\db\nc1.ora'autoextend on; alter database datafile'D:\db\nc2.ora'autoextend on; alter database datafile'D:\db\nc3.ora'autoextend on;
第一次使用nc56登录时需要修改密码
4、导入数据，注意：一定要把网线拔掉，否则很容易覆盖正式库数据
impdp nc56/nc56@nc56 dumpfile=ora11g.dmp
5.配置启动NC
1）在NC_HOME\BIN 目录下运行ncSysConfig.bat，首先需要建立数据源。
2）部署代码，NC5.X需要通过部署生成Ejb代码，否则程序无法使用。
所以在添加数据源后必须部署产品，选择需要部署的模块，点击部署按钮。
3）修改服务器端口，可以在server页签修改web服务器的端口
4）下面启动NC自带的中间件，方法是在上面的NC_HOME目录中双击startup.bat，中间件即可启动，启动界面如下：。