Connecting Powerhouse 8.4 to Oracle10g

[Robert Deskin]

What version of PowerHouse are you using. If you’re using 7.10G, I can’t remember whether Oracle 10g was supported.

Is there no OWNER? Normally I’d expect to see that.

I suggest trying a complete open name first. In your case

ORACLE at PROXY_MFIN_PRMS@MEMPRD.NRS.BCGOV/password

that provides complete information in the form that Oracle expects. You should be able to use the same information as you use for SQLPlus.

Bob


On Feb 5, 2014, at 6:40 PM, Thomson, Martyn <Martyn.Thomson at hpadvancedsolutions.com> wrote:

> Hello.
> 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 –
>  
> MODE:F ACTION:RFO                 FILE Screen
> ┌──────────────────────────────────────────────────────────────────────────────┐
> │ 01 File       IPS                               Organization RELATIONAL      │
> │                                                 Type         ORACLE          │
> │                                                 Auto Defn :  M               │
> │ 02 Open Name                                    Allow Null:  No              │
> │     ORACLE at MEMPRD.NRS.BCGO                                                  │
> └──────────────────────────────────────────────────────────────────────────────┘
> ┌──────────────────────────────────────────────────────────────────────────────┐
> │ MODE:F  ACTION:           RELATIONAL FILE OPTIONS                            │
> │                                                                              │
> │ 01 HEX ? N   Low Fill Char           03 Database Stmt in PDL ?     N         │
> │ 02 HEX ? N   High Fill Char          04 Default Date NULL?         N         │
> ├──────────────────────────────────────────────────────────────────────────────┤
> │                                                                              │
> │ 06 Database Owner                                                            │
> │    Database Password  *********                                              │
> │    User Id            PROXY_MFIN_PRMS                                        │
> │                                                                              │
> │                                                                              │
> │                                                                              │
> └──────────────────────────────────────────────────────────────────────────────┘
>  
> . When Quiz tries to access the db I get –
> :quiz
> > acc IPS_TITLE_FAMILY_UWI_VW in ips
> *W* SQL START DBE error (IPS).
> DMS-E-GENERAL, A general exception has occurred during operation 'attach
> database'.
> ORA-12162: TNS:net service name is incorrectly specified
>  
> *E* The file IPS_TITLE_FAMILY_UWI_VW IN IPS wasn't found in the data
> dictionary.
>  
> Sometimes it will connect but then give – “ORA-01017: invalid username/password; logon denied”.
>  
> Any ideas what’s going on here?
>  
> Regards,
> Martyn Thomson
> Senior Technical Analyst, Development Services
> Information Technology Services
> HP Advanced Solutions Inc.
> phone: 250.405.4555 | fax: 250.405.4422
> email:martyn.thomson at hpadvancedsolutions.com
> web:  www.hpadvancedsolutions.com
>  
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l at lists.sowder.com
> Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com
> Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to powerh-l-request at lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
> Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20140205/de243857/attachment-0001.htm>