Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using oracle procedural gateway to connect to mq series

user11989639Jan 12 2010 — edited Jan 25 2010
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2010
Added on Jan 12 2010
23 comments
4,979 views