Skip to content
ProjectControls.com
Oracle Primavera - PM6

P6 database connection

In the Open Standard
Hamish KingMember for 22 years 7 months
Created
4
3
0
Hello,
I am new to P6 and am having trouble configuring the database. It was working fine until my cuputer crashed and when I open P6 it now asks for me to configure the database.
When I go through that process, using my log in - I get the following message:

Bad private user name or password. Check the public group ID. Database Server Error: ORA-00942: table or view does not exist

I get the same error if I use the admin log in too. I have tried backing up and restoring the datatbase but to no avail.

Any help would be much appreciated as I am losing days of work here!!

Thanks!

H
Save Follow Follow forum Report
Reply New topic

4 replies

Oldest first
  1. 0
    Arnold Puy ·
    #1
    Hi Hamish,

    Welcome to Planning Planet.

    If this a stand-alone installation try to configure your database using the following:

    Host Name: COMPUTER_NAME\PRIMAVERA
    Database name: PMDB$PRIMAVERA
    Username: pubuser
    Password: pubuser
    Public group ID: 1

    Otherwise, there is something wrong with your MSSQL. You need to install again.

    Regards,

    Arnold


    Report
  2. 0
    Hamish King ·
    #2
    Wow - thanks for the immediate response.

    I am given 3 database options:
    ORAPMDB
    ORAMMDB
    Project Management_1

    Using the pubuser log in gives me a different error message during configuration - "Bad public user name or password. Database Server Error: ORA-01017: invalid username/password; logon denied;"?

    Any more thoughts?

    Ta!
    Report
  3. 0
    Arnold Puy ·
    #3
    Hi Hamish,

    If I am not mistaken you installed the Oracle XE (Oracle Express Edition). Well, the passwords for these users will be the password you provide during installation.

    You must remember this password because it will be used as the password for all default database users created during installation.

    Regards,

    Arnold

    Report
  4. 0
    Hamish King ·
    #4
    Thanks again Arnold.

    I think you are right (it was installed in a rush...)

    I have the password set at installation as I can use it to get into the database administrator. My guess is something went wrong with the database when my computer crashed. I left it with the IT chap this afternoon to see what he can do but it appears I know more about the software then he, so it does not bode well.

    Might have to do a total reinstall :-(
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?