PRIMAVERA P6 is a database based software and you may see database configuration problems when you try to login to Primavera P6. This problem states: ‘Unable to connect to the database. Would you like to configure the database connection now?’
This error is due to the database configuration issue which arises when Primavera P6 is unable to recognize Username or Password of the person connecting to the database. Be calm if you have this issue as it can be resolved easily.
STEP 1:
In the Primavera P6 login screen, click on the button with three dots against database name.
STEP 2:
Click on the Configure button in ‘Edit Database Connections’ screen.
STEP 3:
Make sure that you have following settings in ‘Select or Create Alias’ screen. Click on ‘Next’.
STEP 4:
Make sure that you have ‘XE’ written in ‘Oracle Connection String’ in ‘Configure ORACLE Connection’ screen. If not, you can simply type XE in in the box. After that, click on ‘Next’.
STEP 5:
Now type pubprm$pm in Username. Then type the password which you have selected during installation of the database. If you don’t remember it then try putting the password admin, if it works you are lucky otherwise you may have to reinstall the software.
STEP 6:
If above Username has not worked, then try putting admprm$pm with the password which you have selected during installation of the database. If you don’t remember it then try putting the password admin.
STEP 7:
If you are still having the same problem then you can contact us through our Contact Us page or simply by writing an email to info@cemsolutions.org. We’ll try our best to solve your issue.
- Essential Software Tools for Planning Engineers in the Construction Industry - May 22, 2023
- PMI Certifications for Planning Engineers - May 22, 2023
- 10 Basic Interview Questions for a Planning Engineer - May 22, 2023
- Work Break Down Structure & its Importance - September 5, 2018
- Corrosion of Steel in Concrete - March 14, 2017
i cannot connect database i followed up all above steps and it didn’t work what can i do ?
Thanks
i follow the steps, but still connection failed
follow the steps, but still connection failed
Follow the steps, but still connection failed. Please email me for another solution.. Thank you . eral_tolentino@yahoo.com
after all your exercise still i cant open can you advise me …
Bad public user name or password. Database Server Error: ORA-01017: invalid username/password; logon denied
; ( this is coming after done you excercise can you help me)
I am having primavera P6v7 Oracle 11g database and upgraded to 12 C std edition of Oracle and imported oracle dump to new version. I have installed primavera 18.8 and configured database which is configured on server. Database connectivity done and shown connected. But when try to login in primavera with admin / admin or admprm$pm says invalid username and password. what is the issue please let us know. user is available in oracle database.
I followed all the above steps and still my problem is not resolved. Please help me to reaolve this problem and give the solutiin if possible. Thanks
I tried.but,
Bad public user name or password. Unable to Load OCI.DILL;
i tried but same as the others problem… Unable to Load OCI.DILL… Please help
Hi, good day. I followed the steps but still I failed. Requesting from your goodself to help me in this matter. We’re fixing the problems for about three days. This is the message in the end “Bad public user name or password. ORA-01017: invalid username/password; logon denied
;”. Hoping for your help. Thank you so much and stay safe.
THANK YOU