Connecting Powerhouse 8.4 to Oracle10g

[Thomson, Martyn]

Using 8.40G.
That worked – Thanks so much Bob! So the RFO is actually the Red (Herring) Fish Options? Go figure?
Martyn

From: Robert Deskin [mailto:bob.deskin at me.com]
Sent: February-05-14 4:05 PM
To: Thomson, Martyn
Cc: power-l List
Subject: Re: Connecting Powerhouse 8.4 to Oracle10g

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@<mailto:ORACLE at MEMPRD.NRS.BCGOV>PROXY_MFIN_PRMS at MEMPRD.NRS.BCGOV<mailto:ORACLE at 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<mailto: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<mailto: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/>

--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com<mailto:powerh-l at lists.sowder.com>
Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com<mailto:powerh-l-request at lists.sowder.com>
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to powerh-l-request at lists.sowder.com<mailto: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/20140206/b7180ba3/attachment-0001.htm>