Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Who has experience refreshing their CEMR Test DB?

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

15 Posts

6 Users

0 Reactions

81 Views

RSS

mjharunk

(@mjharunk)

Posts: 191

Reputable Member

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

tmarkovina

(@tmarkovina)

Posts: 20

Eminent Member

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

mjharunk

(@mjharunk)

Posts: 191

Reputable Member

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

tmarkovina

(@tmarkovina)

Posts: 20

Eminent Member

Can you please email me so i can ask more questions. The process may be much less complicated than you think.

[email protected]

Posted : December 7, 2015 8:34 am

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

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

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

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

[email protected]

(@btownsenduams-edu)

Posts: 4

Active Member

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.

http://pastebin.com/TfGjhd2j

Posted : December 9, 2015 7:36 am

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

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

swestfisher

(@swestfisher)

Posts: 132

Estimable Member

Funny, I just did this in CPS this morning.

Steve

Posted : December 10, 2015 10:11 am

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

Question was regarding cemr and that is not advice

Posted : December 10, 2015 4:39 pm

swestfisher

(@swestfisher)

Posts: 132

Estimable Member

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

Marketing Committee

(@marketing_committee)

Posts: 358

Reputable Member

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

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

well thanks for that

Posted : December 12, 2015 4:52 am

Marketing Committee

(@marketing_committee)

Posts: 358

Reputable Member

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

Marketing Committee

(@marketing_committee)

Posts: 358

Reputable Member

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

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed