Connecting Powerhouse 8.4 to Oracle10g

[Thomson, Martyn]

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.BCGOV                                                  │
└──────────────────────────────────────────────────────────────────────────────┘
┌──────────────────────────────────────────────────────────────────────────────┐
│ 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<mailto:martyn.thomson at hpadvancedsolutions.com>
web:  www.hpadvancedsolutions.com<http://www.hpadvancedsolutions.com/>

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