Troubleshooting
Problem
When trying to bring a database server online by just running oninit or by doing a in-place upgrade, a error indicating the servicename defined in the sqlhosts file could not be resolved.
Symptom
Error similar to the following will be found in the Online.log file:
listener-thread: err = -931: oserr = 0: errstr = myserver: Cannot locate myserver service/tcp service in /etc/services.
Cause
possible causes
- missing entry in the informix sqlhosts file
- sqlhosts file not found in $INFORMIXDIR/etc
- $INFORMIXSQLHOSTS env variable pointing to invalid file
- servicename not defined in /etc/services
[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"11.5;11.7;12.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21669647