Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Can not connect P6 database

8 replies [Last post]
Thu, 2008-02-28 22:34
K D
User offline. Last seen 15 years 28 weeks ago. Offline
Joined: 25 Sep 2007
Posts: 247
Groups: None
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
Top

Replies

Thu, 2008-03-06 04:21
#1
K D
User offline. Last seen 15 years 28 weeks ago. Offline
Joined: 25 Sep 2007
Posts: 247
Groups: None
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
Top
Thu, 2008-03-06 03:49
#2
Ahmet Cetin
User offline. Last seen 9 years 1 week ago. Offline
Joined: 8 Feb 2005
Posts: 84
Groups: None
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
Top
Wed, 2008-03-05 21:52
#3
K D
User offline. Last seen 15 years 28 weeks ago. Offline
Joined: 25 Sep 2007
Posts: 247
Groups: None
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?
Top
Tue, 2008-03-04 16:20
#4
Ahmet Cetin
User offline. Last seen 9 years 1 week ago. Offline
Joined: 8 Feb 2005
Posts: 84
Groups: None
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


Top
Mon, 2008-03-03 06:26
#5
K D
User offline. Last seen 15 years 28 weeks ago. Offline
Joined: 25 Sep 2007
Posts: 247
Groups: None
Thanks Dieter.
I’m also desperate on this error.
Need help from a hero. :-)
Top
Mon, 2008-03-03 05:27
#6
Dieter Wambach
User offline. Last seen 7 years 4 days ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
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
Top
Sat, 2008-03-01 02:33
#7
K D
User offline. Last seen 15 years 28 weeks ago. Offline
Joined: 25 Sep 2007
Posts: 247
Groups: None
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
Top
Fri, 2008-02-29 10:23
#8
Dieter Wambach
User offline. Last seen 7 years 4 days ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Did you check the TNSNAMES?
Top