Installation / Admin

Database Server Error: ORA-12170: TNS:Connect timeout occurred ;

You just finished Primavera P6 Version 7 installation using standalone mode, and you are brought to configure database connection wizard, and you followed the screen and accepted the default settings, and in the final screen, you got the error below:

Bad public user name or password. Database Server Error: ORA-12170: TNS:Connect timeout occurred

To troubleshoot this issue, you need to do the followings:

1. Open a Comand Prompt (Dos Command Window), and type the following command:

       sqlplus privuser/privuser@XE

Bad public user name or password.

When you configure Project Management to connect to  database server. If you receive the errors below:

Oracle complained with Database Server Error: ORA-01017

My P6 tried to connect to Oracle database, but it gave the error below when I configured the database for P6:

“Bad private user name or password. Check the public group ID. Database Server Error: ORA-01017: invalid username/password; logon denied”

What will happen to my databases if I reinstall Primavera Project Management?

Your databases will not be affected if you re-install.

Whenever you re-install Primavera P5/P6, the installation will overwrite only the P5/P6 software and not the databases.  You data and projects will still be accessible from the newly installed software.

How can I tell what version of Primavera P5/P6 is installed?

Primavera P5 / P6 Project Management Client version and Database version information can be found by logging into the Primavera Project Management Client Application.
Follow these steps:

  1. Click on Help, About Primavera.

CPM Solutions Logo

CPM SOLUTIONS LTD • Collaborative Project Management

Primavera Courses in Vancouver • Calgary • Edmonton • 1-604-294-1577 
Primavera and ARES PRISMG2 • Sales and Inquiries • 1-604-294-1577 


Ares Prism G2Primavera P6eTimeMachine LogoPrimavera Specialized Oracle Gold Partner