Database Server Error: ORA-12170: TNS: Connect timeout occurred

Written on . By CPM Solutions

You just finished Primavera P6 Version 7 installation using standalone mode, and you are brought to configure database connection wizard, and you followed the screen and accepted the default settings, and in the final screen, you got the error below:

Bad public user name or password. Database Server Error: ORA-12170: TNS:Connect timeout occurred

To troubleshoot this issue, you need to do the followings:

1. Open a Comand Prompt (Dos Command Window), and type the following command:

sqlplus privuser/privuser@XE

If you see the prompt with “SQL>”, then the problem is Oracle database server.  You need to check the files in C:\oraclexe\oradata\XE. If you see about six files there, then Oracle is installed properly. Otherwise, you have to reinstall Oracle database server. If Oracle already installed, you need to make sure it is started by go to Windows Start>All Programs > Oracle Database 10g Express Edition >Start Database.

After Oracle is started, you should be able to connect to the database. If not, go ahead to the next step.

2. If the step 1 above not resoves your problem, then go to the control panel. Check your Window Firewall settings, and make sure the port 1521 is open for Oracle traffic. If this step doesn’t fix your problem, go to next step.

3. Make sure Oracle Client or Oracle Instantclient 10.2 or later already installed, in particular, if your operating system is 64 bit.