Troubleshooting, Server fails to start | Sybase DC35823-01-1500-04

Troubleshooting

Before starting Adaptive Server for IPv6-aware operations, make sure that your infrastructure is correctly set up. Once your operating system is correctly configured, an IPv6 connection handler can be configured and enabled. Configuring and enabling the IPv6 connection handler requires adding an additional DCL entry. A single Adaptive Server configuration can typically carry up to 32 connection handler assignments within the DCL.

For example if you have a Site-local setup with two domains administrated under the nameserver setup:

sybase.com - being responsible for all IPv4 networking applications v6.sybase.com - being responsible for all IPv6 networking applications

The DCL entry for Adaptive Server to start named “SYBASE” on the host “revival” for port 17100 would typically look like:

SYBASE

master tcp ether revival.sybase.com 17100 query tcp ether revival.sybase.com 17100 master tcp ether revival.v6.sybase.com 17100 query tcp ether revival.v6.sybase.com 17100

In the above example, when Adaptive Server is started with IPv6-awareness it creates two connection handlers. One listens on port 17100 for incoming IPv4 Clients connection requests, and the other listens on port 17100 for incoming IPv6 Clients connection requests.

Troubleshooting

This section describes how to correct some common situations that may cause a server to not start.

Server fails to start

If a server fails to start with the following message, the port number specified in the interfaces file may be in use:

00:00000:00002:2003/09/22 12:37:23.63 kernel network name SERV_CORPNET, type ether, port 4559, filter NONE

00:00000:00002:2003/09/22 12:37:23.65 kernel ninit: bind, Address already in use

00:00000:00002:2003/09/22 12:37:23.68 server Error: 1602, Severity: 18, State:

66	Adaptive Server Enterprise

Image 82

Sybase DC35823-01-1500-04 manual Troubleshooting, Server fails to start

Contents

Adaptive Server Enterprise 15.0 Document ID DC35823-01-1500-04 Contents Configuring the Operating System Configuring new servers with srvbuildAdaptive Server Default Configuration Starting Adaptive Server Enterprise as IPv6-aware ContentsConfiguring the server for multiple network handlers Conversions between server and client Adding Optional Functionality to Adaptive Server 113 105109 125 This manual contains the following chapters About This BookMedia devices Introduction is an overview of Adaptive Server Viii Related documents About This Book Adaptive Server Enterprise Other sources of information Xii Finding the latest information on component certifications Product description to download the software Formatted using modified Backus Naur Form BNF notationRole to your MySybase profile Following sections describe conventions used in this manual For a command with more options Xiv Select, and select are the same Accessibility featuresExamples of output from the computer appear as follows Information about these and other terms, see the Glossary Xvi If you need help About Adaptive Server IntroductionTopic System-specific issues System-specific issues Environment variables System user rolesIntroduction Environment variables Sybase Adaptive Server devices and system databases Master device Optional devices and databases Sybsystemdb deviceSysprocsdev device Adaptive Server devices and system databases Introduction Dsync option on by default for database device files Adaptive Server database devices Minimum Device Purpose Size Recommended size Choosing a raw partition Client/server communication Changing Adaptive Server configuration Changing Adaptive Server configuration Adaptive Server specifications Languages other than U.S. English Adaptive Server specifications Table specifications Database requirements for varying page sizes Data row and data page tablesMaximum DOL table Number Column size Limits Columns 16K Databases 16K Data limits for tables according to page size Databases 16KTables 16K Overview A P T E R 2 Starting and Stopping ServersRequirements for starting servers Server start-up parameters Default start-up parameters are stored underStarting servers Starting servers Changing start-up parameters Starting and Stopping Servers Using the monserver and backupserver commands Starting servers when the operating system restartsUsing the startserver command Starting servers when the operating system restarts For HP-UX For IBM RS/6000 For Sun Solaris and Linux If your script is named sybstart, type the following ReturnsSo on. If your script is named sybstart, type the following Where servername is the name of the Adaptive Server Starting XP Server after initial installationStarting XP Server after initial installation Stopping servers Stopping Backup Server Enter Stopping Monitor Server Using the kill commandStopping servers Shutdown and shared memory files UID PID Ppid Stime TTY Time Comd Stopping servers Configuring the Operating System Setting environment variables System environment variables Configuring new servers with srvbuildVariable Sample value Function Configuring the Operating System Configuring new servers with srvbuild Using the stty setting For AIX Restoring correct permissionsFile descriptors and user connections Restoring correct permissions Displaying current soft and hard limits For LinuxFor Sun Solaris Increasing the soft limit Increasing the hard limit Setting up the sample program to increase the hard limitFile descriptors and user connections Sample program Maxconnections This step is mandatory for HP users Enabling asynchronous disk I/OEnabling asynchronous disk I/O HP technical support Issue the command To launch the Kernel Configuration use kcweb -FSelect asyncdsk and change the next boot to static Owner of the /dev/async directory This step is mandatory for IBM users Enable asynchronous disk I/OSelect Change/Show Characteristics of Asynchronous I/O Management Interface Tool Smit To display the current timeout period, enter Adjusting the client connection timeout periodTo display the current timeout value, enter Checking for hardware errors Checking for hardware errorsTo display the timeout value, enter Monitoring the use of operating system resources For Sun Solaris and Linux Sample C shell maintenance script Sample C shell maintenance script Defaults for Adaptive Server parameter settings Adaptive Server Default ConfigurationDefault settings Default value Defaults for Backup, Monitor, and XP Servers Default settingsServer Default value A P T E R 5 Setting Up Communications Across the Network Where to find interfaces file tasks and topics Type Interfaces file Task or topic See Creating a directory services entry How a client uses directory servicesSetting Up Communications Across the Network Contents of an interfaces file Supported directory drivers Heterogeneous and homogeneous environments Heterogeneous and homogeneous environments Chico Understanding the format of the interfaces file TCP style entry looks like Components of an interfaces file entryUnderstanding the format of the interfaces file Components of an interfaces file Setting Up Communications Across the Network Using a text editor Using dsedit or dscp to create a master interfaces fileUsing a text editor to create a master interfaces file Creating a master interfaces file Configuring interfaces files for multiple networks Configuring the server for multiple network handlers Configuring the client connections Configuring interfaces files for multiple networks Using one network-independent Dsquery name Configuring for query port backup Understanding IPv6 IPv6 supportAdaptive Server supports IPv6 technology IPv6 support IPv6 infrastructureIPv6 support Starting Adaptive Server Enterprise as IPv6-aware Troubleshooting TroubleshootingServer fails to start Error when executing an ESP Investigating the port assignment Information on how to bring XP Server up Overview Ldap directory services versus the Sybase interfaces file Ldap directory services versus the Sybase interfaces file Lists the Sybase Ldap directory entries Interfaces file versus Ldap directory servicesFor a list of attributes Sybase Ldap directory definitions Libtcl*.cfg file on Libtcl*.cfg file Enabling Ldap directory services Enabling Ldap directory servicesWhere the ldapurl is defined as Ldapurl variables Keyword Description Default For example Adding a server to the directory services Adding a server to the directory servicesAdding a server entry to the directory service using dsedit Multiple directory services Replace the password with the encrypted string Encrypting the passwordEncrypting the password Performance Migrating from the interfaces file to Ldap Migrating from the interfaces file to Ldap Customizing Localization for Adaptive Server Overview of localization support Language modules Overview of localization support Default character sets for servers Customizing Localization for Adaptive Server Changing the default character set for servers Supported character sets Arabic character sets Lists the Baltic character setLists the simplified Chinese character set Character set Unilib required Description Lists the Eastern European character set Lists the traditional Chinese character setLists the Cyrillic character set Lists the Greek character set 10 lists the Korean character set Lists the Hebrew character setLists the Japanese character set 11 lists the Thai character set 14 lists the Vietnamese character set 13 lists the Unicode character set15 lists the Western European character set Character set conversion Conversions between server and client Available sort orders Sort ordersSort orders Srt file for your language. Sort orders are stored At a later time using the sqlloc utilityYour character set definition files 16 Sort orders available in Adaptive Server For utf8, see , Configuring Character Sets, Sort Orders, Language modules Installing a new language moduleMessage languages Localization directories LocalizationLocalization About the charsets directory About the directoryAbout the locales.dat file How client applications use locales.dat Changing the localization configuration Editing the locales.dat file Changing the localization configuration Adaptive Server localization Backup Server localization Configuring Adaptive Server for other character sets 17 Available sort orders Sort orders100 Language or script Sort orders File name 101 Character sets18 lists the supported character sets and their Sybase name 18 Sybase character set names Charset utility 102 19 Keywords and options for charsets 103Keywords Options Description 104 Logging Error Messages and Events Adaptive Server error logging Setting the Adaptive Server error log path Setting error log pathsEnabling and disabling error logging Setting error log paths Logging user-defined messages Logging Error Messages and EventsManaging messages 107 Managing messages Logging auditing events108 Managing database devices Managing Adaptive Server DatabasesDevice requirements Managing database devices Creating files for database devices110 Managing Adaptive Server Databases 111 112 Adding auditing Audit system devices and databases Adding auditing Overview of audit installation114 Adding Optional Functionality to Adaptive Server Pre-installation tasks for auditing devicesInstalling auditing Auditinit displays the following menu 116 Creating a device for an audit table 117 118 Creating a device for the audit database transaction log 119 Enter the number of the device to delete Press Ctrl+A again. auditinit prompts withEnter y yes Press return Online syntax help spsyntax Installing online help for Transact-SQL syntaxSpsyntax installation scripts 121 Installing online help for Transact-SQL syntax Default device for the sybsyntax databaseInstalling sybsyntax 122 123 124 Symbols Index Index 126 127 128 HP-UX 129 Ldap 130 131 Smit 132 133 134