<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.xmsonormal, li.xmsonormal, div.xmsonormal
{mso-style-name:x_msonormal;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Ok. What do we need to test?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> David Sheppard <sheppard@jlab.org>
<br>
<b>Sent:</b> Thursday, May 14, 2020 10:07 AM<br>
<b>To:</b> Valerie Bookwalter <bookwalt@jlab.org><br>
<b>Cc:</b> Bobby Lawrence <robertl@jlab.org>; pansophy <pansophy@jlab.org>; E. Anne McEwen <mcewen@jlab.org>; Tony Reilly <areilly@jlab.org><br>
<b>Subject:</b> Re: Database Stuff<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="color:black">Those databases were 18c databases. Do you really want to test them? I had removed them because there wasn't any data in them.<o:p></o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><i><span style="color:black"><o:p> </o:p></span></i></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="3" width="98%" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Sent:</b> Thursday, May 14, 2020 10:01 AM<br>
<b>To:</b> David Sheppard <<a href="mailto:sheppard@jlab.org">sheppard@jlab.org</a>><br>
<b>Cc:</b> Bobby Lawrence <<a href="mailto:robertl@jlab.org">robertl@jlab.org</a>>; pansophy <<a href="mailto:pansophy@jlab.org">pansophy@jlab.org</a>>; E. Anne McEwen <<a href="mailto:mcewen@jlab.org">mcewen@jlab.org</a>>; Tony Reilly <<a href="mailto:areilly@jlab.org">areilly@jlab.org</a>><br>
<b>Subject:</b> RE: Database Stuff</span> <o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">David,</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">I cannot attach the databases below to our pansophydev server in the ColdFusion administrator.</span><o:p></o:p></p>
<p class="xmsonormal"><span style="color:black;background:yellow">acctst, factst, samtst, and travtst</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">What am I missing? I wanted to test them before we release our production server.</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Also, Mike asked a question about converting our current materialized views inti just views. Is this possible?</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Then we can downgrade to normal Oracle server.</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Will you be rebooting our database servers on the 19<sup>th</sup>? Will the coldfusion servers also be rebooted?</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Thanks.</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Valerie</span><o:p></o:p></p>
<div style="border:none;border-bottom:double windowtext 2.25pt;padding:0in 0in 1.0pt 0in">
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
</div>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D;background:yellow">SQL from materialized_view for MV_C50_DECOMM</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> CREATE MATERIALIZED VIEW "ADAPPS"."MV_C50_DECOMM" ("DATE_STAMP")</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> NOCOMPRESS LOGGING</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> TABLESPACE "USERS"
</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> BUILD IMMEDIATE</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> USING INDEX
</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> REFRESH FORCE ON DEMAND START WITH sysdate+0 NEXT sysdate + 1</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> USING DEFAULT LOCAL ROLLBACK SEGMENT</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> USING ENFORCED CONSTRAINTS ENABLE QUERY REWRITE</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> AS SELECT TO_DATE(TIME_STAMP,'DD-FMMonth-FMYYYY') AS DATE_STAMP</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">FROM adapps.c50_decomm</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">GROUP BY TO_DATE(TIME_STAMP,'DD-FMMonth-FMYYYY')</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">;</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> CREATE UNIQUE INDEX "ADAPPS"."I_SNAP$_MV_C50_DECOMM" ON "ADAPPS"."MV_C50_DECOMM" (SYS_OP_MAP_NONNULL("DATE_STAMP"))
</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> STORAGE(INITIAL 65536 NEXT 8192 MINEXTENTS 1 MAXEXTENTS 2147483645</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> TABLESPACE "USERS" ;</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> COMMENT ON MATERIALIZED VIEW "ADAPPS"."MV_C50_DECOMM" IS 'snapshot table for snapshot ADAPPS.MV_C50_DECOMM';</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="xmsonormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> David Sheppard <<a href="mailto:sheppard@jlab.org">sheppard@jlab.org</a>>
<br>
<b>Sent:</b> Friday, April 24, 2020 3:56 PM<br>
<b>To:</b> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Cc:</b> pansophy <<a href="mailto:pansophy@jlab.org">pansophy@jlab.org</a>>; E. Anne McEwen <<a href="mailto:mcewen@jlab.org">mcewen@jlab.org</a>>; Tony Reilly <<a href="mailto:areilly@jlab.org">areilly@jlab.org</a>><br>
<b>Subject:</b> Re: Database Stuff</span><o:p></o:p></p>
</div>
</div>
<p class="xmsonormal"> <o:p></o:p></p>
<div>
<p class="xmsonormal"><span style="color:black">Good Afternoon,</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black">I have set up a test database environment. The databases
<span style="background:yellow">are acctst, factst, samtst, and travtst</span>.</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black">They have the same naming and password conventions that the production databases have. We</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black">can discuss how to set them up whenever you like. I can even have them refresh data from the</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black">production databases nightly if you would like. In that case, this could be how testing is done</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black">going forward. Just a thought. Anyway, have a great weekend, and we can discuss more as we</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black">move forward.</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black">David Shepard</span><o:p></o:p></p>
</div>
<div>
<div>
<p class="xmsonormal"><i><span style="color:black"> </span></i><o:p></o:p></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="3" width="98%" align="center">
</div>
<div id="x_divRplyFwdMsg">
<p class="xmsonormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"> David Sheppard <<a href="mailto:sheppard@jlab.org">sheppard@jlab.org</a>><br>
<b>Sent:</b> Tuesday, April 21, 2020 10:48 AM<br>
<b>To:</b> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Cc:</b> pansophy <<a href="mailto:pansophy@jlab.org">pansophy@jlab.org</a>>; E. Anne McEwen <<a href="mailto:mcewen@jlab.org">mcewen@jlab.org</a>>; Tony Reilly <<a href="mailto:areilly@jlab.org">areilly@jlab.org</a>><br>
<b>Subject:</b> Re: Database Stuff</span> <o:p></o:p></p>
<div>
<p class="xmsonormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="xmsonormal"><span style="color:black">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.</span><o:p></o:p></p>
</div>
<div>
<div>
<p class="xmsonormal"><i><span style="color:black"> </span></i><o:p></o:p></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="3" width="98%" align="center">
</div>
<div id="x_x_divRplyFwdMsg">
<p class="xmsonormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Sent:</b> Tuesday, April 21, 2020 10:31 AM<br>
<b>To:</b> David Sheppard <<a href="mailto:sheppard@jlab.org">sheppard@jlab.org</a>><br>
<b>Cc:</b> pansophy <<a href="mailto:pansophy@jlab.org">pansophy@jlab.org</a>>; E. Anne McEwen <<a href="mailto:mcewen@jlab.org">mcewen@jlab.org</a>>; Tony Reilly <<a href="mailto:areilly@jlab.org">areilly@jlab.org</a>><br>
<b>Subject:</b> Re: Database Stuff</span> <o:p></o:p></p>
<div>
<p class="xmsonormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="xmsonormal"><span style="font-family:"Calibri",sans-serif;color:black">David,</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="font-size:16.0pt;font-family:"Calibri",sans-serif;color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="font-family:"Calibri",sans-serif;color:black">Yes, please reboot our db server tonight. And yes let's setup a monthly reboot to keep things running smoothly.</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="font-size:16.0pt;font-family:"Calibri",sans-serif;color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="font-family:"Calibri",sans-serif;color:black">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.</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="font-size:16.0pt;font-family:"Calibri",sans-serif;color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="font-family:"Calibri",sans-serif;color:black">Additionally, did our new db server get funded and approved? What is the ETA?</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="font-size:16.0pt;font-family:"Calibri",sans-serif;color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="font-family:"Calibri",sans-serif;color:black">What other information do you need from us?</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="font-family:"Calibri",sans-serif;color:black">Thanks for your support!!</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="font-size:16.0pt;font-family:"Calibri",sans-serif;color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="font-family:"Calibri",sans-serif;color:black">Valerie</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="font-family:"Calibri",sans-serif;color:black">Pansophy Team</span><o:p></o:p></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="3" width="98%" align="center">
</div>
<div id="x_x_x_divRplyFwdMsg">
<p class="xmsonormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"> David Sheppard <<a href="mailto:sheppard@jlab.org">sheppard@jlab.org</a>><br>
<b>Sent:</b> Tuesday, April 21, 2020 10:20 AM<br>
<b>To:</b> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Subject:</b> Database Stuff</span> <o:p></o:p></p>
<div>
<p class="xmsonormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="xmsonormal"><span style="color:black">Good Morning Valerie,</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black">I was wondering if we can start doing monthly database server reboots</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black">during maintenance day. There doesn't appear to be anything wrong. It</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black">may make things run a little better and more efficient. Also, I have</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black">installed Oracle Database 18c on our development database servers.</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black">Since, you don't have development databases or development servers,</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black">I will not attempt to install it right now, but it should be something we</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black">should do in the not to distant future. I'm not as worried about it because</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black">18c is really just 12.2.0.2. You're already running Oracle Database 12.2.0.1.</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black">I just wanted to put a bug in your ear about it. And let me know about</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black">rebooting pansophydb tonight. Stay safe and have a great day.</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="color:black">David Sheppard</span><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>