Unable to connect to the database, would you like to configure the database connection now?
If you are getting the message Unable to connect to the database, would you like to configure the database connection now? while attempting to connect on a standalone installation of Primavera P6 Professional, then the following may be helpful.
When using a standalone copy of Primavera P6 Professional, the typical installation options loaded a copy of Oracle’s free Oracle Express (XE) database on your system. Periodically you may go to login to Primavera P6 and get this message. This happens because the Oracle XE database service has failed and thus Primavera P6 cannot connect to it. The cause of XE failures is varied, but the PC coming out of hibernation is one common item that we encountered.
Go to your Windows Start button and choose All Programs | Oracle Database 10g Express Edition | Start Database.
Once the little Command window reports that the “OracleServiceXE service was started successfully”, you can go ahead and login to Primavera P6 in the usual way.
If that didn’t work for you, simply restart your entire machine and give the Oracle XE database service a few minutes to start up. It is rarely the case that the P6 configuration file has lost the connection information, so DO NOT click Yes to the “configure the database connection now?” prompt.
Once your machine is up and running you should be able to connect to your P6 Professional database.
If you did click on the Yes button to reconfigure your connection, in all likelihood you are now unable to connect because you whacked your original settings.
The following settings may help you restore your configuration:
- Database alias: whatever you want to call it
- Driver Type: Oracle
- Oracle Connection String: XE
- In the Enter Public Login Information dialog:
- User Name: pubprm$pm
- Password: whatever admin password you were using before to login to P6.
User Name and Password details:
Note: the above comment about the database public user name and password are true only for later versions of Primavera P6 such as R8.x or later. When you installed Primavera P6 Professional R8.x or later standalone, you were prompted to create this password during installation. This one password gets used for all the public, privileged and admin users in the system as well as the Primavera P6 Administrator’s default password.
For more Primavera P6 articles click here