Configuring the database

Congiguring the Database in P6 means it will not change anything inside the Database.

It is the configuration to connect the P6 into the DB, just to input the Database alias, Driver Type, Host Name, Database Name, Username and Password.

try this

select yes

if you are using the oracle database

the driver type is Oracle

The connection String is XE

for the user name type pubprm$pm

for the password they the password of you know it of not try admin1

After entering the confurration tool and entering the username and password it come back with Database log on failed. Bad public  username or password. Cannot find OCI DLL:oci dll;

Hi Kathiravan,

Your best best would be to consult those who originally installed Primavera P6 on your computer. This is because quite a few credentials (database, pubuser and privuser, and P6 login) are created during the installation process.

We would like to help you, but for us to guess these credentials for you would be beyond difficult.

SOLUTION I: Start the listener:

1. Click Start >> Run
2. Type 'services.msc' and click 'OK'
3. Locate the following two services and right click on them to start them:
   1. OracleXETNSListener
   2. OracleServiceXE

SOLUTION II: Change XE to Use IP Address

Use IP address in tnsnames.ora and listener.ora instead of hostname.

SOLUTION III: Change XE to use localhost

Change the hostname references in the listener.ora and tnsnames.ora to 'localhost' and restart the Oracle services. If that does not resolve cause number three, comment out the 'sqlnet.authentication=(NTS)' line in the sqlnet.ora file.

SOLUTION IV:  Provide read&write grants to the folder OracleXE

Make a right click to the folder OracleXE by default located in the C drive, select properties->security tab.

Click on edit.

Select the username or group you require to add the new permissions and select read & write grants and click ok to save the changes.

Solution 5: Create a rule allowing traffic through on the port to the listener.