My computer was recently migrated to a new domain after a company merger. Neither company has extensive P6 experience. Knowing this, I should have backed up my database before the migration, but being fairly green myself, I did not. Now, when I attempt to start P6, my database cannot be found. When I go to configure (Driver type, Oracle; Connection String, XE; Username, pubprm$pm; etc...) , I receive the error, "Bad public user name or password. ORA-12170: TNS:Connect timeout occurred;". When I go to "Oracle Database 10G Express Edition" I am unable to start my database (not found), and unable to "backup database", and unable to "go to database homepage".
After scouring the web, I typed "lsnrctl start" into CMD. I found that the listener was looking at the old domain "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=COMPUTERNAME.olddomain.com)(PORT=1521)))"
On a whim, I searched my C: drive, where P6 is installed, for the listener.ora file and opened it in notepad and changed "olddomain.com" to "newdomain.com", and ran command "lsnrctl start". I receive the same error messages, but now the Host is (COMPUTERNAME.newdomain.com)(PORT=1521). Oddly enough, after changing the domain, but not the port, I am able to "go to database homepage" and log in with pubprm$pm and my old password, but none of the other database funcitons (start or backup) will execute. All return errors. Am I able to backup my database from the database homepage? I will be receiving a new computer tomorrow and will install a fresh stand alone copy of P6 onto that computer. I do need to backup the database on my old computer to save the existing project schedules. If anyone could advise me on what to do next, I would greatly appreciate it!
-Steve
(>'.')>
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 post
DELETE
triple post
DELETE