---------------------------------
The Open University is incorporated by Royal Charter (RC 000391), an exempt charity in England & Wales and a charity registered in Scotland (SC 038302).

It appears that this is related to the fact that a VNode has to be used
on the local host.

So on my oracle / Ingres GW server I have to connect to the dbalias I've
set up using a VNode, e.g.:

sql oracle_dbserver_vnode_name::dbalias/oracle

and I have to specify 2 different VNodes when connecting remotely:

sql
ingres_dbserver_vnode_name:racle_dbserver_vnode_ name::dbalias/oracle

I have a vague recollection that during the Ingres GW install I was
prompted about using VNodes and I answered yes. Perhaps a 5 minute skim
through the manual wasn't enough.

I'm going to see if I can undo this behaviour, although I'm not hopeful.
If anyone knows how to do this I'd be grateful for any pointers.

Thanks

Laurence



-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
I.L.Breeze
Sent: 18 December 2008 14:05
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: [Info-Ingres] E_CLFE01_BS_SOCK_ERR





Hi All,

I'm trying to set up an Ingres gateway for Oracle and have had
partial success:

I have a Linux server with Oracle 10g and Ingres 2.6. I've
created a number of aliases.

I can use sql/isql on this server using a local Vnode, e.g.:

sql thismachine::aliasdbname/oracle

I have to specify the Vnode with seems odd, but isn't a problem.


What I'd like to do is to access this database from a remote
machine using a Vnode with the syntax above. However, I've created a
Vnode on a remote server (Ingres 9.1.1) and I get the following error:

INGRES TERMINAL MONITOR Copyright 2007 Ingres Corporation
E_LC0001 GCA protocol service (GCA_REQUEST) failure.
Internal service status E_GCfe01 -- Could not create
connection endpoint..

E_LQ0001 Failed to connect to DBMS session.

The entry in the corresponding server's errlog.log is:

jay ::[ , 20776 , 00000000]:
Thu Dec 18 11:40:21 2008 E_CLFE01_BS_SOCK_ERR Could not create
connection endpoint.

On the Oracle server with the Ingres gateway I get about 500 of
the following entries in the errlog.log:

crossbil::[40999 IIGCC, 00000002]: Thu Dec 18 11:40:20
2008 E_CLFE01_BS_SOCK_ERR Could not create connection endpoint.

I've searched for this error message in previous postings and
have found a couple of postings which relate to:


"where the system is IPv6 capable but IPv6 is not enabled"

None of the postings mention the Ingres gateway for Oracle. One
workaround suggested was to:


ingsetenv II_TCPIP_VERSION 4

If that still doesn't work then try this -

ingsetenv II_GC_PROT TCP_IPV4


Which I've tried with no success.

Any suggestions would be much appreciated.

Many Thanks

Laurence Breeze



---------------------------------
The Open University is incorporated by Royal Charter (RC
000391), an exempt charity in England & Wales and a charity registered
in Scotland (SC 038302).


---------------------------------
The Open University is incorporated by Royal Charter (RC 000391), an exempt charity in England & Wales and a charity registered in Scotland (SC 038302).

On Dec 18, 8:48 am, "I.L.Breeze" <I.L.Bre... (AT) open (DOT) ac.uk> wrote:
.....

You should not need to do this, it doesn't hurt but is an unnecessary
overhead. Gateways are just Ingres servers that do not talk to an
Ingres DBMS.

Ditto for this too + it won't work (whether the end point is gateway
or a regular Ingres DBMS server) :-(


It was probably a question relating to installation passwords - which
are optional so if you set one up you can just ignore it if you are
not using it :-)


I would go ahead a log a support issue for this at;

http://servicedesk.ingres.com/

The error you are getting is very odd and really needs some in depth
checks of your setup.

Chris