I mentioned in the post above that I opened my listener.ora file in notepad and changed "olddomain.com" to "newdomain.com". I found this file in "c:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN". I also had to open tnsnames.ora, which is located in the same location, in notepad and change the "olddomain.com" to "newdomain.com".
If your company ever happens to switch to a new domain, and you are running a stand alone installation, you will need to edit the listener.ora and tnsnames.ora files to include your new domain, otherwise P6 won't be able to find the database. You can see your domain name by right clicking Computer and selecting properties.
The files look like this when you open them in notepad,
I mentioned in the post above
I mentioned in the post above that I opened my listener.ora file in notepad and changed "olddomain.com" to "newdomain.com". I found this file in "c:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN". I also had to open tnsnames.ora, which is located in the same location, in notepad and change the "olddomain.com" to "newdomain.com".
If your company ever happens to switch to a new domain, and you are running a stand alone installation, you will need to edit the listener.ora and tnsnames.ora files to include your new domain, otherwise P6 won't be able to find the database. You can see your domain name by right clicking Computer and selecting properties.
The files look like this when you open them in notepad,
tnsnames.ora
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = COMPUTERNAME.domain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = COMPUTERNAME.domain.com)(PORT = 1521))
double postDELETE
double post
DELETE
triple postDELETE
triple post
DELETE