<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">What version of PowerHouse are you using. If you’re using 7.10G, I can’t remember whether Oracle 10g was supported.<div><br></div><div>Is there no OWNER? Normally I’d expect to see that.</div><div><br></div><div>I suggest trying a complete open name first. In your case</div><div><br></div><div><div lang="EN-CA" link="blue" vlink="purple"><div class="WordSection1" style="page: WordSection1;"><div style="font-family: Calibri, sans-serif; margin: 0cm 0cm 0.0001pt; font-size: 11pt;"><span style="font-family: 'Courier New';"><a href="mailto:ORACLE@MEMPRD.NRS.BCGOV" style="color: purple;">ORACLE@</a></span><span style="font-family: 'Courier New'; font-size: 11pt;">PROXY_MFIN_PRMS</span><a href="mailto:ORACLE@MEMPRD.NRS.BCGOV" style="font-family: 'Courier New'; font-size: 11pt; color: purple;">@MEMPRD.NRS.BCGOV</a>/password</div><div style="font-family: Calibri, sans-serif; margin: 0cm 0cm 0.0001pt; font-size: 11pt;"><br></div><div style="margin: 0cm 0cm 0.0001pt;">that provides complete information in the form that Oracle expects. You should be able to use the same information as you use for SQLPlus.</div><div style="margin: 0cm 0cm 0.0001pt;"><br></div><div style="margin: 0cm 0cm 0.0001pt;">Bob</div><div style="margin: 0cm 0cm 0.0001pt;"><br></div><div style="margin: 0cm 0cm 0.0001pt;"><br></div></div></div><div><div>On Feb 5, 2014, at 6:40 PM, Thomson, Martyn <<a href="mailto:Martyn.Thomson@hpadvancedsolutions.com">Martyn.Thomson@hpadvancedsolutions.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div lang="EN-CA" link="blue" vlink="purple" style="font-family: LucidaGrande; font-size: 16px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><div class="WordSection1" style="page: WordSection1;"><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">Hello.<o:p></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">I can connect to an Oracle 10g db using SQLPLUS no problem. So I defined the db in the Powerhouse Dictionary Manager with the same Id/password like so –<o:p></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><o:p> </o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">MODE:F ACTION:RFO FILE Screen<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">┌──────────────────────────────────────────────────────────────────────────────┐<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">│ 01 File IPS Organization RELATIONAL │<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">│ Type ORACLE │<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">│ Auto Defn : M │<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">│ 02 Open Name Allow Null: No │<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">│ <span class="Apple-converted-space"> </span></span><a href="mailto:ORACLE@MEMPRD.NRS.BCGOV" style="font-family: 'Courier New'; font-size: 11pt; color: purple;">ORACLE@MEMPRD.NRS.BCGO</a><span style="font-family: 'Courier New'; font-size: 11pt;"> │</span></div></div></div></blockquote><blockquote type="cite"><div lang="EN-CA" link="blue" vlink="purple" style="font-family: LucidaGrande; font-size: 16px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><div class="WordSection1" style="page: WordSection1;"><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">└──────────────────────────────────────────────────────────────────────────────┘<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">┌──────────────────────────────────────────────────────────────────────────────┐<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">│ MODE:F ACTION: RELATIONAL FILE OPTIONS │<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">│ │<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">│ 01 HEX ? N Low Fill Char 03 Database Stmt in PDL ? N │<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">│ 02 HEX ? N High Fill Char 04 Default Date NULL? N │<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">├──────────────────────────────────────────────────────────────────────────────┤<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">│ │<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">│ 06 Database Owner │<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">│ Database Password ********* │<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">│ User Id PROXY_MFIN_PRMS │<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">│ │<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">│ │<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">│ │<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Courier New';">└──────────────────────────────────────────────────────────────────────────────┘<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><o:p> </o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">. When Quiz tries to access the db I get –<o:p></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">:quiz<o:p></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">> acc IPS_TITLE_FAMILY_UWI_VW in ips<o:p></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">*W* SQL START DBE error (IPS).<o:p></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">DMS-E-GENERAL, A general exception has occurred during operation 'attach<o:p></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">database'.<o:p></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">ORA-12162: TNS:net service name is incorrectly specified<o:p></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><o:p> </o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">*E* The file IPS_TITLE_FAMILY_UWI_VW IN IPS wasn't found in the data<o:p></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">dictionary.<o:p></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><o:p> </o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">Sometimes it will connect but then give – “ORA-01017: invalid username/password; logon denied”.<o:p></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><o:p> </o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">Any ideas what’s going on here?<o:p></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><o:p> </o:p></div><p class="MsoNormal" style="margin: 6pt 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(31, 73, 125);">Regards,<o:p></o:p></span></p><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: 'Arial Rounded MT Bold', sans-serif; color: rgb(31, 73, 125);">Martyn Thomson<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: Arial, sans-serif; color: rgb(31, 73, 125);">Senior Technical Analyst, Development Services</span><span style="font-family: 'Arial Rounded MT Bold', sans-serif; color: rgb(31, 73, 125);"><o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: Arial, sans-serif; color: rgb(31, 73, 125);">Information Technology Services<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><b><i><span lang="EN-US" style="font-size: 14pt; color: rgb(0, 61, 131);">HP Advanced Solutions Inc.</span></i></b><b><i><span lang="EN-US" style="font-size: 14pt; color: rgb(0, 61, 131);"><o:p></o:p></span></i></b></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(31, 73, 125);">phone: 250.405.4555 | fax: 250.405.4422</span><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(31, 73, 125);"><o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(31, 73, 125);">email:<a href="mailto:martyn.thomson@hpadvancedsolutions.com" style="color: purple; text-decoration: underline;"><span style="color: blue;">martyn.thomson@hpadvancedsolutions.com</span></a></span><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(31, 73, 125);"><o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><span lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(31, 73, 125);">web: <span class="Apple-converted-space"> </span><a href="http://www.hpadvancedsolutions.com/" style="color: purple; text-decoration: underline;"><span style="color: blue;">www.hpadvancedsolutions.com</span></a><o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"><o:p> </o:p></div></div>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list:<span class="Apple-converted-space"> </span><a href="mailto:powerh-l@lists.sowder.com" style="color: purple; text-decoration: underline;">powerh-l@lists.sowder.com</a><br>Subscribe: 'subscribe' in message body to<span class="Apple-converted-space"> </span><a href="mailto:powerh-l-request@lists.sowder.com" style="color: purple; text-decoration: underline;">powerh-l-request@lists.sowder.com</a><br>Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to<span class="Apple-converted-space"> </span><a href="mailto:powerh-l-request@lists.sowder.com" style="color: purple; text-decoration: underline;">powerh-l-request@lists.sowder.com</a><br><a href="http://lists.sowder.com/mailman/listinfo/powerh-l" style="color: purple; text-decoration: underline;">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>This list is closed, thus to post to the list you must be a subscriber.<br>Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.</div></blockquote></div><br></div></body></html>