<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)"><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;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
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;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma",sans-serif;
mso-fareast-language:EN-US;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma",sans-serif;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
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-CA link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Do NOT upgrade to Oracle 12C. <o:p></o:p></p><p class=MsoNormal>PH does not work with that version. It does not even talk to it.<o:p></o:p></p><p class=MsoNormal>We spent weeks trying to get it to work.<o:p></o:p></p><p class=MsoNormal>Until Unicom gets off their collective butts (excessive fee collection) and releases a new version of PH, stay on Oracle 11G.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='mso-fareast-language:EN-CA'>From:</span></b><span lang=EN-US style='mso-fareast-language:EN-CA'> powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com [mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com] <b>On Behalf Of </b>Peter Hofstaetter<br><b>Sent:</b> November 14, 2016 7:32 PM<br><b>To:</b> powerh-l@lists.sowder.com<br><b>Subject:</b> Oracle 12c<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=EN-AU>We are running PowerHouse 8.43.D1 on Solaris 10 using the 9.2 client and have upgraded to Oracle 11g and all seems to be OK for almost a year.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-AU>We are now looking at migrating to Oracle 12c but found that we need to upgrade client as 9.2 will not talk to 12c database which also means that we need to upgrade to Solaris 11 to use the newer clients.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU><o:p> </o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-AU>What we have found is that we cannot find any combination of client that will talk to 12c database without causing errors – mostly </span><span lang=EN-AU style='font-size:10.0pt;font-family:"Segoe UI",sans-serif;color:black;mso-fareast-language:EN-AU'>ORA-01024: invalid datatype in OCI call, but have had other errors also.<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-AU style='font-size:10.0pt;font-family:"Segoe UI",sans-serif;color:black;mso-fareast-language:EN-AU'><o:p> </o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-AU style='font-size:10.0pt;font-family:"Segoe UI",sans-serif;color:black;mso-fareast-language:EN-AU'>Has anyone migrated to 12c and if so what client are you using and how do you have it configured?<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-AU style='font-size:10.0pt;font-family:"Segoe UI",sans-serif;color:black;mso-fareast-language:EN-AU'><o:p> </o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-AU style='font-size:10.0pt;font-family:"Segoe UI",sans-serif;color:black;mso-fareast-language:EN-AU'>Thanks in advance.<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-AU style='font-size:10.0pt;font-family:"Segoe UI",sans-serif;color:black;mso-fareast-language:EN-AU'><o:p> </o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-AU style='font-size:10.0pt;font-family:"Segoe UI",sans-serif;color:black;mso-fareast-language:EN-AU'>Peter<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-AU style='font-size:10.0pt;font-family:"Segoe UI",sans-serif;color:black;mso-fareast-language:EN-AU'><o:p> </o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-AU style='font-size:10.0pt;font-family:"Segoe UI",sans-serif;color:black;mso-fareast-language:EN-AU'><o:p> </o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-AU style='mso-fareast-language:EN-AU'><o:p> </o:p></span></p><p><span lang=EN-AU>IMPORTANT NOTE: Fuji Xerox email transmission, including any attachments, is private and confidential and may contain legally privileged information. It is for the addressee's attention only. If you are not the intended recipient and have received this transmission, you must not use, edit, print, copy or disclose its contents to any person or disseminate the information contained herein or hereto attached, and you must notify sender immediately by return email and delete this transmission from your system. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. We have used reasonable efforts to protect this transmission from computer viruses and other malicious software, but no warranty is made and the sender takes no responsibility for any loss or damage incurred from using this email or the information contained in this email.<o:p></o:p></span></p></div></body></html>