I have a real problem trying to configure and connecto from Primavera P6 to the ORACLE DB 10G.
I can connnect to the ORACLE DB 10G using SYSTEM and SCOTT users account to the oracle using the PRIMAVERA ASSISTANT CONFIG WINDOWS.
I set up the Oracle connection string: orcle.company.com
and I type user scott/tiger AND PUBLIC GROUP ID: 1 by default
I´ve got this message error:
Bad private user name or password. Check the public group ID. Database Server Error: ORA-00942: table or view does not exist
I DON´T KNOW ANYTHING about PUBLIC GROUP ID table or parameter.
Please, try to explainiing me about this parameter which fails at connection DB.
Do I have to set up or create a new PUBLIC GROUP TABLE?
DO i HAVE TO set up a specific parameter for this PUBLIC GROUP TABLE?
How about the PUBLIC GROUP parameter?
this is my tnsnames.ora and the listener is running succesfully in the services screen.
When you created the schema with the automated tool the following 3 default accounts are created:
To configure the alias connection in the PM client you will provide the pubuser information. To administer private database logins you need to specify privuser a the default group id of 1. If you are still having trouble I would try logging into SQL plus with the above accounts.
*Note that if you did not take the defaults when creating the database you may need to substitute the above users.