PRIMAVERA P6 CANNOT CONNECT TO ORACLE DATABASE
PRIMAVERA P6 UNABLE TO CONNECT TO DATABASE SQL
Primavera P6 database configuration username and password should be kept safely. The SQL Server configuration for Primavera P6 database is important part of Primavera P6 installation. Sometimes, users find it really hard to do this. The Primavera P6 unable to connect to database SQL. It says more or less “Primavera P6 bad public username and password“. The software will notify us about Primavera P6 invalid login name or password. For this case, you should understand the Primavera pubuser default password from the beginning then you can solve the next problem.
There is one solution for that database error presented by tensix, check it out.
PRIMAVERA P6 DATABASE CONFIGURATION
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.
By the way, you can try username : “pubuser” and password : “pubuser” .