免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1782 | 回复: 4
打印 上一主题 下一主题

求救!在AIX上安装informix dynamic server7.31 失败! [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2004-10-19 16:59 |只看该作者 |倒序浏览
初始化中断,online。log 上提示如下:
Tue Oct 19 16:42:25 2004

16:42:25  Event alarms enabled.  ALARMPROG = '/usr/informix/etc/log_full.sh'
16:42:30  DR: DRAUTO is 0 (Off)
16:42:30  AIX MP latch code enabled
16:42:30  Informix Dynamic Server Version 7.31.UC5    Software Serial Number ###
16:42:30  listener-thread: err = -25572: oserr = 68: errstr = : Network driver c
annot bind a name to the port.
System error = 68.
16:42:30  Attempting to bring listener thread down.

16:42:30  Server stopped.

16:42:30  Informix Dynamic Server Stopped.
16:42:31  mt_shm_remove: WARNING: may not have removed all/correct segments

论坛徽章:
0
2 [报告]
发表于 2004-10-19 17:08 |只看该作者

求救!在AIX上安装informix dynamic server7.31 失败!

我的onconfig文件配置如下:
# Root Dbspace Configuration

ROOTNAME        rootdbs         # Root dbspace name
ROOTPATH        /dev/rrootdbs   # Path for device containing root dbspace
ROOTOFFSET      0               # Offset of root dbspace into device (Kbytes)
ROOTSIZE        320000          # Size of root dbspace (Kbytes)

# Disk Mirroring Configuration Parameters

MIRROR          0               # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH                      # Path for device containing mirrored root
MIRROROFFSET    0               # Offset into mirrored device (Kbytes)

# Physical Log Configuration



PHYSDBS         rootdbs         # Location (dbspace) of physical log

PHYSFILE        64000           # Physical log file size (Kbytes)



# Logical Log Configuration



LOGFILES        6               # Number of logical log files

LOGSIZE         5000            # 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 path

SYSALARMPROGRAM /usr/informix/etc/evidence.sh # System Alarm program path

TBLSPACE_STATS  1



# System Archive Tape Device



TAPEDEV         /dev/null       # Tape device path

TAPEBLK         16              # Tape block size (Kbytes)

TAPESIZE        10240           # Maximum amount of data to put on tape (Kbytes)
TAPESIZE        10240           # Maximum amount of data to put on tape (Kbytes)
# Log Archive Tape Device



LTAPEDEV        /dev/null       # Log tape device path

LTAPEBLK        16              # Log tape block size (Kbytes)

LTAPESIZE       10240           # Max amount of data to put on log tape (Kbytes)
LTAPESIZE       10240           # Max amount of data to put on log tape (Kbytes)



# Optical



STAGEBLOB                       # Informix Dynamic Server/Optical staging area



# System Configuration
SERVERNUM       1               # Unique id corresponding to a Dynamic Server in

SERVERNUM       1               # Unique id corresponding to a Dynamic Server in
stance

DBSERVERNAME    sz38            # Name of default database server

DBSERVERALIASES                 # List of alternate dbservernames

NETTYPE         soctcp,1,10,CPU # 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 for multi-processor

NUMCPUVPS       1               # Number of user (cpu) vps

SINGLE_CPU_VP   0               # If non-zero, limit number of cpu vps to one
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         2000            # Maximum number of shared buffers

NUMAIOVPS       8               # Number of IO vps

PHYSBUFF        32              # Physical log buffer size (Kbytes)

LOGBUFF         32              # Logical log buffer size (Kbytes)

LOGSMAX         32              # Maximum number of logical log files
CLEANERS        1               # Number of buffer cleaner processes

SHMBASE         0x30000000        # 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 mark percentage

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:
OFF_RECVRY_THREADS 10              # Default number of offline worker threads

ON_RECVRY_THREADS 1               # Default number of online worker threads



# Data Replication Variables

# DRAUTO: 0 manual, 1 retain type, 2 reverse type

DRAUTO          0               # DR automatic switchover

DRINTERVAL      30              # DR max time between DR buffer flushes (in sec)
DRINTERVAL      30              # DR max time between DR buffer flushes (in sec)

DRTIMEOUT       30              # DR network timeout (in sec)

DRLOSTFOUND     /usr/informix/etc/dr.lostfound # DR lost+found file path
# CDR Variables

CDR_LOGBUFFERS  2048            # size of log reading buffer pool (Kbytes)

CDR_EVALTHREADS 1,2             # evaluator threads (per-cpu-vp,additional)

CDR_DSLOCKWAIT  5               # DS lockwait timeout (seconds)

CDR_QUEUEMEM    4096            # Maximum amount of memory for any CDR queue (Kb

CDR_QUEUEMEM    4096            # Maximum amount of memory for any CDR queue (Kb
ytes)

CDR_LOGDELTA    30              # % of log space allowed in queue memory

CDR_NUMCONNECT  16              # Expected connections per server

CDR_NIFRETRY    300             # Connection retry (seconds)

CDR_NIFCOMPRESS 0               # Link level compression (-1 never, 0 none, 9 ma

CDR_NIFCOMPRESS 0               # Link level compression (-1 never, 0 none, 9 ma
x)
# Backup/Restore variables

BAR_ACT_LOG     /tmp/bar_act.log

BAR_MAX_BACKUP  0

BAR_RETRY       1

BAR_NB_XPORT_COUNT 10

BAR_XFER_BUF_SIZE 31



# Informix Storage Manager variables

ISM_DATA_POOL   ISMData         # If the data pool name is changed, be sure to

                                # update $INFORMIXDIR/bin/onbar.  Change to

                                # ism_catalog -create_bootstrap -pool <new name>;
                                # ism_catalog -create_bootstrap -pool <new name>;

ISM_LOG_POOL    ISMLogs
# Read Ahead Variables

RA_PAGES                        # Number of pages to attempt to read ahead

RA_THRESHOLD                    # Number of pages left before next group



# DBSPACETEMP:

# Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces

# that the Dynamic Server SQL Engine will use to create temp tables etc.

# If specified it must be a colon separated list of dbspaces that exist

# when the Dynamic Server system is brought online.  If not specified, or if

# all dbspaces specified are invalid, various ad hoc queries will create

# temporary files in /tmp instead.
DBSPACETEMP     tmpdbs          # Default temp dbspaces



# DUMP*:

# The following parameters control the type of diagnostics information which

# is preserved when an unanticipated error condition (assertion failure) occurs

# during Dynamic Server operations.

# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.



DUMPDIR         /tmp            # Preserve diagnostics in this directory

DUMPSHMEM       1               # Dump a copy of shared memory

DUMPGCORE       0               # Dump a core image using 'gcore'

DUMPCORE        0               # Dump a core image (Warning:this aborts Dynamic
DUMPCORE        0               # Dump a core image (Warning:this aborts Dynamic
Server)

DUMPCNT         1               # Number of shared memory or gcore dumps for

                                # a single user's session



FILLFACTOR      90              # Fill factor for building indexes



# method for Dynamic Server to use when determining current time

USEOSTIME       0               # 0: use internal time(fast), 1: get time from O

USEOSTIME       0               # 0: use internal time(fast), 1: get time from O
S(slow)



# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 100             # Maximum allowed pdqpriority

DS_MAX_QUERIES                  # Maximum number of decision support queries

DS_TOTAL_MEMORY                 # Decision support memory (Kbytes)

DS_MAX_SCANS    1048576         # Maximum number of decision support scans

DATASKIP        off             # List of dbspaces to skip



# OPTCOMPIND

# 0 =>; Nested loop joins will be preferred (where

#      possible) over sortmerge joins and hash joins.

# 1 =>; If the transaction isolation mode is not

#      "repeatable read", optimizer behaves as in (2)

#      below.  Otherwise it behaves as in (0) above.
# 2 =>; Use costs regardless of the transaction isolation

#      mode.  Nested loop joins are not necessarily

#      preferred.  Optimizer bases its decision purely

#      on costs.

OPTCOMPIND      2               # To hint the optimizer



ONDBSPACEDOWN   2               # Dbspace down option: 0 = CONTINUE, 1 = ABORT,

ONDBSPACEDOWN   2               # Dbspace down option: 0 = CONTINUE, 1 = ABORT,
2 = WAIT

LBU_PRESERVE    0               # Preserve last log for log backup

OPCACHEMAX      0               # Maximum optical cache size (Kbytes)



# HETERO_COMMIT (Gateway participation in distributed transactions)
OPTCOMPIND      2               # To hint the optimizer

ONDBSPACEDOWN   2               # Dbspace down option: 0 = CONTINUE, 1 = ABORT,
2 = WAIT
LBU_PRESERVE    0               # Preserve last log for log backup
OPCACHEMAX      0               # Maximum optical cache size (Kbytes)

# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 =>; Heterogeneous Commit is enabled
# 0 (or any other value) =>; Heterogeneous Commit is disabled
HETERO_COMMIT   0

# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
OPT_GOAL        -1

# Optimizer DIRECTIVES ON (1/Default) or OFF (0)
DIRECTIVES      1

# Status of restartable restore
RESTARTABLE_RESTORE off

论坛徽章:
0
3 [报告]
发表于 2004-10-20 08:39 |只看该作者

求救!在AIX上安装informix dynamic server7.31 失败!

检查 /etc/services
       /$INFORMIX/etc/sqlhosts
文件;

论坛徽章:
0
4 [报告]
发表于 2004-10-20 13:52 |只看该作者

求救!在AIX上安装informix dynamic server7.31 失败!

~informix/etc/sqlhost文件多余的要删除了!

论坛徽章:
0
5 [报告]
发表于 2004-10-20 16:43 |只看该作者

求救!在AIX上安装informix dynamic server7.31 失败!

谢谢,昨天已经解决了,确实是sqlhosts文件的问题1
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP