FW: Ph and Oracle error

[Brett Greiner]

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

 

 



--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l at lists.sowder.com
Subscribe: &quot;subscribe&quot; in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; 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.