Generic Connectivity

I am attempting to set up a HS generic connection between Oracle 9i (rel2) on Red Hat 7.2 and our own database application.

Despite my best efforts at reading the Oracle documentation and trying every possible combination I can't get it to work.

My inittest.ora file is:

HS_FDS_CONNECT_INFO=test
HS_FDS_TRACE_LEVEL=ON
HS_FDS_SHAREABLE_NAME=/.../libodb.so

Set ODBCINI=/.../odbc.ini

[test is a valid dsn and libodb.so is the shared library I have built for the ODBC bit of my application]

My tnsnames.ora file is:

TEST=
  (DESCRIPTION=
    (ADDRESS_LIST=
(ADDRESS = (PROTOCOL=TCP)(HOST=kings-redsrv)(PORT=1521))
    )
    (CONNECT_DATA=
(SERVICE_NAME=test)

    )
    (HS=OK)
  )

My listener.ora is:

...
SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
(SID_NAME=test)
(ORACLE_HOME=/…/…)
(PROGRAM=/.../adatasvr)
(ENVS=LD_LIBRARY_PATH=/.../linux)
    )
...

[where ORACLE_HOME is set correctly, adatasvr is my application and the directory ending /linux is where all the libraries are for the adatasvr application]

I start my listener. It tells me that the service "test" has 1 instance and this instance has unknown status and there is 1 handler for this service (in other words - it's telling me exactly the same as for all the other services - which work).

tnsping test tells me that the alias is resolved and it can contact it ok.

lsnrctl service tells me that service "test" has 1 instance, status unknown and one handler, that the handler is on a dedicated server, 0 connections established/refused.

I start up sqlplus and create my database link:

create database link o4a_test connect to UID identified by PWD using 'test';

SQLPLUS tells me this is created ok.

However ... I then try ...
select * from Client_at_o4a_test;

and I get ORA-28545
NCRO Failed to make RSLV connection
ORA-02063. I do not rule out that my odbc driver might not work flawlessly - however, through a simple client program I am able to connect to this database using it (with the same user name and password).

Is the problem with me & Oracle or with my ODBC driver. I think it's most likely something in my .ora files is wrong but I've been backwards and forwards in the documentation with no joy!

I hope someone can help - or at least point me in the direction of some pertinent documentation!

A Received on Tue Aug 27 2002 - 16:19:37 CEST