Primavera P6 - Resolving cannot connect to database issue after chnage host name

The situation

Primavera P6 cannot connect to the local server after computer name change.

The solution

In win 7 environment & Primavera P6 version 8.2

Change the original host name to new host name of listener & tnsnames file.

in link: 

C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN