Running the Validate Tool for a Version 7 or Later Oracle Database

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 latest media pack. For example, if you are attempting to upgrade to Version 23 and you run the Version 23 validate tool against a version 20 database, then the validate tool will not work.

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: Schema validation of Oracle Autonomous Databases is not yet supported.
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.
View the HTML page that the tool creates to ensure your database is not missing objects.
- If upgrading from 7.0, go to the 'Client Application' media pack, then locate the \install\database\scripts\ folder to find the scripts you need to fix.
- If upgrading from 8.0 or later, go to the database folder of the P6 EPPM physical media or download, then locate the \database\scripts\install\ to find the scripts you need to fix.

Related Topics