HI FRIENDS! :)
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.
(ADDRESS = (PROTOCOL = TCP)(HOST = BONAMPAK)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
THANKS FOR YOUR HELP
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.