Error: ninit: bind, Cannot assign requested address

When Sybase starts than it binds to network interfaces as defined in master entires of interfaces file under the server name. For example for the server SAP01, the colored entries determine network interfaces where sybase will bind:


SAP01
        master tcp ether localhost 5000
        query tcp ether localhost 5000
        master tcp ether 192.168.137.100 5000

SAP01_BS
        master tcp ether localhost 5001
        query tcp ether localhost 5001


SAP01_XP
        master tcp ether localhost 5002
        query tcp ether localhost 5002


SAP01_JSAGENT
        master tcp ether localhost 4900
        query tcp ether localhost 4900

However sometimes network was not ready when server was started and than following entries can be started in the errorlog:

network name localhost, interface IPv4, address 127.0.0.1, type tcp, port 5000, filter NONE
network name 192.168.137.100, interface IPv4, address 192.168.137.100, type tcp, port 5000, filter NONE
ninit: bind, Cannot assign requested address

Probably server restart will solve the issue, however you may decide to use an online operation:

Start following commands:

sp_listener status
GO

sp_listener start, '192.168.137.100:5000'
GO

sp_listener status
GO

The 'status' procedures just display the interfaces where sybase is listening. The 'start' command performs the binding operation. Values of IP and port should be the same as in the interfaces file.

In the same time in the errorlog following successful message should be recorded:

network name 192.168.137.100, interface IPv4, address 192.168.137.100, type tcp, port 5000, filter NONE
Listener with protocol tcp, host 192.168.137.100, port 5000 started.