Running the Validate Tool for a 6.2.1 or Later Oracle Database

Previous TopicNext TopicContents

Use the validate tool to ensure your database is not missing objects that could cause the database to fail to upgrade. You must perform the steps below before you download the 8.4 media pack. If you run the 8.4 validate tool against your current database, it will not work.

  1. Double-click validate.bat (validate.sh for Linux) in your current Database folder of the P6 EPPM physical media or download to start the validate tool.

    Note: Ensure you use the validate file from your current Database folder, not the 8.4 database folder.

  2. Provide the following:
    1. In the Username field, enter your administrative user name (for example, admuser).
    2. In the Database host address field, enter your database server name or TCP/IP address.
    3. In the Database host port field, enter the port number that Oracle is using. The default is 1521.
    4. In the Database name field, enter the Oracle Service Name. You can find it in the TNSNAMES.ORA file, which you created when you set up the Oracle client.
  3. View the HTML page that the tool creates to ensure your database is not missing objects.

Related Topics

Pre-Upgrade Procedures

Running the Validate Tool for a 6.2.1 or Later Microsoft SQL Server Database

Converting Methodologies to Projects

Installing Oracle Multimedia for an Oracle Database

Grant Privileges to the System User



Legal Notices
Copyright © 1999, 2015, Oracle and/or its affiliates. All rights reserved.

Last Published Wednesday, July 29, 2015

PDF Library