The IP address is hardcoded (hex) in the sybase interfaces file.
This file can be modified via the sybinit command.
Thanks to all who replied.
-----Original Message-----
From: Jack Burton [mailto:jburton@brio.com]
Sent: Friday, September 01, 2000 12:17 PM
To: 'sun-managers@sunmanagers.ececs.uc.edu'
Subject: Sybase reconfig question ...
I recently changed the IP addresses on my network. This included the
Solaris 2,7 system running Sybase 11. Sybase will no longer start
correctly since the IP was changed. Temporarily put the IP back to the
original number and Sybase started properly. Cannot see any place in the
sybase directory where the ip address
is
hardcoded.
The error log looks like this.
00:00/09/01 11:49:38.12 kernel Using config area from primary master
device.
00:00/09/01 11:49:39.16 kernel Warning: Using default file
'/usr/local/sybase/SYBASE.cfg' since a configuration file was not specified.
Specify a configuration file name in the RUNSERVER file to avoid this
message.
00:00/09/01 11:49:40.03 kernel Using 1024 file descriptors.
00:00/09/01 11:49:40.21 kernel SQL Server/11.0.3/P/Sun_svr4/OS
5.4/2/OPT/Fri Jul 18 18:30:59 PDT 1997
00:00/09/01 11:49:40.21 kernel Confidential property of Sybase, Inc.
00:00/09/01 11:49:40.21 kernel (c) Copyright Sybase Inc., 1987, 1997.
00:00/09/01 11:49:40.21 kernel All rights reserved.
00:00/09/01 11:49:40.21 kernel
00:00/09/01 11:49:40.21 kernel Use, duplication, or disclosure by the
United States Government
00:00/09/01 11:49:40.21 kernel is subject to restrictions as set forth in
FAR subparagraphs
00:00/09/01 11:49:40.21 kernel 52.227-19(a)-(d) for civilian agency
contracts and DFARS
00:00/09/01 11:49:40.21 kernel 252.227-7013(c) (1) (ii) for Department of
Defense contracts.
00:00/09/01 11:49:40.21 kernel Sybase reserves all unpublished rights under
the copyright
00:00/09/01 11:49:40.21 kernel laws of the United States.
00:00/09/01 11:49:40.21 kernel Sybase, Inc. 6475 Christie Avenue,
Emeryville, CA 94608 USA.
00:00/09/01 11:49:40.21 kernel Using '/usr/local/sybase/SYBASE.cfg' for
configuration information.
00:00/09/01 11:49:40.21 kernel Logging SQL Server messages in file
'/usr/local/sybase/install/errorlog'
.
00:00/09/01 11:49:42.68 kernel Network and device connection limit is 1014.
00:00/09/01 11:49:43.05 server Number of proc buffers allocated: 426.
00:00/09/01 11:49:44.02 server Number of blocks left for proc headers: 474.
00:00/09/01 11:49:44.02 server Memory allocated for the default data cache
cache: 3192 Kb
00:00/09/01 11:49:44.13 server Size of the 2K memory pool: 3192 Kb
00:00/09/01 11:49:44.13 kernel Initializing virtual device 0,
'/usr/local/sybase/master.dat'
00:00/09/01 11:49:44.13 kernel Virtual device 0 started using standard unix
i/o.
00:00/09/01 11:49:44.79 server No active traceflags
00:00/09/01 11:49:46.18 server Opening Master Database ...
00:00/09/01 11:49:49.25 server Loading SQL Server's default sort order and
character set
00:00/09/01 11:49:49.64 kernel ninit:0: listener type: master
00:00/09/01 11:49:49.64 kernel ninit:0: listener endpoint: /dev/tcp
00:00/09/01 11:49:49.64 kernel ninit:0: listener raw address:
\x000213920a0000020000000000000000
00:00/09/01 11:49:49.64 kernel ninit:0: transport provider: T_COTS_ORD
00:00/09/01 11:49:49.64 kernel ninit: t_bind, Cannot assign requested
address
00:00/09/01 11:49:49.65 kernel ninit: All master network listeners have
failed. Shutting down.
****************************************************************************
**********************
The sybase interfaces file looks like:
## SYBASE on jupiter
## Services:
## query tcp (5010)
## master tcp (5010)
SYBASE
query tli tcp /dev/tcp \x000213920a0000020000000000000000
master tli tcp /dev/tcp \x000213920a0000020000000000000000
The hex numbers may relate to the ip address. Not sure how to reconfigure
sybase on solaris.
TIA
Jack
S
U BEFORE POSTING please READ the FAQ located at
N ftp://ftp.cs.toronto.edu/pub/jdd/sun-managers/faq
. and the list POLICY statement located at
M ftp://ftp.cs.toronto.edu/pub/jdd/sun-managers/policy
A To submit questions/summaries to this list send your email message to:
N sun-managers@ececs.uc.edu
A To unsubscribe from this list please send an email message to:
G majordomo@sunmanagers.ececs.uc.edu
E and in the BODY type:
R unsubscribe sun-managers
S Or
. unsubscribe sun-managers original@subscription.address
L To view an archive of this list please visit:
I http://www.latech.edu/sunman.html
S
T
S
U BEFORE POSTING please READ the FAQ located at
N ftp://ftp.cs.toronto.edu/pub/jdd/sun-managers/faq
. and the list POLICY statement located at
M ftp://ftp.cs.toronto.edu/pub/jdd/sun-managers/policy
A To submit questions/summaries to this list send your email message to:
N sun-managers@ececs.uc.edu
A To unsubscribe from this list please send an email message to:
G majordomo@sunmanagers.ececs.uc.edu
E and in the BODY type:
R unsubscribe sun-managers
S Or
. unsubscribe sun-managers original@subscription.address
L To view an archive of this list please visit:
I http://www.latech.edu/sunman.html
S
T
This archive was generated by hypermail 2.1.2 : Fri Sep 28 2001 - 23:14:16 CDT