Ph and Oracle error

[Joe Boyle]

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: &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.






-- 

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.

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: &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.