A couple of weeks ago I couldn't open my 8.2 stand alone P6 on the laptop loaned to me by the consultancy that I am contracting through. Didn't get any help and got the problem fixed by taking the laptop to a local repairer who deleted quite a few viruses.
P6 now opens but is asking to configure the database. Before I do this I want to verify whether the data in P6 is safe if I configure the database or will configuring overwrite the data?
SOLUTION I: Start the listener:
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.
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.
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;
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
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.