Below is my summary of P6 Oracle configuration in Windows:
1. Modify the path D: \ oraclexe \ app \ oracle \ product \ 10.2.0 \ Server \ Network \ ADMIN on the computer of each client as follows:
Host = even.oracle.com
Note: even.oracle.com is the host name of the Oracle server. The client PC needs to connect to the Oracle database of the server.
2. log on to the database homepage on the server. The database portal username defaults to system. The password is the password entered when the P6 client is installed. For example, qazwsx.
3. log on to the database, choose "manage"> "Database User"> "admprm $ PM", and click "open. After entering, the user name cannot be modified. You can set "password" and "Confirm Password" on your own ". The password can be simple, such as ABC123. The optional boxes below are all points except "password failure" (do not select "Lock "). After completing the preceding operations, select "Change User" to save the preceding settings.
4. Go back to database user management at the upper level, select admprm $ mm, repeat step 1, and set the password and permissions. Close your browser.
5. Start-Program-Oracle-Primavera P6-help and utilities-database configuration. Open the database Activation Program. Configure My database connection-project management database (orapmdb by default)-database alias and driver type default (orapmdb and Oracle respectively) -Enter the Oracle connection string Xe-enter admprm $ PM as the user name, and enter abc123. the password is displayed successfully.
6. Repeat Step 1 to activate the Methdology management database and use admprm $ mm and the corresponding password.
7. log on to the Oracle database of the client PC server, and open the project management, User Name Admin, and password admin. You can change the password.