Notifications
Clear all
Topic starter
I'm looking for advice from someone with experience refreshing their test DB. We run CEMR 9.8.10 and haven't updated our test DB to match production in over 18 months. Our current system engineers were not employed here the last time it occurred and there's little documentation describing the process. They are concerned that they will miss some critical steps when re-pointing the EMR and ancillary applications.
We have been postponing this project due to the lack of confidence, but need to complete to test the immunization wizard tool ASAP.
Any help would be appreciated.
Posted : December 7, 2015 7:33 am
Hi,
Are you speaking of the EMR Network Training database? Are you on CPS or the Oracle version of EMR?
The GE Website has all the information you need. Perhaps they just need to request a login to access the documentation.
https://engage.gehealthcare.com/community/en/emr/documentation#emr98
Posted : December 7, 2015 7:58 am
Topic starter
Thanks for the response. We are on CEMR, therefore an Oracle DB. And no, this is not the network training application, but a fully functional replica of our production environment used for testing.
GE doesn't have any (let alone reliable) documentation on the subject. Their engineers were at a loss when we presented the subject to them months ago.
Posted : December 7, 2015 8:09 am
Can you please email me so i can ask more questions. The process may be much less complicated than you think.
Posted : December 7, 2015 8:34 am
I started a post on this to help document all of the steps (on oracle C EMR). it wasn't too long ago, you should look and find it. it is pretty straight forward if all of your data directories are the same.
Posted : December 8, 2015 4:59 am
https://centricityusers.com/forum/creating-a-test-server-from-production/
Here is the previous post I mentioned. Our test and production instance are named the same as well as the data directories.
I pretty quickly build a new server from scratch if everything matches.
Might want to check any DTS export takes or when you bring the test server up just disable all DTS machines until you figure out what can/want to test.
Posted : December 8, 2015 5:05 am
Here is a link to a document one of my old workmates put together when we were moving EMR 2005 Oracle databases from old hardware to new hardware. He was the brains behind it so I am not sure I would be able to elaborate much on it.
Posted : December 9, 2015 7:36 am
The import/export method used to be the way to go. It still might work, but over time the database has gotten more complex, and I have become less of an oracle export, so I am afraid a stored procedure will become invalid or something and I will not be aware of it ,so for now I would recommend the backup and restore.
I'd love to use the import export again so I can re-org my tables, but not sure I need to with Oracle these days.
Posted : December 9, 2015 8:22 am
Funny, I just did this in CPS this morning.
Steve
Posted : December 10, 2015 10:11 am
Question was regarding cemr and that is not advice
Posted : December 10, 2015 4:39 pm
I hadn't seen such strict rules listed on this forum. The forum does include CPS, and often when searching problems I look at similar topics. What needs to be done in CPS has changed with the new jboss in 12.0.10 and I can help with that.
Sorry to have offended the List Moms,
Steve
Posted : December 11, 2015 3:09 am
I do this with CPS all the time. Used to do it with Oracle EMR but that was a few years ago so I don't remember all the steps.
Posted : December 11, 2015 1:19 pm
well thanks for that
Posted : December 12, 2015 4:52 am
Pete, Sorry I didm't mean to sound like a jerk. I'll tell you what I do remember.
You'll need a second database server setup identically to the first. I used to build one following the new server setup documentation from GE and this is the part where the same matters same drives so if the DB is on the D drive now you'll need to choose D drive on the new setup documentation and also match the database name as well.
Then stop the Oracle Services. Make a backup copy of the install database files and copy the live files either from the live DB server after Oracle is stopped there or from your backup. Then start Oracle. Most likely it will error out and not start or start and hang. Look at the Oracle logs and you'll most likely see an error about a password file. That password file can either be recreated (reference google for that) or copied over from the live DB server. Now stop and restart Oracle hopefully it will start without an issue this time. Check the logs to be sure.
Now Oracle is running.You'll need to repoint your test clients do it and setup JBOSS but you should be good to go.
Most (Won't say all) ancillary applications pull data from the EMR i.e. the EMR database server doesn't go out and push to the ancillary application. So youIf there is any concern here you can always run your test environment in a segregated network or on a different VLAN.
My parting advice is that it can be done its just very finicky so don't get discouraged. The first time I tried it about 10 years ago I rebuilt the server 2 or 3 times before I had it working the way I liked. Also being able to do this is important if for nothing else than testing your database backups.
p.s. If anyone needs help doing this with CPS let me know.
Posted : December 12, 2015 7:44 am
The one real positive to Import and Export is that it used to massively speed up Oracle. I remember almost doubling the speed of our EMR by doing this after we had been live for about 8 years and the database was well over 150GB. Pete is right though its a little dangerous if you don't know what your doing and I wouldn't even attempt it if I haven't tested with a group of test servers before hand to make sure I had the process down.
Posted : December 12, 2015 7:49 am
