Shell Programming and Scripting

Hi Robin. These aren't database listeners. As mentioned earlier, they're gateway listeners and a listener for MSSQL has to be configured differently to one for say DRDA. They cannot be shared.

I don't see MSSQL mentioned earlier and I missed the point about them being Gateway as opposed to plain database listeners, but how about this suggestion:-That way you know the ports should be allocated to just your service. If you start them at boot, then one would think that they should still be free. if something else is grabbing one, then find out why and/or change /etc/services to move your service to a new port. It's not foolproof because not everything respects /etc/services but it's a good place to start and many network tools (e.g. netstat & lsof) do, making their output more meaningful.

You could even (if your databases are using a sequential naming system) make the port numbers obvious and predictable, e.g. DA is port 13001, DB is port 13002, etc. This would give your clients wanting to connect a consistent port to connect to.


Would that help?

Robin

MSQL or DRDA are just examples of some of the gateways I'm using so there was no actual need to mention them specifically. The range of free ports is defined initially and they're reserved for Oracle. I just have to assign a new one when creating the gateway listener file so I'll just use netstat for that. Your point about making port numbers more obvious is a sensible approach. I'll modify my script slightly to assign ports from that defined range incrementally if possible. Thanks for your advice.