[Bulk] powerh-l Digest, Vol 103, Issue 1
Ken Langendock
ken.langendock at rogers.com
Thu Feb 6 09:55:39 CST 2014
Very interesting, I got Bob's reply BEFORE I received the original
message....still hasn't show up yet actually.
This may help you, I defined the variables I used to 'explain' the
connection string.
DATABASE CoreDB &
Type ORACLE &
NULL VALUES NOT ALLOWED & ; NEVER set this to ALLOWED!!!
; Owner (User) cannot be a variable
Owner CORE &
@if UNIX
OPEN "ORACLE@$ORDBUSER@$ORACLE_SID/$ORDBPASS" &
@elseif WINDOWS
OPEN "ORACLE@%ORDBUSER%@%ORACLE_SID%/%ORDBPASS%"
@endif
Ken
-----Original Message-----
From: powerh-l-bounces+ken=langendock.com at lists.sowder.com
[mailto:powerh-l-bounces+ken=langendock.com at lists.sowder.com] On Behalf Of
powerh-l-request at lists.sowder.com
Sent: Wednesday, February 05, 2014 7:05 PM
To: powerh-l at lists.sowder.com
Subject: [Bulk] powerh-l Digest, Vol 103, Issue 1
Send powerh-l mailing list submissions to
powerh-l at lists.sowder.com
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.sowder.com/mailman/listinfo/powerh-l
or, via email, send a message with subject or body 'help' to
powerh-l-request at lists.sowder.com
You can reach the person managing the list at
powerh-l-owner at lists.sowder.com
When replying, please edit your Subject line so it is more specific
than "Re: Contents of powerh-l digest..."
Today's Topics:
1. Connecting Powerhouse 8.4 to Oracle10g (Thomson, Martyn)
2. Re:Connecting Powerhouse 8.4 to Oracle10g (Robert Deskin)
----------------------------------------------------------------------
Message: 1
Date: Wed, 5 Feb 2014 23:40:24 +0000
From: "Thomson, Martyn" <Martyn.Thomson at hpadvancedsolutions.com>
Subject: Connecting Powerhouse 8.4 to Oracle10g
To: "'powerh-l at lists.sowder.com'" <powerh-l at lists.sowder.com>
Message-ID: <BE839CB5CAB7014090AA763C5C442839874F401D at cavtmase135>
Content-Type: text/plain; charset="koi8-r"
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 hpadvance
dsolutions.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/at
tachment-0001.htm>
------------------------------
Message: 2
Date: Wed, 05 Feb 2014 19:04:44 -0500
From: Robert Deskin <bob.deskin at me.com>
Subject: Re: Connecting Powerhouse 8.4 to Oracle10g
To: "Thomson, Martyn" <Martyn.Thomson at hpadvancedsolutions.com>
Cc: power-l List <powerh-l at lists.sowder.com>
Message-ID: <9A44B6C1-8BF5-4D29-A669-C35266F92E8F at me.com>
Content-Type: text/plain; charset="utf-8"
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 <password>' 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/at
tachment.htm>
------------------------------
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" 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.
End of powerh-l Digest, Vol 103, Issue 1
****************************************
More information about the powerh-l
mailing list