《Averify Release Notes.pdf》由会员分享，可在线阅读，更多相关《Averify Release Notes.pdf（8页珍藏版）》请在三一文库上搜索。
1、 Agile Product Lifecycle Management Averify Release Notes June 2010 v1.6.3 Part No. E17296-01 ii Agile Product Lifecycle Management Oracle Copyright Copyright 1995, 2010, Oracle and/or its affiliates. All rights reserved. This software and related documentation are provided under a license agreement
2、 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 displ
3、ay 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 erro
4、rs, please report them to us in writing. If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable: U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and tech
5、nical data delivered to U.S. Government customers are “commercial computer software“ or “commercial technical data“ pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be
6、 subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle
7、Parkway, Redwood City, CA 94065. This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this softwa
8、re in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous appli
9、cations. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. This software and documentation may provide access to or information on content, products and services from third parties. Oracle Corporation and its affil
10、iates 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, prod
11、ucts or services. v1.6.3 iii CONTENTS Oracle Copyright . ii Chapter 1 Averify Release Notes 1 Requirements .1 Downloading Averify .1 The averify.properties File 1 Destination Details 2 NLS Language Details 2 Averify Details (For 9.x Databases Only) . 2 Email Options . 3 Running Averify 4 Checking th
12、e Status of Averify .4 iv Agile Product Lifecycle Management Preface The Agile PLM documentation set includes Adobe Acrobat PDF files. The Oracle Technology Network (OTN) Web site http:/ contains the latest versions of the Agile PLM PDF files. You can view or download these manuals from the Web site
13、, or you can ask your Agile administrator if there is an Agile PLM Documentation folder available on your network from which you can access the Agile PLM documentation (PDF) files. Note To read the PDF files, you must use the free Adobe Acrobat Reader version 7.0 or later. This program can be downlo
14、aded from the Adobe Web site http:/. The Oracle Technology Network (OTN) Web site http:/ can be accessed through Help Manuals in both Agile Web Client and Agile JavaClient. If you need additional assistance or information, please contact My Oracle Support (https:/) for assistance. Note Before callin
15、g Oracle Support about a problem with an Agile PLM manual, please have the full part number, which is located on the title page. TTY Access to Oracle Support Services Oracle provides dedicated Text Telephone (TTY) access to Oracle Support Services within the United States of America 24 hours a day,
16、7 days a week. For TTY support, call 800.446.2398. Outside the United States, call +1.407.458.2479. Readme Any last-minute information about Agile PLM can be found in the Readme file on the Oracle Technology Network (OTN) Web site http:/ Agile Training Aids Go to the Oracle University Web page http:
17、/ for more information on Agile Training offerings. Accessibility of Code Examples in Documentation Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some sc
18、reen readers may not always read a line of text that consists solely of a bracket or brace. This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of
19、 these Web sites. v1.6.3 1 Chapter 1 Averify Release Notes Averify is a scripting tool that performs an integrity check against the PLM database and reports on specific errors. Averify includes a check for missing indexes and inconsistent data stored in the various database tables. Averify only repo
20、rts errors, and does not attempt to fix them or modify your database. Running Averify and using the results to eliminate known errors is a prerequisite for diagnosing problems. Averify is not comprehensive, however, and finding no errors does not certify a database as perfect. Requirements JRE 1.5 D
21、ownloading Averify Averify can be downloaded from My Oracle Support. The software should be downloaded to your destination database server. Extract the averify.zip file to a local drive. After Averify is extracted, all of the files are located in the following directories on the local drive: bin con
22、fig lib logs META-INF scripts The averify.properties File The averify.properties file, located in the config directory, contains a set of properties where you can specify database details. By default, the file does not contain user-supplied information. You must modify the averify.properties file to
23、 complete the destination database details, averify options, and email options. The destination database parameters contain information about the user and host details of the database you are checking. The Averify options contain information on which portions of the database you want to verify. The
24、email options enable you to send the averify.zip file, containing the averify.log and oracle_averify_report.log, to a specific email address upon completion. If you do not wish to change the averify.properties file each time you run Averify with different options, you can set the environment variabl
25、e, PROPERTYFILE, with the full path to another .properties file. You can create multiple .properties files modified with the parameters you need for specific runs of Averify. 2 Agile Product Lifecycle Management Destination Details Parameter Value Definition averify.dest.jdbc.url The JDBC connection
26、 string to the destination database. The format is jdbc:oracle:thin: : where DESTINATION_DB_HOST_NAME is the hostname of the destination database, PORT is the listener port of the destination database (1521 is the default), and SID is the database instance. averify.dest.jdbc.driver The database driv
27、er of the destination database. The default is oracle.jdbc.driver.OracleDriver. averify.dest.db.user The database user of the destination database. averify.dest.db.password The encrypted database password of the destination database. Use the encryptpwd utility located in the bin directory to encrypt
28、 the password. averify.dest.tns.name The TNS entry name in the Oracle Home of the destination database. averify.dest.oracle.home The Oracle Home of the destination database. This value can be a mapped drive on the system where Averify is run on the host machine. Note: Use either double back slashes
29、or a forward slash for directory separation, for example, d:/oracle/ora92. NLS Language Details Parameter Value Definition averify.nls.lang Specifies the NLS parameter value used by the database. The default value is AMERICAN_AMERICA.UTF8. Averify Details (For 9.x Databases Only) Parameter Value Def
30、inition averify.runOption Specifies how you want Averify to check the database. The values are all, modules, resetflags, tables, and testcases. Note: Only one option can be specified for this v1.6.3 3 Parameter Value Definition parameter. averify.modules Specific modules chosen for averify to check.
31、 This parameter is only used if you entered modules as the value of the runOption parameter. Note: You can check tables that are not specific to the Agile database with the checkNonAgileTables module. averify.testcases Specific testcases chosen for Averify to check. This parameter is only used if yo
32、u entered testcases as the value of the runOption parameter. averify.tables Specific database tables chosen for Averify to check. This parameter is only used if you entered tables as the value of the runOption parameter. An example of how the averify details work is as follows: averify.runOptions=mo
33、dules averify.modules=PPM, PCPQM, XXXX averify.testcases=AGIL-0000XXXXXX Because the specified runOptions parameter is modules, the testcases parameter is ignored when averify is run. Email Options Parameter Value Definition averify.email Decides if the averify.zip file, containing the averify.log a
34、nd oracle_averify_report.log, is sent as an email attachment upon completion. Value options are true or false. If set to false, the log files can still be viewed in the logs directory. averify.customer Name of Agile customer. averify.mailhost Name of email server. averify.mailport Port number of you
35、r email server. The standard default is 25. averify.toAddress averify.fromAddress Email address of the sender. averify.ccAddress Email address of an additional recipient. 4 Agile Product Lifecycle Management This section should be configured each time Averify is run. The logs are used by Agile PLM
36、Development only and are not a replacement for logging a request. Running Averify Go to the bin directory and run the averify.bat script on Windows or averify.sh script on UNIX. If you are running Averify as a Cron job, add the following line to the averify.sh file after the # Set up the environment
37、 comment line: cd /export/home/oracle/averify/bin Checking the Status of Averify You can monitor the status through the log file that is generated while Averify is run. The logs directory contains the averify.log file. If you chose to have the log files sent as an email attachment, the averify.zip file, containing the averify.log and oracle_averify_report.log, is sent upon completion.