Lab 3a - Installation of Oracle WebCenter JSK
Oracle Real Application Testing 用户指南说明书
Real Application Testing Certified for SAPMaking a change to the SAP database can represent a significant risk to an organisation. The effects ofan unexpected problem could be widely felt and have serious consequences. For this reason, testing of changes prior to production deployment is considered critical. The cost involved in testing using traditional methods can be very high both in time and money. Even after testing, many problems will only be discovered in production, and as a result end-users will suffer from poor performance or possibly even outages.Oracle now has a new and unique testing tool for the Oracle Database called Real Application Testing. This Database option comprises of two complementary features, SQL Performance Analyzer (SPA) and Database Replay. Together, these features can help ensure that database changes do not negatively impact SAP availability and performance. They significantly improve the quality and lower the cost of testing changes to the SAP database system.SQL Performance Analyzer (SPA)One of the key tasks for a DBA is to tune SQL statements for optimal performance. Changes to database systems (such as optimizer statistics refresh, database upgrades, and patches) can cause the performance of previously well tuned SQL statements to regress, which can dramatically impact system performance for end-users. Until now, it was difficult if not impossible to predict how day to day operational changes to the database will impact application SQL performance. With SQL Performance Analyzer, or SPA, you can now know exactly how SQL will behave after routine system changes.SPA automatically captures production SQL statements from your SAP database and re-executes them following a change to measure the impact. The statements are executed serially, in isolation from each other and regressed statements are automatically highlighted. Integration with SQL Plan Management and SQL Tuning Advisor enables automatic tuning of these statements to address any regressions priorto a change being implemented in production.Orchestration of the entire SPA process can be done using Enterprise Manager, which provides a number of workflows for testing common operations such as Database Upgrades. There is also a Guided Workflow which enables custom experiments to be conducted.Real Application Testing was introduced in the 11g release of the Oracle Database, however, SQL Performance Analyzer is also available for previous releases of the Oracle Database. Consequently, SQL Performance Analyzer can be used to test changes in SAP environments even if there are no immediate plans to move to Oracle Database 11g Release 2.Some examples of changes that could be assessed using SQL Performance Analyzer in SAP environments are:-∙Upgrade SAP Database from Oracle Database 10g Release 2 to 11g Release 2∙Install Database Patchset∙Migration from single instance to RAC∙Implement Partitioning∙Implement Advanced Compression∙Changes to _FIX_CONTROLS parameter settings∙Creation of Histograms on SAP tablesSome of these changes can actually be tested safely on the production system, therefore removing the need for establishing a separate test environment.There are no SAP specific patches required to use SQL Performance Analyzer. Further general information on using SQL Performance Analyzer can be found in the following documents:Technical White Paper: SQL Performance AnalyzerViewlet: SQL Performance Analyzer in Oracle Database 11gOracle Database Real Application Testing User’s GuideDatabase ReplayLoad testing today is generally done using tools that allow testing teams to generate synthetic workloads based on what they expect users to do on a system. These workloads can then be replayed by application virtual users, which simulate the end users by submitting requests to the application. Although widely used, this approach has a number of shortcomings when it comes to testing database level changes:∙Creating the synthetic workload can take a considerable time and requires programming expertise∙User behaviour is not well understood, so many possible workflows are often missed in the synthetic tests∙Production scale database concurrency is near impossible to simulate with these tools∙ A full application stack is required for testing as these tools simulate end usersDatabase Replay makes it possible to capture a workload on a production system with negligible performance overhead and replay it on a test system with the exact timing, concurrency, and transaction characteristics of the original workload.Database Replay is suitable for testing changes to the database tier and anything below it, such as storage or OS platform. This also means that tiers such as the Web and Application Server tier are not required in the test environment. The Database Replay capture process has been backported and certified for SAP databases running on Oracle Database 10g Release 2 (10.2.0.4).Changes that Database Replay could be used to validate include:∙SAP Database upgrade from 10gR2 (10.2.0.4) to 11gR2∙Platform migration such as from Windows to Oracle Solaris∙Database Patchset install∙Changes to _FIX_CONTROLS parameter settings∙Schema changes∙Migration from single instance to RAC∙Implement Partitioning∙Implement Advanced Compression∙Database storage changes (e.g. Direct NFS)∙Tablespace encryption∙Object ReorganizationDatabase Replay is included with Oracle Database 11g. In addition, Database Replay capture can be run against Oracle Database 10.2.0.4 and higher versions.Patch 9233285 is required on the Replay database to use Database Replay in SAP environments.For more technical information on using Database Replay please refer to the following whitepaperTechnical White Paper: Database Replay Viewlet: Database Replay in Oracle Database 11g Oracle Database Real Application Testing User’s GuideResults of TestingThe Oracle/SAP Development Team recently concluded comprehensive testing of SAP applications using both SQL Performance Analyzer and Database Replay. The testing consisted of SAP R/3 and BW workloads running in-house on the ABAP stack. Further testing was undertaken at a large utilities customer running the SAP IS-U (Industry Specific Utilities) module.The objective was to use Real Application Testing to measure the effects of Advanced Compression for OLTP and SecureFiles on DML operations for SAP R/3. The testing activity consisted of using Database Replay to capture a production workload from a 10.2.0.4 SAP database. This workload was thenreplayed multiple times against both compressed and non-compressed Oracle Database 11g Release 2 databases. Key AWR metrics from the replays are shown below.KEY AWR MetricsReplay without CompressionReplay with Compression%DiffIn order to further analyze the effects of Advanced Compression on DML operations, SQL Performance Analyzer (SPA) was used concurrently with Database Replay. As the workload was being r eplayed, SPA’s automatic cursor cache capture feature was used to capture the SQL statements into a SQL Tuning Set. SQL Tuning Set contains the text of the SQL statements along with their bind values, execution plans and statistics. This was done for both replays, with compression enabled and without compression. In all over 5000 SQL statements were analyzed. The table below shows the SQL Tuning Set comparison of some the most frequently executed DML operations in the SAP workload.Sample SQL Tuning Set ComparisonCompression SQL ID SQL Text Executions ElapsedTimeCPUTimeBufferGetsDiskReads ModuleN g9makkh1cnq94 INSERT INTO "ALCLASTOOL" VALUES( :A0 , :A1 , :A2 , :A3 , :A4... 37648 180,29 152,97 1136194 32901 SAPLSALU Y g9makkh1cnq94 INSERT INTO "ALCLASTOOL" VALUES( :A0 , :A1 , :A2 , :A3 , :A4... 40434 215,54 164,10 1118975 33911 SAPLSALU N 6kxdz6nknay0m INSERT INTO "ALGRPCUSGE" VALUES( :A0 , :A1 , :A2 , :A3 , :A4... 18257 80,88 71,32 518407 9978 SAPLSALU Y 6kxdz6nknay0m INSERT INTO "ALGRPCUSGE" VALUES( :A0 , :A1 , :A2 , :A3 , :A4... 18889 92,12 74,99 532217 9615 SAPLSALU N c42810chs804v INSERT INTO "ALGRPCUSPF" VALUES( :A0 , :A1 , :A2 , :A3 , :A4... 4100 20,51 16,67 134523 3652 SAPLSALU Y c42810chs804v INSERT INTO "ALGRPCUSPF" VALUES( :A0 , :A1 , :A2 , :A3 , :A4... 4202 24,07 17,32 137029 3493 SAPLSALU N 8wz2ywwcrh7c7 INSERT INTO "ALGRPCUSMC" VALUES( :A0 , :A1 , :A2 , :A3 , :A4... 2144 12,48 9,08 77571 2758 SAPLSALU Y 8wz2ywwcrh7c7 INSERT INTO "ALGRPCUSMC" VALUES( :A0 , :A1 , :A2 , :A3 , :A4... 1820 13,18 7,94 65849 2289 SAPLSALUOverall the test results were very instructive. Key findings are described as follows (note: results willvary according to your workload):∙No significant overhead observed during capture process∙Advanced Compression reduced database size by 50%∙Redo generated increased by ~25%∙Physical reads reduced by 60%∙CPU usage stayed flatProblems encountered:During the testing bug # 9233285 was encountered. Patch for this bug must be applied before usingReal Application Testing with SAP systems.ConclusionReal Application Testing proved a vital tool for validating upgrade from Oracle Database 10g Release 2 to11g Release 2. The ability to test with production workloads and SQL statements is essential for testing business critical applications like SAP and this feature will significantly mitigate upgrade and change riskwhen used by experienced DBAs.。
OBTR安装程序指南说明书
OBTR Installer Index Oracle Banking Treasury ManagementRelease 14.5.2.0.0[August] [2021]Table of Contents1.ABOUT THE MANUAL ................................................................................................................................. 1-11.1I NTRODUCTION........................................................................................................................................... 1-1 1.2A UDIENCE .................................................................................................................................................. 1-1 1.3A BBREVIATIONS AND A CRONYMS.............................................................................................................. 1-12.INDEX .............................................................................................................................................................. 2-12.1S ECURITY G UIDELINES............................................................................................................................... 2-1 2.2E NVIRONMENT S ETUP ................................................................................................................................ 2-1 2.3S UPPORT FOR E XTENSIBILITY..................................................................................................................... 2-2 2.4I NSTALLER I NSTALLATION ......................................................................................................................... 2-3 2.5I NSTALLATION............................................................................................................................................ 2-3 2.6M AINTENANCE ........................................................................................................................................... 2-3 2.7I NSTALLER U TILITIES ................................................................................................................................. 2-3 2.8T ROUBLESHOOTING.................................................................................................................................... 2-31. About the Manual 1.1 IntroductionThis manual is designed to help acquaint you with the installation of Oracle Banking Treasury Management.1.2 AudienceThis manual is intended for the following User/User Roles:The user of this manual is expected to have basic understanding of Application servers like Oracle Weblogic, IBM Websphere and Oracle Database.1.3 Abbreviations and AcronymsThis guide may refer to the following abbreviations:2. Index 2.1 Security GuidelinesThe user of this manual should ensure security guidelines for this release of OBTR are adhered to as mentioned in the Security Guide document. This is a pre-requisite before proceedingfurther.2.2 Environment SetupThis section helps you get an outline of the chapters included in the Installation Manuals and provides a summary of each chapter. You can identify the chapters containing the details of each activity that you will perform during Oracle Banking Treasury Management installation.The Installation Manuals are organized as follows:2.3 Support for Extensibility2.4 Installer InstallationInstaller support installation of Oracle FLEXCUBE in two modes Graphical mode and silent mode.2.5 Installation2.6 Maintenance2.7 Installer Utilities2.8 TroubleshootingOracle OBTR Installer IndexAugust [2021]Version 14.5.2.0.0Oracle Financial Services Software LimitedOracle ParkOff Western Express HighwayGoregaon (East)Mumbai, Maharashtra 400 063IndiaWorldwide Inquiries:Phone: +91 22 6718 3000Fax: +91 22 6718 3001https:///industries/financial-services/index.htmlCopyright © [2020], [2021]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 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.。
Oracle WebService Manager 12.1.2 REST客户端安全化指南说明书
Securing REST Clients using Oracle WebService Manager 12.1.2August 2013Step-by-Step Instruction GuideAuthor: Prakash YamunaOracle CorporationTable of Contents1 Getting Started (4)1.1 Pre-Requisites (4)1.2 Install Locations (4)1.3 Topology (4)1.4 Install & Topology Verification (4)1.4.1 Verify all Product Consoles are reachable (5)2 Usecase (5)3 Create “rest-saml-idprop” Application (7)3.1 Create “service” Project (8)3.2 Create “HelloWorldIdPropSample” POJO class (9)3.3 Add method “hello” to the POJO Class (10)3.4 Add Jersey Libraries via Project Properties (11)3.5 Create a RESTFul Service from the POJO Class (13)3.6 Using @Context and SecurityContext (16)3.7 Modify the Servlet name (17)3.8 Secure the REST service in JDeveloper (18)3.9 Create a Deployment Profile and WAR (19)3.10 Deploy the REST service “helloworld.war” to WLS using EM (22)3.11 Validate the REST service (25)4 Create REST client (28)4.1 Create a new “rest-client” Web project (28)4.2 Create “HelloWorld Servlet” (32)4.3 Create REST Client Proxy (35)4.4 Secure the REST Client Proxy (38)4.5 Modify the HelloWorldServlet to call the RESTful Client Proxy (41)4.6 Modifying the REST Client Security Policy (42)4.7 Secure the HelloWorldServlet web application (43)4.7.1 Select Authentication Mechanism (43)4.7.2 Add Security Constraints (44)4.7.3 Final “web.xml” for the HelloWorldServlet (45)4.7.4 Create weblogic.xml deployment descriptor (46)4.7.5 weblogic.xml for the HelloWorldServlet (48)4.8 Create Deployment Profile and WAR for the Client (49)5 Create users in weblogic using WLS Console (51)6 Create credentials in credential store to be used by REST Client (54)6.1 Create “oracle.wsm.security” CSF map (54)6.2 Create “weblogic-csf-key” under the oracle.wsm.security CSF map (55)6.3 Mapping newly created “testuser” in weblogic.xml (57)7 Deploy the client application to Weblogic using EM (57)8 Testing (60)1Getting Started1.1Pre-RequisitesThis How-To guide assumes that you have already downloaded and installed the followingproducts/components.∙Download and install FMW 12.1.2 – this includes Oracle WebService Manager 12.1.2.∙Download and install Database 11.2.0.3∙Download JDeveloper 12.1.2∙JDK7 is preinstalled1.2Install LocationsThis How-To does not provide installation instructions for the pre-requisite components.You can consult the following how-to for installing FMW 12.1.2:/technetwork/middleware/webservices-manager/owsm-installation-12c-1971739.pdfYou can also consult the appropriate Install guides. OWSM documentation can be found at:/middleware/1212/owsm/index.htmlThe components in this How-To are installed at the following locations:1.3TopologyThis How-To uses a single domain. The domain includes a single weblogic server. The steps provided in this How-To can vary based on Topology.∙Domain Name: base_domain∙Weblogic Server: AdminServer1.4Install & Topology VerificationStart the Admin ServerNavigate to: D:\oracle_12.1.2\user_projects\domains\base_domain\bin1.4.1Verify all Product Consoles are reachableGo to the product console URL and provide username as weblogic and password as appropriate to your installation.2UsecaseDescriptionThis How-To describes how to secure a JAX-RS REST service and client using OWSM 12.1.2.HelloWorldIdPropSample(REST service)ObjectiveThe main objective of this How-To:∙How to build a simple REST services using JAX-RS technology in JDeveloper∙How to secure a simple HelloWorld JAX-RS application using OWSM Policy in JDeveloper∙Deploy and Run the HelloWorld JAX-RS application to a Weblogic domain∙How to build a simple HelloWorld REST Client Proxy for the HelloWorld REST service using JAX-RS technology in JDeveloper∙How to secure the HelloWorld REST Client Proxy using OWSM Policy in JDeveloper∙Testing end to end.3Create “rest-saml-idprop” ApplicationThis application will contain two projects. One for the REST service and another for the REST Client.NOTE: Ignore the name of the sample (I plan to have another How To that describes identity propagation using SAML)Provide the necessary information for creating the Application as shown in the screenshot below.Click “Next”3.1Create “service” ProjectCreate a project called “service” in JDeveloper as show in the screenshot below. This project will be used to build the REST service.Click “Next”Click “Next”Click “Finish”3.2Create “HelloWorldIdPropSample” POJO class Create a POJO class under the “service” Project.Click “OK”3.3Add method “hello” to the POJO Class3.4Add Jersey Libraries via Project PropertiesWe will use APIs that require Jersey Libraries in the Project. Add these Libraries via the Project Properties. This can be achieved by right-clicking on the “service” project and clicking on the “Project Properties” menu item as shown in the screenshot below.Click on “Add Library” button in the screenshot above. This will pop up the “Add Library” dialog below.Click “OK”Click “OK”3.5Create a RESTFul Service from the POJO ClassYou can create a RESTFul Service by right clicking on the POJO Class and clicking on “Create RESTful Service” menu item as shown below.For the purposes of this How-To select the media type as text/plain by Clicking “Produces”.Click “OK”.Click “Next”Click “Finish”3.6Using @Context and SecurityContext**************************************************************************************NOTE: Modify the code to use the @Context annotation to get the authenticated user after creating a RESTful Service.Pay special attention to the import statements.import java.security.Principal;import javax.ws.rs.core.Context;import javax.ws.rs.core.SecurityContext;Also note that that the method “hello” has a Path annotation.WARNING: If you add the @Context parameter before creating the RESTful service – then you will not be able to use the “Create RESTFul Service” menu item as shown above to create a RESTful servic e. So the sequence described above is important.While you can add the @Path annotations, etc manually the “Create RESTful Service” converts the project to a Web Project and adds the web.xml deployment descriptor – which allows you to secure the RESTful Service.NOTE: There are other ways of programming this sample in JDeveloper. The sequence shown here is important only for this particular scenario.3.7Modify the Servlet nameWhen you create a RESTful service – Jdeveloper automatically modified the project to be a Web Project and adds web.xml. However the default servlet name is called “jersey”. Modify the servlet name and provide a more user friendly name as shown below.3.8Secure the REST service in JDeveloperYou can secure a REST service by right-clicking on “web.xml” and selecting the “Secure RESTful Application” menu item as shown below.You can search for a policy of a particular name in JDeveloper as shown below.Click “OK”Securing a RESTful Service will create a wsm-assembly.xml document as shown below.3.9Create a Deployment Profile and WARClick “OK”Click “OK”Click “Next”Click “Finish”3.10Deploy the REST service “helloworld.war” to WLS using EMClick “Webogic Domain->Deployments” from the RHS menu in the screenshot above.Click “Next”Click “Next”Click “Next”Click “Deploy”Click “Close”3.11Validate the REST serviceExpand the “helloworld” node in the LHS and click on the helloworld (AdminServer) instance as shown in the screenshot below. This will open up the Application Home page in EM. Select “Application Deployment->Web Services” menu item on the RHS as shown in the below screenshot.4Create REST client4.1Create a new “rest-client” Web projectCreate a new Project for the client as shown in the screenshot below.We will create “Web Project” since the client will act as a JEE Client.Click “OK”.Click “Next”Click “Next”Click “Next”Click “Next”Click “Next”Click “Finish”4.2Create “HelloWorld Servlet”Create a HTTPServlet which will act as the REST Client. You can create a Servlet by right-clicking on the project and selecting “New->HTTPServlet” from the context menu.Click “Next”Click “Next”Click “Next”Click “Finish”4.3Create REST Client ProxyYou can create a REST Client Proxy by right-clicking on the project and selecting “New->From Gallery” as shown below.Select the “Web Services” category from the “New Gallery” dialog on the Left Hand side. This will show all the options related to Web Services on the Right hand side. Select “Restful Client and Proxy” from RHS to create a REST client as shown in the screenshot below.Click “OK”Click “Next”To create a RESTful Proxy Client – you will need the WADL of the REST service.NOTE: Either you need to save the WADL of the service a priori or have the RESTful Service running in order to be able to provide the WADL url.Click “Next”By default JDeveloper generates a classname for the Proxy client. Provide a more user friendly name in this dialog as shown in the screenshot above.Click “Next”Select the OWSM policy you want to use to secure the client and click “Next”.IMPORTANT: Although JDeveloper provides you a policy selection dialog to select the OWSM policy in the REST Client Proxy creation wizard – there is a bug in JDeveloper - due to which the Policy is not added to the Client Proxy code. You will need to manually add the following lines of code show below.4.4Secure the REST Client ProxyPay special attention to the import statements in the code snippet above.import oracle.wsm.metadata.feature.AbstractPolicyFeature;import oracle.wsm.metadata.feature.PolicyReferenceFeature;import oracle.wsm.metadata.feature.PolicySetFeature;import oracle.wsm.metadata.feature.PropertyFeature;import oracle.wsm.security.util.SecurityConstants;import weblogic.jaxrs.api.client.Client;Few other things to note:∙The oracle/wss_http_token_client_policy – provides basic auth functionality and requires a username/password that needs to be sent to the client.∙For the username/password – we will store it in the credential store. The key to the entry will be called “weblogic-csf-key”under “oracle.wsm.security” CSF map.4.5Modify the HelloWorldServlet to call the RESTful Client ProxyFor purposes of brevity I have provided the code snippet for how to call the generated RESTful Proxy Client code above.4.6Modifying the REST Client Security PolicyOne can modify the OWSM client policy used to secure the client by right-clicking on the RESTful Client Proxy class and selecting “Secure RESTful Client” from the context menu as shown below.You can use the above dialog to make a different policy selection if required. In this case I did not modify the policy since I had already selected the correct policy.NOTE: Any changes you do in terms of selecting a different policy via this dialog will be effective and the corresponding code in the RESTful Proxy Client will be modified.4.7Secure the HelloWorldServlet web applicationOpen web.xml for the “rest-client” Project in JDeveloper and add an entry for the HelloWorldServlet as shown below.4.7.1Select Authentication MechanismSelect “HTTP Basic Authentication” mechanism.4.7.2Add Security Constraints4.7.3Final “web.xml” for the HelloWorldServlet4.7.4Create weblogic.xml deployment descriptor Right click on the project and select “New->From Gallery”.Click “OK”Click “Next”Click “Next”Click “Finish”4.7.5weblogic.xml for the HelloWorldServlet4.8Create Deployment Profile and WAR for the Client Click “OK”Click “OK”Click “Next”。
Oracle应用测试套件和实际应用测试解决方案说明书
The solutions consist of three distinct offerings.Oracle Application Testing Suite •(includes Oracle Test Manager, Oracle Functional Testing, and Oracle Load Testing)Oracle Real Application Testing • Oracle Data Masking Pack•T ogether these solutions enable you to manage your entire quality assurance (QA) process, including defining test requirements, executing automated and manual test cases, and tracking subsequent defects.Simplify T est Process ManagementManaging QA and testing programs for applications is more challenging than ever. Applications and their environments continue to grow more complex, making it increasingly difficult to understand the requirements for successful testing. Oracle T est Manager includes a flexible, easy-to-use process management solution on which you can build and organize your entire testing program.Organizations are getting ahead in today’s competitive environment by turning to the internet to improve business agility, reduce costs for the delivery of goods and services, and reach more customers. However, the internet business paradigm can create new and complex challenges. An inability to deliver a consistent, high-quality experience can put customer loyalty at risk and threaten revenue opportunities. Fixing performance issues before going live is resource-intensive and may result in time-to-market delays, but it’s still much less expensive than solving the same problems in a live production system. Y ou need a solution that lets you deploy higher-quality applications with less cost and effort. Oracle’s application-quality management solutions thoroughly test your packaged, Web-based, and service-oriented architecture (SOA)–based applications to ensure the quality, scalability, and availability of the applications and their underlying infrastructure.Deploy Higher-Quality Applications in Less Time with Secure, Comprehensive TestingHow can you ensure that your mission-critical applications perform well and comply with government regulations in the face of evolving technology, limited understanding of test parameters, and understaffed testing and development teams? The answer is simple when you test with Oracle’s application-quality management solutions.QualiTy aPPlicaTion TeSTing froM oracleThe following offerings comprise Oracle’s application-quality management solutions:Oracle Application Testing Suite • Oracle Real Application Testing • Oracle Data Masking Pack•The following products make up Oracle Application Testing Suite:Oracle Test Manager • Oracle Functional Testing • Oracle Load Testing•Copyright © 2010, 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.10049850 | C17386conTacT uSTo learn more, call +1.800.ORACLE1 to speak to an Oracle representative or visit /goto/application-quality. Outside North America, visit /corporate/contact/global.html to find the phone number foryour local Oracle office.Deploy Databases with confidenceHardware and software upgrades are essential for maintaining a competitive edge and complying with changing security and privacy laws. Even though system changes are designed to have a positive business impact, they can also lead to unexpected and undesirable behaviors and performance.Oracle Real Application Testing lets you safely and rapidly adopt new database and infrastructure technologies by reducing the testing effort and the time required to ensure the robustness and quality of applications. Oracle RealApplication T esting has the unique ability to record real-world database workloads and replay them in test environments while maintaining the characteristics of the production workloads. This enables you to identify and fix performance issues and minimize undesirable results such as service outages and performance degradations.realize faster returns on investmentOracle’s application-quality management solutions maximize the efficiency of your testing, QA, and operations teams by helping themPlan testing processes• Execute rigorous functional and •performance testsReport on application readiness in •real-world deployment schedulesY ou can define testing requirements, specify and execute manual and automat-ed tests to validate those requirements, and manage the defects that the tests uncover. Coordinating your entire QA program on a single, unified platform lets you manage quality as a process through-out the lifespan of your applications.ensure functional reliabilityProperly functioning applications enhance the end-user experience and increase customer loyalty. The quickest way to ensure the functional reliability of your applications is through functional and regression testing.Oracle Functional Testing tests the functional reliability of today’s cutting-edge .NET and J2EE Web applications, as well as Oracle packaged applications. By simplifying and automating functional and regression testing, you can stream-line the scripting process and build test cases without manual checkpoints, saving your organization time and money.Maximize application PerformanceOrganizations doing business over the internet know that the costs associated with poor application performance can be staggering—especially during peak business volumes. To ensure that your applications are performing at their best, you need to analyze your applications and their infrastructure under extreme stress and then fine-tune them both for optimal performance before you go live. OracleLoad T esting lets you easily and accurately test the load performance and scalabil- ity of your Web-based software and services. Y ou can execute real business transactions while simulating hundreds of thousands of concurrent users to analyze performance under an extreme load. Y ou can also monitor your back-end application infrastructure during load tests and identify—at the source—the hard-to-find performance bottlenecks that cause application slowdowns.Protect Sensitive enterprise DataInformation leaks are responsible for a growing number of identity theft and fraud incidents every year. Whether or not your organization does business over the internet, it is imperative that you safe-guard production data and prevent leaks of sensitive or confidential information. Oracle Data Masking Pack helps organiza-tions comply with privacy and confidential-ity laws during the entire QA process. The solution uses masking rules to replace sensitive data in the database with scrubbed, realistic-looking data, letting your QA staff use real data and authentic application and database scenarios in their testing processes. By helping the QA staff maintain the integrity of your applications and mask confidential data in development, test, and staging environments, you can decrease the costs and risks associated with deploying higher-quality products,applications, and services.Testing Suite can help you reduce testing times by“Oracle Real Application Testing provides a unique tool that enables us to significantly improve our speed in rolling out technology, and reduces our costs associated with critical testing.”Erzsébet Szirjákné Birkás, expert of System Programming, Mol Hungarian oil and gas company (Mol group)。
Fortify SSC 20.2.0在CentOS 8上的安装与部署指南说明书
Deployment GuideInstalling Fortify SSC 20.2.0 with MySQL 8 in Easy Steps on CentOS 8Fortify SSC 20.xAuthor: Vikas JohariDate: 29 January 2021Document Version: v0.1ContentsContents (2)Introduction (3)Installation of Oracle JDK 1.8 (3)Installing Tomcat 9.0.41 (4)Configure Apache (optional) (5)Installing MySQL 8 Community Edition (6)Configuring MySQL Database for SSC (8)Deploying JDBC Driver on Tomcat Server (11)Deploying SSC on Tomcat Server (11)IntroductionThis document is written to guide Pre-Sales and Partners to install Fortify SSC 20.2.0 in CentOS 8.x with MySQL 8 Community edition Database, in the same server.This document is not written to install Fortify SSC 20.2.0 in a Production Environment. However, this document can be used to setup Fortify SSC 20.2.0 in a controlled environment like Lab or PoC or CoE Environment.The Hardware and Software requirements are given in the link –https:///documentation/fortify-software-security-center/2020/Fortify_Sys_Reqs_20.2.0/index.htm#SSC/SSC_Reqs.htm?TocPath=Fortify%2520Software%2520 Security%2520Center%2520Server%2520Requirements%257C_____0Detailed SSC 20.2.0 User Guide is given in https:///documentation/fortify-software-security-center/2020/SSC_Help_20.2.0/index.htmI have used a VM with the below hardware configuration –CPU: 4 VCPURAM: 8 GB RAMDisk: 100 GB Thin ProvisionedCentOS 8: Download link /centos/8/isos/x86_64/MySQL 8 Community EditionInternet Connection on CentOS VMInstall CentOS 8 and apply all the required patches.Installation of Oracle JDK 1.8Download Oracle JDK 11 “jdk-11.0.10_linux-x64_bin.rpm” file fromhttps:///in/java/technologies/javase-jdk11-downloads.html and upload “jdk-11.0.10_linux-x64_bin.rpm” to server.Install Oracle JDK 11 using –[root@localhost ~]# rpm -ivh jdk-11.0.10_linux-x64_bin.rpmVerify that only Oracle JDK is installed in the server –[root@localhost ~]# rpm -qa | grep -i jdkjdk-11.0.10-11.0.10-ga.x86_64Add the below lines in /etc/profile file (at the end of it) using a text editor.export JAVA_HOME=$(dirname $(dirname $(readlink $(readlink $(which javac))))) export PATH=$PATH:$JAVA_HOME/binexport CLASSPATH=.:$JAVA_HOME/jre/lib:$JAVA_HOME/lib:$JAVA_HOME/lib/tools.jar Reboot the server and login as root.Installing Tomcat 9.0.41Post-installation of JDK 11, now we can install tomcat 9.[root@localhost ~]# cd Downloads[root@localhost Downloads]# wgethttps://mirrors.estointernet.in/apache/tomcat/tomcat-9/v9.0.41/bin/apache-tomcat-9.0.41.tar.gzExtract tomcat[root@localhost Downloads]# tar -xvf apache-tomcat-9.0.41.tar.gz -C /usr/share/Create a symbolic link -[root@localhost Downloads]# ln -s /usr/share/apache-tomcat-9.0.41/ /usr/share/tomcatCreate a tomcat service[root@localhost Downloads]# vi /etc/systemd/system/tomcat.service Add the below configuration –[Unit]Description=Tomcat 9 ServerAfter=syslog.target network.target[Service]Type=forkingUser=rootGroup=rootEnvironment='JAVA_OPTS=-Djava.awt.headless=true'Environment=CATALINA_HOME=/usr/share/tomcatEnvironment=CATALINA_BASE=/usr/share/tomcatEnvironment=CATALINA_PID=/usr/share/tomcat/temp/tomcat.pidEnvironment='CATALINA_OPTS=-Xms4096M -Xmx6144M'ExecStart=/usr/share/tomcat/bin/catalina.sh startExecStop=/usr/share/tomcat/bin/catalina.sh stop[Install]WantedBy=multi-user.targetStart and enable the tomcat service[root@localhost Downloads]# systemctl daemon-reload[root@localhost Downloads]# systemctl start tomcat[root@localhost Downloads]# systemctl status tomcat● tomcat.service - Apache Tomcat ServerLoaded: loaded (/etc/systemd/system/tomcat.service; enabled; vendor preset: disabled)Active: active (running) since Thu 2021-01-28 22:46:02 CST; 2min 59s agoProcess: 1028 ExecStart=/usr/local/tomcat9/bin/catalina.sh start (code=exited, status=0/SUCCESS) Main PID: 1110 (java)Tasks: 99 (limit: 100787)Memory: 2.0GCGroup: /system.slice/tomcat.service└─1110 /usr/bin/java -Djava.util.logging.config.file=/usr/local/tomcat9/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djdk.tls.e>Jan 28 22:46:01 systemd[1]: Starting Apache Tomcat Server...Jan 28 22:46:01 catalina.sh[1028]: Tomcat started.Jan 28 22:46:02 systemd[1]: Started Apache Tomcat Server.[root@localhost Downloads]# systemctl enable tomcatCreated symlink /etc/systemd/system/multi-user.target.wants/tomcat.service →/etc/systemd/system/tomcat.service.Open Port 8080 & 80 in the firewall.[root@localhost Downloads]# firewall-cmd --permanent --add-port=8080/tcp success[root@localhost Downloads]# firewall-cmd --permanent --add-port=80/tcp success[root@localhost Downloads]# firewall-cmd --reloadsuccessConfigure Apache (optional)Apache is an optional component, it is used to act as a reverse proxy for tomcat server.Install apache server using -[root@localhost ~]# yum install httpd -yCreate a reverse proxy configuration for tomcat using a text editor -[root@localhost ~]# vi /etc/httpd/conf.d/tomcat9.conf<VirtualHost *:80>ServerAdmin root@localhostServerName DefaultType text/htmlProxyRequests offProxyPreserveHost OnProxyPass / http://localhost:8080/ProxyPassReverse / http://localhost:8080/</VirtualHost>Configure SELinux Rules –[root@localhost ~]# setsebool -P httpd_can_network_connect 1[root@localhost ~]# setsebool -P httpd_can_network_relay 1[root@localhost ~]# setsebool -P httpd_graceful_shutdown 1[root@localhost ~]# setsebool -P nis_enabled 1Restart and enable the apache service.[root@localhost ~]# systemctl restart httpd[root@localhost ~]# systemctl enable httpdUse a browser to validate the tomcat and apache service is running as per configuration, using, http://ip, :8080, http://ip:8080 of the server.Installing MySQL 8 Community EditionRun the below command to download and install MySQL 8 community edition database.[root@localhost Downloads]# wget https:///get/Downloads/MySQL-8.0/mysql-community-libs-8.0.19-1.el8.x86_64.rpm[root@localhost Downloads]# wget https:///get/Downloads/MySQL-8.0/mysql-community-common-8.0.19-1.el8.x86_64.rpm[root@localhost Downloads]# wget https:///get/Downloads/MySQL-8.0/mysql-community-client-8.0.19-1.el8.x86_64.rpm[root@localhost Downloads]# wget https:///get/Downloads/MySQL-8.0/mysql-community-server-8.0.19-1.el8.x86_64.rpm[root@localhost Downloads]# rpm -ivh mysql-community-client-8.0.19-1.el8.x86_64.rpm mysql-community-common-8.0.19-1.el8.x86_64.rpm mysql-community-libs-8.0.19-1.el8.x86_64.rpm mysql-community-server-8.0.19-1.el8.x86_64.rpmStart and Enable the MySQL Service[root@localhost Downloads]# systemctl start mysqld[root@localhost Downloads]# systemctl enable mysqldGrab the temporary password for root user of mysql[root@localhost ~]# cat /var/log/mysqld.log | grep -i 'temporary password'Note down the password.2020-02-12T13:23:05.319292Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: niy4pkkn1t,TTest MySQL server.[root@localhost ~]# mysql -u root -pEnter password: niy4pkkn1t,T <- Enter the temporary password from log fileWelcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 8Server version: 8.0.19 MySQL Community Server - GPLCopyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || sys |+--------------------+4 rows in set (0.00 sec) mysql>quitByeConfiguring MySQL Database for SSCModify the MySQL Configuration file for SSC.[root@localhost ~]# mv /etc/f /etc/f_orig [root@localhost ~]# vi /etc/fPaste the below content in the file -[client]port = 3306socket = /var/run/mysqld/mysqld.sock[mysql]no-beepsocket = /var/run/mysqld/mysqld.sock[mysqld]collation-server = latin1_general_csinit-connect = 'SET NAMES latin1'character-set-server = latin1pid-file = /var/run/mysqld/mysqld.pidsocket = /var/run/mysqld/mysqld.sockport = 3306datadir = /var/lib/mysql/datadefault_authentication_plugin = mysql_native_passworddefault-storage-engine = INNODBsql-mode = "TRADITIONAL"long_query_time=10report_port = 3306lower_case_table_names = 1secure-file-priv = NULLsymbolic-links = 0max_connections = 151table_open_cache = 2000tmp_table_size = 648Mthread_cache_size = 10myisam_max_sort_file_size = 100Gmyisam_sort_buffer_size = 2Gkey_buffer_size = 8Mread_buffer_size = 64Kread_rnd_buffer_size = 256Kinnodb_flush_log_at_trx_commit = 1innodb_log_buffer_size = 1Minnodb_buffer_pool_size = 10Ginnodb_log_file_size = 5Ginnodb_lock_wait_timeout = 300innodb_thread_concurrency = 9innodb_autoextend_increment = 64innodb_buffer_pool_instances = 8innodb_concurrency_tickets = 5000innodb_old_blocks_time = 1000innodb_open_files = 300innodb_stats_on_metadata = 0innodb_file_per_table = 1innodb_checksum_algorithm = 0back_log = 80flush_time = 0join_buffer_size = 256Kmax_allowed_packet = 1Gmax_connect_errors = 100open_files_limit = 4161sort_buffer_size = 256Ktable_definition_cache = 1400binlog_row_event_max_size = 8Ksync_master_info = 10000sync_relay_log = 10000sync_relay_log_info = 10000#!includedir /etc/mysql/conf.d/[mysqldump]max_allowed_packet = 1GStop MySQL Service[root@localhost ~]# service mysqld stopInitialize the MySQL Database server.[root@localhost ~]# mysqld --initialize-insecure --console --user=mysql 2020-03-05T10:20:08.891111Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.2020-03-05T10:20:08.891266Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld8.0.19) initializing of server in progress as process 32938100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 2100 2200 2300 2400 2500 2600 2700 2800 2900 3000 3100 3200 3300 3400 3500 3600 3700 3800 3900 4000 4100 4200 4300 4400 4500 4600 4700 4800 4900 5000 5100100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 2100 2200 2300 2400 2500 2600 2700 2800 2900 3000 3100 3200 3300 3400 3500 3600 3700 3800 3900 4000 4100 4200 4300 4400 4500 4600 4700 4800 4900 5000 51002020-03-05T10:21:25.170585Z 5 [Warning] [MY-010453] [Server] root@localhost is createdwith an empty password ! Please consider switching off the --initialize-insecure option. Start the MySQL Service[root@localhost ~]# service mysqld startValidate the service, make sure it is running[root@localhost ~]# service mysqld statusSecure the installation of MySQL server.[root@localhost ~]# mysql_secure_installationThis wizard will ask many questions, answer them carefully.Would you like to setup VALIDATE PASSWORD component?Press y|Y for Yes, any other key for No: nPlease set the password for root here.New password: <- Enter a password for root user of mysqlRe-enter new password: <- ReEnter a password for root user of mysqlEstimated strength of the password: 100Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y......Remove anonymous users? (Press y|Y for Yes, any other key for No) : y......Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y......Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y....Reload privilege tables now? (Press y|Y for Yes, any other key for No) : ySuccess.All done!Now let's create a Database and a User which will be used by SSC.[root@localhost ~]# mysql -u root -pEnter password:<- Enter the root’s password of mysqlmysql> create database SSC_DB DEFAULT CHARACTER SET latin1 COLLATElatin1_general_cs;mysql> CREATE USER 'sscuser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'SscUser@123';You may use any complex password for sscuser of MySQL server, but make a note of it.mysql> GRANT ALL PRIVILEGES ON *.* TO 'sscuser'@'localhost' WITH GRANT OPTION; Query OK, 0 rows affected (0.02 sec)mysql> FLUSH PRIVILEGES;mysql> quitByeNow Create the DB structure.Extract the Fortify_SSC_Server_20.2.0.zip file, then extract Fortify_20.2.0_Server_WAR_Tomcat.zip file.The \Fortify_SSC_Server_20.2.0\Fortify_20.2.0_Server_WAR_Tomcat\sql\mysqlIt contains two files.Upload “create-tables.sql” file into /root/Downloads folder of CentOS server.[root@localhost Downloads]# mysql --user="sscuser" -p --database="ssc_db" --host="localhost" < "create-tables.sql"Enter password: <- Type the password of sscuser and then hit enterValidate the DB Structure is created.[root@localhost Downloads]# mysql -u sscuser -pEnter password: <- Type the password of sscuser and then hit enterWelcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 23Server version: 8.0.19 MySQL Community Server - GPLCopyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> use ssc_db;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> show tables;+------------------------------+| Tables_in_ssc_db |+------------------------------+| activity || activity_persona || activitycomment || activityinstance |mysql> quit;Deploying JDBC Driver on Tomcat ServerThere is no need to deploy the JDBC Driver of MySQL on the Tomcat server because SSC 20.2.0 has the JDBC Driver of MySQL and MSSQL inbuilt into the WAR file.Deploying SSC on Tomcat ServerStop Tomcat server.[root@localhost Downloads]# service tomcat stopUpload ssc.war file from Fortify_20.2.0_Server_WAR_Tomcat.zip file to /usr/share/tomcat/webapps.Start tomcat.[root@localhost Downloads]# service tomcat startWait for few mins, tomcat will take few mins to deploy ssc war file.Open Chrome browser and open the URL http://ip_of_server:8080/sscClick on ADMINISTRATORS./root/.fortify/ssc/init.token and paste it in the token field.Click Sign In.Click Next.Click Next.In the URL: http://ip_of_server:8080/sscEnable HTTP host header validation: DisabledGlobal Search: /globalsearchI have read and understood this warning: EnabledClick Next.Database Type: MYSQLDatabase username: sscuserDatabase Password: ss cuser’s passwordJDBC URL:jdbc:mysql://127.0.0.1:3306/ssc_db?connectionCollation=latin1_general_cs&rewriteB atchedStatements=trueClick Test Connection.If Test connection is successful, then click Next.Browse and Select the Process Seed Bundle.Click on Seed Database.Now, Browse and Select Report Seed Bundle and click on Seed Database.This time, Browse and Select PCI Basic Seed Bundle and click on Seed Database.Now the last one, Browse and select PCI SSF Basic Bundle then click on Seed Database.Click Next.Click Finish.Close and Start Browser, then open SSC url.Login as “admin” and password “admin”.In the Change Password window, change the admin’s password. Click Save.Login with new admin credentials.Click on ADMINISTRTION.Click on Rulepacks, then click on “Update from Server”.Click OK.Click Close.Now SSC is ready to use.< !! End of the Document !! >。
Oracle SPARC T4-4 服务器入门指南说明书
This guide describes how to quickly power on and boot Oracle’s SPARC T4-4server for the first time using the preinstalled Oracle Solaris Operating System (Oracle Solaris OS).Detailed installation information can be found in the SPARC T4-4Server Installation Guide ,which is available at the Oracle documentation web site:/docs/cd/E23411_01Shipping ContentsSafety and Compliance InformationBefore performing an installation,refer to the following documents for safety information regarding the SPARC T4-4server:QuantityItem1Server4AC power cords1RJ-45to DB-9crossover adapter 1RJ-45to DB-25crossover adapter 1Antistatic wrist strap 1Rackmountkit1Cable management assembly VariousdocumentsSPARC T4-4 ServerGetting Started Guide■Important Safety Information for Sun Hardware Systems-Printed document included in the shipping kit.■SPARC T4-4Server Safety and Compliance Manual-Available online at the Oracle documentation web site.▼Install Optional ComponentsBefore installing the server into the rack,you must first install any optional components that you ordered with the server,such as DIMMs and PCIe cards.Refer to the SPARC T4-4Server Service Manual for instructions on installing optional components.▼Prepare to Install the ServerSetting up the server for the first time takes about45to75minutes.Plan for additional time if you are also installing optional hardware and rackmounting kits.Caution–Do not apply power until instructed to do so.–This system includes a service processor (SP)that is used to configure and boot the host server.To properly configure the host server and view SP messages,do not apply AC power to the server until the SP and host networking connections are made,as described in this guide.1.Choose the best way to set up the server for your environment.The instructions in this guide work for any networking environment and require a terminal device for connecting to a serial port.If you have a networking environment running DHCP,you can configure your system using the Ethernet management port by following the instructions in the installation guide.2.Obtain a terminal device.You configure the server through the SP using the built-in serial and network management ports,not through a graphical interface and keyboard.To communicate with the SP,you need a terminal device,which can be a terminal,a terminal server,or a laptop running terminal emulation software.3.Gather your configuration information.Refer to the installation guide for a checklist.▼Install the ServerFor quick installation and configuration,follow these steps.For more detailed information,refer to the complete online product documentation set.1.Confirm that you received all the parts needed for setting up the server.See“Shipping Contents”for details.2.Place the server in its intended location.For rackmounting instructions,refer to the installation guide.3.Connect a serial cable between the server’s SER MGT port and a terminal device.This connection provides the initial communication with the SP.Set up the server to communicate using9600baud,8bit,no parity,1stop bit.For DTE-to-DTEcommunication,use the supplied RJ-45crossover adapters with a standard RJ-45cable to set up a null modem configuration so that the transmit and receive signals are crossed over.FIGURE1Server Connections4.(Optional)Connect an Ethernet cable between the server’s NET MGT port and the network to whichfuture connections to the SP and host will be made.Configure the system for the first time through the SER MGT port.After the initial configuration,you can set up communication between the SP and host through this Ethernet interface.5.Connect an Ethernet cable between one of the server’s NET ports and the network to which the serverwill communicate.6.Connect the power cords to the power supplies and to separate power sources.Your server is equipped with four power supplies.Connect them to two separate power sources to provide power redundancy.The system can operate with two power connections,but having only one power source reduces the redundancy.When the power cords are connected,the SP initializes and the power supply LEDs illuminate.After a few minutes,the SP login prompt displays on the terminal device.At this time,the host is not initialized or powered on.7.At the terminal device,log in to the SP as root with a password of changeme .After a brief delay,the Oracle Integrated Lights Out Manager (Oracle ILOM)prompt (->)is displayed.For optimal security,change the root password.Refer to the Oracle ILOM documentation for more information about administration tasks such as changing passwords,adding accounts,and setting account privileges.Note –By default,the SP is configured to use DHCP to obtain an IP address.If instead you plan to assign astatic IP address to the SP,refer to the online SPARC T4-4Server Installation Guide for instructions.8.Power on the server and redirect the host output to display on the serial terminal device.The server initialization takes approximately 20minutes to complete.9.When prompted,follow the onscreen instructions and type the configuration information for your system.If you are not sure how to respond,accept the default and make changes later when the Oracle Solaris OS is running.After you confirm the configuration information,the server reboots and displays the Oracle Solaris login prompt.10.Log in to the server.Use the following commands to display information about the system:■showrev –Displays the host name and system architecture e the -a option to display the patches that are installed.■psrinfo –Displays information about the number and status of the processors and cores in the host.Refer to the Oracle Solaris OS man pages and documentation for more details about these commands.▼Check for Latest Patches and FirmwareLater versions of OS patches and server firmware might be available for your server.Some server features are enabled only when certain versions of patches or firmware are installed.Refer to the SPARC T4-4Server Product Notes for details about required versions and patches.For updates,go to the My Oracle Support web site:https://SUNSP00144FAC732F login:root Password:changeme . . .->->start /SYSAre you sure you want to start /SYS (y/n)?y ->start /HOST/consoleAre you sure you want to start /HOST/CONSOLE (y/n)?y Serial console started.. . .Related DocumentationFeedbackProvide feedback on this document at:/goto/docfeedbackSupport and AccessibilityDocumentationLinksAll Oracle products /documentationSPARC T4-4server /docs/cd/E23411_01Oracle ILOM/docs/cd/E19860-01Oracle Solaris and other system software/technetwork/indexes/documentation/index.html#sys_swDescriptionLinksAccess electronic support through My Oracle Support.https:// For hearing impaired:/accessibility/support.html Learn about Oracle’s commitment to accessibility./us/corporate/accessibilityCopyright©2011,Oracle and/or its affiliates.All rights reserved. Copyright©2011,Oracle et/ou ses affiliés.Tous droits réservés.Part Number: E23416-01Mfg. Number: 702559October 2011。
Oracle-11.2.0.1-升级到-11.2.0.3-示例
（3）Out-of-placepatch set upgrades recommended, in which you install the patch set into a new,separate Oracle home. In-place upgrades are supported, but not recommended.
这部分内容copy 自patchset的readme 文档。
Oracle Databasepatch set, release 11.2.0.3（11.2.0.2） is a full installation of the Oracle Database software. This meansthat you do not need to install Oracle Database 11gRelease 2 (11.2.0.1)before installing Oracle Database 11gRelease 2 (11.2.0.3/11.2.0.2).
注意这里的安装位置，我之前的安装目录是11.2.0. 这里我改成了11.2.0.3. 即将oracle 安装到其他位置，这样可以减少宕机时间，也是oracle 推荐的方法。
注意这里的Inventory directory，这里用来存放安装文件的，我们之前安装过DB，所以这个目录已经存在，2种解决方法，删除之前的目录，二放到其他目录，我这里将安装文件存放到其他目录。
Oracle11.2.0.3 的Patchset no是：10404530，下载地址：
Oracle Database 12c安装和升级工作坊说明书
Oracle Database 12c: Install and UpgradeWorkshopOracle Database 12c Overview∙Oracle Database 12c Introduction∙Oracle Database Architecture Overview∙Oracle Database Instance Configurations∙Oracle Database Memory Structures∙Process Structures∙Database Storage Architecture∙Logical and Physical Database Structures∙Container and Pluggable Database OverviewInstalling Oracle Grid Infrastructure for a Standalone Server∙Overview of Oracle Grid Infrastructure for a Standalone Server∙System Requirements for Oracle Grid Infrastructure∙Configuring Storage for Oracle Automatic Storage Management (ASM)∙Installing Oracle Grid Infrastructure for a Standalone Server∙Upgrading Oracle Grid Infrastructure for a Standalone ServerInstalling Oracle Database Software∙Planning Your Installation∙System Requirements for Oracle Database∙Preparing the Operating System∙Using 4 KB Sector Disks∙Setting Environment Variables∙Checking the System Requirements∙Using the Oracle Universal Installer (OUI)∙Performing a Silent Mode InstallationCreating an Oracle Database by Using DBCA∙Planning the Database Storage Structure∙Choosing non-CDB or CDB∙Types of Databases (based on workload)∙Choosing the Appropriate Character Set∙Understanding How Character Sets are Used∙Setting the NLS_LANG Initialization Parameter∙Using the Database Configuration Assistant (DBCA)Using Oracle Restart∙Oracle Restart Overview∙Oracle Restart Process startup∙Controlling Oracle Restart∙Choosing the Correct SRVCTL Utility∙Oracle Restart Configuration∙Using the SRVCTL Utility∙Obtaining Help for the SRVCTL Utility∙Starting Components by Using the SRVCTL UtilityIntroduction to Upgrading to Oracle Database 12c∙Upgrade Methods∙Data Migration Methods∙Supported Releases for Direct Upgrade∙Overview of Upgrade Process∙Performing a Rolling Upgrade∙Upgrading a CBDPreparing to Upgrade to Oracle Database 12c∙Developing a Test Plan∙Performance Testing∙Requirements for Databases Using Oracle Label Security or Oracle Database Vault ∙Requirement for Databases Using Oracle Warehouse Builder∙Using the Pre-Upgrade Information Tool∙Backing Up the Database∙Installing the Oracle Database 12c Software∙Preparing the New Oracle HomeUpgrading to Oracle Database 12c∙Upgrading by Using the Database Upgrade Assistant (DBUA)∙Manually Upgrading to Oracle Database 12c∙Migrating a non-CDB to a CDBPerforming Post-Upgrade Tasks∙Migrating to Unified Auditing∙Performing Post-Upgrade Tasks Following a Manual UpgradeMigrating Data by Using Oracle Data Pump∙Data Pump Overview∙Migrating by Using Data Pump∙Importing by Using a Network Link。
b14313
Oracle® DatabaseClient Installation Guide10g Release 2 (10.2) for Microsoft Windows (64-Bit) on Intel ItaniumB14313-02November 2005Oracle Database Client Installation Guide 10g Release 2 (10.2) for Microsoft Windows (64-Bit) on Intel ItaniumB14313-02Copyright © 1996, 2005, Oracle. All rights reserved.Primary Author: Patricia HueyContributors: Punsri Abeywickrema, Phil Choi, Toby Close, Sudip Datta, Alex Keh, Mark Kennedy, Peter LaQuerre, Anu Natarajan, Bharat Paliwal, Sham Rao Pavan, Rajendra Pingte, Helen Slattery, Debbie Steiner, Linus Tanaka, Sujatha Tolstoy, Alice Watson, Janelle SimmonsThe Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited.The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. This document is not warranted to be error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose.If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the United States 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, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software—Restricted Rights (June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and we disclaim liability for any damages caused by such use of the Programs.Oracle, JD Edwards, PeopleSoft, and Retek are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.The Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear all risks associated with the use of such content. If you choose to purchase any products or services from a third party, the relationship is directly between you and the third party. Oracle is not responsible for: (a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warranty obligations related to purchased products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third party.ContentsPreface (vii)Audience (vii)Documentation Accessibility (vii)Related Documentation (viii)Conventions (viii)1 Oracle Database Client Installation OverviewInstallation Overview.............................................................................................................................. 1-1 Oracle Database Client Installation Types.......................................................................................... 1-2 2 Oracle Database Client Preinstallation RequirementsOracle Database Client Hardware Requirements.............................................................................. 2-1 Hard Disk Space Requirements....................................................................................................... 2-1 Oracle Database Client Software Requirements............................................................................... 2-3 General Oracle Database Client Software Requirements............................................................. 2-3 Instant Client Light Language and Character Set Requirements................................................ 2-4 Oracle Database Client Hardware and Software Certification....................................................... 2-5 Windows Telnet Services Support................................................................................................... 2-5 Windows Terminal Services and Remote Desktop Support....................................................... 2-5 Windows Support.............................................................................................................................. 2-6 3 Installing Oracle Database ClientPreinstallation Considerations Before Installing Oracle Database Client................................... 3-1 Installing Oracle Database Client Installations in Silent or Nonteractive Mode...................... 3-1 Creating the Oracle Base Directory................................................................................................. 3-2 Installing Oracle Database Client into Multiple Oracle Homes.................................................. 3-2 Installing on a System with an Existing Oracle Installation........................................................ 3-2 Accessing the Installation Software..................................................................................................... 3-2 Installing from a Remote DVD Drive.............................................................................................. 3-3 Step 1: On the Remote Computer, Share the DVD Drive..................................................... 3-3Step 2: On the Local Computer, Map the DVD Drive........................................................... 3-3 Installing on Remote Computers Through Remote Access Software........................................ 3-4 Installing on Remote Computers from a Hard Drive............................................................ 3-4Installing on Remote Computers from a Remote DVD Drive.............................................. 3-4 Downloading Oracle Software from the Oracle Technology Network Web Site..................... 3-5iiiCopying the Oracle Database Client Software to a Hard Disk................................................... 3-5 Installing the Oracle Database Client Software................................................................................. 3-5 Guidelines for Installing Oracle Database Client.......................................................................... 3-5 Procedure for Installing Oracle Database Client........................................................................... 3-6 4 Oracle Database Client Postinstallation TasksRequired Postinstallation Tasks............................................................................................................ 4-1 Downloading and Installing Patches.............................................................................................. 4-1 Updating Instant Client..................................................................................................................... 4-2 Recommended Postinstallation Tasks.................................................................................................. 4-2 Configuring Instant Client Light..................................................................................................... 4-2 Connecting Oracle Database Client to an Oracle Database......................................................... 4-3 Connecting Instant Client or Instant Client Light to an Oracle Database................................. 4-4 Specifying a Connection by Using the Easy Connect Naming Method............................. 4-4Specifying a Connection by Configuring a tnsnames.ora File............................................. 4-5Specifying a Connection by Using an Empty Connect String and the LOCAL Variable. 4-5 Setting Up User Accounts................................................................................................................. 4-6 Using Oracle9i Language and Definition Files with Oracle Database 10g Release 2 (10.2).... 4-6 Configuring Oracle Counters for Windows Performance Monitor............................................ 4-6 Required Product-Specific Postinstallation Task – Configuring Oracle Net Services............... 4-7 5 Removing Oracle Database Client SoftwareStopping Oracle Services on Windows ............................................................................................... 5-1 Removing Oracle Database Client with Oracle Universal Installer.............................................. 5-1 Guidelines for Removing Oracle Database Client with Oracle Universal Installer................. 5-2 Procedure for Removing Oracle Database Client with Oracle Universal Installer.................. 5-2 Manually Removing the Remaining Oracle Database Client Components................................. 5-3 Removing Oracle Keys from the Registry Editor on Windows.................................................. 5-4 Removing Only the Oracle Net Service Registry Key........................................................... 5-4Removing All Oracle Registry Keys......................................................................................... 5-4 Updating the PATH Environment Variable Path.......................................................................... 5-5 Removing Oracle Database Client from the Start Menu.............................................................. 5-5 Removing Oracle Database Client Directories............................................................................... 5-6 A Installing Oracle Database Client Using Response FilesHow Response Files Work.....................................................................................................................A-1 Reasons for Using Silent Mode or Noninteractive Mode............................................................A-2 General Procedure for Using Response Files................................................................................A-2 Preparing a Response File.....................................................................................................................A-3 Editing a Response File Template ..................................................................................................A-3 Recording a Response File...............................................................................................................A-4 Running Oracle Universal Installer Using the Response File.......................................................A-5 B Configuring Oracle Database Client Globalization SupportInstalling and Using Oracle Components in Different Languages...............................................B-1 Running Oracle Universal Installer in Different Languages......................................................B-1 ivUsing Oracle Components in Different Languages.....................................................................B-2 About the NLS_LANG Parameter........................................................................................................B-2 Commonly Used Values for NLS_LANG...........................................................................................B-3 NLS_LANG Settings in MS-DOS Mode and Batch Mode ............................................................B-4 C Troubleshooting the Oracle Database Client InstallationVerifying Requirements.........................................................................................................................C-1 What to Do if an Installation Error Occurs......................................................................................... C-1 Reviewing the Log of an Installation Session...................................................................................C-2 Silent or Noninteractive Installation Response File Error Handling...........................................C-2 Troubleshooting Configuration Assistants........................................................................................C-3 Configuration Assistant Failure......................................................................................................C-3 Fatal Errors.........................................................................................................................................C-3 Cleaning Up After a Failed Installation..............................................................................................C-3 GlossaryIndexvviviiPrefaceThis guide provides instructions on installing and configuring Oracle Database Client for Microsoft Windows (64-Bit) on Intel Itanium. The supported Windows operating system for this product is Windows Server 2003.This preface contains these topics:■Audience ■Documentation Accessibility ■Related Documentation ■ConventionsAudienceOracle Database Client Installation Guide for Microsoft Windows (64-Bit) on Intel Itanium is intended for anyone installing an Oracle Database Client.To use this document, you need the following:■ A supported Microsoft Windows operating system installed and tested on your computer system■Administrative privileges on the computer where you are installing Oracle Database Client■Familiarity with object-relational database management conceptsDocumentation AccessibilityOur goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, ourdocumentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leadingtechnology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at/accessibility/See Also:Oracle Database Client Quick Installation Guide for MicrosoftWindows (64-Bit) on Intel Itanium if you want to perform a quickinstallation using the default settingsAccessibility of Code Examples in DocumentationScreen readers may not always correctly read the code examples in this document. Theconventions for writing code require that closing braces should appear on anotherwise empty line; however, some screen readers may not always read a line of textthat consists solely of a bracket or brace.Accessibility of Links to External Web Sites in DocumentationThis documentation may contain links to Web sites of other companies ororganizations that Oracle does not own or control. Oracle neither evaluates nor makesany representations regarding the accessibility of these Web sites.TTY Access to Oracle Support ServicesOracle provides dedicated Text Telephone (TTY) access to Oracle Support Serviceswithin the United States of America 24 hours a day, seven days a week. For TTYsupport, call 800.446.2398.Related DocumentationFor more information, see these Oracle resources:■Oracle Database Release Notes for Microsoft Windows (64-Bit) on Intel Itanium■Oracle Database Installation Guide for Microsoft Windows (64-Bit) on IntelItanium■Oracle Database Platform Guide for Microsoft Windows (64-Bit) on Intel Itanium■Oracle Database 2 Day DBAMany of the examples in this book use the sample schemas, which are installed bydefault when you select the Basic Installation option with an Oracle Databaseinstallation. Refer to Oracle Database Sample Schemas for information on how theseschemas were created and how you can use them yourself.Printed documentation is available for sale in the Oracle Store at/To download free release notes, installation documentation, white papers, or othercollateral, please visit the Oracle Technology Network (OTN). You must register onlinebefore using OTN; registration is free and can be done at/technology/membership/If you already have a username and password for OTN, then you can go directly to thedocumentation section of the OTN Web site at/technology/documentation/ ConventionsThe following text conventions are used in this document:Convention Meaningboldface Boldface type indicates graphical user interface elements associatedwith an action, or terms defined in text or the glossary.italic Italic type indicates book titles, emphasis, or placeholder variables forwhich you supply particular values.viiiConvention Meaningmonospace Monospace type indicates commands within a paragraph, URLs, codein examples, text that appears on the screen, or text that you enter.ixx1 Oracle Database Client Installation Overview■■Installation Overview1.Read the release notes g/technology/documentation2.Plan your installation:You may also want to refer to Appendix A, "Frequently Asked Questions aboutInstallation," in Oracle Database Installation Guide. This appendix advises on thebest way to install Oracle products depending on your site’s requirements.plete preinstallation tasks:Chapter2 describes preinstallation tasks that youmust complete before installing Oracle Database Client.4.Install the software: Use the following sections to install Oracle Database Client:■Chapter3 describes how to use the Oracle Universal Installer (OUI) GUI toinstall Oracle Database Client.■Appendix A describes how to perform a silent or noninteractive installationusing response files.■"Installing and Using Oracle Components in Different Languages" onpage B-1 describes how to install and use Oracle components in differentlanguages.■Appendix C provides troubleshooting advice in case you encounter problemswith the installation.■Chapter5 describes how to remove Oracle Database Client.plete postinstallation tasks: Use the following sections to complete thepostinstallation tasks:Oracle Database Client Installation Overview1-1Oracle Database Client Installation Types1-2Oracle Database Client Installation Guide■Chapter 4 describes recommended and required postinstallation tasks.■Appendix B provides information on globalization support.Oracle Database Client Installation TypesYou can choose one of the following installation types when installing Oracle DatabaseClient:■ Installs only the shared libraries required by Oracle Call Interface applications that use the Instant Client feature. This installation type requiresmuch less disk space than the other Oracle Database Client installation types.Included in the Instant Client installation is Instant Client Light. You may want touse this version of Instant Client if your applications will generate error messagesin American English only. The advantage of using Instant Client Light is that it hasa much smaller footprint than regular Instant Client. Hence, your applications useless memory.■ Enables applications to connect to an Oracle database on the local system or on a remote system. It provides tools that let you administer an Oracledatabase.■ Enables applications to connect to an Oracle database on the local system or on a remote system.■Enables you to select individual components from the list of Administrator and Runtime components.Oracle Database Client Preinstallation Requirements2Oracle Database Client Preinstallation RequirementsOracle Database Client Hardware RequirementsTable 2–1 lists the required hardware components for Oracle Database Client.Hard Disk Space Requirementsrequired to install Java Runtime Environment (JRE) and Oracle Universal Installer onthe partition where the operating system is installed. If sufficient space is not detected,then installation fails and an error message appears.Table 2–2 lists the space requirements for NTFS.Table 2–1Hardware Requirements Requirement Minimum Value Physical memory (RAM) 1 GB mininum Virtual memory 512 MB Hard disk space Total ranges from 280–855 MB. See Table 2–2 for details.Video adapter 256 colorsProcessorIntel Itanium 2 or laterOracle Database Client Hardware Requirements2-2* This size varies, depending on the on the installation components selected.To ensure that the system meets these requirements, follow these steps:1.Determine the physical RAM size. For a computer using Windows 2003, forexample, open in the Windows Control Panel and select the tab. If the size of the physical RAM installed in the system is less than the required size, then you must install more memory before continuing.2.Determine the size of the configured virtual memory (also known as paging filesize). For a computer using Windows 2003, for example, open in theControl Panel, select the tab, and click in thesection. Then select the tab. The virtual memory is listed in thesection.If necessary, see your operating system documentation for information about how to configure additional virtual memory.3.Determine the amount of free disk space on the system. For a computer usingWindows 2003, for example, open , right-click the drive where the Oracle software is to be installed, and choose .4.Determine the amount of disk space available in the directory. This isequivalent to the total amount of free disk space, minus what will be needed for the Oracle software to be installed.If there is less than 100 MB of disk space available in the directory, then first delete all unnecessary files. If the temp disk space is still less than 100 MB, then set the TEMP TMPTable 2–2Disk Space Requirements for NTFSInstallation Type TEMP Space SYSTEM_DRIVE:\ProgramFiles\Oracle\Inventory Oracle Home TotalInstant Client100 MB 5 MB175 MB 280 MB Administrator100 MB 5 MB750 MB855 MB Runtime100 MB 5 MB350 MB 455 MB Custom (all componentsinstalled)100 MB 5 MB *650 MB *755 MB *See Also:"NTFS File System and Windows Registry Permissions" inOracle Database Client Software Requirements2-3Oracle Database Client Software RequirementsThis section covers the following topics:■General Oracle Database Client Software Requirements ■Instant Client Light Language and Character Set RequirementsGeneral Oracle Database Client Software RequirementsTable 2–3 lists the software requirements for Oracle Database Client.Table 2–3Software Requirements Requirement Value System Architecture Processor: Intel Itanium 2 or later Note: Oracle provides 32-bit (x86), 64-bit (Itanium), and 64-bit (x64) versions of Oracle Database for Windows. The 64-bit (Itanium) database version, which this installation guide describes, runs on the 64-bit version of Windows on Itanium hardware. For additional information, visit Oracle MetaLink at:Operating System Oracle Database for 64-bit Windows is supported on thefollowing operating systems:■Windows Server 2003 Datacenter Edition for 64-bit Itanium 2 Systems■Windows Server 2003 Enterprise Edition for 64-bit Itanium 2 Systems Windows Multilingual User Interface Pack is supported on Windows Server 2003.Windows XP is not supported.Compiler The following components are supported with the Windows 2003 Microsoft Platform SDK or later compiler and Intel compiler versions 7.1 and 8.1■Oracle C++ Call Interface ■Oracle Call Interface ■External callouts ■PL/SQL native compilation ■Pro*C ■XDKGNU Compiler Collection (GCC), Object Oriented COBOL (OOCOBOL) specifications, and Pro*COBOL are not supported.Network Protocol The Oracle Net foundation layer uses Oracle protocol support to communicate with the following industry-standard network protocols:■TCP/IP ■TCP/IP with SSL ■Named Pipes2-4Instant Client Light Language and Character Set RequirementsIn addition to the requirements described in the previous section, if you plan to useInstant Client Light, your applications must use the following languages and charactersets:■US English ■Any territory that is supported by Oracle ■Single byte*US7ASCII *WE8DEC –Unicode*UTF8*AL16UTF16*AL32UTF8The language, territory, and character sets are determined by the NLS_LANGparameter, which is stored in the registry under the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME ID subkey, where ID is the uniquenumber identifying the Oracle home.See Also:■"Windows Terminal Services and Remote Desktop Support" on page 2-5■"Windows Support" on page 2-6Caution:AL32UTF8 is the Oracle Database character set that isappropriate for XMLType data. It is equivalent to the IANA registeredstandard UTF-8 encoding, which supports all valid XML characters.Do not confuse Oracle Database database character set UTF8 (nohyphen) with database character set AL32UTF8 or with characterencoding UTF-8. Database character set UTF8 has been superseded byAL32UTF8. Do not use UTF8 for XML data. UTF8 supports onlyUnicode version 3.1 and earlier; it does not support all valid XMLcharacters. AL32UTF8 has no such limitation.Using database character set UTF8 for XML data could potentiallycause a fatal error or affect security negatively. If a character that is notsupported by the database character set appears in an input-documentelement name, a replacement character (usually "?") is substituted forit. This will terminate parsing and raise an exception.See Also:Appendix B, "Configuring Oracle Database ClientGlobalization Support" for more information on2-5The platform-specific hardware and software requirements included in thisinstallation guide were current at the time this guide was published. However,because new platforms and operating system software versions might be certified afterthis guide is published, review the certification matrix on the Oracle MetaLink Web sitefor the most up-to-date list of certified hardware platforms and operating systemversions. This Web site also provides compatible client an database versions, patches,and workaround information for bugs. The Oracle MetaLink Web site is available at thefollowing URL:/You must register online before using Oracle MetaLink . After logging in, select Certify& Availability from the left-hand column. From the Product Lifecycle page, select theCertifications button. Other Product Lifecycle options include Product Availability ,Desupport Notices , and Alerts .The following sections list the following certification information:■Windows Telnet Services Support ■Windows Terminal Services and Remote Desktop Support ■Windows SupportWindows Telnet Services SupportWindows 2003 includes a Telnet Service that allows remote users to log on to theoperating system and run console programs using the command line, in the same waythat they do on UNIX. Oracle supports the use of command line utilities, such asSQL*Plus, Export, Import, and SQL*Loader, using this feature, but does not supporttheir GUI tools.Windows Terminal Services and Remote Desktop SupportOracle supports Terminal Services on Windows 2003. However, installation of Oraclecomponents from a remote Terminal Services Client on to a 64-bit Windows server thatis running a Terminal Server service is not supported. Start all configuration tools fromthe Terminal Server console and not from the Terminal Services Client.Oracle Connection Manager is not supported with Windows Terminal Services.You can configure Windows 2003 to use Terminal Services in Remote Desktop forAdministration Mode or Terminal Server Mode.Note:Make sure that the Telnet service is started on the WindowsServices utility.See Also:■The Microsoft Web site for more information about terminal servers/■The Oracle MetaLink Web site for the latest Terminal Server certification information /。
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
Installing the Oracle WebCenter Sites JumpStartKit
Disclaimer
The Sites 11gR1 Jump Start Kit is provided for demo purposes only. It is provided on an as is basis and is not a supported product SKU. Please do not open official support cases for the JSK.
This document covers how to install and start using the Sites Jump Start Kit (JSK). At a glance, you will need to:
1. Make sure that the prerequisites are installed
2. Install the JSK
3. Start JSK
1. Prerequisite for the JSK
----------------------------
a. Download the JSK. You will download a file named
"JSK_Installer11.1.1.6.1.jar"
b. JDK 1.6 or higher must be installed on your computer
c. Set up the environment variable:
> Linux:
set JAVA_HOME=<location of the JDK> (e.g., set JAVA_HOME=/opt/jdk1.6) run "java -jar JSK_Installer11.1.1.6.1.jar"
> Windows:
Not required on Windows, however you will need to logout and log back in if you just installed Java.
2. Install the JSK
--------------------
a. Double-click the JSK and an installation window will open.
- On Windows, if you are prompted with the "Run As" popup, deselect "Protect my computer and data from
unauthorized program activity" to continue the installation.
- On Linux use the following command: java -jar JSK_Installer11.1.1.6.1.jar
b. On clicking Next, you will see:
- Options to select
- Folder to extract the JSK to
c. The installer will display a "Finished" message when the installation is complete.
3. Start the JSK
----------------
a. After installation, start the JSK by double-clicking run.bat or run.sh (this will be in the extracted JSK folder). The default directory on Windows is: C:\Oracle\WebCenter\Sites\11gR1
b. If "Configure JSK after Install" was not selected in step 2 - a dialog
will appear:
- Select the application server
- Select the installation type
c. The progress bar will appear. When the JSK configuration is complete, the "JSK Startup Window" will appear.
d. Start the JSK by clicking the Start button (to the left of the status bar). The message window closes when the JSK has successfully started.
e. Go to the Sites URL
- http://localhost:<port>/cs/login
- You can login as user demo (pwd: demo) or fwadmin (pwd: xceladmin)
f. Enable AVIImage specific index
- In the Admin UI, go to the "Admin" tree tab and click on "Configure Asset Type Search"
- Enable index for AVIImage
- Go to "Configure Attributes for Asset Type Index" and add the fields Height, Width, Category to the AVIImage index. Switch the "Stored" column to true and save the configuration
- Go back to "Configure Asset Type Search" and reindex AVIImage
g. Binary indexing should be enabled manually (if needed)。