From: | "Spendius" <spendius(at)muchomail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Trying to connect to an Oracle instance... |
Date: | 2006-07-13 12:46:55 |
Message-ID: | 1152794815.455650.302830@75g2000cwc.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I've been trying to perform a connection to an Oracle DB for a while,
to no avail. Here is what I get at my psql prompt:
postdb=# Select dblink_connect('login','hostaddr=<host IP> port=1521 \
dbname=orasid user=mylogin password=mypwd');
ERROR: could not establish connection
DETAIL: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
I installed postgresql 8.1 on an Win XP PC a few days ago without
any problem, and I get no error at all when I run any other SQL
instructions or PostgreSQL functions. I ran the
%POSTGRES_HOME%\share\contrib\dblink.sql
file as the same user (which is the 'postgres' Windows user I created
-as I have admin privs on my PC- and with which I execute the following
every time I want to use postgresql:
DOS>runas /env /user:<pc_name>\postgres
d:\prgs\postgresql\81\bin\postmaster
DOS>runas /env /user:<pc_name>\postgres "d:\prgs\postgresql\81\bin\psql
postdb"
in a DOS box)
<host IP>, orasid, mylogin and mypwd are valid parameters necessary
to connect myself to an Oracle 'orasid' DB that resides on a
Sun/Solaris
server, they work in a SQL*Plus session for example (I use the IP
address
rather than the name of this server because if I don't I get the error
"could
not translate host name "host name" to address: Unknown host", yet I
can
ping it of course). Obviously I need to configure something for the
network
inside PostgreSQL directories, don't I ?
Hopefully I gave all details required to give me some hints... Thanks
for
any suggestion...
Spendius
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2006-07-13 13:10:52 | Re: stored function - array parameter - how many element in array ? |
Previous Message | Özgür Tuğrul | 2006-07-13 12:38:50 | stored function - array parameter - how many element in array ? |