Oracle Connector stage issue

vgundavarapu · Post by **vgundavarapu** » Wed Apr 09, 2014 8:59 pm

Hi,

I am getting the following DataStage issue, so please let me know what are the steps to be taken to fix it.

Oracle Connector issue:

Failed to send the request to the handler: The agent at the datastage:31531 is not available.

Thanks,
Venkat

ray.wurlod · Post by **ray.wurlod** » Wed Apr 09, 2014 9:02 pm

The ASB Node Agent is not started on the engine tier machine where your DataStage project resides.

vgundavarapu · Post by **vgundavarapu** » Wed Apr 09, 2014 9:13 pm

ASB Agent is started and DB2 Connector connection is working fine. The problem is with Oracle Connector stage connection.

May be I am missing any other service or any confirguration set up.

Thank you in advance.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 10, 2014 3:21 am

31531 is the port number used by the ASB Node agent (at least by default).
Until this is remedied you cannot assert that this is an Oracle issue.

Use a netstat command to verify that this port is listening.

vgundavarapu · Post by **vgundavarapu** » Thu Apr 10, 2014 4:53 am

Hi Ray/all,

I have run and check netstat command, but I don't see this port number: 31531 in the netstat list.

When I looked at Services and NET AGENT Service is running and I am able to connect Datastage and DB2.

Could you please let me know what steps need to be taken to start port number 31531.

Thanks,
Venkata

ray.wurlod · Post by **ray.wurlod** » Thu Apr 10, 2014 5:19 pm

NET AGENT is not the same as ASB Node Agent.

You need to start the ASB Node agent (and probably the Logging agent as well, which uses port number 31533 by default).

There is a single script (Node_Agents.sh) in the ASBNode/bin directory that starts both agents. This should be documented in your shut down/start up documentation.

vgundavarapu · Post by **vgundavarapu** » Thu Apr 10, 2014 8:41 pm

Thank you for your reply.

I am using Datastge 8.7 and run the script as you mentioned. Now I am able to see the port number 31533, but it is in TIME_WAIT state, I have run netstat command again and again, still I see the same message.

Thanks,
Venkat

chulett · Post by **chulett** » Thu Apr 10, 2014 9:00 pm

Talk to your System Administrator about what that state means and what can be done about it. For some light reading, here is probably more than you've ever wanted to know about it.

vgundavarapu · Post by **vgundavarapu** » Thu Apr 10, 2014 9:20 pm

Thank you Craig, I will check with administrator.

Thanks,
Venkat

lstsaur · Post by **lstsaur** » Thu Apr 10, 2014 9:44 pm

What you can do is
1.) lsof -P | grep 31533
2.) Find pid
3.) Kill pid
4.) Restart Ds