oracle 11g 客户端配置
Oracle HTTP Server 11g R1配置指南说明书
Oracle HTTP Server 11g R1 Configuration for FLEXCUBEOracle FLEXCUBE Universal BankingRelease 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.。
Linux系统（X64）安装Oracle11g完整安装图文教程另附基本操作
Linux系统（X64）安装Oracle11g完整安装图⽂教程另附基本操作⼀、修改操作系统核⼼参数在Root⽤户下执⾏以下步骤：1）修改⽤户的SHELL的限制，修改/etc/security/limits.conf⽂件输⼊命令：vi /etc/security/limits.conf，按i键进⼊编辑模式，将下列内容加⼊该⽂件。
oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536编辑完成后按Esc键，输⼊“:wq”存盘退出2）修改/etc/pam.d/login ⽂件，输⼊命令：vi /etc/pam.d/login，按i键进⼊编辑模式，将下列内容加⼊该⽂件。
session required /lib/security/pam_limits.sosession required pam_limits.so编辑完成后按Esc键，输⼊“:wq”存盘退出3）修改linux内核，修改/etc/sysctl.conf⽂件，输⼊命令: vi /etc/sysctl.conf ，按i键进⼊编辑模式，将下列内容加⼊该⽂件fs.file-max = 6815744fs.aio-max-nr = 1048576kernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 4194304net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576编辑完成后按Esc键，输⼊“:wq”存盘退出4）要使 /etc/sysctl.conf 更改⽴即⽣效，执⾏以下命令。
自己整理手动配置oracle11gem
安装oracle最后一步，报错em配置不正确，需要手工配置。
打开运行——cmd，将下面语句复制粘贴到文件d:\*.sql，在命令窗口执行sqlplus“/as sysdba” @d:\*.sql————这句执行了文件中的sql语句，删除了em资料库，使用emca -deconfigdbcontroldb -repos drop可能会造成删除不干净，在创建时报错。
第二步就该创建了执行emca–repos create第三步进行配置：在这一步，是最揪心的，我试了好多种方法始终报错。
这样下一步就需要开始——所有程序——Oracle - OraDb11g_home1——配置和移植工具——net Manager按照下图选择数据库服务，并添加oracle主目录同时执行然后执行配置语句emca -configdbcontroldb大功告成了：D:\*.sqldrop user SYSMAN cascade;drop user MGMT_VIEW cascade;drop role MGMT_USER;drop public synonym MGMT_TARGET_BLACKOUTS; drop public synonym SETEMVIEWUSERCONTEXT;drop user sysman cascade;drop public synonym MGMT_ADMIN;drop public synonym MGMT_AS_ECM_UTIL;drop public synonym MGMT_AVAILABILITY;drop public synonym MGMT_COLLECTION_PROPERTIES; drop public synonym MGMT_CREDENTIAL;drop public synonym MGMT_CURRENT_METRICS;drop public synonym MGMT_CURRENT_METRIC_ERRORS;drop public synonym MGMT_CURRENT_SEVERITY;drop public synonym MGMT_DELTA;drop public synonym MGMT_DELTA_ENTRY;drop public synonym MGMT_DELTA_ENTRY_VALUES;drop public synonym MGMT_DELTA_IDS;drop public synonym MGMT_DELTA_ID_VALUES;drop public synonym MGMT_DELTA_VALUE;drop public synonym MGMT_DELTA_VALUES;drop public synonym MGMT_GLOBAL;drop public synonym MGMT_GUID_ARRAY;drop public synonym MGMT_GUID_OBJ;drop public synonym MGMT_IP_TGT_GUID_ARRAY;drop public synonym MGMT_JOB;drop public synonym MGMT_JOBS;drop public synonym MGMT_JOB_EXECPLAN;drop public synonym MGMT_JOB_EXECUTION;drop public synonym MGMT_JOB_EXEC_SUMMARY;drop public synonym MGMT_JOB_OUTPUT;drop public synonym MGMT_JOB_PARAMETER;drop public synonym MGMT_JOB_SCHEDULE;drop public synonym MGMT_JOB_TARGET;drop public synonym MGMT_LOG;drop public synonym MGMT_LONG_TEXT;drop public synonym MGMT_MESSAGES;drop public synonym MGMT_METRICS;drop public synonym MGMT_METRICS_1DAY; drop public synonym MGMT_METRICS_1HOUR;drop public synonym MGMT_METRICS_COMPOSITE_KEYS;drop public synonym MGMT_METRICS_RAW;drop public synonym MGMT_METRIC_COLLECTIONS;drop public synonym MGMT_METRIC_ERRORS;drop public synonym MGMT_METRIC_THRESHOLDS;drop public synonym MGMT_NAME_VALUE;drop public synonym MGMT_NAME_VALUES;drop public synonym MGMT_PREFERENCES;drop public synonym MGMT_SEVERITY;drop public synonym MGMT_SEVERITY_ARRAY;drop public synonym MGMT_SEVERITY_OBJ;drop public synonym MGMT_STRING_METRIC_HISTORY;drop public synonym MGMT_TARGET;drop public synonym MGMT_TARGETS;drop public synonym MGMT_TARGET_BLACKOUTS;drop public synonym MGMT_TARGET_PROPERTIES;drop public synonym MGMT_TYPE_PROPERTIES;drop public synonym MGMT_USER;drop public synonym MGMT_VIEW_UTIL;drop public synonym MGMT$DELTA_ORACLE_HOME;drop public synonym MGMT$DELTA_OS_COMPONENTS;drop public synonym MGMT$DELTA_OS_COMP_DETAILS;drop public synonym MGMT$DELTA_OS_KERNEL_PARAMS;drop public synonym MGMT$DELTA_PATCHSETS;drop public synonym MGMT$DELTA_PATCHSET_DETAILS;drop public synonym MGMT$DELTA_TABLESPACES;drop public synonym MGMT$DELTA_VENDOR_SW;drop public synonym MGMT$DELTA_VIEW;drop public synonym MGMT$DELTA_VIEW_DETAILS;drop public synonym MGMT$ECM_CURRENT_SNAPSHOTS;drop public synonym MGMT$ECM_VISIBLE_SNAPSHOTS;drop public synonym MGMT$GROUP_DERIVED_MEMBERSHIPS; drop public synonym MGMT$GROUP_FLAT_MEMBERSHIPS; drop public synonym MGMT$GROUP_MEMBERS;drop public synonym MGMT$HA_BACKUP;drop public synonym MGMT$HA_FILES;drop public synonym MGMT$HA_INFO;drop public synonym MGMT$HA_INIT_PARAMS;drop public synonym MGMT$HA_MTTR;drop public synonym MGMT$HA_RMAN_CONFIG;drop public synonym MGMT$HW_NIC;drop public synonym MGMT$METRIC_COLLECTION;drop public synonym MGMT$METRIC_CURRENT;drop public synonym MGMT$METRIC_DAILY;drop public synonym MGMT$METRIC_DETAILS;drop public synonym MGMT$METRIC_HOURLY;drop public synonym MGMT$MISSING_TARGETS;drop public synonym MGMT$MISSING_TARGETS_IN_GROUPS; drop public synonym MGMT$OS_COMPONENTS;drop public synonym MGMT$OS_FS_MOUNT;drop public synonym MGMT$OS_HW_SUMMARY;drop public synonym MGMT$OS_KERNEL_PARAMS;drop public synonym MGMT$OS_PATCHES;drop public synonym MGMT$OS_SUMMARY;drop public synonym MGMT$SOFTWARE_COMPONENTS;drop public synonym MGMT$SOFTWARE_COMPONENT_ONEOFF; drop public synonym MGMT$SOFTWARE_COMP_PATCHSET; drop public synonym MGMT$SOFTWARE_DEPENDENCIES;drop public synonym MGMT$SOFTWARE_HOMES;drop public synonym MGMT$SOFTWARE_ONEOFF_PATCHES; drop public synonym MGMT$SOFTWARE_OTHERS;drop public synonym MGMT$SOFTWARE_PATCHES_IN_HOMES; drop public synonym MGMT$SOFTWARE_PATCHSETS;drop public synonym MGMT$TARGET;drop public synonym MGMT$TARGET_COMPONENTS;drop public synonym MGMT$TARGET_COMPOSITE;drop public synonym MGMT$TARGET_PROPERTIES;drop public synonym MGMT$TARGET_TYPE;drop PUBLIC SYNONYM SMP_EMD_AVAIL_OBJ;drop public synonym EMD_MNTR;drop public synonym SMP_EMD_AVAIL_OBJ;drop public synonym SMP_EMD_DELETE_REC_ARRAY;drop public synonym SMP_EMD_INTEGER_ARRAY;drop public synonym SMP_EMD_INTEGER_ARRAY_ARRAY; drop public synonym SMP_EMD_NVPAIR;drop public synonym SMP_EMD_NVPAIR_ARRAY;drop public synonym SMP_EMD_STRING_ARRAY;drop public synonym SMP_EMD_STRING_ARRAY_ARRAY;drop public synonym SMP_EMD_TARGET_OBJ;drop public synonym SMP_EMD_TARGET_OBJ_ARRAY;drop public synonym ECM_UTIL;drop role mgmt_user;DROP USER sysman CASCADE;DROP USER mgmt_view CASCADE;DROP ROLE MGMT_USER;ALTER USER dbsnmp ACCOUNT UNLOCK;ALTER USER dbsnmp identified by dbsnmp;DROP PUBLIC SYNONYM SETEMVIEWUSERCONTEXT;DROP PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS; DROP PUBLIC SYNONYM MGMT_AVAILABILITY;DROP PUBLIC SYNONYM MGMT_CURRENT_AVAILABILITY; DROP PUBLIC SYNONYM MGMT_SEVERITY_OBJ;DROP PUBLIC SYNONYM MGMT_SEVERITY_ARRAY;DROP PUBLIC SYNONYM MGMT_GUID_OBJ;DROP PUBLIC SYNONYM MGMT_GUID_ARRAY;DROP PUBLIC SYNONYM SMP_EMD_AVAIL_OBJ;DROP PUBLIC SYNONYM SMP_EMD_TARGET_OBJ;DROP PUBLIC SYNONYM SMP_EMD_TARGET_OBJ_ARRAY; DROP PUBLIC SYNONYM SMP_EMD_DELETE_REC_ARRAY; DROP PUBLIC SYNONYM MGMT_METRICS;DROP PUBLIC SYNONYM MGMT_TARGETS;DROP PUBLIC SYNONYM MGMT_TYPE_PROPERTIES;DROP PUBLIC SYNONYM MGMT_TARGET_PROPERTIES; DROP PUBLIC SYNONYM MGMT_METRICS_RAW;DROP PUBLIC SYNONYM MGMT_CURRENT_METRICS; DROP PUBLIC SYNONYM MGMT_STRING_METRIC_HISTORY; DROP PUBLIC SYNONYM MGMT_LONG_TEXT;DROP PUBLIC SYNONYM MGMT_METRICS_COMPOSITE_KEYS; DROP PUBLIC SYNONYM MGMT_METRICS_1HOUR;DROP PUBLIC SYNONYM MGMT_METRICS_1DAY;DROP PUBLIC SYNONYM MGMT_METRIC_ERRORS;DROP PUBLIC SYNONYM MGMT_CURRENT_METRIC_ERRORS; DROP PUBLIC SYNONYM EMD_MNTR;DROP PUBLIC SYNONYM MGMT_METRIC_COLLECTIONS; DROP PUBLIC SYNONYM MGMT_COLLECTION_PROPERTIES ; DROP PUBLIC SYNONYM MGMT_METRIC_THRESHOLDS; DROP PUBLIC SYNONYM SMP_EMD_NVPAIR;DROP PUBLIC SYNONYM SMP_EMD_NVPAIR_ARRAY;DROP PUBLIC SYNONYM SMP_EMD_STRING_ARRAY;DROP PUBLIC SYNONYM SMP_EMD_STRING_ARRAY_ARRAY; DROP PUBLIC SYNONYM SMP_EMD_INTEGER_ARRAY; DROP PUBLIC SYNONYM SMP_EMD_INTEGER_ARRAY_ARRAY; DROP PUBLIC SYNONYM MGMT_DELTA_IDS;DROP PUBLIC SYNONYM MGMT_DELTA_ID_VALUES;DROP PUBLIC SYNONYM MGMT_DELTA_ENTRY;DROP PUBLIC SYNONYM MGMT_DELTA_ENTRY_VALUES; DROP PUBLIC SYNONYM MGMT_DELTA_VALUE;DROP PUBLIC SYNONYM MGMT_DELTA_VALUES;DROP PUBLIC SYNONYM MGMT_NAME_VALUE;DROP PUBLIC SYNONYM MGMT_NAME_VALUES;DROP PUBLIC SYNONYM ECM_UTIL;DROP PUBLIC SYNONYM MGMT_DELTA;DROP PUBLIC SYNONYM MGMT_TARGET_MEMBERSHIPS; DROP PUBLIC SYNONYM MGMT_JOB;DROP PUBLIC SYNONYM MGMT_JOB_PARAMETER;DROP PUBLIC SYNONYM MGMT_JOB_TARGET;DROP PUBLIC SYNONYM MGMT_JOB_SCHEDULE;DROP PUBLIC SYNONYM MGMT_JOB_EXECPLAN;DROP PUBLIC SYNONYM MGMT_JOB_EXEC_SUMMARY; DROP PUBLIC SYNONYM MGMT_JOB_OUTPUT;DROP PUBLIC SYNONYM MGMT_JOB_EXECUTION;DROP PUBLIC SYNONYM MGMT_LOG;DROP PUBLIC SYNONYM MGMT_ADMIN;DROP PUBLIC SYNONYM MGMT_GLOBAL;DROP PUBLIC SYNONYM MGMT_TARGET;DROP PUBLIC SYNONYM MGMT_CREDENTIAL;DROP PUBLIC SYNONYM MGMT_JOBS;DROP PUBLIC SYNONYM MGMT_PREFERENCES; DROP PUBLIC SYNONYM MGMT_USER;DROP PUBLIC SYNONYM MGMT_SEVERITY;DROP PUBLIC SYNONYM MGMT_CURRENT_SEVERITY; DROP PUBLIC SYNONYM MGMT_PAF_PROCS_LATEST; DROP PUBLIC SYNONYM MGMT_PAF_JOBS;DROP PUBLIC SYNONYM MGMT_PAF$PROCEDURES; DROP PUBLIC SYNONYM MGMT_PAF$INSTANCES; DROP PUBLIC SYNONYM MGMT_PAF$STATES; DROP PUBLIC SYNONYM MGMT_PAF$APPLICATIONS; DROP PUBLIC SYNONYM MGMT_VIEW_UTIL; DROP PUBLIC SYNONYM MGMT_MESSAGES;。
oracle安装配置教程
oracle安装配置教程新中大Oracle数据库安装配置教程本教程旨在提供一个通用的简洁明了的安装教程，有经验的读者可根据自己的实际需要进行相关调整。
本教程所使用数据库版本为Oracle11G，安装步骤可能与读者所使用的安装程序有所不同，请读者根据自己的安装程序进行调整。
重要内容已用红色进行标注。
因为排版原因可能导致图片略小，若读者想要看清图片，可以放大页面查看。
1Oracle数据库服务端安装: (2)2服务端配置数据库监听程序 (4)3Oracle客户端安装程序（同时安装64位和32位客户端） (5) 4客户端配置TNSName (6)5PL/SQL Developer的基本使用 (7)6数据库表空间和用户的建立以及用户的权限赋予脚本 (9)7数据库备份与恢复 (10)1Oracle数据库服务端安装:1.1点击下一步1.2选择创建和配置数据库，下一步1.3选择服务器类1.4选择单实例数据库1.5选择高级安装，下一步1.6根据需要选择语言1.7选择企业版1.8根据需要自行选择位置1.9选择一般用途/事务处理1.10根据自己的需求填写数据库信息一般Oracle服务标识符(SID)和全局数据库名都为orcl1.11字符集如图选择简体中文ZHS16GBK，其余选项按自己需求选择，下一步1.12选择使用Database Control管理数据库1.13按需求选择存储位置1.14不启用自动备份，下一步1.15根据需求填写口令1.16下一步(如果有不满足先决条件的在确认没有问题后点击忽略)1.17点击完成进行安装。
2服务端配置数据库监听程序配置监听程序可以使用Oracle提供的UI界面进行配置，也可以直接修改listener.ora，在此介绍如何使用Net Manager程序进行配置。
2.1打开数据库服务器上的Net Manager。
如图:2.2选中Oracle Net本地配置→本地→监听程序,点击左上角加号2.3根据实际需求输入监听程序名，点击确定2.4选中刚才添加的监听程序，点击添加地址2.5协议选择TCP/IP，主机选择127.0.0.1或者localhost，端口根据需要选择，默认端口为15212.6点击左上角文件→保存网络配置3Oracle客户端安装程序（同时安装64位和32位客户端）由于产品需求，在安装DBCNT的机子上需要安装32位和64位客户端。
在linux64上安装oracle11g_完整版本
Oracle 11g安装手册1、在linux的root用户下建立一个oracle用户//添加用户组及用户groupadd dbagroupadd oinstalluseradd oracle -g oinstall -G dbapasswd oracle//新建目录权限mkdir -p /u01chown -R oracle:dba /u01chmod -R 755 /u01安装时步骤8、9会指向此位置（建议：用户更改/opt/oracle11g）2、将Oracle11g安装文件复制到linux中的指定目录下（/home/oracle/tools）cp /光盘目录/linux.x64_11gR2_database_1of2 /home/oracle/tools3、执行目录中的runInstallsu - oracleLANG=zh_CN.gbk4、开始图像界面安装可能需要export DIAPLAY=:1.0xdpyinfo步骤1：将红框中的内容勾选去掉，点击下一步。
提示“未指定电子邮件地址”点击“是”步骤2：点选“创建和配置数据库”此选项也为默认选项，点击下一步。
步骤3：点击选中“服务器类”，点击“下一步”步骤4：点击选中“单实例数据库安装”，点击下一步。
步骤5：点击选中“高级安装”，点击“下一步”步骤6：选择需要的语言，点击“下一步”，此处客户确认是否需要增加其他语言步骤7：点击选中“企业版（4.29GB）”，点击“下一步”点击上图的“选择选项”，勾选需要的组件，此处全部勾选。
步骤8：此处为默认路径，u01的建立参考第1点orcale用户的建立，点击“下一步”步骤9：此处默认即可，点击“下一步”步骤10：点击选中“一般用途/事务处理”，点击“下一步”步骤11：此处默认，点击“下一步”vpmsdbs步骤12：此处可以设置内存、字符集、安全性、示例方案（可根据用户环境调整），点击“下一步”，内存分配建议至少50%步骤13：此处默认，点击“下一步”步骤14：此处默认处理，点击“下一步”步骤15：点击选中“不启用自动备份”，点击“下一步”步骤16：各帐号口令设定，此处统一使用相同口令，客户现场请在同客户确认口令设定规则步骤17：点击“下一步”步骤18：点击“修补并在此检查”，会产生修补文件，按照提示内容执行即可A、切换到root用户，此处为测试环境执行内容如上述步骤执行完成后依旧存在失败内容，请到linux光盘中寻找对应的rpm文件，复制到linux某一目录中，按下图命令执行步骤19：修补完成后，出现如下信息，点击“完成”步骤20：执行安装过程复制文件，创建实例过程完成后信息，点击“确定”完成后，如出现以下内容，请按照操作步骤，执行完成后，完成安装过程配置监听器1、执行su - oraclesh /u01/app/oracle/product/11.2.0/dbhome_1/bin/netca2、点击选中“监听程序配置”，点击“下一步”3、点击选中“添加”，点击“下一步”4、设定监听程序名，点击“下一步”5、选定协议所有协议，点击“下一步”6、设定标准端口号，点击“下一步”7、设定标准TCP/IP SSL端口号，点击“下一步”8、设置IPC键值，点击“下一步”9、提示是否配置另一个监听程序，点“是”，再点击“下一步”配置数据库1、执行sh /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbca2、点击“下一步”3、点选“创建数据库”，点击“下一步”4、点选“一般用途或事物处理”，点击“下一步”5、设定数据库名及SID，点击“下一步”6、配置管理选项，此处暂时用7、设定口令，点击“下一步”8、网络配置，点击“下一步”9、数据库文件所在位置，点击“下一步”,按照实际的文件规划位置10、恢复配置，点击“下一步”11、数据库内容，点击“下一步”12、初始化参数，点击“下一步”13、数据库存储，点击“下一步”14、创建选项，点击“完成”15、概要显示，点击“确定”16、创建进行17、创建完成，点击“退出”环境变量设置及启动1、设置环境变量在服务器上配置环境变量，编辑vi /etc/profile,在末尾加入以下配置export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1export PATH=.:$ORACLE_HOME/bin:$PATHexport ORACLE_SID=VPMSDBS (数据库SID)保存并退出vi /etc/oratab最后的N 改成Y（否则dbstart和dbshut命令无效）lsnrctl start (启动oracle监听)提示:The listener supports no servicesThe command completed successfully这样启动后远程连接会造成oracle ORA-12514:TNS:listener does not currently know of service requested in connect descriptor-----方案一-------------------------在listener.ora里面添加了一行SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(GLOBAL_DBNAME = VENDB)(ORACLE_HOME = /opt/oracle11g/app/oracle/product/11.2.0/dbhome_1)(SID_NAME = VENDB)))-----方案二-------------------------linux上面：[oracle@localhost ~]$ netmgr在下图的Listeners->Database Services中配置要监听的SID及ORACLE_HOME，退出保存。
oracle11g监听配置
监听配置相关问题客户终端(Client)无法连接服务器端(Server)本文现对监听配置作一简单介绍，并提出一些客户终端无法连接服务器端的解决思路。
一、监听器(LISTENER)监听器是Oracle基于服务器端的一种网络服务，主要用于监听客户端向数据库服务器端提出的连接请求。
既然是基于服务器端的服务，那么它也只存在于数据库服务器端，进行监听器的设置也是在数据库服务器端完成的。
二、本地服务名(Tnsname)Oracle客户端与服务器端的连接是通过客户端发出连接请求，由服务器端监听器对客户端连接请求进行合法检查，如果连接请求有效，则进行连接，否则拒绝该连接。
本地服务名是Oracle客户端网络配置的一种，另外还有Oracle名字服务器(Oracle Names Server)等。
Oracle常用的客户端配置就是采用的本地服务名，本文中介绍的也主要是基于本地服务名的配置。
三、Oracle网络连接配置方法首先，要确保Oracle相关的服务已经开启，如下图所示：配置Oracle服务器端与客户端都可以在其自带的图形化Oracle网络管理器(Oracle Net Manager)里完成。
点击“开始/程序/Oracle – OraHome11g_home1/配置和移植工具/Net Manager”启动Oracle网络管理器工具，启动Net Manager图形窗口如下图示：图(一)1、Oracle监听器配置(LISTENER)选中监听程序，点击左上侧“+”按钮添加监听程序，默认新加的监听器名称是LISTENER(该名称也可以由任意合法字符命名)。
点击确定，选中窗口右侧栏下拉选项中的“监听位置”，点击添加地址按钮。
在出现的网络地址栏的协议下拉选项中选中“TCP/IP”，主机文本框中输入主机名称(localhost)，端口文本框中输入数字端口，默认是1521。
配置好的监听位置如下图示：图(二)选中窗口右侧栏下拉选项中的“数据库服务”，点击添加数据库按钮。
配置ORACLE11g绿色版客户端连接oracle服务
配置ORACLE 11g绿色版客户端连接oracle服务亲手配置ORACLE 11g绿色版客户端连接oracle服务，测试成功。
下面是店铺收集整理的配置ORACLE 11g绿色版客户端连接oracle服务，希望对大家有帮助~~配置ORACLE 11g绿色版客户端连接oracle服务工具/原料win7 32位操作系统ORACLE 11g绿色版客户端PLSQL Developer 10.0方法/步骤下载PLSQL Developer 10.0下载ORACLE 11g绿色版客户端。
Instant client的版本很多：主要是Basic和Basic Lite。
Basic版本包括了所有的支持运行OCI、OCCI、JDBC、JDBC-OCI的文件，支持多种语言。
Basic Lite是Basic版本的精简版，只包括了英文的错误描述，也只支持Unicode、ASCII和欧洲字符集。
因此，如果数据库服务器是中文字符集(如SIMPLIFIED CHINESE_CHINA.ZHS16GBK),则必须下载Basic版本。
安装PLSQL Developer 10.0，默认安装就好。
解压ORACLE 11g绿色版客户端到D:\app\instantclient_11_2(笔者是这个路径，你也可以解压到任何路径，路径不要带空格和中文)运行PLSQL Developer，在工具-首选项-连接1、oracle 主目录名D:\app\instantclient_11_22、OCI库d:\app\instantclient_11_2\oci.dll配置win7环境变量，计算机-属性-高级系统设置-环境变量1、变量名：ORACLE_HOME变量值：d:\app\instantclient_11_22、变量名：TNS_ADMIN变量值：d:\app\instantclient_11_23、变量名：NLS_LANG变量值：SIMPLIFIED CHINESE_CHINA.ZHS16GBK说明：该值定义所连接的数据库使用的编码，其它类型可自己到服务器看一下或网上查找一下。
Oracle11g客户端安装及plsql配置
1,项目使用的是oracle11g数据库,安装个客户端访问服务器.到oracle官方下载:/technology/global/cn/software/tech/oci/instantclient/htdocs/winsoft.html (中文) /technology/software/tech/oci/instantclient/htdocs/winsoft.html下载下列几个压宿文件下面是我已经搜到的，直接复制到网页上下载即可。
/otn/nt/instantclient/111070/instantclient-sqlplus-win32-11.1.0.7.0. zip下载的三个压缩文件oracleDBinstantclient-basic-win32-11.1.0.7.0.zip 这是最核心的包instantclient-jdbc-win32-11.1.0.7.0.zip包含JDBC Driver的包instantclient-sqlplus-win32-11.1.0.7.0.zip 最简单的SQLPLUS包我把文件解压到了D盘,D:\OracleClient下面最后的文件结构应该如下：2.配置tnsnames.ora，如果本机上没有安装oracle，可以从安装了oracle的机上拷贝一个(tnsnames.ora 文件在% ORACLE_HOME%\network\admin下)放在上面的目录D:\OracleClient下。
tnsnames.ora的内容为：# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools.ORCL =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.255.128)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)))3,添加一个环境变量，名为TNS_ADMIN，值为tnsnames.ora文件所在路径（如：D:\OracleClient)，这是为了能够找到上面说的tnsnames.ora。
oracle11g client安装及配置
Oracle Client 客户端的安装和配置一、客户端的下载解压1、在官方网站下载客户端（此处用的是11gR2）/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html ?ssSourceSiteId=otncn选择合适的版本（这里是32为的windows 操作系统）2、下载完成后解压缩如下所示，双击setup.exe可执行文件进行安装。
二、客户端的安装1、选择安装类型：这里是开发用，所以选择【管理员(1.02GB) (A)】安装类型。
2、选择选择语言（这里选择简体中文和英语）3、选择客户端安装的位置4、检查先行条件（系统自动检查）5、系统显示前面步骤的设置摘要信息。
6、点击完成进行安装。
7、Oracle Clinet客户端安装完成。
三：配置Oracle Client 连接Oracle 服务器找到oracle client的【配置和移植工具】下的【Net Configuration Assistant】1、配置Client的监听。
A、添加一个监听器（如果客户端中原先以配置监听器则可以修改，也可以在添加一个新的监听器），点【下一步(N)】B、输入该客户端未使用的监听名（如：LISTENER），完成后点击【下一步(N)】。
C、选择该监听连接Oracle服务器所使用的协议（如：TCP），完成后点击【下一步(N)】。
D、选择该监听连接Oracle服务器所使用的端口号（默认端口号:1512），完成后点击【下一步(N)】。
E、完成该监听程序，选择是否要配置另一个监听程序，然后【下一步(N)】。
2、配置Client的本地网络服务名A、在 Net Configuration Assistant配置界面中选中【本地网络服务名配置】，然后【下一步(N)】。
B、在本地网络服务名配置界面中网络配置名，（如果客户端中原先已配置网络配置名则可以修改，也可以再添加一个新的网络配置名），点【下一步(N)】C、输入该客户端未存使用的服务名，点【下一步(N)】D、选择该服务连接Oracle服务器所使用的协议（如：TCP），完成后点击【下一步(N)】。
图解Oracle 11g客户端安装
6.安装Oracle 11g客户端双击之后出现如下界面：选择“管理员”选项之后默认安装Configuration assistant(配置助手)安装之后：6.1 Oracle的连接和使用将文件tnsnames.ora复制到安装目录X:\app\Administrator\product\11.1.0\client_1\network\ad min和X:\app\Administrator\product\11.1.0\client_1\network\admi n\sample下注：文件tnsnames.ora的IP需要改成数据库的IPX表示安装的驱动器，Administrator或登录账户如：CAOD:\app\CAO\product\11.1.0\client_1\network\admin\samp le6.2如果没有文件，需要自己在Net Manager进行配置：进入开始→Oracle→配置和移植工具→Net Manager在左侧树形图中选择 Oracle Net配置→本地→服务命名，若没有服务，点击工具条的”+”进行添加，右侧是地址配置，“主机号”填写服务器所在的IP，退出并保存。
6.2运行toad会出现OK，之后还会有一系列的界面，默认处理然后，进入Toad,用户名：SYSTEM 密码：sys左侧是已创建的登录用户，右侧输入用户名和密码，TNS选项卡选择数据库名称，Connect Using选择连接的Oracle ，选择TNSNames Editor对服务进行配置如图：OK，Connect7Oracle 11g 服务器版进入Toad 用户名system 密码：system选项注意TNSNames Editor选oracle服务器，将Connect Using 选为服务器即可Connect，成功登录界面如果连接不上，替换一下D:\app\CAO\product\11.1.0\db_1\NETWORK\ADMIN下的listener文件。
oracle11g instanclient安装步骤
ORACLE 11G R2 instantclient安装步骤测试环境系统: windows 7 UItimate X64windows server 2008 enterprise X64以上两种系统均亲自测试都可成功。
1.下载oracle 11G客户端。
登录到oracle官网，下载oracle win64_11gR2_client下载地址：/otn/nt/oracle11g/112010/win64_11gR2_client.zip2安装oracle win64_11gR2_client下载之后，将其解压，双击setup进行安装。
选择“下一步”选择软件的安装位置。
然后“下一步”。
本演示使用默认路径。
单机“完成”，进行安装。
点击“关闭”。
3.配置环境变量新建环境变量ORACLE_HOME = C:\app\Administrator\product\11.2.0\client_1TNS_ADMIN = C:\app\Administrator\product\11.2.0\client_1NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK打开instantclient的安装目录(C:\app\Administrator\product\11.2.0\client_1)新建“tnsnames.ora”文件。
内容如下ORCL =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.20)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = )))文件内容中的192.168.1.20是我安装oracle服务器的IP地址，1521则是我安装oracle服务器上的监听端口。
4.测试连接使用sqlplus进行连接打开“运行”输入“cmd”，进入DOS界面，输入红线部分命令。
Oracle 11g Gateway (ODBC)安装配置
Oracle 11g Gateway (ODBC)安装配置(UTF-8中文支持) 环境信息：操作系统：RHEL 6U4 64bitLANG使用：zh_CN.UTF-8Oracle 数据库版本：Oracle 11g database 11.2.0.1.0安装目录：/home/oracle/product/ora11g服务名称(ORACLE_SID)：ora11gOracle Gateway版本：Oracle 11g gateway 11.2.0.1.0安装目录：/home/gateway/product/gateway服务名称(ORACLE_SID)：gatewayGbase 8t数据库版本：Gbase 8t V8.5 12.10.FC4G1AEE_1.6.3.43安装目录：/home/gbase8t/8t服务名称(INFORMIXSERER)：gbase8tInformix CSDK版本：Informix CSDK 4.10.FC7安装目录：/home/gbase8t/8t连接方式：Oracle Database通过dblink连接到Gateway；Gateway通过CSDK提供的ODBC驱动(unixODBC)，访问Gbase 8t/Informix数据库。
组件安装1，Oracle 11g database安装详细过程略Oracle database使用的环境如下：安装时选上中文支持，数据库的字符集使用AL32UTF8。
数据库安装时，如果LANG=zh_CN.UTF-8时，界面有乱码，可使用LANG=en_US.UTF-8来安装。
另一种方式是将中文字体zysong.ttf放到操作系统的/usr/share/fonts/zh_CN/TrueType/目录下。
2，Gbase 8t database安装详细过程略3，Informix CSDK安装详细过程略Gbase 8t database和Informix CSDK使用的环境如下：4，Oracle gateway安装详细过程a.创建gateway 用户，并设置密码[root@rhel64 ~]# useradd -g oinstall -G dba -d /home/gateway -m -s /bin/bash gateway[root@rhel64 ~]# passwd gatewayb.设置用户环境变量：c.解压缩gateway安装包，然后在窗口模式下执行安装[gateway@rhel64 soft]$ unzip linux.x64_11gR2_gateways.zip[gateway@rhel64 soft]$ cd gateways开始安装./runInstaller增加产品语言支持，选上简体中文，服务名使用gateway安装组件选上：Oracle Database Gateway for InformixOracle Database Gateway for ODBC注：仅使用ODBC时，不需要安装Oracle Database Gateway for Informix若选了Gateway for Informix，会要求指定Informix服务器信息开始安装组件如果gateway与oracle database安装在同一个服务器上，可以不用再执行root.sh组件安装完成后，自动调用netca，创建LISTENER如果gateway和oracle database在同一台服务器，需要指定不同的LISTENER端口，这里指定为1522完成网络配置后，整个安装过程完成。
Redhat 5 上的Oracle 11g配置SSL连接
Redhat 5 上的Oracle 11g配置SSL连接前置声明本例中Oracle的安装目录在/home/oracle，机构证书和用户证书放在/home/oracle/ssl/ca目录下，ssl和ca目录需要事先mkdir创建。
配置wallet本步骤需要在客户端和服务器端进行，在oracle用户下运行own，程序在/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin目录下服务器端配置wallet在oracle用户下运行own，如图：点击wallet-新建，此时会提示默认wallet目录不存在，选择创建即可，如图：此时会要求输入wallet口令，如图：输入符合要求的wallet口令（本例中口令为prs3000），wallet类型选择标准，点击确定，如图：选择是，继续先写好相关信息，点击确定，如图：此时own界面会出现证书请求的信息，如图：点击wallet-保存到系统默认位置（注意一定要选保存到默认位置，避免引起不必要的麻烦），同时勾选wallet-自动登录（否则会报ORA-28759：无法打开文件），如图：保存到系统默认位置自动登录保存完毕后可以点击wallet-另存为，查看保存位置，本例中保存在/home/oracle/app/oracle/product/11.2.0/dbhome_1/owm/wallets/oracle目录下，再次打开own，可以从相应位置打开保存的wallet选择wallet-证书[已请求]，然后点击操作-导出证书请求，如图：此时会弹出对话框选择保存证书请求的目录，如图：选择保存在/home/oracle/ssl目录下，文件名改成request.txt，选择保存，如图：提示证书请求已经成功导出到/home/oracle/ssl/request.txt客户端配置wallet同服务器端配置，不一一叙述生成机构证书Wallet配置好后，需要生成机构证书。
ORACLE 11g配置安装文档
Orcal 11g安装配置文档1.首先同时选择图片中选择的两个文件，解压到文件夹生成oracle文件夹
2.打开Oracle文件夹
3.打开database文件夹
4.选择Setup.Exe运行文件
5.运行出现此页面不要关闭，等待跳转
6.跳转完成出现下示图片
7.进入安装界面
8.电子邮箱不用填写，直接下一步，弹出下示错误直接点是
10.选择服务器类，否则下面没有高级安装选项
12.出现高级安装并选择，若没有则表示第10步未选择安装服务器类
13.查看所选语言是否有中文，如若没有找到之后添加上
14.选择安装企业版，点击下一步
15.设定Oracle基目录与软件位置，确认位置之后点击下一步注：不要选择C盘，C盘空间太小影响电脑正常工作运行
16.默认安装一般用途/事务处理
17.设置全局数据库名与Oracle服务标识符（SID），确认后点击进入下一步
18.注意选择字符集更改选项
19.选择使用Unicode（Al32UTF8），确认后点击进入下一步
20.选择使用Database Control管理数据库
21．默认为文件西永不用更改，路径可以自己设置
22.默认不启用自动备份
23.选择对所有账户使用相同的口令，输入口令（大小写字母加数字，最少8位）
24.等待检验
25.确认安装信息没有错误，点击进入下一步
26．检测环境
27.等待安装复制数据库文件
28.跳出此页面点击口令管理
29.取消SCOTT勾选项
30.确认SCOTT没有勾选，点击确定。
64位环境下Oracle 11g配置
64位Windows 7环境下Oracle 11g及PL/SQL Developmentr的安装配置安装准备：1) 64位Oracle 11g R2 DB/otn/nt/oracle11g/112010/win64_11gR2_database_1of2.zip /otn/nt/oracle11g/112010/win64_11gR2_database_2of2.zip 2) 32位Oracle 11g Client/otn/nt/oracle11g/112010/win32_11gR2_client.zip3) PL/SQL Development安装步骤：1.下载所需软件2.将64位Oracle 11g R2 DB的两个压缩包解压到同一个目录下，即“database”，然后运行“setup.exe”开始安装Oracle 11g R2：3.在出现的“配置安全更新”窗口中，取消“我希望通过My Oracle Support接受安全更新”：4.在“安装选项”窗口中，选择“创建和配置数据库”：5.在“系统类”窗口中，选择“桌面类”6.在“典型安装”窗口中，选择Oracle的基目录，为数据库命名，并选择“企业版”和“默认值”进行安装，可将管理口令统一为：Oracle11g7.Oracle自动检查“先决条件检查”：8.在“概要”窗口中检查之前的配置，检查无误可点击”完成”进行Oracle的安装：9.安装过程如下：数据库创建完成后，会出现如下“Database Configuration Assistant”界面选择“口令管理”，查看并修常用用户名及密码：超级管理员：sys 密码：change_on_install普通管理员：system密码：manager普通用户：scott密码：tiger大数据用户：sh 密码：sh10.在“完成”窗口中，单击“关闭”完成Oracle 11g R2的安装11.安装32位的Oracle 11g Client，注意选择安装类型时，选择“管理员”：12.在指定安装位置时要注意不要和Oracle装在同一目录下其他设置参考Oracle 11g R2基本默认安装即可：13.新建环境变量TNS_ADMIN，值为Oracle 11g R2基目录下的\product\11.2.0\dbhome_1\NETWORK\ADMIN目录14.安装PLSQL Developer，注意PL/SQL Development 不要安装在默认的C: \Program Files(x86)目录下，否则会报错，原因是不能解析这个带（）的路径：15.第一次登陆选择Cancel，不连接数据库登陆，之后在Tools Preferences中设置OracleHome为Oracle Client：16.重新登陆PLSQL Developer，使用用户名、密码及数据库名称连接Oracle：17.成功登陆数据库，可以开始Oracle练习了：。
Oracle_11g服务器配置和管理(详细正确版------自测)
安装Oracle前linux系统参数的配置检查下列包是否安装，如果未安装则要先安装。
# rpm -qa | grep make gcc glibc 等等binutils-2.17.50.0.6-2.el5compat-libstdc++-33-3.2.3-61elfutils-libelf-0.125-3.el5elfutils-libelf-devel-0.125glibc-2.5-12glibc-common-2.5-12glibc-devel-2.5-12gcc-4.1.1-52gcc-c++-4.1.1-52libaio-0.3.106libaio-devel-0.3.106libgcc-4.1.1-52libstdc++-4.1.1libstdc++-devel-4.1.1-52.e15make-3.81-1.1sysstat-7.0.0unixODBC-2.2.11unixODBC-devel-2.2.11在安装Oracle 11g前，先关闭系统防火墙，禁用selinux；需要手工更改系统的内核参数以及创建oracle用户和用户组，具体操作步骤如下所述。
（1）创建oracle用户和oinstall、dba用户组命令如下所示。
# /usr/sbin/groupadd oinstall //创建用户组oinstall# /usr/sbin/groupadd dba //创建用户组dba# /usr/sbin/useradd -m -g oinstall -G dba oracle //创建用户oracle# id oracle //查看用户oracle的属性uid=512(oracle) gid=1005(oinstall) groups=1005(oinstall),1006(dba)（2）设置oracle用户的口令，命令如下所示。
# passwd oracle //设置oracle用户的口令Changing password for user oracle.New UNIX password:BAD PASSWORD: it is too simplistic/systematicRetype new UNIX password:passwd: all authentication tokens updated successfully.//口令更改成功（3）创建Oracle的安装目录。
oracle11g客户端安装教程
oracle11g客户端安装教程Oracle 11g是一款功能强大的关系型数据库管理系统，安装Oracle 11g客户端可以让用户在自己的计算机上连接到Oracle 数据库服务器，进行数据库管理和数据操作。
本文将介绍Oracle 11g客户端安装教程。
首先，准备安装文件。
你可以从Oracle官网下载Oracle 11g客户端的安装包，确保选择与你计算机操作系统相匹配的版本。
下载完成后，双击安装包进行安装。
安装过程中可能会提示你运行安装程序，点击“是”继续。
接下来，进入安装向导。
你可以选择安装类型，这里建议选择“完全安装”以获取全部功能。
然后点击“下一步”。
然后，选择安装位置。
默认情况下，Oracle 11g客户端将被安装在C盘的“Program Files”文件夹下。
如果你希望安装在其他位置，请点击“浏览”选择自定义位置。
然后点击“下一步”。
在接下来的界面中，你需要设置Oracle Inventory目录。
该目录用于记录安装的组件和配置信息。
你可以保留默认设置，也可以选择自定义目录。
然后点击“下一步”。
在接下来的界面中，你需要为Oracle Base目录设置密码。
这是管理Oracle 11g客户端的重要步骤。
请根据指引设置一个强密码，并点击“下一步”。
安装向导将自动检测你的计算机配置，然后在下一个界面中显示所需的硬件和软件。
确保满足这些要求，并点击“下一步”。
然后，你需要选择是否创建一个新的数据库，或者连接到现有的数据库。
如果你是第一次安装Oracle 11g客户端，选择“创建和配置一个数据库”，然后点击“下一步”。
在接下来的界面中，你需要设置数据库名称、数据库标识符和数据库存储位置。
请根据需要进行设置，然后点击“下一步”。
安装向导将开始配置数据库，这个过程可能需要一些时间。
等待配置完成后，点击“下一步”。
最后，安装程序将开始安装所选的组件和配置。
等待安装完成后，点击“完成”。
恭喜你，Oracle 11g客户端已经成功安装在你的计算机上了！现在你可以使用Oracle 11g客户端连接到数据库服务器，进行数据库管理和数据操作了。
Oracle11g安装文档
CentOs6.5下Oracle11g安装文档一：系统环境设置：1、系统环境配置说明：由于oracle11g对系统环境要求比较高，所以在安装之前需要对系统环境进行配置：包括检查安装oracle11g所依赖的文件包是否已经安装、修改系统内核参数、对用户设置shell 限制、修改/etc/hosts文件等。
利用root权限检查系统是否包含安装oracle11g所需要的依赖包, 安装过程中有的包会提示已经是最新版本了，安装的时候要根据提示注意一下。
yum install binutils-2.*yum install compat-libstdc++-33*yum install elfutils-libelf-0.*yum install elfutils-libelf-devel-*yum install gcc-4.*yum install gcc-c++-4.*yum install glibc-2.*yum install glibc-common-2.*yum install glibc-devel-2.*yum install glibc-headers-2.*yum install ksh-2*yum install libaio-0.*yum install libaio-devel-0.*yum install libgcc-4.*yum install libstdc++-4.*yum install libstdc++-devel-4.*yum install make-3.*yum install unixODBC-2.*yum install unixODBC-devel-2.*yum install pdksh*利用上述命令下载需要的依赖包。
为了使得系统环境适合安装oracle11g，修改系统内核参数文件[root@oracle ~]#vim /etc/sysctl.conf按字母i按键，进行修改文件，在打开文件末尾增加下列语句kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 6815744net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 4194304net.core.wmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_max = 1048576fs.aio-max-nr = 1048576按esc按键，输入：wq，保存修改。
centos6.5下安装oracle11gR2与Oracle自动启动的配置
centos6.5下安装oracle11gR2与Oracle⾃动启动的配置注意：以下命令使⽤ root ⽤户操作安装依赖包主要思路为配置 oracle yum 仓库，直接使⽤ yum 命令来安装依赖包，避免⼿⼯逐个的安装依赖包。
配置 yum 仓库以下载 orcale 依赖包注意：这⾥是CentOS 6.X 的 oracle 依赖仓库，其他版本不同的。
导⼊ GPG Keyswget https:///RPM-GPG-KEY-oracle-ol6 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle --no-check-certificate安装 oracle 依赖yum install oracle-rdbms-server-11gR2-preinstall设置 hostname打开⽂件 /etc/sysconfig/network，并修改 HOSTNAME。
vi /etc/sysconfig/networkNETWORKING=yesHOSTNAME=打开 /etc/host，添加服务器本机IP地址指向到 HOSTNAMEvi /etc/hosts192.168.1.15 oracleoracle ⽤户设置当安装好 oracle 依赖之后， oracle ⽤户已经创建好了，不需要⼿⼯创建 oracle ⽤户和相关的⽤户组。
修改 oracle ⽤户密码[root@oracle ~]# passwd oracle更改⽤户 oracle 的密码。
新的密码：重新输⼊新的密码：passwd：所有的⾝份验证令牌已经成功更新。
修改系统限制在⽂件 /etc/security/limits.d/90-nproc.conf 中添加如下的最后⼀⾏[root@oracle ~]# vi /etc/security/limits.d/90-nproc.conf# Default limit for number of user's processes to prevent# accidental fork bombs.# See rhbz #432903 for reasoning.* soft nproc 1024root soft nproc unlimited* - nproc 16384修改 SELinux 为 permissive 模式修改⽂件 /etc/selinux/config 如下所⽰[root@oracle ~]# vi /etc/selinux/config# This file controls the state of SELinux on the system.# SELINUX= can take one of these three values:# enforcing - SELinux security policy is enforced.# permissive - SELinux prints warnings instead of enforcing.# disabled - No SELinux policy is loaded.SELINUX=permissive# SELINUXTYPE= can take one of these two values:# targeted - Targeted processes are protected,# mls - Multi Level Security protection.SELINUXTYPE=targeted重启机器[root@oracle]# reboot创建 oracle 安装⽬录，并授权[root@oracle]# mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1[root@oracle]# chown -R oracle:oinstall /u01[root@oracle]# chmod -R 775 /u01授权 oracle ⽤户能够访问 X Server[root@oracle]# xhost + # 要在主机上运⾏，不能是远程 shell注意：以下命令使⽤ oracle ⽤户操作配置 oracle 安装环境变量切换到 oracle ⽤户, 编辑 .bash_profile ⽂件, 如下所⽰, 添加环境配置。