Primavera P6 Cannot Connect to Database | Problem Solved
Primavera P6 Cannot Connect to Database Problem Solving. This article is about Primavera P6 Cannot Connect to Database Problem Solving. In this article we are trying to provide you good information about Primavera P6 Cannot Connect to Database Problem Solving. We have arranged the information in this post to make you understand it easily. We hope that you can understand it well. Please check the information below.
Primavera P6 Cannot Connect to Database Problem Solving
PRIMAVERA P6 is a software that works based on database. When you want to set the database, you might find database configuration problems when you want to login to Primavera P6 Software. There will be a window popup say: ‘Unable to connect to the database. Would you like to configure the database connection now?’
This kind of error is because of the database configuration problem. This happens when Primavera P6 is unable to recognize Username or Password of the person connecting to the database. If you find this database configuration problem, you can solve it by following these steps:
Reach your Windows Start button and select All Programs | Oracle Database 10g Express Edition | Start Database.
After that, Command (CMD) window will tell you that the “OracleServiceXE service was started successfully”, you now are able to go ahead and login to Primavera P6 in the usual way.
If after the step 2 you cannot solve the problem, you have to restart your computer/laptop and let the Oracle XE database service to load for few minutes. This problem that the P6 configuration file has lost the connection information, actually happens not quite often, so no need to click “Yes” to the “configure the database connection now?” prompt. This is super important. You should take care of this.
After your computer is on and running, I am quite sure that you can connect to your P6 Professional database.
What if accidentally you click “Yes”?
If you accidentally clicked on the Yes button to reconfigure your connection, the result will be bad. Because you will not be able to connect to your database. Basically when you did this, you destroy your original database setting.
To solve the problem above, you can work on these following setting:
Database alias: up to you
Driver Type: Oracle
Oracle Connection String: XE
In the Enter Public Login Information dialog:Sponsored Links :
User Name: pubprm$pm
Password: [your previous password]
As an alternative to solve this “Primavera P6 Cannot Connect to Database“, you can also use these following steps:
Find the Primavera P6 login screen then click on the button with three dots near the database name.
Click on the Configure button in ‘Edit Database Connections’ screen.
You have to ensure that you get the settings in ‘Select or Create Alias’ screen as below, then click on ‘Next’.
In ‘Oracle Connection String’ box which is shown in ‘Configure ORACLE Connection’ screen, you have to write it wth “XE“. Then you can click on ‘Next’.
In username box, you can fill it with “pubprm$pm“. If “pubprm$pm” is not working, try to use “admprm$pm“. For the password box, you can fill it with the password you used when you did the database installation. What if you forget? Try with “admin“, this is the basic password for this software.
So that is all about Primavera P6 Cannot Connect to Database Problem Solving. We think that it is good information about Primavera P6 Cannot Connect to Database Problem Solving. We hope that this information is useful for you. Please share if you think that this information can be useful for others. If you need more article related, you can simply subscribe this blog. Thanks for visiting and have a nice browsing.