This post is more than 5 years old
2 Intern
•
63 Posts
0
1228
July 27th, 2010 01:00
DPA: migrate oracle DB from one server to another
Hi all,
We have DPA running on a solaris machine, and the database for DPA is running on a oracle server.
Now, last night the DBA's moved the DPA database from one oracle server to another, without informing us.
So this morning, I noticed that DPA wasn't working anymore.
I'm trying to adapt DPA so it will connect to the new oracle server, but it won't work.
I modified the DBSERVER_DBSERVER value in the /etc/dpa.config
and started DPA. But in the /var/log/dpa/controller.log I still see that he is trying to connect to the old oracle server.
What should I modify in order to have it working again?
Kind regards
No Events found!
Bahaa1
56 Posts
0
July 27th, 2010 01:00
If the databases have already been moved then edit the controller.xml located in
C:\program files\EMC\DPA
or
/opt/dpa/etc
you will only be able to update the settings for for the config database in the controller.xml once the change has been made the controller and gui will start and then you can change the database information for the datamine database in system settings database section.
TimTh
2 Intern
•
63 Posts
0
July 27th, 2010 01:00
You are correct, the datamine server was still set to the old server in the GUI --> System Settings --> Database.
Thanks
TimTh
2 Intern
•
63 Posts
0
July 27th, 2010 01:00
Ow, I found it myself.
I'll put it here, if someone else might need it.
I did a grep of the old server in all the files in the /etc directory, and found that it also had a reference in the controller.xml file.
So I just changed the tag in the part of the controller.xml file to the new server, and started DPA.
Worked like a charm.
TimTh
2 Intern
•
63 Posts
0
July 27th, 2010 03:00
Hmmm, it seems there still is a problem with the reporter.
In the /var/log/dpa/reporter.log, I still see that he tries to connect to the old server.
And there's nothing in the GUI --> system settings --> Reporter.
Any idea?
Karleke
11 Posts
0
August 30th, 2011 08:00
Tim,
seems that you also have to remove the old host from "DPA Server" -> Database in the DPA-view. That made it work for me
As a work-around I had put the old-name in the hosts-file, pointing to the IP of the new one, but that was only a temp work-around.
Regards,
Karl.