transparant gateay to as400 issues

am trying to set up a TG to an as400 .
i installed the gateway software on a seperate home as the db software,
(so no cause outage)

so in gateway_home i create listener.ora as

LISTENER_GATEWAY =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = prddb01.domain.com)(PORT =
1525))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = S20OLD))

)
)
)

SID_LIST_LISTENER_GATEWAY =
(SID_LIST =
(SID_DESC =
(SID_NAME = LSBISE01)
(ORACLE_HOME = /u01/app/oracle/product/10.1)
(PROGRAM = /u01/app/oracle/product/10.1/gateway/bin/g4drsrv)
)
)

listener starts successfully

tnsname.ora

LSBISE01 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = LSBISE01))
(CONNECT_DATA =
(SID = LSBISE01)

)
(HS=)

)

initLSBISE01.ora in gateway_home/tg4drda/admin

when oracle_home is set up as gateway_home , i can tnsping the as400 successfully

in the database running from db_home
i create a db link to the as400 but if i try and query any table on it i get :
SQL> select * from sasrwdata.RWCPMYPF_at_lsbise01; select * from sasrwdata.RWCPMYPF_at_lsbise01 *
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent NCRO: Failed to make RSLV connection
ORA-02063: preceding 2 lines from LSBISE01

i have set this up on other server in what i believe exactly the same way and it works, so nothing wrong with as400 end, and it is fine about have gateway install in a different home as the db-home

any one any ideas????

Dug Received on Thu Jan 26 2006 - 10:18:20 CST