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
(>'.')>