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 attempt to upgrade to Version 20 and you run the Version 20 validate tool against a 15 R2 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.
- Provide the following:
- In the Username field, enter your administrative user name (for example, admuser).
- In the Database host address field, enter your database server name or TCP/IP address.
- In the Database host port field, enter the port number that Oracle is using. The default is 1521.
- 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.