Using oracle procedural gateway to connect to mq series
Hi,
I am working on setting up my connection to export data from oracle database to db2 using mq-series.
MQ-Series client software and oracle procedural gateway v9 are installed on HP-UX .
initsid.ora & initsid.gtwboot file for the gateway are configured. listener.ora and tnsnames.ora are also configured and running.
I created a dblink and then tried to test my connection using the test scripts given by IBM.
I got the following error,
ORA-04052: error occurred when looking up remote object APPS.MQOPEN@DCY3.WORLD
ORA-00604: error occurred at recursive SQL level 1
ORA-28509: unable to establish a connection to non-Oracle system
ORA-02063: preceding line from DCY3
I generated a trace and I got the following information from listener.trc
nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcnp: getting sockname
nttcnr: waiting to accept a connection.
nttcnr: getting sockname
nttvlser: valid node check on incoming node 172.25.228.7
nttvlser: Accepted Entry: 172.25.228.7
nttcon: set TCP_NODELAY on 11
nsopen: transport is open
nsnainit: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd
nsopen: global context check-in (to slot 4) complete
nsanswer: deferring connect attempt; at stage 5
nscon: doing connect handshake...
nscon: got NSPTCN packet
nsevdansw: exit
nsbeqaddr: connecting...
sntpcall: About to exec /u46/oracle/app/oracle/product/bin/pg4mqc90drv
sntpcall: detaching from parent with additional fork
sntpcall: only 0 bytes read
sntpcall: Can't read from pipe; err[1] = 32
nserror: nsres: id=4, op=72, ns=12547, ns2=12560; nt[0]=517, nt[1]=32, nt[2]=0;
ora[0]=0, ora[1]=0, ora[2]=0
nscon: sending NSPTRF packet
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 4) complete
nsglecmd: Deallocating cxd 0x40045ef0.
Listener.log gave me the following information,
12-JAN-2010 14:47:34 * (CONNECT_DATA=(SID=dcy3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=
172.25.228.7)(PORT=59501)) * establish * dcy3 * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
HPUX Error: 32: Broken pipe
I researched online and made sure that I have enough swap,memory on my OS.I increased the value for processes in init.ora file.
My log files have not exceeded the maximum limit.
The trace shows that my listener is loosing contact when it is trying to read the driver from /u46/oracle/app/oracle/product/bin/pg4mqc90drv.
I am not sure how to proceed from this point,though I have a thought of relinking my libraries in oracle.
Can anyone give any information on this.