Primavera P6 Database Connection Configuration Details

We appreciate your interest in helping out the P6 community.  I do have a correction for TheP6Pro; while the pubuser password is the password that you entered during the P6 Pro installation, it is NOT the same password as the default password used for admin when logging onto P6.  The default for that is ‘admin’.  One may change it to the one used in your example, but the two passwords are initially different.

Hi Ronald,

I'm not sure what version you are referring to or to what installation type. The blog is based upon the R8.2 standalone installation. When P6 standalone is installed, Oracle Express is installed as the underlying database. During the installation the following dialog clearly states that "the password selected here will be used as the password for the Oracle system user, all default database users, and the application admin superuser". Am I missing something here?

Emily,

What about the compatibility of "Activity6x.xls and Dictionary60.xls" from the installed version?

I mean that, is this excel files working well with this version, R8.2?

Regards,

Raymund

Emily,

 What you say is most interesting.  I am positive that the passwords are different with Version 6 & 7 installations (by that, I mean that the default admin P6 account is automatically given the ‘admin’ password and not the Oracle password.)  When I installed my P6 Professional Version 8.1 software on a new computer, the admin account also had the default admin password (while I had provided a different one for the Oracle database during installation.) 

 Perhaps this is a new ‘feature’ that I was unaware of until now.  I predict a fair amount of confusion as all of the trainers that I know of expect the password to be ‘admin’ unless changed.  Most P6 stand-alone users that I know of do not remember the installation password (they thought that they were trying to guess the correct password instead of actually setting it.)

 Cheers!

Hi Ronald,

Yes, you are correct! This was introduced as part of the enhancements for R8.2 to make installation easier. The blog doesn't really call this fact out so we could add it in for clarity.

Cheers,

Emily