RE: Solaris 8, IDSWE 7.31, WARNING: Network Down
Posted in 2000
Need to upgrade Sun changed the IP addressing to the new format.
-----Original Message-----
From: KCStout [mailto:kstout@mindspring.com]
Sent: Monday, July 24, 2000 1:40 AM
To: informix-list@iiug.org
Subject: Solaris 8, IDSWE 7.31, WARNING: Network Down
OS: Solaris 8
Database Engine: Informix Dynamic Server Workgroup Edition 7.31.UC4-1
Problems:
1. database initializes using oninit but the following error displays
running onmonitor as root:
** WARNING: Network Down **
2. running dbaccess as informix:
25572: Network driver cannot bind a name to the port.
Exec format error
Process of installing and initializing Informix Dynamic Server Workgroup
Edition 7.31.UC4-1:
1. created informix group
2. created informix user
3. placed informix user in group
4. entries in /etc/hosts (see below)
5. added entry to /etc/services (see below)
6. added environment variables to /etc/profile (see below)
7. reboot server
8. installed Informix database server as root
9. ran onmonitor, parameters, initialize, set parameters (see end of
message)
10. installed I-Connect as informix
11. modified /etc/system to increase shared memory segment
12. reboot server
13. oninit -iv (see excerpt from buildsmi.866)
System status & settings:
I can access the web and ping outside sources from the server.
*** file: /etc/hosts
# Internet host table
127.0.0.1 localhost
198.78.8.37 eprospector01 loghost
*** file: /etc/services
idswe2 1525/tcp # Informix Dynamic Server
*** file: /usr/informix/etc/sqlhosts
ep01_net ontlitcp eprospector01 idswe2
*** file: /etc/profile
INFORMIXDIR=/usr/informixexport INFORMIXDIR
PATH=$INFORMIXDIR/bin:$PATHexport PATH
INFORMIXSERVER=ep01_netexport INFORMIXSERVER
ONCONFIG=onconfig.ep01_netexport ONCONFIG
SQLEXEC=$INFORMIXDIR/lib/sqlrm
export SQLEXEC
xhost +localhost
# netstat -an | grep 1525
198.78.8.37.1525 *.* 0 0 24576 0 LISTEN
*** file: /tmp/buildsmi.866
# tail buildsmi.866
25572: Network driver cannot bind a name to the port.
Exec format error
Error in line 3118Near character position 1
Cleaning up whatever was successfully created
25572: Network driver cannot bind a name to the port.
Exec format error
#**************************************************************************
# INFORMIX SOFTWARE, INC.
# Title: onconfig.ep01_net
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /dev/chunk1 # Path for raw device containing rootdbspace
ROOTOFFSET 0 # Offset of root dbspace into device
(Kbytes)
ROOTSIZE 540000 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR 1 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH /dev/mirror1 # Path for device containing mirrored root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
# Physical Log Configuration
PHYSDBS rootdbs # Location (dbspace) of physical log
PHYSFILE 4000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 6 # Number of logical log files
LOGSIZE 60000 # Logical log size (Kbytes)
# Diagnostics
MSGPATH /usr/informix/online.log # System message log file path
CONSOLE /dev/console # System console message path
ALARMPROGRAM /usr/informix/etc/log_full.sh # Alarm program pathSYSALARMPROGRAM /usr/informix/etc/evidence.sh # System Alarm program path
TBLSPACE_STATS 1
# System Archive Tape Device
TAPEDEV /dev/rmt/0 # Tape device path
TAPEBLK 16 # Tape block size (Kbytes)
TAPESIZE 4756764 # Maximum amount of data to put on tape
(Kbytes)
# Log Archive Tape Device
LTAPEDEV /dev/rmt/0 # Log tape device path
LTAPEBLK 16 # Log tape block size (Kbytes)
LTAPESIZE 4756764 # Max amount of data to put on log tape
(Kbytes)
# Optical
STAGEBLOB # Informix Dynamic Server/Optical staging
area
# System Configuration
SERVERNUM 0 # Unique id corresponding to a DynamicServer instance
DBSERVERNAME ep01_net # Name of default database server
DBSERVERALIASES # List of alternate dbservernames
NETTYPE tlitcp,,, # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed
env.
RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
MULTIPROCESSOR 0 # 0 for single-processor, 1 formulti-processor
NUMCPUVPS 1 # Number of user (cpu) vps
SINGLE_CPU_VP 1 # If non-zero, limit number of cpu vps toone
NOAGE 0 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
# Shared Memory Parameters
LOCKS 20000 # Maximum number of locks
BUFFERS 4750 # Maximum number of shared buffers
NUMAIOVPS # Number of IO vps
PHYSBUFF 128 # Physical log buffer size (Kbytes)
LOGBUFF 128 # Logical log buffer size (Kbytes)LOGSMAX 35 # Maximum number of logical log files
CLEANERS 2 # Number of buffer cleaner processes
SHMBASE 0xa000000 # Shared memory base address
SHMVIRTSIZE 8000 # initial virtual shared memory segment size
SHMADD 8192 # Size of new shared memory segments
(Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
LTXHWM 50 # Long transaction high water markpercentage
LTXEHWM 60 # Long transaction high water mark
(exclusive)
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)
# System Page Size
# BUFFSIZE - Dynamic Server no longer supports this configuration parameter.
# To determine the page size used by Dynamic Server on your
platform
# see the last line of output from the command, 'onstat -b'.
# Recovery Variables
# OFF_RECVRY_THREADS:
# Number of parallel worker threads during fast recovery or an offline
restore.
# ON_RECVRY_THREADS:
# Number of parallel worker threads during an online restore.
OFF_RECVRY_THREADS 10 # Default number of offline workerthreads
ON_RECVRY_THREADS 1 # Default number of online worker threads@@