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.

Webinar:Schedule Integration with Oracle Primavera Cloud

24th of November 2020

Project schedulers would appreciate the difficulty of integrating different contractor schedules and build a master program out of them.


Oracle Primavera Cloud may lend a helping hand and save many days of work. With cloud and collaborative features, enforcing standard data structures and advanced scheduling capabilities, it can streamline the schedule building and review process. 

Join us to see how!
This free webinar will be delivered in English.

Click here to register!

 

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