[Pansophy] Database Stuff

[David Sheppard]

ok. Thank you. I will do my best to set up some sort of test environment for you. You only have test schemas, not test databases. I will try to create some test databases with version 18c. Then, we can navigate how you can test using them.

________________________________
From: Valerie Bookwalter <bookwalt at jlab.org>
Sent: Tuesday, April 21, 2020 10:31 AM
To: David Sheppard <sheppard at jlab.org>
Cc: pansophy <pansophy at jlab.org>; E. Anne McEwen <mcewen at jlab.org>; Tony Reilly <areilly at jlab.org>
Subject: Re: Database Stuff

David,

Yes, please reboot our db server tonight. And yes let's setup a monthly reboot to keep things running smoothly.

Also, Yes to upgrading our database server. Let us know how much time you need and possible dates. Will there be a need for us to test before going to production? We will also have to let users know before we do the switch.

Additionally, did our new db server get funded and approved? What is the ETA?

What other information do you need from us?
Thanks for your support!!

Valerie
Pansophy Team
________________________________
From: David Sheppard <sheppard at jlab.org>
Sent: Tuesday, April 21, 2020 10:20 AM
To: Valerie Bookwalter <bookwalt at jlab.org>
Subject: Database Stuff

Good Morning Valerie,

I was wondering if we can start doing monthly database server reboots
during maintenance day. There doesn't appear to be anything wrong. It
may make things run a little better and more efficient. Also, I have
installed Oracle Database 18c on our development database servers.
Since, you don't have development databases or development servers,
I will not attempt to install it right now, but it should be something we
should do in the not to distant future. I'm not as worried about it because
18c is really just 12.2.0.2. You're already running Oracle Database 12.2.0.1.
I just wanted to put a bug in your ear about it. And let me know about
rebooting pansophydb tonight. Stay safe and have a great day.

David Sheppard
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20200421/86418143/attachment.html>