"Project Management is what you are forced to do when you don’t Plan and Schedule!" - who said this? Read more...

Can not connect P6 database

8 replies [Last post]
K D
User offline. Last seen 6 years 1 week ago. Offline
Joined: 25 Sep 2007
Posts: 247
Hi all.
I install P6 database in Window server2003, using Oracle Express Edition 10g database.
I install Oracle client in my laptop (Win Vista) but I do not know how to connect to P6 database.
When create database configuration to connect to P6 database it produce eror:
Bad public user name or password. Database Server Error: ORA-12154: TNS:could not resolve the connect identifier specified;

Any help is appreciate.
Thanks & regard

Replies

K D
User offline. Last seen 6 years 1 week ago. Offline
Joined: 25 Sep 2007
Posts: 247
Hi all.
From Primavera POINT The reason is Oracle client I used to install is not capatible for Vista. I’m downloading a new version.
I will install it soon to check it out.

Thanks & regards
Ahmet Cetin
User offline. Last seen 1 year 1 week ago. Offline
Joined: 8 Feb 2005
Posts: 84
It is just one of the reason actually. The error you’ve got caused by connection. The reason can be:
- Wrong server name
- Wrong database name
- User name/password error (for pubuser and privuser)

When you install P6 in standalone mode you’re also installing MSSQLExpress, and all connection settings made automatically, so you won’t get any error. If you install the database using the scripts manually (which is the case if you want to change the collation) then you need to create privuser and pubuser manually and assign them to the database, and this might be the reason.

If you installed the database using setup, then it also creates the pubuser and privuser with their default passwords (pubuser and privuser, respectively), so when you are connecting using the client, there shouldn’t be a problem as long as you supply the server name and the database name correctly.

To be sure, check the database users in database servers, if pubuser and privuser are allowed to use the database.

Hope this helps,

Ahmet Cetin
Visit PrimaveraTools.com


Primavera Tools, Forum, Tutorials, Outlook Plugin, Articles
K D
User offline. Last seen 6 years 1 week ago. Offline
Joined: 25 Sep 2007
Posts: 247
Hi Ahmet.
I install Primavera client on server 2003 for testing standalone mode. It can connect successfully using pubuser account.
So do you think the reason is pubuser account?
Ahmet Cetin
User offline. Last seen 1 year 1 week ago. Offline
Joined: 8 Feb 2005
Posts: 84
Hello,

Try this:

Log into SQLPlus as admuser and run the following command:
alter user pubuser identified by newpassword

Then run Primavera client, on the login dialog, click on elipse button (...) in Database. Highlight the alias, and click on Configure. At the ’Select or Create Alias screen’, click on Next. At the ’Configure Server Connection’ screen, click on Next. When prompted to ’Enter Public Login Information’, overtype the old pubuser password with the new password and click on Next. Click on Next and Finish to complete the configuration and login to Project Management.

Hope this helps.

Cheers,

Ahmet Cetin
Visit PrimaveraTools.com

Primavera Tools, Forum, Tutorials, Outlook Plugin


K D
User offline. Last seen 6 years 1 week ago. Offline
Joined: 25 Sep 2007
Posts: 247
Thanks Dieter.
I’m also desperate on this error.
Need help from a hero. :-)
Hi
Allways when I had this error message, the problem was on IT-side - TNSNAMES, Pub- and Privuser not assigned to db, line, name of the server, ...
Sorry, no further idea.
Dieter
K D
User offline. Last seen 6 years 1 week ago. Offline
Joined: 25 Sep 2007
Posts: 247
Hi Dieter.
I just finish setting up the Net service configuration of Oracle. About Oracle respect ,it can connect successful to server.
But when configuring Primavera connection, it produce error:
Bad public user name or password. dbExpress Error: Unknown Error Code ’1804’;

I thought my Primavera client have some problem. I reinstall it, but error still happen.
Now stucking here.

Regards
Did you check the TNSNAMES?