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
2. Update the Listener.ora to include the new machine name.For Example:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = NewMachineName)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
The default location of this file is \oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN
3. Reboot the machine.For Example:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = NewMachineName)(PORT = 1521))
)
)
There should be no need to reconfigure the Primavera P6 Project Management alias connecting to the database when using Oracle XE.