Ph and Oracle error
Joe Boyle
atla38 at dsl.pipex.com
Wed Apr 4 20:41:44 CDT 2007
There was also a time when you had to switch some PH library files for PH843
to work with Oracle 9:
1. point LD_LIBRARY_PATH to /isv/oracle/9.2.0/lib32
2. Change the oracle gateway to the one for Oracle 9. To do this, rename
ordba.sl in $PH_USR/lib to ordba8.sl, and then rename ordba9.sl to
ordba.sl. If you don't want to change the gateway in the product area, you
can copy the content of $PH_USR/lib in your working area, switch the
gateways, and change SHLIB_PATH to point there.
Perhaps you are hitting a similar problem.
-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Joe Boyle
Sent: 05 April 2007 02:08
To: 'Brett Greiner'
Cc: powerh-l at lists.sowder.com
Subject: RE: Ph and Oracle error
I once had to use syntax as below ( i.e. add .world); admittedly this was
because the default client config file was'nt set up correctly,
DATABASE CMSDB &
TYPE ORACLE &
NULL VALUES ALLOWED &
OWNER <username> &
OPEN "ORACLE@<username>@CMSTEST.world/<password>"
-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Rohde, Dirk
Sent: 05 April 2007 00:05
To: Brett Greiner
Cc: powerh-l at lists.sowder.com
Subject: RE: Ph and Oracle error
The "open" clause in your database statement should be:
OPEN ORACLE@<username>@CMSTEST/<password>
-----Original Message-----
From: powerh-l-bounces+dirk.rohde=vpgroup.com at lists.sowder.com
[mailto:powerh-l-bounces+dirk.rohde=vpgroup.com at lists.sowder.com] On
Behalf Of Brett Greiner
Sent: April 4, 2007 3:40 PM
To: mgo at columbus.rr.com
Cc: powerh-l at lists.sowder.com
Subject: FW: Ph and Oracle error
Hi Mike
Comes back as Ok. Its on the same server so should be no firewall
issues.
I can connect to Oracle from the shell> sqlplus
<username>@cmstest/<password> and connects fine. Just the Powerhouse
connect from the PH Dictionary. Maybe it's the setup of the Database
command?
cmstest is the Oracle instance name
DATABASE CMSDB &
TYPE ORACLE &
NULL VALUES ALLOWED &
OWNER <username> &
OPEN cmstest &
USERID "<username>" &
PASSWORD "<password>"
Is the above correct?
Thanks
Brett
-----Original Message-----
From: Mike Godsey [mailto:mgo at columbus.rr.com]
Sent: Thursday, 5 April 2007 09:53
To: Brett Greiner
Subject: RE: Ph and Oracle error
Brett,
Try doing a TNSPING that will validate your connectivity. Also, review
any firewalls between your server and the database server that may be
blocking ports 1521 and 1529.
Mike
-----Original Message-----
From: powerh-l-bounces+mgo=columbus.rr.com at lists.sowder.com
[mailto:powerh-l-bounces+mgo=columbus.rr.com at lists.sowder.com] On Behalf
Of Brett Greiner
Sent: Wednesday, April 04, 2007 12:37 AM
To: powerh-l at lists.sowder.com
Subject: Ph and Oracle error
Hi all
We're getting there on setting up Oracle with Powerhouse so there might
be a few posts over tht next week or two...
Using qshow to show the tables from the Oracle database I get this
error. Any ideas what would be causing this?
*W* SQL START DBE error (CMS)
DMS-E-CONNECTREJECT, A connection has been rejected by the remote
interface during operation 'attach database'.
Error while trying to retrieve text for error ORA-12154
Records & Sizes: ** none **
Thanks
Brett
--
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.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
This email may contain information that is privileged, confidential, or
otherwise exempt from disclosure under applicable laws. Unauthorized use,
reproduction or dissemination of this email is strictly prohibited. If you
have received this e-mail in error please inform the sender and delete it
from your mailbox or any other storage mechanism. VantagePoint Systems, Inc.
cannot accept liability for any statements made which are clearly the
sender's own and not expressly made on behalf of VantagePoint Systems, Inc.
or one of its agents.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
More information about the powerh-l
mailing list