Changing out XE Enterprise and Deployment servers

Hello List,
This information may be useful if you want to rename your XE enterprise and/or your deployment server. In my case I wanted to create a test replica of my production system. I didn’t rename the Oracle instance.
As a main resource I used document OTI-99-0057, however I found it incomplete. I still had problems. So I reworked the SQL script, which is the most important part in the replication.
Here it is:
update sys7333.f9631 set pdjobn='DEP2' where pdjobn='DEP1';
update SYS7333.f9650 set MMMKEY='ent2' where MMMKEY='ent1';
update SYS7333.f9650 set MMMKEY='DEP2' where MMMKEY='DEP1';
update SYS7333.f9650 set MMDATP='ENT2 - B7333 Server Map' where MMDATP='ENT1 - B7333 Server Map';
update SYS7333.f9650 set MMDATP='ent2 - B7333 Server Map' where MMDATP='ent1 - B7333 Server Map';
update sys7333.f9650 set mmlgname ='ENT2' where mmlgname ='ENT1';
update sys7333.f9650 set mmdepsrvnm ='DEP2' where mmdepsrvnm ='DEP1';
update sys7333.f9651 set mdmkey ='DEP2' where mdmkey ='DEP1';
update sys7333.f9651 set mdmkey ='ent2' where mdmkey ='ent1';

update sys7333.f98210 set lhmkey ='DEP2' where lhmkey ='DEP1';
update sys7333.f98211 set ldmkey ='DEP2' where ldmkey ='DEP1';
update sys7333.f98220 set pmmkey ='DEP2' where pmmkey ='DEP1';
update sys7333.f98221 set pumkey ='DEP2' where pumkey ='DEP1';
update sys7333.f98222 set poomwmkey ='DEP2' where poomwmkey ='DEP1';
update sys7333.f98222 set poomwmkey ='DEP2' where poomwmkey ='DEP1';
update sys7333.f98222 set pomkey ='DEP2' where pomkey ='DEP1';
update SYS7333.f986101 set OMDATP='ENT2' where OMDATP='ENT1';
update SYS7333.f986101 set OMJOBN='DEP2' where OMJOBN='DEP1';
update SYS7333.f98611 set omsrvr='ent2' where omsrvr='ent1';
update SYS7333.f98611 set OMDATP='ENT2' where OMDATP='ENT1';
update SYS7333.f98611 set OMDATP='ENT2 - B7333 Server Map' where OMDATP='ENT1 - B7333 Server Map';
update SYS7333.f98611 set OMDATP='ent2 - B7333 Server Map' where OMDATP='ent1 - B7333 Server Map';
update SYS7333.f98611 set OMDATP='ENT2 - Logic' where OMDATP='ENT1 - Logic';
update sys7333.f986115 set tddatp ='ENT2' where tddatp='ENT1';
update sys7333.f986115 set tddatp ='ENT2 - Logic' where tddatp='ENT1 - Logic';
update sys7333.f986115 set tddatp ='ent2 - B7333 Server Map' where tddatp='ent1 - B7333 Server Map';

update SVM7333.f986101 set OMDATP='ENT2' where OMDATP='ENT1';
update Svm7333.f98611 set OMDATP='ent2 - B7333 Server Map' where OMDATP='ent1 - B7333 Server Map';
update SVM7333.f98611 set OMSRVR='ent2' where OMSRVR='ent1';
update SVM7333.f98611 set OMDATP='ENT2' where OMDATP='ENT1';
update SVM7333.F986110 set JCEXEHOST='ent2' where JCEXEHOST='ent1';

update OBJ7333.f9861 set simkey='DEP2' where simkey='DEP1';
update pd7333.F983051 set vrmkey='DEP2' where vrmkey='DEP1';

DEP1 and ENT1 are the original deployment and enterprise servers.
DEP2 and ENT2 are the replicated servers.

It’s a good idea to check your records later with commands like this one:
SELECT DISTINCT pdjobn FROM sys7333.f9631 WHERE upper(pdjobn) LIKE ‘%DEP%’ OR upper(pdjobn) like ‘%ENT%’;
You will verify that all records are correct.
And don’t forget to modify jdeplan.mdb, ini and inf files, etc.
Good luck! [smile]


Alex Shevchenko
XE SP18 Oracle 8.1.7, Solaris production
XE SP18 Oracle 8.1.7, Solaris test