BlogRead the Latest Articles

How to Re-Configure A Primavera P6 Project Management Standalone Installation after A Machine Name Change

If Primavera P6 is running on OracleXE database server, changing the Windows machine name would cause losing the database connection.
1.  Update TNSNames.ora to include the new machine name. 
The default location of this file is \oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN
For Example:

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = NewMachineName)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
2.  Update the Listener.ora to include the new machine name. 
The default location of this file is \oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN
For Example:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = NewMachineName)(PORT = 1521))
)
)
3.  Reboot the machine.

There should be no need to reconfigure the Primavera P6 Project Management alias connecting to the database when using Oracle XE.

Share This

PRMTransfer

A utility to import/export P6 data

Import P6 data including WBS, activity codes, resources, unit prices etc. from Excel spreadsheets easily with our utility: PRMTransfer.

A replacement for the old Primavera SDK based import

As Primavera SDK is not supported with recent Primavera P6 releases this utility may replace SDK based Excel sheets we used to utilize. PRMTransfer facilitates Primavera API for bi-directional data exchange.


Click here to download it!

 

Giriş yapmak için size sağlanan kullanıcı adını ve şifrenizi giriniz